This discussion is archived
2 Replies Latest reply: Apr 17, 2012 1:37 PM by onedbguru RSS

how do I verify if the rac 10g database start at boot?

user5133995 Newbie
Currently Being Moderated
Hi,

I know that to disable a rac database the command is:

srvctl disable database -d <db_unique_name>

But, how do I verify if the database is disable o enable at boot?

I search on metalink and google but unsuccessfully...

Thanks at all,

Cinzia
  • 1. Re: how do I verify if the rac 10g database start at boot?
    vinothp Newbie
    Currently Being Moderated
    Hi,

    The crs_stat -p <resource_name> command ,

    provides you with list of values with which the resource is managed. In the below example, you can observe that there is a parameter called AUTO_START which indicates the action that clusterware shoud perform when the clusterware is started(whatever be it, either a node reboot or a crs reboot)

    NAME=ora.XXXXXXXXX
    TYPE=application
    ACTION_SCRIPT=/opt/oracle/product/10.2.0.4.0_RAC/bin/racgwrap
    ACTIVE_PLACEMENT=0
    AUTO_START=1 --------------------> 1 indicates that CRS auto starts the resource, value "restore" indicates tht crs has to put the resurce back in the state what it was before the crs reboot. (http://docs.oracle.com/cd/B28359_01/rac.111/b28255/crschp.htm......has a detailed explanation on this )
    CHECK_INTERVAL=600
    DESCRIPTION=CRS application for Instance
    FAILOVER_DELAY=0
    FAILURE_INTERVAL=0
    FAILURE_THRESHOLD=0
    HOSTING_MEMBERS=<server_name>
    OPTIONAL_RESOURCES=
    PLACEMENT=restricted
    REQUIRED_RESOURCES=ora.XXXXXXXXXXXX
    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=
  • 2. Re: how do I verify if the rac 10g database start at boot?
    onedbguru Pro
    Currently Being Moderated
    srvctl status database -d <dbname>???
    srvctl config database -d <dbname>???

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points