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 ...
Get Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
