Auto restart of Oracle Database and DDS software in Linux single-instance Environment

Auto restart of Oracle Database and DDS software in Linux single-instance Environment

1. Modify/etc/oratab
# Vi/etc/oratab
Oradb:/opt/ora10/product/10.2.0.1: Y (changed from N to Y)

2. Modify/etc/selinux/config
# Vi/etc/selinux/config
SELINUX = disabled

3. Copy a system-configured PFILE to the dbs directory.
SQL> create pfile = '/oracle/pfile. ora' from spfile;
File created.
Oracle@bkjia.com ~ $ Cp/oracle/pfile. ora/oracle/product/10g/dbs/init. ora

4. Modify dbstart
Modify the 78th rows of dbstart ($ ORACLE_HOME/bin/dbstart)
ORACLE_HOME_LISTNER =/ade/vikrkuma_new/oracle
ORACLE_HOME_LISTNER = $ ORACLE_HOME

5. Modify/etc/rc. local.
[Oracle@bkjia.com etc] $ vi rc. local
#! /Bin/sh
# This script will be executed * after * all the other init scripts.
# Want to do the full Sys V style init stuff.
Touch/var/lock/subsys/local
Su-oracle-c '/oracle/product/10g/bin/lsnrctl start' ++ open the listener
Su-oracle-c '/oracle/product/10g/bin/dbstart' ++ open the database
Su-dds-c '/home/dds/ds/ddstart' ++ start the DDS Software
Su-dds-c '/home/dds/bin/dds_pweb-s' ++ start the WEB
Su-dds-c '/home/dds/bin/dds_pweb-t' +++ start the WEB

With the above five steps, when a single server loses power or is shut down in a plan, the Oracle database and DDS software can be automatically restarted after the server is started .......