Shulou(Shulou.com)06/01 Report--

Method 1:

Modify oratab (oracle users can)

Vi / etc/oratab

Change "N" to "Y" in orcl:/oracle/u01/product:N. Note: only uppercase, not lowercase.

Modify dbstart (can automatically start listening before starting the instance)

Vi $ORACLE_HOME/bin/dbstart

Change 1 in ORACLE_HOME_LISTNER=$1 to: ORACLE_HOME, as follows

ORACLE_HOME_LISTNER=$ORACLE_HOME

Modify rc.local (only root users have permission)

Vi / etc/rc.d/rc.local

Add a line: su-oracle-c $ORACLE_HOME/bin/dbstart or directly as follows:

Su-oracle-c dbstart

Run directly under the root user: / etc/rc.d/rc.local, that is, you can test the effect without restarting the system.

Method 2:

Modify oratab (oracle users can)

Vi / etc/oratab

Change "N" to "Y" in orcl:/oracle/u01/product:N. Note: only uppercase, not lowercase.

Instead of modifying the dbstart, add two lines to the rc.local:

Vi / etc/rc.d/rc.local

Su-oracle-c'$ORACLE_HOME/bin/lsnrctl start'

Su-oracle-c $ORACLE_HOME/bin/dbstart or:

Su-oracle-c 'lsnrctl start'

Su-oracle-c dbstart

In this method, you will be prompted to listen for warnings that have been turned on when you start the instance.

Summary: 1. The corresponding log files are $ORACLE_HOME/listener.log and $ORACLE_HOME/startup.log

2. Su-oracle-c can also be written as: su oracle-lc

3. You can verify the effect directly without restarting the system. Run / etc/rc.d/rc.local.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.