Friday, 19 October 2012

ORA-29516: Aurora assertion failure during 11.2.0.3 RAC database creation

 Oracle Server - Enterprise Edition - Version 11.2.0.3
Linux x86

Oracle El 5.3

Symptoms


I was creating brand new RAC on two servers with grid.  Grid installed fine but when I runinstall Oracle 11.2.0.3 with option software+creation of database.  At the close to 75% completion. I was getting  "ORA-29516: Aurora assertion failure: Assertion failure at joez.c:3311 " .  I didn't see any more informations from cfgtools installation log.

Diagnosis


Try searching oracle metalink, found few articles related to same error but it is not helpful.  Articles and oracle forum that other people had was related after they had created database already.  My case is brand new install.
Oracle article said to Disable the JIT compiler:

Alter system set JAVA_JIT_ENABLED=FALSE scope=both;


But i dont' have database created yet.

Solution


During the database creation, you will need to quickly login to your database with sysdba.

1.  Set/export your oracle sid to your RAC database name. 
export ORACLE_SID=RAC
. oraenv

2. ps -ef | grep pmon for few time to see if your pmon_RAC1 has been created and running.

3.  When you see pmon_RAC1 process then right away export ORACLE_SID=RAC1.

4. sqlplus / as sysdba 

5.  Alter system set JAVA_JIT_ENABLED=FALSE

note: this steps must be completed before the ORA-29516  error pop up.  
 
  




No comments:

Post a Comment