Question: I have an Oracle 10.2.0.5.0 2-node RAC
running on Linux OS version Redhat 4. When the Cluster Ready
Services (CRS) start, all the services are online. The problem
is that when I try to connect the database, it is connecting to idle
instance.
A detail check indicates that the processes all get
started, but the instance is not.
I have tried stopping the background processes and starting
the instance manually using SQL*Plus, and the DB instance started
and I can connect.
But when I check the crs service status using
crs_stat -t, the instance and service
status are offline, nodeapps services are online. Attempting a
restart using crs_start results in an
error.
Does anyone have any ideas on what else I can try?
Answer:
If Clusterware is not automatically starting your database and it is
showing an idle instance, it could be that your
ORACLE_HOME is not set properly in the cluster configuration.
You can
use srvctl to drop and re-add the database from cluster services
to ensure everything is set up properly for the DB and instances.
You can
use crs_stat -p to get the profile of
any RAC resource.
If the ORACLE_HOME is not the issue, I would suggest looking at
your Clusterware logs in $ORA_CRS_HOME/log/nodename, specifically
those in the racg subdirectory.
An overview of building your own RAC cluster properly is
available
here.
Additional information on RAC CRS is available
here.
