Thursday, October 28, 2010

DBCA failed at the end on 11gR2 grid

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 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.

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