Hi Gurus,
OS->6.1
Oracle->11.2.0.1
Oracle Restart with ASM->11.2.0.1
GI owner for Oracle Restart ->gmvmxp1
Database owner->omvmxp1
I have successfully added the standby database to OCR/OLR on single instance GI(Oracle Restart) and the syntax used was shown below from DB_HOME using DB_OWNER id..i could start it using sqlplus.
palmer60:/home/omvmxp1>srvctl config database -d mvmxs2
Database unique name: mvmxs2
Database name: mvmxp2
Oracle home: /u01/app/omvmxp1/product/11.2.0/dbhome_1
Oracle user: omvmxp1
Spfile: /u01/app/omvmxp1/product/11.2.0/dbhome_1/dbs/spfilemvmxs2.ora
Domain: state.nj.us
Start options: open
Stop options: immediate
Database role: physical_standby
Management policy: AUTOMATIC
Disk Groups: MVMXS2_DATA,MVMXS_REC
Services:
palmer60:/home/omvmxp1>srvctl start database -d mvmxs2
PRCR-1079 : Failed to start resource ora.mvmxs2.db
CRS-5011: Check of resource "mvmxs2" failed: details at "(:CLSN00007:)" in "/u01/app/11.2.0/grid/log/palmer60/agent/ohasd/oraagent_gmvmxp1/oraagent_gmvmxp1.log"
CRS-2674: Start of 'ora.mvmxs2.db' on 'palmer60' failed
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
IBM AIX RISC System/6000 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
palmer60:/home/gmvmxp1>crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE palmer60
ora.MVMXS1_DATA.dg
ONLINE ONLINE palmer60
ora.MVMXS2_DATA.dg
ONLINE ONLINE palmer60
ora.MVMXS_REC.dg
ONLINE ONLINE palmer60
ora.asm
ONLINE ONLINE palmer60 Started
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE palmer60
ora.diskmon
1 ONLINE ONLINE palmer60
ora.mvmxs2.db
1 ONLINE OFFLINE
palmer60:/home/gmvmxp1>
From /u01/app/11.2.0/grid/log/palmer60/agent/ohasd/oraagent_gmvmxp1/oraagent_gmvmxp1.log
2011-10-14 07:12:06.235: [ AGFW][3599] Executing command: clean for resource: ora.mvmxs2.db 1 1
2011-10-14 07:12:06.236: [ora.mvmxs2.db][3599] [clean] clsn_agent::clean {
2011-10-14 07:12:06.236: [ora.mvmxs2.db][3599] [clean] clean {
2011-10-14 07:12:06.236: [ora.mvmxs2.db][3599] [clean] InstAgent::stop {
2011-10-14 07:12:06.236: [ora.mvmxs2.db][3599] [clean] Agent::flagUsrOraOpiIsSet(false)
2011-10-14 07:12:06.237: [ora.mvmxs2.db][3599] [clean] Agent::valueOfAttribIs attrib: REASON compare value: dependency attribute value: system
2011-10-14 07:12:06.237: [ora.mvmxs2.db][3599] [clean] Agent::valueOfAttribIs returns 0
2011-10-14 07:12:06.237: [ora.mvmxs2.db][3599] [clean] Gimh::check OH /u01/app/omvmxp1/product/11.2.0/dbhome_1 SID mvmxp2
2011-10-14 07:12:06.237: [ora.mvmxs2.db][3599] [clean] 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-10-14 07:12:06.237: [ora.mvmxs2.db][3599] [clean] (:CLSN00007:)DbAgent::check failed gimh state 0
2011-10-14 07:12:06.237: [ora.mvmxs2.db][3599] [clean] (:CLSN00007:)InstAgent::check: return unplanned offline ret: 5
2011-10-14 07:12:06.237: [ora.mvmxs2.db][3599] [clean] In
Please let me know where i'm going wrong with this.
Regards