Shulou(Shulou.com)05/31 Report--

This article mainly explains "the reason why the database can not be started automatically after rac startup". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "the reason why the database cannot be started automatically after rac startup".

View resource configuration:

[oracle@ocm1 public] $crs_stat-p ora.prodb.prodb1.inst

NAME=ora.prodb.prodb1.inst

TYPE=application

ACTION_SCRIPT=/u01/app/oracle/product/10.2.0/db_1/bin/racgwrap

ACTIVE_PLACEMENT=0

AUTO_START=1

CHECK_INTERVAL=600

DESCRIPTION=CRS application for Instance

FAILOVER_DELAY=0

FAILURE_INTERVAL=0

FAILURE_THRESHOLD=0

HOSTING_MEMBERS=ocm1

OPTIONAL_RESOURCES=

PLACEMENT=restricted

REQUIRED_RESOURCES=ora.ocm1.ASM1.asm

RESTART_ATTEMPTS=5

SCRIPT_TIMEOUT=600

START_TIMEOUT=0

STOP_TIMEOUT=0

UPTIME_THRESHOLD=7d

USR_ORA_ALERT_NAME=

USR_ORA_CHECK_TIMEOUT=0

USR_ORA_CONNECT_STR=/ as sysdba

USR_ORA_DEBUG=0

USR_ORA_DISCONNECT=false

USR_ORA_FLAGS=

USR_ORA_IF=

USR_ORA_INST_NOT_SHUTDOWN=

USR_ORA_LANG=

USR_ORA_NETMASK=

USR_ORA_OPEN_MODE=

USR_ORA_OPI=false

USR_ORA_PFILE=

USR_ORA_PRECONNECT=none

USR_ORA_SRV=

USR_ORA_START_TIMEOUT=0

USR_ORA_STOP_MODE=immediate

USR_ORA_STOP_TIMEOUT=0

USR_ORA_VIP=

Where AUTO_START=1 means to start automatically, and if it is not 1, use the following command to modify:

[oracle@ocm1 public] $crs_register ora.prodb.prodb1.inst-update-o as=1

[oracle@ocm1 public] $crs_register ora.prodb.prodb1.inst-update-o as=always

There is also a situation that causes the default startup to fail, where REQUIRED_RESOURCES is empty:

REQUIRED_RESOURCES=

Use the following command to fix:

Srvctl modify instance-d-I-s

Example:

Srvctl modify instance-d prodb-I prodb1-s + ASM3

At this point, I believe you have a deeper understanding of "the reason why the database cannot be started automatically after rac startup". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.