問(wèn)題描述：設(shè)置28401事件后啟動(dòng)數(shù)據(jù)庫(kù)時(shí)報(bào)錯(cuò)ORA-49100，如下所示：

數(shù)據(jù)庫(kù)：oracle 11.2.0.464位

系統(tǒng)：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..

異常原因：設(shè)置28401事件語(yǔ)句錯(cuò)誤，將“namecontext“寫(xiě)成”namecontext“.

處理方案：用spfile生成pfile，修改pfile后用pfile啟動(dòng)數(shù)據(jù)庫(kù),如下所示：

[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啟動(dòng)數(shù)據(jù)庫(kù)

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