Inside the Database Alert Log

The directory where the install software for Oracle RDBMS is stored is known as ORACLE_HOME. The log files stored are related to each of the database instances running out of this Oracle home. Suppose, for example, that you have a database called TEST with a database instance called TEST1. All its background process trace files, along with alert.log, would be available in the $ORACLE_ BASE/diag/rdbms/test/TEST1/trace directory; that’s the default location Oracle 11g database

Let’s take a closer look at staring up an instance in a two-node Oracle RAC cluster running version 11.2.0.2. We use SQL*Plus to issue the startup command on node1 and then on node2. The sequence of events follows, with additional explanations added as required.