-
RAC problem -- PRKP-1001 and CRS-0212
I am new to Oracle and I inherited to clustered windows DB servers. This is Oracle 10g with RAC on Windows 2k3 x64
I have no idea what happened to break it, came in in the morning to complains the DB wasn't working.
When I do a crs_stat -t I see that several of the DBs are offline. When I try to start them I get CRS-0223 resource placement error. No amount of restarting or rebooting corrects this.
If I try to bring up the database via the EMC I get PRKP-1001 and CRS-0212 and it says resources are unregistered.
I don't know what to do at this point. Any help would be appreciated.
-
Fixed
Symptoms - database offline, start fails with errors CRS-0212 resource <resource name> is not registerd
Attempts to start from EMC result in PRKP-1001 and CRS-0212 errors together
Cause - database has been unregistered from the RAC cluster
Actions required -
1 - remove the unregistered database from the cluster configuration
D:\...\crs\BIN> srvctl remove database -d <database name>
Remove the database devdb? (y/[n]) y
2 - add the database back into the cluster configration using the following steps
D:\...\crs\BIN> srvctl add database -d <database name> -o %ORACLE_HOME%
D:\...\crs\BIN> srvctl add instance -d <database name> -i <database instance> -n <host>
D:\...\crs\BIN> srvctl add instance -d <database name> -i <database instance> -n <host>
D:\...\crs\BIN> srvctl add service -d <database name> -s <service name> -r <host>,<host> -P BASIC
-
correction
Symptoms - database offline, start fails with errors CRS-0212 resource <resource name> is not registerd
Attempts to start from EMC result in PRKP-1001 and CRS-0212 errors together
Cause - database has been unregistered from the RAC cluster
note: do this from within the DB's environment
Actions required -
1 - shutdown the database, stop each instance
<database> (ex: navytap)
sqlplus / as sysdba
shutdown immediate;
2 - remove the unregistered database from the cluster configuration
D:\...\crs\BIN> srvctl remove database -d <database name>
Remove the database devdb? (y/[n]) y
3 - add the database back into the cluster configration using the following steps
D:\...\crs\BIN> srvctl add database -d <database name> -o %ORACLE_HOME%
D:\...\crs\BIN> srvctl add instance -d <database name> -i <database instance> -n <host>
D:\...\crs\BIN> srvctl add instance -d <database name> -i <database instance> -n <host>
D:\...\crs\BIN> srvctl add service -d <database name> -s <service name> -r <instance>,<instance> -P BASIC
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|