oracle has
[grid@vm11gr2] /home/grid> sqlplus "/as sysasm"
SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 25 10:16:21 2009
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service
SQL>
無法連線到CSS服務上.到作業系統上檢查一下看看
[grid@vm11gr2] /home/grid> crsctl check css
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
[grid@vm11gr2] /home/grid>
[grid@vm11gr2] /home/grid> ps -ef|grep cssd
果然沒有CSS的服務daemon程式,再看一下HAS(High Availability Service)的狀態
[grid@vm11gr2] /home/grid> crsctl check has
CRS-4638: Oracle High Availability Services is online
[grid@vm11gr2] /home/grid> ps -ef|grep d.bin
grid 5886 1 0 10:06 ? 00:00:01 /u01/app/grid/product/11.2/grid/bin/ohasd.bin reboot
[grid@vm11gr2] /home/grid>
發現HAS的服務確實啟動了的,而ora.cssd和ora.diskmon這2個服務是依賴於HAS維護的.
進一步檢視各資源的狀態
[grid@vm11gr2] /home/grid> crs_stat -t
Name Type Target State Host
--------------------------------------------------------------
ora.FLASH_DATA.dg ora.diskgroup.type OFFLINE OFFLINE vm11gr2
ora.SYS_DATA.dg ora.diskgroup.type OFFLINE OFFLINE vm11gr2
ora.asm ora.asm.type OFFLINE OFFLINE vm11gr2
ora.cssd ora.cssd.type OFFLINE OFFLINE vm11gr2
ora.diskmon ora.diskmon.type OFFLINE OFFLINE vm11gr2
[grid@vm11gr2] /home/grid>
[grid@vm11gr2] /home/grid> crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_ DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.FLASH_DATA.dg
OFFLINE OFFLINE vm11gr2
ora.SYS_DATA.dg
OFFLINE OFFLINE vm11gr2
ora.asm
OFFLINE OFFLINE vm11gr2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 OFFLINE OFFLINE
ora.diskmon
1 OFFLINE OFFLINE
再看一下ora.cssd和ora.diskmon的屬性
[grid@vm11gr2] /home/grid> crs_stat -p ora.cssd
NAME=ora.cssd
TYPE=ora.cssd.type
ACTION_SCRIPT=
ACTIVE_PLACEMENT=0
AUTO_START=never
CHECK_INTERVAL=30
DESCRIPTION="Resource type for CSSD"
FAILOVER_DELAY=0
FAILURE_INTERVAL=3
FAILURE_THRESHOLD=5
HOSTING_MEMBERS=
PLACEMENT=balanced
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=600
START_TIMEOUT=600
STOP_TIMEOUT=900
UPTIME_THRESHOLD=1m
[grid@vm11gr2] /home/grid> crs_stat -p ora.diskmon
NAME=ora.diskmon
TYPE=ora.diskmon.type
ACTION_SCRIPT=
ACTIVE_PLACEMENT=0
AUTO_START=never
CHECK_INTERVAL=20
DESCRIPTION="Resource type for Diskmon"
FAILOVER_DELAY=0
FAILURE_INTERVAL=3
FAILURE_THRESHOLD=5
HOSTING_MEMBERS=
PLACEMENT=balanced
RESTART_ATTEMPTS=10
SCRIPT_TIMEOUT=60
START_TIMEOUT=60
STOP_TIMEOUT=60
UPTIME_THRESHOLD=5s
[grid@vm11gr2] /home/grid>
到這裡基本就找到了原因了,可以看到這兩個資源的AUTO_START屬性預設都設定為never,也就是說他們不會隨著HAS服務的啟動而自動啟動的,
儘管預設情況下HAS服務是開機自動啟動的.好了,那我們就手動啟動一下吧:
[grid@vm11gr2] /home/grid> crsctl start resource ora.cssd
CRS-2672: Attempting to start 'ora.cssd' on 'vm11gr2'
CRS-2679: Attempting to clean 'ora.diskmon' on 'vm11gr2'
CRS-2681: Clean of 'ora.diskmon' on 'vm11gr2' succeeded
CRS-2672: Attempting to start 'ora.diskmon' on 'vm11gr2'
CRS-2676: Start of 'ora.diskmon' on 'vm11gr2' succeeded
CRS-2676: Start of 'ora.cssd' on 'vm11gr2' succeeded
[grid@vm11gr2] /home/grid>
注:ora.cssd和ora.diskmon這兩個服務是有依賴關係的,啟動哪個都會把兩個都起來.
[grid@vm11gr2] /home/grid> crs_stat -t
Name Type Target State Host
--------------------------------------------------------------
ora.FLASH_DATA.dg ora.diskgroup.type OFFLINE OFFLINE vm11gr2
ora.SYS_DATA.dg ora.diskgroup.type OFFLINE OFFLINE vm11gr2
ora.asm ora.asm.type OFFLINE OFFLINE vm11gr2
ora.cssd ora.cssd.type ONLINE ONLINE vm11gr2
ora.diskmon ora.diskmon.type ONLINE ONLINE vm11gr2
[grid@vm11gr2] /home/grid>
CSS服務起來了,重啟動asm instance
[grid@vm11gr2] /home/grid> sqlplus "/as sysasm"
SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 25 10:30:03 2009
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ASM instance started
Total System Global Area 284565504 bytes
Fixed Size 1336036 bytes
Variable Size 258063644 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
[grid@vm11gr2] /home/grid> crs_stat -t
Name Type Target State Host
--------------------------------------------------------------
ora.FLASH_DATA.dg ora.diskgroup.type ONLINE ONLINE vm11gr2
ora.SYS_DATA.dg ora.diskgroup.type ONLINE ONLINE vm11gr2
ora.asm ora.asm.type ONLINE ONLINE vm11gr2
ora.cssd ora.cssd.type ONLINE ONLINE vm11gr2
ora.diskmon ora.diskmon.type ONLINE ONLINE vm11gr2
[grid@vm11gr2] /home/grid>
tips
1)預設情況下HAS(High Availability Service)是自動啟動的.透過如下命令可以取消和啟用自動啟動
crsctl disable has
crsctl enable has
2)HAS手動啟動和停止
crsctl start has
crsctl stop has
3)檢視HAS的狀態
crsctl check has
4)如果想讓ora.css和ora.diskmon服務隨著HAS的啟動而自動啟動,那麼你可以這兩個服務的AUTO_START屬性
crsctl modify resource "ora.cssd" -attr "AUTO_START=1"
or
crsctl modify resource "ora.diskmon" -attr "AUTO_START=1"
5)如果想取消ora.css和ora.diskmon的Auto start
crsctl modify resource "ora.cssd" -attr "AUTO_START=never"
crsctl modify resource "ora.diskmon" -attr "AUTO_START=never"
SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 25 10:16:21 2009
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service
SQL>
無法連線到CSS服務上.到作業系統上檢查一下看看
[grid@vm11gr2] /home/grid> crsctl check css
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
[grid@vm11gr2] /home/grid>
[grid@vm11gr2] /home/grid> ps -ef|grep cssd
果然沒有CSS的服務daemon程式,再看一下HAS(High Availability Service)的狀態
[grid@vm11gr2] /home/grid> crsctl check has
CRS-4638: Oracle High Availability Services is online
[grid@vm11gr2] /home/grid> ps -ef|grep d.bin
grid 5886 1 0 10:06 ? 00:00:01 /u01/app/grid/product/11.2/grid/bin/ohasd.bin reboot
[grid@vm11gr2] /home/grid>
發現HAS的服務確實啟動了的,而ora.cssd和ora.diskmon這2個服務是依賴於HAS維護的.
進一步檢視各資源的狀態
[grid@vm11gr2] /home/grid> crs_stat -t
Name Type Target State Host
--------------------------------------------------------------
ora.FLASH_DATA.dg ora.diskgroup.type OFFLINE OFFLINE vm11gr2
ora.SYS_DATA.dg ora.diskgroup.type OFFLINE OFFLINE vm11gr2
ora.asm ora.asm.type OFFLINE OFFLINE vm11gr2
ora.cssd ora.cssd.type OFFLINE OFFLINE vm11gr2
ora.diskmon ora.diskmon.type OFFLINE OFFLINE vm11gr2
[grid@vm11gr2] /home/grid>
[grid@vm11gr2] /home/grid> crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_ DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.FLASH_DATA.dg
OFFLINE OFFLINE vm11gr2
ora.SYS_DATA.dg
OFFLINE OFFLINE vm11gr2
ora.asm
OFFLINE OFFLINE vm11gr2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 OFFLINE OFFLINE
ora.diskmon
1 OFFLINE OFFLINE
再看一下ora.cssd和ora.diskmon的屬性
[grid@vm11gr2] /home/grid> crs_stat -p ora.cssd
NAME=ora.cssd
TYPE=ora.cssd.type
ACTION_SCRIPT=
ACTIVE_PLACEMENT=0
AUTO_START=never
CHECK_INTERVAL=30
DESCRIPTION="Resource type for CSSD"
FAILOVER_DELAY=0
FAILURE_INTERVAL=3
FAILURE_THRESHOLD=5
HOSTING_MEMBERS=
PLACEMENT=balanced
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=600
START_TIMEOUT=600
STOP_TIMEOUT=900
UPTIME_THRESHOLD=1m
[grid@vm11gr2] /home/grid> crs_stat -p ora.diskmon
NAME=ora.diskmon
TYPE=ora.diskmon.type
ACTION_SCRIPT=
ACTIVE_PLACEMENT=0
AUTO_START=never
CHECK_INTERVAL=20
DESCRIPTION="Resource type for Diskmon"
FAILOVER_DELAY=0
FAILURE_INTERVAL=3
FAILURE_THRESHOLD=5
HOSTING_MEMBERS=
PLACEMENT=balanced
RESTART_ATTEMPTS=10
SCRIPT_TIMEOUT=60
START_TIMEOUT=60
STOP_TIMEOUT=60
UPTIME_THRESHOLD=5s
[grid@vm11gr2] /home/grid>
到這裡基本就找到了原因了,可以看到這兩個資源的AUTO_START屬性預設都設定為never,也就是說他們不會隨著HAS服務的啟動而自動啟動的,
儘管預設情況下HAS服務是開機自動啟動的.好了,那我們就手動啟動一下吧:
[grid@vm11gr2] /home/grid> crsctl start resource ora.cssd
CRS-2672: Attempting to start 'ora.cssd' on 'vm11gr2'
CRS-2679: Attempting to clean 'ora.diskmon' on 'vm11gr2'
CRS-2681: Clean of 'ora.diskmon' on 'vm11gr2' succeeded
CRS-2672: Attempting to start 'ora.diskmon' on 'vm11gr2'
CRS-2676: Start of 'ora.diskmon' on 'vm11gr2' succeeded
CRS-2676: Start of 'ora.cssd' on 'vm11gr2' succeeded
[grid@vm11gr2] /home/grid>
注:ora.cssd和ora.diskmon這兩個服務是有依賴關係的,啟動哪個都會把兩個都起來.
[grid@vm11gr2] /home/grid> crs_stat -t
Name Type Target State Host
--------------------------------------------------------------
ora.FLASH_DATA.dg ora.diskgroup.type OFFLINE OFFLINE vm11gr2
ora.SYS_DATA.dg ora.diskgroup.type OFFLINE OFFLINE vm11gr2
ora.asm ora.asm.type OFFLINE OFFLINE vm11gr2
ora.cssd ora.cssd.type ONLINE ONLINE vm11gr2
ora.diskmon ora.diskmon.type ONLINE ONLINE vm11gr2
[grid@vm11gr2] /home/grid>
CSS服務起來了,重啟動asm instance
[grid@vm11gr2] /home/grid> sqlplus "/as sysasm"
SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 25 10:30:03 2009
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ASM instance started
Total System Global Area 284565504 bytes
Fixed Size 1336036 bytes
Variable Size 258063644 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
[grid@vm11gr2] /home/grid> crs_stat -t
Name Type Target State Host
--------------------------------------------------------------
ora.FLASH_DATA.dg ora.diskgroup.type ONLINE ONLINE vm11gr2
ora.SYS_DATA.dg ora.diskgroup.type ONLINE ONLINE vm11gr2
ora.asm ora.asm.type ONLINE ONLINE vm11gr2
ora.cssd ora.cssd.type ONLINE ONLINE vm11gr2
ora.diskmon ora.diskmon.type ONLINE ONLINE vm11gr2
[grid@vm11gr2] /home/grid>
tips
1)預設情況下HAS(High Availability Service)是自動啟動的.透過如下命令可以取消和啟用自動啟動
crsctl disable has
crsctl enable has
2)HAS手動啟動和停止
crsctl start has
crsctl stop has
3)檢視HAS的狀態
crsctl check has
4)如果想讓ora.css和ora.diskmon服務隨著HAS的啟動而自動啟動,那麼你可以這兩個服務的AUTO_START屬性
crsctl modify resource "ora.cssd" -attr "AUTO_START=1"
or
crsctl modify resource "ora.diskmon" -attr "AUTO_START=1"
5)如果想取消ora.css和ora.diskmon的Auto start
crsctl modify resource "ora.cssd" -attr "AUTO_START=never"
crsctl modify resource "ora.diskmon" -attr "AUTO_START=never"
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7191998/viewspace-772298/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle has a disk HB, but no network HB, DHB has r cfg , wrtcntOracle
- The installer has not detected any Oracle 10.2.0.4.0Oracle
- Disable the automatic startup of the Oracle Clusterware (CRS|HAS) softwareOracle
- oracle11g asm單例項重建hasOracleASM單例
- jQuery has()jQuery
- jQuery :has()jQuery
- 'oracle.sysman.emcp.oms.OmsPlugIn has failed' Error [ID 436605.1]OraclePluginAIError
- Oracle - ORA-01789: Query block has incorrect number of result columnsOracleBloC
- AttributeError: 'dict' object has no attribute 'has_key'ErrorObject
- oracle資料庫升級的時候oracle universal installer has detected........Oracle資料庫
- Troubleshooting oracle.sysman.emcp.agent.AgentPlugIn has failed error_734981.1OraclePluginAIError
- u01/app/oracle/product/10.2.0/db_1/bin/dbca has failedAPPOracleAI
- MySQL server has gone awayMySqlServerGo
- Python has two GILsPython
- RuntimeError: An attempt has been made to start a new process before the current process hasError
- Oracle opatch apply 時提示oci.dll has active的解決辦法OracleAPP
- Process object has no attribute '_popen'Object
- ‘dict‘ object has no attribute ‘iteritems‘Object
- He also has best iphone casesiPhone
- An out of memory error has occurred.Error
- How has JBuilder 8 source codeUI
- getOutputStream() has already been called
- Teamcenter 《POM has not start》處理
- “setting.xml” has syntax errorsXMLError
- akka-typed(3) - PersistentActor has EventSourcedBehavior
- 問題MySQL server has gone awayMySqlServerGo
- Window Application has "update" key wordsAPP
- Uncaught TypeError: Object # has no method 'load'ErrorObject
- 關於“Client 000 has status ‘not modifiable’”client
- SELinux has to be disabled on RHEL/OEL 5Linux
- Oracle RAC crsd日誌-0Resource ora!dbtest2!vip has incomplete attribute setOracle
- has(),find()以及filter()方法的區別Filter
- ‘FirewallD‘ object has no attribute ‘path‘ 、‘fw‘、is not registeredObject
- An internal error has occurred. Java heap spaceErrorJava
- AttributeError: 'module' object has no attribute 'lock'ErrorObject
- MySQL server has gone away 解決方案MySqlServerGo
- JIRA startup failed, JIRA has been locked.AI
- InnoDB Plugin has been upgraded to version 1.0.8Plugin