Solution to Oracle dbstart failure
Solution to Oracle dbstart failure
[Oracle @ CentOS-1 ~] $ Dbstart
ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Usage:/u01/app/oracle/product/12.1.0/dbhome_1/bin/dbstart ORACLE_HOME
Modify dbstart and dbshut files
"/U01/app/oracle/product/12.1.0/dbhome_1/bin/dbstart"
# First argument is used to bring up Oracle Net Listenerexport ORACLE_HOME_LISTNER = $ ORACLE_HOME # ORACLE_HOME_LISTNER = $ 1if [! $ ORACLE_HOME_LISTNER]; then
Echo "ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener"
Echo "Usage: $0 ORACLE_HOME"
Else
LOG = $ ORACLE_HOME_LISTNER/listener. log
# Set the ORACLE_HOME for the Oracle Net Listener, it gets reset
# A different ORACLE_HOME for each entry in the oratab.
Export ORACLE_HOME = $ ORACLE_HOME_LISTNER
Comment out the red part and add the blue part of the code.
[Oracle @ centos-1 ~] $ Vi/u01/app/oracle/product/12.1.0/dbhome_1/bin/dbshut
# The this to bring down Oracle Net Listenerexport ORACLE_HOME_LISTNER = $ ORACLE_HOME # ORACLE_HOME_LISTNER = $ 1if [! $ ORACLE_HOME_LISTNER]; then
Echo "ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener"
Echo "Usage: $0 ORACLE_HOME"
Else
LOG = $ ORACLE_HOME_LISTNER/listener. log
# Set the ORACLE_HOME for the Oracle Net Listener, it gets reset
# A different ORACLE_HOME for each entry in the oratab.
Export ORACLE_HOME = $ ORACLE_HOME_LISTNER
# Stop Oracle Net Listener
If [-f $ ORACLE_HOME_LISTNER/bin/tnslsnr]; then
Echo "$0: Stoping Oracle Net Listener" >>$ LOG 2> & 1
$ ORACLE_HOME_LISTNER/bin/lsnrctl stop >>$ LOG 2> & 1 &
Else
Echo "Failed to auto-stop Oracle Net Listener using $ ORACLE_HOME_LISTNER/bin/tnslsnr"
Fi
Fi
After the retry, the command does not go wrong, but does not respond.
$ Su root
Modify/etc/oratab
Orcl:/u01/app/oracle/product/12.1.0/dbhome_1: N
Modify
Orcl:/u01/app/oracle/product/12.1.0/dbhome_1: Y
Retry successful
-------------------------------------- Split line --------------------------------------
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian
-------------------------------------- Split line --------------------------------------