First page Back Continue Last page Graphics

Continuation of Notes


Notes:

You will find, among other events, these events in the Alert log:
Instance startup and shutdown
Log switches
Instance recovery messages
Oracle errors, for example:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\DAVE\SYSTEM01.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
This error would be an indication that the SYSTEM datafile had been moved or corrupted, and possibly needs recovery.
We will study how to find and solve some common Oracle errors later in this course.
Supplemental Notes
Note that the SQL*Plus SHOW command can also be used to display the database initialization parameters. For example:
SQL> show parameter background_dump
NAME TYPE VALUE
-------------------- -------- ------------------
background_dump_dest string C:\oracle\admin\class2