• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Database » why-database-not-startup-automatic in 11gR2 cluster

why-database-not-startup-automatic in 11gR2 cluster

June 6, 2012 by techgoeasy Leave a Comment

There is one important attribute in 11gR2 cluster  ie. AUTO_START
We can check it using following command
$ crsctl status resource ora.TEST.db -p
| grep AUTO_START
AUTO_START=restore
– always:
Restarts the resource when the server restarts regardless of the state of the
resource when the server stopped.
– restore: Restores the resource to the same state that it was in when
the server stopped. Oracle Clusterware attempts to restart the resource if the
value of TARGET was ONLINE before the server stopped.
– never: Oracle Clusterware never restarts the resource regardless of
the state of the resource when the server stopped.
So if AUTO_START is set to restore,it will restore to same state as when cluster was stopped
ie. if the DB was up,when we stop the cluster or reboot the server, database will come up automatically after reboot but if DB was down ,then it wont come Up.
You can modify this attribute to always also using these command
$ crsctl modify resource

Parse error:

Argument ‘resource’ is missing a value

Usage:

crsctl modify resource -attr
“[,…]” [-f] [-delete] [-i]

: {= |
@=}

: {@SERVERNAME()[@DEGREEID()] |

@CARDINALITYID()[@DEGREEID()] }

where

resName Modify named resource

attrName Attribute name

value Attribute value

server Server name

cid Resource cardinality ID

did Resource degree ID

-f Force option

-delete Delete named attribute

-i Fail if request cannot be processed immediately

$ crsctl modify
resource ora.TEST.db -attr AUTO_START=always

 



 

Filed Under: Oracle, Oracle Database Tagged With: why-database-not-startup-automatic in 11gR2 cluster

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • Password Version in oracle
  • How to login as user without changing the password in Oracle database(alter user identified by values)
  • How to check encrypted tablespace in the Database
  • How To Export -Import TDE Master Encryption Key
  • How to Configure Auto Login TDE Wallet

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us