This content has been marked as final. Show 10 replies
974011 wrote:ps -ef | grep -i pmon
three of the machines are RAC database and there is one single node database. How do I know if the DB will automatically startup with Linux machine?
and if does not automatically start how can I modify the DB's so that they will automatically start with the Linux Machine?Read The Fine Manual; Installation Guide
It's relatively easy to configure Oracle autostart on Linux. You basically have to make sure that there's correct oratab entry (/etc/oratab on RH Linux) and Oracle supplied startup/shutdown scripts are included into OS startup/shutdown sequence.
There're plenty [url http://www.dba-oracle.com/art_dbazine_ault_start_stop_db.htm]sites on the internet providing step-by-step instructions. Once you correctly executed the steps and tested the process it should work fine.
I guess I missed the RAC part. My bad.
For Oracle RAC Oracle Clusterware is responsible for the restart of individual resources and tracking dependencies. You'd be better of consulting official documentation for the details. At the end you have to make sure that the instances are in 'ENABLED' state and have all the right dependencies.
Do you use Oracle Restart for you single instance installation? If not then I already answered the question above otherwise HAS work in a similar way to CRS.
I assume we're talking about 11gR2.
Try the following:
ps -ef | grep ohas
In general if you use ASM you use Oracle Restart.
Here is the [url http://docs.oracle.com/cd/E11882_01/server.112/e25494/restart001.htm#ADMIN12709]documentation.
In fact it's not that complicated and if you use GUI tools (don't hate) such as asmca, netca, dbca all the components are automatically registered with Oracle Restart. If you don't then you can always use srvctl utility (same as in case of RAC) to start, stop, register, remove, check configuration of your services e.g. listener, asm, instances and much more. Actually there're a lot of similarities to Oracle Clusterware, but of cause it's just a single instance with all the simplifications that follow.
It's just very unpractical for me to type a page of text that would pretty much copy readily available documentation.
Hope it helps.
Edited by: Max Seleznev on Nov 29, 2012 9:06 PM