Auto Start/Stop Didnt Work in Solaris 10

adzuanamir · #1 (**permalink**) 04-22-2008

Hi...all

database - 10g Rs 2 with ASM
platform - Sun Solaris V890 64bit

This is the step i use to auto start the database n ASM: (auto start can start but need to kill lsvcrun first)

1 dbora---script
2 start_shutdown_asm.ksh---script
3. Dbora file must be put under /etc/init.d directory and start_shutdown_asm.ksh must be put under /ek_ora/script directory.

Note : Please create the 'script' directory if it does not exist. Create ‘log’ directory in the ‘script’ directory. Also create ‘data’ and ‘arch’ in /ek_bkup

4. Go to /etc/rc3.d OR rc2.d, delete all S96init.cssd file/link.----as root

5. Go to /etc/rc3.d OR rc2.d, delete all S99dbora file/link.----as root

6. Create this new file in /etc/rc3.d as root.

7. vi S96init.cssd.

Insert this command in the file. Refer file attached

Code:

/etc/init.d/init.cssd start
sleep 10
kill -9 `ps -ef | grep lsvcrun | grep S96init.cssd | awk '{print $2}'`
sleep 30
/etc/init.d/dbora start

8. Change mod 775 to the file.

This is the step i use to auto stop the database n ASM:

1. edit the file /etc/rc0.d/K01dbora

2. Contents of K01dbora :
/etc/rc0.d/dbora stop

-------------------------------------------------------------------

Some Info :

1. I didnt edit anything in /etc/inittab
2. I need to kill the lsvcrun process first in order to bring up the asm n database.
3. This is the content of dbora :

Code:

#!/bin/sh
#export ORA_DB_HOME=/u01/app/oracle/product/10.2.0/db_1
#export SH=/apps/oracle/general/sh

ORA_DB_HOME=/ek_ora/10.2.0/db_1
SH=/ek_ora/script
export ORA_DB_HOME SH

ORA_OWNER=oracle
case "$1" in
    'start')
        # Start the Oracle databases:
        # The following command assumes that the oracle login
        # will not prompt the user for any values
      su - $ORA_OWNER -c "$SH/start_shutdown_asm.ksh start" >  /tmp/start_asm.log
      su - $ORA_OWNER -c "$ORA_DB_HOME/bin/dbstart $ORA_DB_HOME" > /tmp/dbstart.log
	su - $ORA_OWNER -c "$ORA_DB_HOME/bin/lsnrctl start" > /tmp/start_lsnrctl.log
      su - $ORA_OWNER -c "$ORA_DB_HOME/bin/emctl start dbconsole" > /tmp/emctl_start.log
        ;;
    'stop')
        # Stop the Oracle databases:
        # The following command assumes that the oracle login
        # will not prompt the user for any values
 	su - $ORA_OWNER -c "$SH/start_shutdown_asm.ksh stop" > /tmp/shutdown_asm.log
	su - $ORA_OWNER -c "$ORA_DB_HOME/bin/dbshut" > /tmp/dbshut.log
	su - $ORA_OWNER -c "$ORA_DB_HOME/bin/lsnrctl stop" > /tmp/stop_lsnrctl.log        
	su - $ORA_OWNER -c "$ORA_DB_HOME/bin/emctl stop dbconsole" > /tmp/emctl_stop.log
        ;;
esac

APPRECIATE TO ANYBODY TO HELP ME SOLVE THIS ISSUE. I'VE ALREADY REFER TO ORACLE METALINK AND THE NOTES IT SEEM DOESNT WORK

This is the logfile show that autostop didnt work...

Errors in file /ek_ora/admin/ekadaste/bdump/ekadaste_asmb_2759.trc:
ORA-15064: communication failure with ASM instance
ORA-03113: end-of-file on communication channel
Mon Mar 24 07:34:47 2008
ASMB: terminating instance due to error 15064
Instance terminated by ASMB, pid = 2759
Wed Apr 16 17:14:07 2008

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Hardware Change 715/33 715/100 HIL - PS2 - XServer didnt start ???	rbrandt1	HP-UX	0	06-05-2007 07:29 AM
how to start and stop the network in Solaris 9??	eldiego	UNIX for Dummies Questions & Answers	1	11-21-2005 08:28 PM
Help: how to start/stop FTP server in solaris?	eddsos	SUN Solaris	1	08-07-2005 01:32 PM
stop cdrom from auto-mounting	jalburger	UNIX for Dummies Questions & Answers	2	09-13-2004 11:56 PM
Start/Stop Script	jjv1	UNIX for Dummies Questions & Answers	2	12-16-2003 04:28 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by