错误:
在执行oracle命令的时候报以下错误:
ORA-04045: errors during recompilation/revalidation of XDB.XDB_PI_TRIG
ORA-01031: insufficient privileges
解决办法:
1.切换到oracle用户下
su - oracle
2.进入sqlplus
sqlplus / as sysdba
3.执行以下命令
alter system set "_system_trig_enabled" = false scope=spfile;
alter system set aq_tm_processes=0 scope=spfile;
alter system set job_queue_processes=0 scope=spfile;
4.直接在sqlplus重启数据库
shutdown immediate
startup