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:
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_