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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle 10g 10.2.0.5關閉共享伺服器模式資料庫報MMNL absent for %u secsOracle 10g伺服器模式資料庫
- MMNL absent ,資料庫無法連線資料庫
- Restrict Session與Restricted MoodRESTSession
- 關於華碩主機板“USB Devices Over Current Status Detected!”dev
- Restricted RowidsREST
- JavaScript解析SECS GEM報文JavaScript
- status 與 state 的區別
- restricted_session_quiesce_suspendRESTSessionUI
- over fit與underfit的區別與解決方法
- row_number() over,rank() over,dense_rank() over的區別
- Restricted Mode of Instance Startup (291)REST
- Restricted Operations of the Shared Server (132)RESTServer
- oracle資料庫mmnl日誌很大Oracle資料庫
- sum()over()和count()over()分析函式函式
- over (partition by)
- Import OverImport
- Connections to NOMOUNT/MOUNTED or RESTRICTED Databases FailRESTDatabaseAI
- MMMNL absent錯誤 ,資料庫無法連線資料庫
- 高通mdm9607 mcfg_sw.mbn配置編譯流程編譯
- ASM diskgroup dismount with "Waited 15 secs for write IO to PST"ASMAI
- oracle的exclusive和restricted啟動方式OracleREST
- 淺談Oracle的受限模式(Restricted Mode)Oracle模式REST
- 12.29 Our club membership is restricted to twenty.REST
- Check failed: status == CUDNN_STATUS_SUCCESS (4 vs. 0) CUDNN_STATUS_INTERNAL_ERRORAIDNNError
- Sun eyes taking JavaOne to China in 2003Java
- mysql自動排序函式dense_rank() over()、rank() over()、row_num() over()用法和區別MySql排序函式
- 分析函式 over函式
- git status 命令Git
- SQL語句中的rank () over , row_number() over ,rank_dense ()SQL
- 【MOS】Index Rebuild Is Hanging Or Taking Too Long (文件 ID 272762.1)IndexRebuild
- AT_arc175_a [ARC175A] Spoon Taking Problem 題解
- Django WSGI Error:class.__dict__ not accessible in restricted modeDjangoErrorREST
- OVER(PARTITION BY)函式用法函式
- Oracle RDBMS History Over the YearsOracle
- Rsync over SSH with No Password (Crontab)
- Oracle over()函式使用Oracle函式
- over partition簡單使用
- Check database status in RACDatabase