Solaris

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