Db Troubleshooting : Tips to Check alert log file error using command

 

• locate <file name>

[oracle@srv6 trace]$ locate alert_primary19c.log

/u01/app/oracle/diag/rdbms/primary19c/primary19c/trace/alert_primary19c.log

[oracle@srv6 trace]$

• check ORA- error in alert log using vi editor

/ORA-

• grep 'ORA-' <alert file >|tail

[oracle@srv6 trace]$ grep 'ORA-' alert_primary19c.log|tail

ORA-12541: TNS:no listener

ORA-16055: FAL request rejected

ORA-16055: FAL request rejected

ORA-12543: TNS:destination host unreachable

ORA-12543: TNS:destination host unreachable

ORA-12543: TNS:destination host unreachable

ORA-12543: TNS:destination host unreachable

ORA-16055: FAL request rejected

ORA-16055: FAL request rejected

ORA-12543: TNS:destination host unreachable

[oracle@srv6 trace]$

• grep -A5 'ORA-' <alert file >|tail

[oracle@srv6 trace]$ grep -A5 'ORA-' alert_primary19c.log|tail

2022-12-25T13:49:18.741705+05:30

PDB(3):Endian type of dictionary set to little

2022-12-25T13:49:19.125446+05:30

--

ORA-12543: TNS:destination host unreachable

TT00 (PID:2918): krsg_check_connection: Error 12543 connecting to standby 'standby19c'

2022-12-25T13:49:33.300551+05:30

PDB3(4):Opening pdb with no Resource Manager plan active

2022-12-25T13:49:33.753469+05:30

PDB4(5):Opening pdb with no Resource Manager plan active

[oracle@srv6 trace]$