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

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問題，也會導致我們登陸不了資料庫。重新解決。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26442936/viewspace-741821/，如需轉載，請註明出處，否則將追究法律責任。