Where's the Oracle alert log in version 20? Plus, no util o/3 in v21-up

• Article Type: General
• Product: Aleph
• Product Version: 20, 21, 22, 23

Description:
In Aleph 18/19 (Oracle 10) the Oracle alert log was in the .../oracle/admin/bdump/ directory and aleph_start was looking there:

setenv ORACLE_ALERT_LOG $ORACLE_BASE/admin/$ORACLE_SID/bdump/alert_${ORACLE_SID}.log

In Aleph 20 (Oracle 11) I find that there is no alert_xxxxx.log file in the bdump directory -- and util o/3/1 gets the following error message:

Enter number of lines to see from log : [100]
tail: cannot open `.../bdump/alert_alephnn.log' for reading: No such file or directory

Where is the alert log?

Additionally, in Aleph 21-up, there is no util o/3. (The util o menu no longer contains the option "3. Oracle Logs".)

Resolution:

In version 20-up, the alert log is in the /exlibris/app/oracle/diag/rdbms/alephnn/alephnn/trace/ directory. 

For versions 22 and 23:  v22 rep_change 2333 and v23 rep_change 76 restore the util o/3 functionality.  Note:   "setenv ORACLE_ALERT_LOG" needs to be properly set in $alephe_root/aleph_start.

For versions 20 and 21:  the following can be used to view the alert log:

> view /exlibris/app/oracle/diag/rdbms/alephnn/alephnn/trace/alert_aleph22.log

NOTE 1: In Aleph 20 and 21, option 3 ("Oracle Logs") was removed from the util O menu, but the above information about the location of the log is still valid,... it's just that you can't use the util menu to get to it.

NOTE 2: By default the alert log has the following permissions:
-rw-r-----

In order to be able read this file when you are logged in as "aleph" (and for util o/3/1 to work!), you may need to do this:

> echo $ORACLE_BASE
/exlibris/app/oracle
> echo $ORACLE_SID
aleph0

> su - root
> cd /exlibris/app/oracle/diag/rdbms/alephnn/alephnn/trace/
> chmod +r alert_aleph0.log
> exit

When you then do

> ls -lrt alert_aleph0.log

you should see:

> -rw-r--r-- ... alert_aleph0.log

• Article last edited: 18-Jul-2016