Question: I
inherited a new database and it shuts down every night at
midnight but I cannot find the shutdown script! I have
check the crontab for the oracle user and all jobs in
dbms_scheduler. Where else might an Oracle shutdown
job reside? Any idea how can I trace or locate what
launches the shutdown of the database?
Answer: Sadly, the
Oracle "shutdown" command is not easily traced since it often
comes-into Oracle from an external location! Any shell script
might have a shutdown command, not just the cron for the oracle
OS user ID.
- Check the "oratab" file (/etc/oratab
or /var/opt/oracle/oratab). The
third field in oratab specified whether autostart is being used.
- Check for dbstart and dbstop procedures in
/etc/rc.d/init.d/oracle
and check your
$ORACLE_HOME/rdbms/log/dbstop.log?
- Check ALL
user's crontab files, not just the Oracle ones (check
/etc/users)
For more complete details on Oracle shutdown scripts, see the
popular book "
Oracle
Shell Scripting".
