MMNL absent for 9607 secs; Foregrounds taking over

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 问题，也会导致我们登陆不了数据库。重新解决。