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