Database Software

Hello,

Versions:
S.O: Solaris SPARC 64bit
database: 9.2.0.8
cluster: 11.2.0.1

I am trying to add and start a database 9.2.0.8 to a cluster 11.2.0.1.

The add database works fine: srvctl add database -d orcl -o /u01/app/oracle/product/9.2.0/dbhome_5 -p '/u01/app/oracle/product/9.2.0/dbhome_5/dbs/spfileorcl.ora';

The add instance also: srvctl add instance -d orcl -i orcl1 -n node1

But when I try to start the instance with srvctl start instance -d orcl -i oracl1 I get the following errors:

PRCR-1013 : Failed to start resource ora.orcl.db
PRCR-1064 : Failed to start resource ora.orc.db on node node1
CRS-5011: Check of resource "orcl" failed: details at "(:CLSN00007:)" in "/u01/app/11.2.0/grid/log/node1/agent/crsd/oraagent_oracle/oraagent_oracle.log"
CRS-2674: Start of 'ora.orcl.db' on 'node1' failed


GIM-00090: OS-dependent operation:open failed with status: 2
GIM-00091: OS failure message: No such file or directory
GIM-00092: OS failure occurred at: sskgmsmr_7

the log says:
2011-08-20 17:20:34.810: [ AGFW][11] Command: start for resource: ora.orcl.db 1 1 completed with status: SUCCESS
2011-08-20 17:20:34.811: [ AGFW][7] Executing command: check for resource: ora.orcl.db 1 1
2011-08-20 17:20:34.811: [ora.orcl.db][7] [check] Gimh::check OH /u01/app/oracle/product/9.2.0/dbhome_5 SID orcl1
2011-08-20 17:20:34.812: [ AGFW][9] Agent sending reply for: RESOURCE_START[ora.orcl.db 1 1] ID 4098:924247
2011-08-20 17:20:34.813: [ora.orcl.db][7] [check] GIMH: GIM-00104: Health check failed to connect to instance
.
GIM-00090: OS-dependent operation:open failed with status: 2
GIM-00091: OS failure message: No such file or directory
GIM-00092: OS failure occurred at: sskgmsmr_7

2011-08-20 17:20:34.813: [ora.orcl.db][7] [check] (:CLSN00007:)DbAgent::check failed gimh state 0
2011-08-20 17:20:34.813: [ora.orcl.db][7] [check] Exception type=2 string=CRS-5011: Check of resource "orcl"
failed: details at "(:CLSN00007:)" in "/u01/app/11.2.0/grid/log/vettel/agent/crsd/oraagent_oracle/oraagent_oracle.log"

2011-08-20 17:20:34.814: [ AGFW][9] Agent sending reply for: RESOURCE_START[ora.orcl.db 1 1] ID 4098:924247
2011-08-20 17:20:34.814: [ AGFW][7] check for resource: ora.orcl.db 1 1 completed with status: FAILED
2011-08-20 17:20:34.815: [ AGFW][9] ora.orcl.db 1 1 state changed from: STARTING to: FAILED
2011-08-20 17:20:34.815: [ AGFW][7] Executing command: res_attr_modified for resource: ora.orcl.db 1 1
2011-08-20 17:20:34.815: [ AGFW][9] Agent sending last reply for: RESOURCE_START[ora.orcl.db 1 1] ID 4098:924247
2011-08-20 17:20:34.816: [ora.orcl.db][7] [res_attr_modified] clsn_agent::modify {
2011-08-20 17:20:34.816: [ora.orcl.db][7] [res_attr_modified] clsn_agent::modify }
2011-08-20 17:20:34.816: [ AGFW][7] Command: res_attr_modified for resource: ora.orcl.db 1 1 completed with status: SUCCESS
2011-08-20 17:20:34.816: [ AGFW][9] config version updated to : 150 for ora.orcl.db 1 1
2011-08-20 17:20:34.816: [ AGFW][9] Agent sending last reply for: RESOURCE_MODIFY_ATTR[ora.orcl.db 1 1] ID 4355:924252
2011-08-20 17:20:35.829: [ AGFW][9] Agent received the message: RESOURCE_CLEAN[ora.orcl.db 1 1] ID 4100:924293
2011-08-20 17:20:35.829: [ AGFW][9] Preparing CLEAN command for: ora.orcl.db 1 1
2011-08-20 17:20:35.829: [ AGFW][9] ora.orcl.db 1 1 state changed from: FAILED to: CLEANING
2011-08-20 17:20:35.830: [ AGFW][7] Executing command: clean for resource: ora.orcl.db 1 1


output from srvctl config database -d orcl -a

Database unique name: orcl
Database name:
Oracle home: /u01/app/oracle/product/9.2.0/dbhome_5
Oracle user: oracle
Spfile: /u01/app/oracle/product/9.2.0/dbhome_5/dbs/spfileorcl.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orcl
Database instances: orcl1
Disk Groups:
Services:
Database is enabled
Database is administrator managed


I tried to find a health check file for this database but none exists.

Can someone help me out? what file is it trying to find to give this error? "No such file or directory". How can I solve this issue?

Thank you.

Edited by: cibernauta on Aug 20, 2011 10:05 PM