MMNL absent for 9607 secs; Foregrounds taking over与status RESTRICTED
Oracle 10.2.0.1
系统:centos5.6
http://www.eygle.com/archives/2005/12/oracle_diagnost_mmnl_absent.html(盖老师解决这个问题的方案) 感谢盖老师
模拟MMNL absent for 9607 secs; Foregrounds taking over 环境测试(次环境不是每次都会出现MMMNL错误的,但是记录一下这个错误以后遇到可以解决)
SQL> conn /as sysdba
Connected.
SQL> shutdown abort;
ORACLE instance shut down.
Lsnrctl 状态
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Alert日志
Shutting down instance (abort)
License high water mark = 8
Instance terminated by USER, pid = 20437
Startup restrict 开启库
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup restrict;
ORACLE instance started.
Total System Global Area 457179136 bytes
Fixed Size 1219976 bytes
Variable Size 146801272 bytes
Database Buffers 306184192 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
Lsnrctl 状态
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status RESTRICTED, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "test", status RESTRICTED, has 1 handler(s) for this service...
Service "test_XPT" has 1 instance(s).
Instance "test", status RESTRICTED, has 1 handler(s) for this service...
The command completed successfully
Alert日志
MMNL absent for 9607 secs; Foregrounds taking over
Fri Apr 6 18:02:02 2012
MMNL absent for 9909 secs; Foregrounds taking over
Fri Apr 6 18:07:02 2012
MMNL absent for 10207 secs; Foregrounds taking over
解决方法:
1、 shutdown abort
2、 startup
3、 alter system register (注册监听)
4、 问题解决,盖老师说10G R2已经修复了这个BUG。
总结:这里有2个问题
1、 startup restrict 启库之后导致, listeners状态为status RESTRICTED ,然后我们不能登陆
2、 MMNL absent for 10207 secs; Foregrounds taking over 是10g r1 bug问题,也会导致我们登陆不了数据库。重新解决。