Usage : we can use dbshut script file in $ORACLE_HOME/bin to shutdown database & listener.
[oracle@Linux03 bin]$ ps -ef|grep pmon
oracle 20693 1 0 10:57 ? 00:00:00 ora_pmon_orcl
oracle 21133 19211 0 11:01 pts/0 00:00:00 grep pmon
[oracle@Linux03 bin]$ dbshut
Processing Database instance "orcl": log file /u01/app/oracle/product/12.1.0.2/db_1/shutdown.log
[oracle@Linux03 bin]$ ps -ef|grep pmon
oracle 21287 19211 0 11:09 pts/0 00:00:00 grep pmon
[oracle@Linux03 bin]$
Error : Failed to auto-stop Oracle Net Listener using ORACLE_HOME/bin/tnslsnr
[oracle@Linux03 bin]$ dbshut
Failed to auto-stop Oracle Net Listener using ORACLE_HOME/bin/tnslsnr
Solution (same as above): edit dbshut script and change
From : ORACLE_HOME_LISTNER=$1
To : ORACLE_HOME_LISTNER=$ORACLE_HOME
Note :
One pre-req for this script to run is set 'Y' in /etc/oratab. This basically tell the script to start all database instance running of this home. while 'N' tells not to start db using dbshut script.
[oracle@Linux03 Desktop]$ grep 'orcl' /etc/oratab
orcl:/u01/app/oracle/product/12.1.0.2/db_1:Y
No comments :
Post a Comment