| unable to start asm database with dbstart [message #190202] |
Tue, 29 August 2006 12:23 |
hpaccess
Messages: 17
Registered: October 2005
|
Junior Member |
|
|
I have two separate oracle homes - one for ASM (ORA_ASM_HOME) and one for Oracle databases (ORACLE_HOME).
Try to configure dbstart to bring ASM, listener from ASM home and databases from Oracle home when system boot up.
Here are the steps i did:
$ cat /etc/oratab
CATALOG:/opt/app/oracle/product/10.2.0/oracle:Y
+ASM:/opt/app/oracle/product/10.2.0/asm:N
UCQAS:/opt/app/oracle/product/10.2.0/oracle:Y
*:/opt/app/oracle/product/10.2.0/grid/db10g:N
*:/opt/app/oracle/product/10.2.0/grid/oms10g:N
emrep:/opt/app/oracle/product/10.2.0/grid/db10g:N
-- i played chaning with W and Y, but both are not working
$ cat dbora
#!/bin/sh
# Description - This program call dbStart and dbShut which are custom created
# scripts which internally call dbstart and dbshut (provided by Oracle)
#
set -x
SLEEP_TIME=180
case $1 in
'start')
sleep $SLEEP_TIME
echo "Starting Oracle 10g databases"
su - oracle -c $ORACLE_HOME/bin/dbStart # &
;;
'stop')
echo "Shutting down Oracle 10g databases"
su - oracle -c $ORACLE_HOME/bin/dbShut # &
;;
*)
echo "usage: $0 {start|stop}"
exit 1
;;
esac
#
# exit
created 2 custom scripts to start and stop databases
$ cat dbStart
# !bin/sh
# Description - Custom scripts to start databases
#
set -x
ORACLE_HOME=/opt/app/oracle/product/10.2.0/asm
export ORACLE_HOME
#$ORACLE_HOME/bin/dbstart
lsnrctl start
ORACLE_HOME=/opt/app/oracle/product/10.2.0/oracle
export ORACLE_HOME
$ORACLE_HOME/bin/dbstart
$ cat dbShut
# !bin/sh
# Description - Custom script to stop databases
#
set -x
ORACLE_HOME=/opt/app/oracle/product/10.2.0/asm
export ORACLE_HOME
#$ORACLE_HOME/bin/dbshut
lsnrctl stop
ORACLE_HOME=/opt/app/oracle/product/10.2.0/oracle
export ORACLE_HOME
$ORACLE_HOME/bin/dbshut
Could some one please have a look at my problem?
Thanks,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
