Home > Oracle Rac > 11gR2 Rac fix the “ORACLE_BASE not set in environment” error in alertlog

11gR2 Rac fix the “ORACLE_BASE not set in environment” error in alertlog

The following error was reported in the alert log during instance startup after recovering from a pmon crash in a RAC environment

Starting background process RSMN
Fri Dec 16 16:55:40 2011
RSMN started with pid=28, OS id=24795
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Fri Dec 16 16:55:40 2011
ALTER DATABASE MOUNT /* db agent *//* {4:8516:36317} */

to fix the error run the following command using srvctl

srvctl setenv database -d romeo -t “ORACLE_BASE=/u01/app/oracle”

Once that was executed, I bounced this particular instance using:

srvctl stop instance -d romeo -i romeo2
srvctl start instance -d romeo -i romeo2

this resolved the issue

Starting background process RSMN
Wed Jan 25 12:39:47 2012
RSMN started with pid=28, OS id=16293
ORACLE_BASE from environment = /u01/app/oracle
Wed Jan 25 12:39:48 2012
ALTER DATABASE MOUNT /* db agent *//* {2:43873:47317} */
Advertisements
Categories: Oracle Rac
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: