OraFAQ Forum: Linux » Only instance is auto start while system reboot

Home » Infrastructure » Linux » Only instance is auto start while system reboot (Oracle 11.2.0.2.0 , SUSE Linux Enterprise Server 11 sp1 64bit, )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Only instance is auto start while system reboot [message #506261]

Sat, 07 May 2011 13:30

snowball
Messages: 229
Registered: April 2006
Location: China

Senior Member

Hi, guys
I met a problem with Oracle 11g (11.2.0.2.0), when trying to auto startup the database on SUSE Linux Enterprise Server 11 sp1 64bit.

I have configurated these files to let Oracle auto startup along with SUSE reboot.

1. /etc/oratab

demo:/opt/app/oracle/product/11gR2/db_1:Y

2. wrote a script called "oracle" at /etc/init.d/

# cat /etc/init.d/oracle 
#!/bin/bash
#
#
#/etc/init.d/oracle
#
#
### BEGIN INIT INFO
# Provides: oracle
# Required-Start: $network
# Required-Stop: $network
# Default-Start: 3 5
# Default-Stop: 0 1 2 6
# Description: Oracle DB startup script
### END INIT INFO

ORACLE_OWNER="oracle"
ORACLE_HOME="/opt/app/oracle/product/11gR2/db_1"

case "$1" in
start)
        echo -n $"Starting Oracle DB:"
        su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME" && echo "DB started!"
;;

stop)
        echo -n $"Stopping Oracle DB:"
        su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME" && echo "DB stoped!"
;;

restart)
        echo -n $"Stopping Oracle DB:"
        su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME" && echo "DB stoped!"
        echo -n $"Starting Oracle DB:"
        su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME" && echo "DB started!"
;;

*)
echo $"Usage: $0 {start|stop|restart}"
esac

change the file permission:

# ll /etc/init.d/oracle 
-rwxr-x--- 1 root root 889 May  8 10:01 /etc/init.d/oracle

let this service at level 3 and 5 run:

# chkconfig --list | grep oracle
oracle                    0:off  1:off  2:off  3:on   4:off  5:on   6:off

After configurated there files, I did a reboot to test if oracle will auto startup.

Actually, I see a lot of process of oracle , but when I login to the database with sqlplus, it shows me "Connect to an idle instance."

So it's only start the instance and database is not open.

I test the service :

# service oracle start
Starting Oracle DB:Processing Database instance "demo": log file /opt/app/oracle/product/11gR2/db_1/startup.log
DB started!

I also trace the startup.log:

/opt/app/oracle/product/11gR2/db_1/bin/dbstart: Starting up database "demo"
Sun May  8 10:10:58 CST 2011


SQL*Plus: Release 11.2.0.2.0 Production on Sun May 8 10:10:59 2011

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

SQL> Connected to an idle instance.
SQL> ORACLE instance started.

Total System Global Area  304807936 bytes
Fixed Size                  2225992 bytes
Variable Size             134219960 bytes
Database Buffers          163577856 bytes
Redo Buffers                4784128 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

/opt/app/oracle/product/11gR2/db_1/bin/dbstart: Database instance "demo" warm started.

oracle@vmsuse:~> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Sun May 8 10:12:28 2011

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

Connected to an idle instance.

SQL> select * from v$instance;
select * from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>

It shows that the database is already open, but what I see in the sqlplus is that I still connect to an idle instance.

I tried to work it out, but I am still confuse why the startup.log give me the wrong result, how can I fix it?

Thanks very much,
Milo