10gR2 database with 11gR2 Grid infrastructure
I have upgraded the CRS and ASM to 11gR2, but database is still in 10gR2 release. I have removed the database from crs and re-register again with the 10g Oracle home, but unable to start the database using srvctl. But I can start the database using sqlplus.
I have even tried setting LD_LIBRARY_PATH,SHLIB_PATH and TNS_ADMIN pointing to 10g home using "srvctl setene database" command, but no change in the result.
Details:
$ srvctl config database -d racdb
Database unique name: racdb
Database name:
Oracle home: /u03/app/oracle/product/102/db
Oracle user: oracle
Spfile:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances: racdb1,racdb2
Disk Groups:
Services:
Database is administrator managed
$ srvctl start database -d racdb
PRCR-1079 : Failed to start resource ora.racdb.db
CRS-5011: Check of resource "racdb" failed: details at "(:CLSN00007:)" in "/u02/app/oracle/product/11.2.0/grid/log/sf2-db1a/agent/crsd/oraagent_oracle/oraagent_oracle.log"
CRS-2674: Start of 'ora.racdb.db' on 'sf2-db1a' failed
CRS-2632: There are no more servers to try to place resource 'ora.racdb.db' on that would satisfy its placement policy
CRS-5011: Check of resource "racdb" failed: details at "(:CLSN00007:)" in "/u02/app/oracle/product/11.2.0/grid/log/sf2-db2a/agent/crsd/oraagent_oracle/oraagent_oracle.log"
Alert log is not showing any error message, but shutdown about was initiated.
Thu Jun 24 11:03:44 2010
Completed: ALTER DATABASE OPEN
Thu Jun 24 11:03:44 2010
db_recovery_file_dest_size of 5120 MB is 0.50% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Thu Jun 24 11:03:45 2010
Shutting down instance (abort)
License high water mark = 17
Instance terminated by USER, pid = 26322
Same issue with the instance start
$ srvctl start instance -d racdb -i racdb1
PRCR-1013 : Failed to start resource ora.racdb.db
PRCR-1064 : Failed to start resource ora.racdb.db on node sf2-db1a
CRS-5011: Check of resource "racdb" failed: details at "(:CLSN00007:)" in "/u02/app/oracle/product/11.2.0/grid/log/sf2-db1a/agent/crsd/oraagent_oracle/oraagent_oracle.log"
CRS-2674: Start of 'ora.racdb.db' on 'sf2-db1a' failed
Regards
Siva