alert log checking methods
1)adrci> show alert (11g onwards)
2)select name,value from v$diag_info;(11g onwards)
3)show parameter back and navigate the alert log locations
4)navigate thru OEM
Sharing DBA experience to all -- Oracle,MS SQL, DB2 , Netezza DBA,postgreSQL,AWS Redshift,MySQL,oracle SAP