Requirement-Finding location of alert.log in Oracle
You can try this
SQL> select * from v$version;
BANNER
——————————————————————————–
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production
PL/SQL Release 11.1.0.7.0 – Production
CORE 11.1.0.7.0 Production
TNS for Linux: Version 11.1.0.7.0 – Production
NLSRTL Version 11.1.0.7.0 – Production
SQL> show parameter background
NAME TYPE VALUE
———————————— ———– ——————————
background_core_dump string partial
background_dump_dest string /oracle/app/oracle/diag/rdbms/PROD/PROD/trace
SQL> !ls -ltr /oracle/app/oracle/diag/rdbms/PROD/PROD/trace/al*
-rw-r—– 1 oracle oinstall 78512424 2011-10-03 02:00 /oracle/app/oracle/diag/rdbms/PROD/PROD/trace/alert_PROD.log
OR before running this query you can check on this location
/u01/app/oracle/diag/rdbms/repo/REPO/trace
Happy learning with Vinay Kumar in techartifact