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
-
Go to /etc/rc3.d OR rc2.d, delete all S96init.cssd file/link.----as root
-
Go to /etc/rc3.d OR rc2.d, delete all S99dbora file/link.----as root
-
Create this new file in /etc/rc3.d as root.
-
vi S96init.cssd.
Insert this command in the file. Refer file attached
/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
- Change mod 775 to the file.
This is the step i use to auto stop the database n ASM:
-
edit the file /etc/rc0.d/K01dbora
-
Contents of K01dbora : /etc/rc0.d/dbora stop
-------------------------------------------------------------------
Some Info :
-
I didnt edit anything in /etc/inittab
-
I need to kill the lsvcrun process first in order to bring up the asm n database.
-
This is the content of dbora :
#!/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