Oracle 11gR2 clusterware startup sequence

最新推荐文章于 2018-11-02 17:56:59 发布

原创最新推荐文章于 2018-11-02 17:56:59 发布 · 1k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #resources #database #server #less #unix

RAC 专栏收录该内容

47 篇文章

订阅专栏

本文深入探讨了Oracle高可用性服务（OHAS）的工作原理，包括资源管理、集群资源状态检查、服务启动与停止等关键操作。通过Metalink ID 1053147.1提供的信息，详细解释了如何确保集群环境下的数据库服务稳定运行。

Metalink:

http://blog.youkuaiyun.com/microjoey/article/details/7462855

ohasd -> orarootagent->ora.cssdmonitor : Monitors CSSD and node health (along with the cssdagent). Try to restart the node if the node is unhealthy.

->ora.ctssd : Cluster Time Synchronization Services Daemon

->ora.crsd -> oraagent -> ora.LISTENER.lsnr

-> ora.LISTENER_SCAN.lsnr

-> ora.ons

-> ora.eons

-> ora.asm

-> ora.DB.db

->orarootagent-> ora.nodename.vip

-> ora.net1.network

-> ora.gns.vip

-> ora.gnsd

-> ora.SCANn.vip

->cssdagent -> ora.cssd : Cluster Synchronization Services

-> oraagent -> ora.mdnsd :Used for DNS lookup
-> ora.evmd

-> ora.asmd

-> ora.gpnpd :Grid Plug and Play = adding a node to the cluster is easier (we need less configuration for the new node)

If a resource is written using blue & bold font => resource owned byroot. The other resources are owner by oracle. (all this on UNIX environment)

When a resource is managed byroot, we need to run the commandcrsctl asrootor oracle.

Clusterware Resource Status Check

$ crsctl status resource -t

-------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr

ONLINE ONLINE tzdev1rac ONLINE ONLINE tzdev2rac ora.asm

OFFLINE OFFLINE tzdev1rac OFFLINE OFFLINE tzdev2rac ora.eons

ONLINE ONLINE tzdev1rac ONLINE ONLINE tzdev2rac ora.gsd OFFLINE OFFLINE tzdev1rac OFFLINE OFFLINE tzdev2rac ora.net1.network ONLINE ONLINE tzdev1rac ONLINE ONLINE tzdev2rac ora.ons ONLINE ONLINE tzdev1rac ONLINE ONLINE tzdev2rac -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE tzdev1rac ora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE tzdev2rac ora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE tzdev2rac ora.oc4j 1 OFFLINE OFFLINE ora.scan1.vip 1 ONLINE ONLINE tzdev1rac ora.scan2.vip 1 ONLINE ONLINE tzdev2rac ora.scan3.vip 1 ONLINE ONLINE tzdev2rac ora.trezor.db 1 ONLINE ONLINE tzdev1rac Open 2 ONLINE ONLINE tzdev2rac ora.tzdev1rac.vip 1 ONLINE ONLINE tzdev1rac ora.tzdev2rac.vip 1 ONLINE ONLINE tzdev2rac

crsctl start has -> start all the clusterware services/ resources (including the database server and the listener);
crsctl stop has -> stop all the clusterware services/ resources (including the database server and the listener);

crsctl check has-> to check if ohasd is running/ stopped

crsctl check has CRS-4638: Oracle High Availability Services is online >> the ohasd daemon is running => the clusterware is (must be) up and running (if no error occur).

crsctl check has CRS-4639: Could not contact Oracle High Availability Services

>> the ohasd daemon is NOT running => the clusterware is DOWN (stopped).

crsctl enable has -> enable Oracle High Availability Services autostart

crsctl disable has->disable Oracle High Availability Services autostart

crsctl config has-> check if Oracle High Availability Services autostart is enabled/ disabled.

crsctl config has CRS-4622: Oracle High Availability Services autostart is enabled.

Useful information you can get from Metalink ID1053147.1: 11gR2 Clusterware and Grid Home - What You Need to Know