Oracle Tips by Burleson
Example Dbora script.
To call the above scripts, entries are
needed in the appropriate init.d or rc.d directories corresponding
to the run level at which Oracle needs to be stopped or started.
Usually start in levels 2, 3, and 4, and shut down in 0 and 6.
To accomplish this, you will place links
from the rc2.d, rc3.d, rc4.d, rc0.d, and rc6.d subdirectories to the
Dbora script. The links are usually of the form SnDbora or KnDbora,
where n is an integer corresponding to the order of other start or
stop calls are present: S means start the database, K means kill it.
Typically, you will want an S99Dbora entry in levels 2, 3, and 4
directories, and a K01Dbora entry in levels 0 and 6. The commands
lsnrctl, dbstart, and dbshut may have to be full-path’ed depending
on your environment. The startup links are formed with these
See Code Depot
One the script Dbora is in place and the
links have been created on Linux, you must run the insserv command
to tell the various configuration scripts where the Dbora file is
located. The insserv command is available from the root user.
If you get an error on Linux such as:
/etc/init.d/Dbora: bad interpreter:
this indicates that the program was written
in a Windows environment and was not properly converted to UNIX
format. I suggest getting a program called dos2unix; at the time of
this writing it was available at http://www.bastet.com/software/software.html.
Also, be sure you have the proper execute privileges set on the
On all systems, manual startup is
accomplished via the supplied scripts, through the SVRMGR, or, in
the later Oracle8i and Oracle9i releases, through the SQLPLUS
program. To start up a database using SVRMGR or SQLPLUS, use the
following procedure. The command used is STARTUP; its format
See Code Depot