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

Set power on (Linux) to automatically start Oracle shutdown and automatically shut down Oracle

1. Switch to the root user and make sure that the startup file and the closed file exist.

[oracle@oracle3 bin] $pwd

/ u01/oracle/product/10.2.0/db_1/bin

[oracle@oracle3 bin] $ls dbstart

Dbstart-the script that sqlplus calls when it executes startup

[oracle@oracle3 bin] $ls dbshut

Dbshut-the script that sqlplus calls when it executes shutdown

2. Modify oratab file

[oracle@oracle3 etc] $vim / etc/oratab

ORCL:/u01/oracle/product/10.2.0/db_1:Y-change N to Y

3. Test the correctness of startup files and closed files

/ u01/oracle/product/10.2.0/db_1/bin

[oracle@oracle3 bin] $export ORACLE_SID=ORCL

[oracle@oracle3 bin] $dbshut

[oracle@oracle3 bin] $sqlplus / nolog

SQL*Plus: Release 10.2.0.1.0-Production on Thu Jun 5 16:23:12 2014

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL > conn / as sysdba

Connected to an idle instance. The database is closed

Note: conn / as sysdba = conn sys/orcl as sysdba

SQL > conn sys/orcl as sysdba

Connected to an idle instance. Connecting to an idle routine indicates that the database is not started

SQL > conn sys/orcl@ORCL as sysdba

ERROR:

ORA-12514: TNS:listener does not currently know of service requested in connect

Descriptor

Warning: You are no longer connected to ORACLE. Because the database is closed, it cannot be accessed by listeners, and can only be connected as sysdba.

No matter what you do, you must connect and log in to verify the operating system's password file with the identity of sysdba.

[oracle@oracle3 bin] $dbstart-- Test startup files are available

Failed to auto-start Oracle Net Listene using / ade/vikrkuma_new/oracle/bin/tnslsnr

Processing Database instance "ORCL": log file / u01/oracle/product/10.2.0/db_1/startup.log

[oracle@oracle3 bin] $sqlplus / nolog

SQL*Plus: Release 10.2.0.1.0-Production on Thu Jun 5 16:30:35 2014

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL > conn / as sysdba

Connected. --

4. Write a shell script

[root@oracle3 ~] # cd / etc/rc.d/init.d

[root@oracle3 init.d] # touch start_shut

[root@oracle3 init.d] # vi start_shut

-

#! / bin/sh

OPT_=$1

Case "$OPT_" in

Start)

/ bin/echo "$0: (start)"

#

# your service startup command goes here

#

Su-oracle-c "/ u01/oracle/product/10.2.0/db_1/bin/lsnrctl start"

Su-oracle-c "/ u01/oracle/product/10.2.0/db_1/bin/dbstart"

# NOTE:Must exit with zero unless error is server

Chmod 1777 / tmp

Chown sys:sys / tmp

Exit 0

Stop)

/ bin/echo "$: (stop)"

#

# your service shutdown command goes here.

#

Su-oralce-c "/ u01/oracle/product/10.2.0/db_1/bin/dbshut"

Su-oracle-c "/ u01/oracle/product/10.2.0/db_1/bin/lsnrctl stop"

# Note: Must exit with zero unless error is server

Exit 0

*) / bin/echo''

/ bin/echo "Usage: $0 [start | stop]"

/ bin/echo "Invalid argument = = >\" ${OPT_}\ ""

/ bin/echo''

Exit 0

Esac

5. Modify permissions

[root@oracle3 init.d] # chmod 755 start_shut

6. Link the file to the startup area and the closed area

[root@oracle3 init.d] # cd / etc/rc5.d

[root@oracle3 rc5.d] # ln-s / etc/rc.d/init.d/start_shut S99start_shut

[root@oracle3 rc5.d] # cd / etc/rc0.d

[root@oracle3 rc0.d] # ln-s / etc/rc.d/init.d/start_shut K01start_shut

7. Test:

Init 6

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.