11.2 grid and 10g Oracle home. DBCA can create the database all the way to 100%. But after creating the database, it failed to start.
Solution:
Looking at Oracle Doc
Incorrect Ownership and Permission after Relinking or Patching 11gR2 Grid Infrastructure [ID 1083982.1]
Thursday, October 28, 2010
Thursday, October 14, 2010
Error when try to connect 11g ASM using 10g DBCA
11g R2 RAC environemnt and successfully installed 10.2.0.4. While runing dbca to create a database, got the following error
"DBCA could not startup the ASM instance configured on this node. To processd with database creation using ASM you need the ASM instance to be up and running. Do you want to recreate the ASM instance on this node?"
Solution, according to Oracle Note
Pre 11.2 Database Issues in 11gR2 Grid Infrastructure Environment [ID 948456.1], applied patch 8288940.
"DBCA could not startup the ASM instance configured on this node. To processd with database creation using ASM you need the ASM instance to be up and running. Do you want to recreate the ASM instance on this node?"
Solution, according to Oracle Note
Pre 11.2 Database Issues in 11gR2 Grid Infrastructure Environment [ID 948456.1], applied patch 8288940.
Saturday, October 9, 2010
ORA-29701: unable to connect to Cluster Synchronization Service
11g R2 grid infrustructure on a standalone server. After the Server moved from one data center to another, go the following errors while start the ASM.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service
Solution:
run crsctl start resource -all.
[oracle@passl07 bin]$ ./crsctl start resource -all
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'passl07'
CRS-2672: Attempting to start 'ora.cssd' on 'passl07'
CRS-2679: Attempting to clean 'ora.diskmon' on 'passl07'
CRS-2681: Clean of 'ora.diskmon' on 'passl07' succeeded
CRS-2672: Attempting to start 'ora.diskmon' on 'passl07'
CRS-2676: Start of 'ora.diskmon' on 'passl07' succeeded
CRS-2676: Start of 'ora.cssd' on 'passl07' succeeded
CRS-5014: Agent "/u01/app/oracle/product/11.2.0/grid/bin/oraagent.bin" timed out starting process "/u01/app/oracle/product/11.2.0/grid/bin/lsnrctl" for action "start": details at "(:CLSN00009:)" in "/u01/app/oracle/product/11.2.0/grid/log/passl07/agent/ohasd/oraagent_oracle/oraagent_oracle.log"
CRS-5014: Agent "/u01/app/oracle/product/11.2.0/grid/bin/oraagent.bin" timed out starting process "/u01/app/oracle/product/11.2.0/grid/bin/lsnrctl" for action "check": details at "(:CLSN00009:)" in "/u01/app/oracle/product/11.2.0/grid/log/passl07/agent/ohasd/oraagent_oracle/oraagent_oracle.log"
(:CLSN00009:)Utils:execCmd aborted
CRS-2674: Start of 'ora.LISTENER.lsnr' on 'passl07' failed
CRS-2679: Attempting to clean 'ora.LISTENER.lsnr' on 'passl07'
CRS-2678: 'ora.LISTENER.lsnr' on 'passl07' has experienced an unrecoverable failure
CRS-0267: Human intervention required to resume its availability.
CRS-2672: Attempting to start 'ora.asm' on 'passl07'
CRS-2676: Start of 'ora.asm' on 'passl07' succeeded
CRS-2672: Attempting to start 'ora.PASS_DATA.dg' on 'passl07'
CRS-2672: Attempting to start 'ora.PASS_FLASH.dg' on 'passl07'
CRS-2672: Attempting to start 'ora.PASS_LOG.dg' on 'passl07'
CRS-2672: Attempting to start 'ora.PASS_BACKUP.dg' on 'passl07'
CRS-2676: Start of 'ora.PASS_FLASH.dg' on 'passl07' succeeded
CRS-2676: Start of 'ora.PASS_BACKUP.dg' on 'passl07' succeeded
CRS-2676: Start of 'ora.PASS_DATA.dg' on 'passl07' succeeded
CRS-2676: Start of 'ora.PASS_LOG.dg' on 'passl07' succeeded
SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service
Solution:
run crsctl start resource -all.
[oracle@passl07 bin]$ ./crsctl start resource -all
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'passl07'
CRS-2672: Attempting to start 'ora.cssd' on 'passl07'
CRS-2679: Attempting to clean 'ora.diskmon' on 'passl07'
CRS-2681: Clean of 'ora.diskmon' on 'passl07' succeeded
CRS-2672: Attempting to start 'ora.diskmon' on 'passl07'
CRS-2676: Start of 'ora.diskmon' on 'passl07' succeeded
CRS-2676: Start of 'ora.cssd' on 'passl07' succeeded
CRS-5014: Agent "/u01/app/oracle/product/11.2.0/grid/bin/oraagent.bin" timed out starting process "/u01/app/oracle/product/11.2.0/grid/bin/lsnrctl" for action "start": details at "(:CLSN00009:)" in "/u01/app/oracle/product/11.2.0/grid/log/passl07/agent/ohasd/oraagent_oracle/oraagent_oracle.log"
CRS-5014: Agent "/u01/app/oracle/product/11.2.0/grid/bin/oraagent.bin" timed out starting process "/u01/app/oracle/product/11.2.0/grid/bin/lsnrctl" for action "check": details at "(:CLSN00009:)" in "/u01/app/oracle/product/11.2.0/grid/log/passl07/agent/ohasd/oraagent_oracle/oraagent_oracle.log"
(:CLSN00009:)Utils:execCmd aborted
CRS-2674: Start of 'ora.LISTENER.lsnr' on 'passl07' failed
CRS-2679: Attempting to clean 'ora.LISTENER.lsnr' on 'passl07'
CRS-2678: 'ora.LISTENER.lsnr' on 'passl07' has experienced an unrecoverable failure
CRS-0267: Human intervention required to resume its availability.
CRS-2672: Attempting to start 'ora.asm' on 'passl07'
CRS-2676: Start of 'ora.asm' on 'passl07' succeeded
CRS-2672: Attempting to start 'ora.PASS_DATA.dg' on 'passl07'
CRS-2672: Attempting to start 'ora.PASS_FLASH.dg' on 'passl07'
CRS-2672: Attempting to start 'ora.PASS_LOG.dg' on 'passl07'
CRS-2672: Attempting to start 'ora.PASS_BACKUP.dg' on 'passl07'
CRS-2676: Start of 'ora.PASS_FLASH.dg' on 'passl07' succeeded
CRS-2676: Start of 'ora.PASS_BACKUP.dg' on 'passl07' succeeded
CRS-2676: Start of 'ora.PASS_DATA.dg' on 'passl07' succeeded
CRS-2676: Start of 'ora.PASS_LOG.dg' on 'passl07' succeeded
Subscribe to:
Posts (Atom)