Oracle Utilities - Using Hidden
Programs, Import/Export, SQL Loader, oradebug, Dbverify, Tkprof and
More
Utilities for Starting and Stopping Databases
Oracle provides two UNIX scripts that assist DBAs with starting and
stopping the database: dbstart and dbshut. For Windows platforms, the
oradim utility is provided for starting and stopping the Oracle
instance.
The dbstart utility reads the oratab file, shown in the example below.
The oratab file will reside in either /etc or /var/opt/oracle, depending
on the UNIX version. It contains three data items separated by colons:
The first field is the Oracle SID. The second field is the home
directory for that Oracle SID. The Y or N instructs Oracle whether to
start or stop the particular database when either the dbstart or dbshut
command is issued. The dbstart command simply parses the oratab file and
starts those databases that have a Y in the third field. It also uses
the ORACLE_HOME specified in the file to connect internally to the
database and issue the startup command.
The dbstart command can be added to the UNIX servers’ initialization or
run level scripts. This enables dbstart to be executed each time the
machine is booted or when it changes run levels. The method for
implementing this is platform specific, as we see below.
The above is an excerpt from Oracle Utilities - Using
Hidden Programs, Import/Export, SQL Loader, oradebug, Dbverify, Tkprof
and More by Rampant TechPress.
For more details on Oracle
utilities, see the book "Advanced
Oracle Utilities" by Bert Scalzo, Donald K. Burleson, and Steve Callan.
You can buy it direct from the publisher
for 30% off directly from
Rampant TechPress.
