Usage : we can use dbstart script file in $ORACLE_HOME/bin to start database & listener.
[oracle@Linux03 bin]$ ps -ef|grep pmon
oracle 20588 19211 0 10:56 pts/0 00:00:00 grep pmon
[oracle@Linux03 bin]$ dbstart
Processing Database instance "orcl": log file /u01/app/oracle/product/12.1.0.2/db_1/startup.log
[oracle@Linux03 bin]$ ps -ef|grep pmon
oracle 20693 1 0 10:57 ? 00:00:00 ora_pmon_orcl
oracle 21035 19211 0 10:57 pts/0 00:00:00 grep pmon
[oracle@Linux03 bin]$
Common error with dbstart script :
Error : /u01/app/oracle/product/12.1.0.2/db_1/bin/dbstart: line 275: ORACLE_HOME_LISTNER: command not found
[oracle@Linux03 bin]$ dbstart
/u01/app/oracle/product/12.1.0.2/db_1/bin/dbstart: line 275: ORACLE_HOME_LISTNER: command not found
Solution : Edit dbstart script and change (~ line 275)
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