问题描述:设置
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
|
思庄oracle技术分享-设置28401事件后启动数据库时报错ORA-49100
![](https://img-home.csdnimg.cn/images/20240711042549.png)