ORA-02194: event specification syntax error 231 (minor error 286) near 'CONTEXTFOREVER'

原来修改ALTER SYSTEM SET EVENT='44951 TRACE NAME CONTEXT FOREVER, LEVEL 1024'   scope=spfile;

误操作ALTER SYSTEM SET EVENT='44951 TRACE NAME CONTEXTFOREVER, LEVEL 1024' scope=spfile;

报错

SQL> ALTER SYSTEM SET EVENT='44951 TRACE NAME CONTEXTFOREVER, LEVEL 1024' scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-02194: event specification syntax error 231 (minor error 286) near 'CONTEXTFOREVER'

解决:

进入$ORACLE_HOME/dbs

将原来spfile文件strings一份到其它地方

strings /dev/rgxspfile >/home/oracle/kfc

vi /home/oracle/kfc--将报错相关指示的内容先删除

SQL> startup pfile='/home/oracle/kfc'
ORACLE instance started.

Total System Global Area 2.1475E+10 bytes
Fixed Size                  2122472 bytes
Variable Size            1392512280 bytes
Database Buffers         2.0066E+10 bytes
Redo Buffers               14651392 bytes
Database mounted.
Database opened.

--创建回spfile

SQL> create spfile from pfile='/home/oracle/kfc';   

File created.

                                                 spfilegxtest.ora
SQL> ALTER SYSTEM SET EVENT='44951 TRACE NAME CONTEXT FOREVER, LEVEL 1024'   scope=spfile;

System altered.

[oracle@gxtest] $strings spfilegxtest.ora |grep CONTEXT
*.event='44951 TRACE NAME CONTEXT FOREVER, LEVEL 1024'

--修改成功并正常重启