sqlplus "/ as sysdba" startup mount; oradebug setmypid oradebug EVENT 10046 TRACE NAME CONTEXT FOREVER, LEVEL 12 alter session set db_file_multiblocK_read_count=1; oradebug TRACEFILE_NAME alter database Open;oradebug EVENT 10046 trace name context off把生成的文件发我--------------------------------------------------------------- QQ号:107644445 邮箱:[email protected] BLOG:http://www.xifenfei.com
版本问题 alter system set aq_tm_processes=0 scope=both;
aq_tm_processes 会导致重启 官方文档,mos哪里建议你把该参数设置为0?
You might be hit with bug 3248886 (CONTINOUS 'RESTARTING DEAD BACKGROUND PROCESS QMN0' MESSAGE IN ALERT.LOG) If shutdown and startup does not work , please check for above BUG.Workaround to bug 3248886The workaround is to set aq_tm_processes=0 in the init.ora/spfile prior to startup. After startup alter system set aq_tm_processes=n (original value-n) https://forums.oracle.com/message/10533662
startup mount;
oradebug setmypid
oradebug EVENT 10046 TRACE NAME CONTEXT FOREVER, LEVEL 12
alter session set db_file_multiblocK_read_count=1;
oradebug TRACEFILE_NAME
alter database Open;oradebug EVENT 10046 trace name context off把生成的文件发我---------------------------------------------------------------
QQ号:107644445
邮箱:[email protected]
BLOG:http://www.xifenfei.com
alter system set aq_tm_processes=0 scope=both;
官方文档,mos哪里建议你把该参数设置为0?
If shutdown and startup does not work , please check for above BUG.Workaround to bug 3248886The workaround is to set aq_tm_processes=0 in the init.ora/spfile prior to startup. After startup
alter system set aq_tm_processes=n (original value-n)
https://forums.oracle.com/message/10533662
官方文档,mos哪里建议你把该参数设置为0?
https://forums.oracle.com/message/10533662