I noticed some services were started and some other weren't. When I tried to start up the services, the 'placement' error showed up.
[oracle@pclone bin]$ ./srvctl start instance -d amct -i amct1
PRKP-1001 : Error starting instance amct1 on node pclone
CRS-1028: Dependency analysis failed because of:
CRS-0223: Resource 'ora.amct.amct1.inst' has placement error.
PRKP-1001 : Error starting instance amct1 on node pclone
CRS-1028: Dependency analysis failed because of:
CRS-0223: Resource 'ora.amct.amct1.inst' has placement error.
[oracle@pclone bin]$ ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....t1.inst application ONLINE UNKNOWN pclone
ora.amct.db application OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE pclone
ora.pclone.gsd application ONLINE ONLINE pclone
ora.pclone.ons application ONLINE ONLINE pclone
ora.pclone.vip application ONLINE ONLINE pclone
Name Type Target State Host
------------------------------------------------------------
ora....t1.inst application ONLINE UNKNOWN pclone
ora.amct.db application OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE pclone
ora.pclone.gsd application ONLINE ONLINE pclone
ora.pclone.ons application ONLINE ONLINE pclone
ora.pclone.vip application ONLINE ONLINE pclone
I restarted the CRS manually but still did not have any luck.
change user to root and then stop CRS. remove temporary files and then restart the CRS.
[oracle@pclone bin]$ su -
[root@pclone bin]# ./crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
rm -f /var/tmp/.oracle/*
./crsctl start crs
Attempting to start CRS stack
The CRS stack will be started shortly
The CRS stack will be started shortly
Wait until CRS gets started.
[root@pclone bin]# ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....t1.inst application ONLINE OFFLINE
ora.amct.db application OFFLINE OFFLINE
ora....SM1.asm application ONLINE OFFLINE
ora.pclone.gsd application ONLINE OFFLINE
ora.pclone.ons application ONLINE OFFLINE
ora.pclone.vip application ONLINE OFFLINE Still No Luck ~~~.
So Let's find out OCR Configuration.
[oracle@pclone bin]$ ./srvctl config database -d amct -a
pclone amct1 /u01/oracle/amctdb/10.2.0/db_1
DB_NAME: null
ORACLE_HOME: /u01/oracle/amctdb/10.2.0/db_1
SPFILE: null
DOMAIN: null
DB_ROLE: null
START_OPTIONS: null
POLICY: AUTOMATIC
ENABLE FLAG: DB ENABLED
As per the output of OCR Configuration "DB_NAME" and "SPFILE" are null and this seems to be the reason the instance was not coming up using srvctl start instance command.
srvctl modify database syntax
The srvctl modify database command is used to modify a database configurations in the OCR (Oracle cluster registry).
The OCR is the repository used by the CRS (cluster readu services) processes to run a database in RAC environment.
The OCR is the repository used by the CRS (cluster readu services) processes to run a database in RAC environment.
Syntax:
srvctl modify database -d db_unique_name [-n db_name] [-o oracle_home] [-m domain_name]
[-p spfile] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY}] [-s start_options] [-y {AUTOMATIC | MANUAL}]
-d database name (unique name)
-n db_name: database name if different from unique name
-o oracle_home:Oracle home
-m domain_name: Domain name of the database
-p spfile: server parameter file
-r role [PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY]: Role of the database
-s start_options:Startup options for the database.
-y Management policy for the database, either automatic or manual.
-h
srvctl modify database -d db_unique_name [-n db_name] [-o oracle_home] [-m domain_name]
[-p spfile] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY}] [-s start_options] [-y {AUTOMATIC | MANUAL}]
-d database name (unique name)
-n db_name: database name if different from unique name
-o oracle_home:Oracle home
-m domain_name: Domain name of the database
-p spfile: server parameter file
-r role [PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY]: Role of the database
-s start_options:Startup options for the database.
-y Management policy for the database, either automatic or manual.
-h
./srvctl modify database -d amct -p '/u01/oracle/amctdb/10.2.0/db_1/dbs/spfileamct1.ora' -n amct -s open
[oracle@pclone bin]$ ./srvctl config database -d amct -a
pclone amct1 /u01/oracle/amctdb/10.2.0/db_1
DB_NAME: amct
ORACLE_HOME: /u01/oracle/amctdb/10.2.0/db_1
SPFILE: /u01/oracle/amctdb/10.2.0/db_1/dbs/spfileamct1.ora
DOMAIN: null
DB_ROLE: null
START_OPTIONS: open
POLICY: AUTOMATIC
ENABLE FLAG: DB ENABLED
Once configuration is modified this seems to fix the issue.
No comments:
Post a Comment