设置28401事件后启动数据库时报错ORA-49100

denglj

问题描述：设置28401事件后启动数据库时报错ORA-49100，如下所示：

数据库：oracle 11.2.0.464位

系统：centos 7.964位

20:36:27SQL> alter system set event='28401 trace namecontext forever,level 1'scope=spfile;

Systemaltered.

20:37:19SQL> shutdown immediate

Databaseclosed.

Database dismounted.

ORACLEinstance shut down.

20:37:43SQL> startup

ORA-49601:syntax error: found "%s": expecting one of: "%s" etc..

20:37:49SQL> startup

ORA-49100:Failed to process event statement [28401 trace namecontext forever,level 1]

ORA-49601:syntax error: found "FOREVER": expecting one of:"End-of-Statement" etc..

异常原因：设置28401事件语句错误，将“namecontext“写成”namecontext“.

处理方案：用spfile生成pfile，修改pfile后用pfile启动数据库,如下所示：

[oracle@leo~]$ sqlplus / as sysdba

SQL*Plus:Release 11.2.0.4.0 Production on Sun Jul 24 20:39:55 2022

Copyright(c) 1982, 2013, Oracle.  All rightsreserved.

Connectedto an idle instance.

SQL>create pfile from spfile;

Filecreated.

[oracle@leodbs]$ ll

total 24

-rw-rw----1 oracle asmadmin 1544 Jul 24 20:37 hc_orcl.dat

-rw-r--r--1 oracle oinstall 2851 May 15  2009init.ora

-rw-r--r--1 oracle asmadmin 1027 Jul 24 20:40 initorcl.ora

-rw-r-----1 oracle asmadmin   24 Jul 17 00:23lkORCL

-rw-r-----1 oracle oinstall 1536 Jul 24 12:24 orapworcl

-rw-r-----1 oracle asmadmin 3584 Jul 24 20:37 spfileorcl.ora

[oracle@leodbs]$ vi initorcl.ora

将以下

*.event='28401trace namecontext forever,level 1'

修改为：

*.event='28401trace name context forever,level 1'

然后以pfile启动数据库

SQL>startup pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora';

ORACLE instancestarted.

TotalSystem Global Area 3006406656 bytes

FixedSize                  2257032 bytes

VariableSize             704647032 bytes

DatabaseBuffers         2281701376 bytes

RedoBuffers               17801216 bytes

Databasemounted.

Databaseopened.

SQL>create spfile frompfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora';

Filecreated.

SQL>show parameter pfile

NAME                                 TYPE        VALUE

----------------------------------------------- ------------------------------

spfile                               string