思庄oracle技术分享-设置28401事件后启动数据库时报错ORA-49100

问题描述：设置 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