MMNL absent for 9607 secs; Foregrounds taking over与status RESTRICTED

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