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