V9 LOGS – HOW TO VIEW LISTENER ALERT & TRACE LOG FILES

You can locate/view the specific logs and their locations by running adrci (Oracle’s Automatic Diagnostic Repository Command Interpreter) from the Windows command line. (as long as the Oracle BIN directory is in your path) launch CMD window and run the following command.

adrci

at the adrci prompt
adrci>
type in
“SHOW ALERT”
and hit enter.

You will be presented with the locations of the various logs as well as a menu to view them. The paths to the files are all with respect to the ORACLE folder. You can either go to the locations and grab the files or simply view the log files in notepad by selecting one of the menu options and save a copy to a convenient location . .

Type ‘q’ to quit that view and then ‘EXIT’ to get out of adrci