• 周四. 12月 1st, 2022

5G编程聚合网

5G时代下一个聚合的编程学习网

热门标签

How to view alert log in Oracle 11g

[db:作者]

1月 6, 2022

One . The first method

1. Switch to oracle user

su – oracle

2. Get into sqlplus window

sqlplus / as sysdba

3. perform sql command , see trace file location :background_dump_dest It’s the background log

show parameter dump;

4. Switch to trace Under the table of contents

cd /u01/app/oracle/diag/rdbms/prod/PROD/trace

 

5. Look at the pictures with alert Keyword file ,alert_INSTANCENAME.ora That is alert The name of the Journal

ls alert*

 

 

6. Consider using tail Command view alert After the log 500 That’s ok , then -f Represents a real-time refresh

tail -500f alert_PROD.log

 

 

Two . The second method (oracle Provides adrci Tools )

1. Switch to oracle user

 

 

2. perform adrci command

 

 

3.show homes See what you can see right now home (adrci Very powerful , You can see the monitoring log and alert Log etc. , I won’t go into details here )

 

 

 4.set oracle alert journal home

 

 

5. Execute the following command to view in real time alert After the log 500 That’s ok

 

 

6.ctrl+c Quit the command

 

 

7. sign out adrci Command line

 

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注