Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Oracle 11.2.0.3 set up the startup script to enable ORACLE to start automatically

2025-01-16 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

After installation under Linux, you have to start the corresponding service each time with the following command:

Start the service dbstart

Start the monitor lsnrctl start

Start the console emctl start dbconsole

In this paper, we take Red Hat Enterprise Linux 6.4x86x64 + oracle11G as an example to set up oracle boot automatically:

Method 1:

Use the dbstart command for startup, as follows

First modify the / etc/oratab file, change N in orcl:/u01/app/oracle/product/11.2.0/dbhome_1:N to Y, and then add the following lines in / etc/rc.local

Su-oracle-c'$ORACLE_HOME/bin/dbstart'su-oracle-c'$ORACLE_HOME/bin/lsnrctl start'su-oracle-c'$ORACLE_HOME/bin/emctl start dbconsole'

If the ORACLE_HOMEH environment variable is not set, replace it with an absolute path, such as / dba/app/oracle/product/..

When you run dbstart for the first time, you usually get this error:

Su-oracle-c "dbstart"

ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener

This hint indicates

The oracle listening service is not started when the oracle service is started, so if you want to start the oracle service at the same time I start the listening service

You need to modify the dbstart/dbshut to set the ORACLE_HOME_LISTNER value to $ORACLE_HOME (originally $1)

Method 2:

Vi / etc/rc.local

Add the following

Su-oracle-c "export ORACLE_SID=orclsqlplus / nolog

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report