{"id":614,"date":"2009-03-19T11:54:53","date_gmt":"2009-03-19T09:54:53","guid":{"rendered":"http:\/\/www.ora-solutions.net\/web\/?p=614"},"modified":"2009-03-23T21:27:07","modified_gmt":"2009-03-23T19:27:07","slug":"autostart-oracle-services-at-clusterware-startup","status":"publish","type":"post","link":"https:\/\/www.ora-solutions.net\/web\/2009\/03\/19\/autostart-oracle-services-at-clusterware-startup\/","title":{"rendered":"Autostart Oracle Services at Clusterware startup"},"content":{"rendered":"

I recently recommended the utilization of Oracle Services to a new client. I knew that you have to start a service manually if you restart your cluster. I told them that I will investigate on how to set the services to autostart. I knew that there is an AUTO_START property of the clusterware service resource set to “restore”, which means that at instance crash, Clusterware will restore the services to the status before crash. However, on manual shutdown\/startup, the services will not be autostarted.<\/p>\n

[root@ora-vm1 tmp]# crs_stat -p ora.MDDB.S_TEST.MDDB1.srv
\nNAME=ora.MDDB.S_TEST.MDDB1.srv
\nTYPE=application
\nAUTO_START=restore
\n…<\/p><\/blockquote>\n

I did some research and learned that the easiest way to configure autostart is with user callouts. A quick web search referred me to the OTN site “Real Application Clusters Sample Scripts”<\/a> which contains a FAN callout script to autostart services<\/a>.<\/p>\n

The steps to install the scripts are:<\/p>\n

    \n
  1. Copy them to $ORA_CRS_HOME\/racg\/usrco on both nodes<\/li>\n
  2. Set permissions to 710 and ownership to oracle:oinstall or whatever your installation is using.<\/li>\n
  3. Modify perl Scripts to contain your ORA_CRS_HOME, ORACLE_HOME. Moreover, if you have used short hostnames for your CRS installation, you have to change “\/bin\/hostname” to “\/bin\/hostname -s”.<\/li>\n<\/ol>\n

    I just realized that Dan Norris<\/a> also blogged about this topic.<\/p>\n","protected":false},"excerpt":{"rendered":"

    I recently recommended the utilization of Oracle Services to a new client. I knew that you have to start a service manually if you restart your cluster. I told them that I will investigate on how to set the services to autostart. I knew that there is an AUTO_START property of the clusterware service resource […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[13,14,35],"tags":[],"class_list":["post-614","post","type-post","status-publish","format-standard","hentry","category-10g","category-11g","category-real-application-clusters-oracle-database-2"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/614","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/comments?post=614"}],"version-history":[{"count":6,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/614\/revisions"}],"predecessor-version":[{"id":619,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/614\/revisions\/619"}],"wp:attachment":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/media?parent=614"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/categories?post=614"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/tags?post=614"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}