啟動ASM 例項報錯
在一個10G的環境下,啟動 ASM INSTANCE 報錯:
$ export ORACLE_SID=+ASM
$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 25 22:33:51 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-29701: unable to connect to Cluster Manager
SQL> select * from v$instance;
select * from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
第一次遇到unable to connect to Cluster Manager 這樣的錯誤,有點不知所措的。
後來翻閱了文件,報錯是因為沒有啟動CSS程式造成的。 原來是需要啟動css 後臺程式。
下面是啟動的步驟:
1) 用root使用者登入;
2) 確認 $ORACLE_HOME/bin 在環境變數PATH中;
3) 輸入下面的命令:
# localconfig add
如果使用localconfig add 有報錯,那嘗試使用:[B]localconfig reset[/B]
# ./localconfig reset
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'system'..
Operation successful.
Configuration for local CSS has been initialized
Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
h3cap61
CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)
./localconfig 會在inittab中加入一個項內容,讓程式在伺服器啟動後會自動執行:
h1:2:respawn:/etc/init.cssd run >/dev/null 2>&1 檢查程式是否在執行,可以通過ps命令來檢查:
# ps -ef|grep css
root 122976 102866 0 22:53:30 pts/0 0:00 grep css
oracle 303132 1 0 22:44:43 - 0:00 /oracle/product/10g/bin/ocssd.bin
或者通過oracle 使用者的crsctl 命令來檢查。
$ crsctl check cssd
Failure 1 contacting CSS daemon (這樣的反饋為css程式沒有執行)
$ crsctl check cssd
CSS appears healthy (css程式已經在執行)
css程式已經在執行,這時可以起到ASM例項:
$ ORACLE_SID=+ASM
$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 25 22:58:10 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ASM instance started
Total System Global Area 130023424 bytes
Fixed Size 2019136 bytes
Variable Size 102838464 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
ADMINISTRATOR MUNUAL關於CSS程式的說明:
[Size=11]CSS requirement:
The Cluster Synchronization Services (CSS) daemon is required to enable synchronization between ASM and its client database instances. The CSS daemon is normally started (and configured to start upon reboot) when you use Database Configuration Assistant (DBCA) to create your database. If you did not use DBCA to create the database, you must ensure that the CSS daemon is running before you start
the ASM instance.
[/Size]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/40239/viewspace-557980/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 11.2單例項ASM啟動報錯ORA-15186單例ASM
- ASM例項啟動報錯:ORA-29701 :unable to connect to Cluster ManagerASM
- 啟動ASM例項出現ORA-29701錯誤ASM
- dubbo啟動報錯,反射例項化問題反射
- ASM CRS 例項啟動和關閉ASM
- Oracle單例項+ASM啟動與關閉Oracle單例ASM
- asm報錯一例-support 報錯rename failedASMAI
- RAC環境啟動單例項報錯ORA-1105單例
- 建立ASM啟動SPFILE報錯ORA-17502ASM
- Flex ASM自動重定位ASM例項測試FlexASM
- 驗證11gR2 RAC中ASM例項通過gpnp profile獲得spfile資訊來啟動ASM例項ASM
- oracle 11gR2 asm例項 不能啟動處理方法OracleASM
- ASM之建立ASM例項ASM
- 單例項刪除ASM例項單例ASM
- oracle 10203啟動例項報警Oracle
- 管理 ASM 例項ASM
- 停止ASM例項ASM
- 11.2.0.4單例項ASM安裝報錯ohasd failed to ... line 73.單例ASMAI
- 【ASM】Oracle RAC css啟動報錯"Duplicate voting file found"ASMOracleCSS
- 11gR2啟動ASM例項時遭遇ORA-29701ASM
- keepalived啟動報錯解決一例
- RAC環境單例項啟動資料庫收到ORA-29702報錯單例資料庫
- ASM例項出現ORA-4031錯誤導致例項崩潰ASM
- Oracle Restart啟動資料庫例項故障一例( Oracle ASM儲存Spfile解析)OracleREST資料庫ASM
- asm磁碟組依賴導致資料庫自啟動報錯ASM資料庫
- Linux中設定oracle例項和asm同時隨機自動啟動LinuxOracleASM隨機
- 基於asm的單例項資料庫啟動時報錯ORA-15032 ORA-15063一例ASM單例資料庫
- 【轉】11gR2啟動ASM例項時遭遇ORA-29701ASM
- 刪除ASM例項ASM
- AIX6調整系統時間,引發asm報錯例項當機AIASM
- oracle10.2.0.1 (rhel4)rac刪除asm例項不乾淨導致重建asm例項出錯OracleASM
- 使用SRVCTL啟動例項與使用sqlplus啟動例項的區別SQL
- 11.2.0.3 例項啟動報大記憶體頁資訊記憶體
- 2 Day DBA-管理Oracle例項-關於例項的啟動和關閉-關於例項啟動Oracle
- mongodb 啟動報錯MongoDB
- php啟動報錯PHP
- 啟動CRS單例項、設定自動啟動單例
- 3.1.5.9 啟動遠端例項