using ORATAB to automate oracle startup


Q.  How do you automate starting and shutting down of databases in Unix?

Automatic startup can be done with /etc/oratab/ entyr of the linux machine.
Automatic shutdown we can’t configure in the entry.

Q.   What is stored in oratab file?

This file is used by ORACLE utilities.  It is created by root.sh and updated by the Database Configuration Assistant when creating a database.
A colon, ‘:’, is used as the field terminator.  A new line terminates the entry.  Lines beginning with a pound sign, ‘#’, are comments.
Entries are of the form:
$ORACLE_SID:$ORACLE_HOME:<N|Y>:
The first and second fields are the system identifier and home directory of the database respectively.  The third filed indicates to the dbstart utility that the database should , “Y”, or should not, “N”, be brought up at system boot time.
Multiple entries with the same $ORACLE_SID are not allowed.

If you are working on a server which has multiple oracle instances running on it then

Q. How do you see how many instances are running?

In unix, you can use the command line
% ps -ef|grep ora_

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s