I am using oracle 11gR2 (Version : 18.104.22.168) and OS RHEL 5.4.
There is two nodes in the cluster database environment.
I have issued the command as oracle user "srvctl start database -d racdb".
The following errors are showing.
PRCR-1079 : Failed to start resource ora.racdb.db
CRS-2674 : Start of 'ora.racdb.db' on 'racnode1' failed
CRS-2678 : 'ora.racdb.db' on racnode1' has experienced an unrecoverable failure
CRS-0267 : Human intervention required to resume its availability.
CRS-5802 : Unable to start the agent process
Please anybody has idea what is the root cause?
Simply waiting for the valuable reply.
Start with the basics: attempt to start the instance with SQL*Plus. If it starts, fine. If it does not, then follow the usual diagnostic process: observe thhe error message, and look at the instance alertlog.
Do not blame the clusterwere. Yet.
Yes Watson. It is working while using sqlplus in racnode1.
But there is no abnormalities in the instance alert log file.
That is why I am not finding any clue to rectify the database start command using srvctl.
Please suggest me if there is any other path exists to rectify the issue.
Thanks a lot for your reply.
I am explaining the scenarios.
While using sqlplus / as sysdba, instance is up and running using the '+RACDB_DATA/racdb/spfileracdb1.ora'. In this case, I mentioned the line +RACDB_DATA/racdb/spfileracdb1.ora' in initracdb1.ora file. Every database parameter is taking from the mentioned spfile.
But, when checking through 'srvctl status database -d racdb'
racdb1 is not running, racdb2 is running.
Ultimately how can i up the instance racdb1 through srvctl utility?