Monday, September 30, 2013

ORA-2194 Starting up the Database

Weekend after applying PSU while trying to start a database was receiving an ORA-2194 error.

ORA-2194, 00000, "event specification syntax error %s (minor error %s) near '%s'"
// *Cause: There is a syntax error in an event specification.
// *Action: Fix the error.

SQL>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL>startup
SQL>ORA-2194: event specification syntax error 231 (minor error 286) near 'CONETXT'

after searching all log file i found-
Someone have added a one new event. and my db was using spfile.

SQL>alter system set event='10046 trace name conetxt forever, level 12' scope=spfile;
System altered 



These are the steps to resolve the problem.

1. Create a PFILE from the current SPFILE.  You only need to be connected as
   Sysdba, the database does not need to be started.

   SQL>create pfile from spfile;
   File created.

2. Edit the generated PFILE and fix the problem.

   Change...  *.event='10046 trace name conetxt forever, level 12'
   -to-       *.event='10046 trace name context forever, level 12'

3. Startup the database with the newly generated PFILE.

   SQL>startup pfile=/.....

4. Recreate the SPFILE.

   SQL>create spfile from pfile;
   File created.

No comments:

Post a Comment