|Lesson 2||Identify the location of the alert log|
|Objective||Find the alert log on any Oracle server.|
$ORACLE_HOME/dbs directoryto find the initialization files for all databases on a server. And the init.ora files are generally called init$SID.ora. For example, a database called CUSTOMER would have an init.ora file called $ORACLE_HOME/dbs/initCUSTOMER.ora.
$ORACLE_HOME/dbsdirectory. Type cd $ORACLE_HOME/dbs at the prompt and hit Enter to continue.
connect internalat the SVRMGR prompt and hit Enter.
show parameters dumpcommand and hit Enter.
cd $ORACLE_HOME/dbsat the prompt and hit Enter to continue.
grep -i background *.orato look for background_dump_dest in *.ora.