starting oracle db instance

[tomecki24]

Hello,

I've got a script for starting db instance on Solaris 7 startup. But there is an error in it. Could You tell if the script is ok?
Here it is:

#!/bin/ksh -
#script for Oracle
ORACLE_SID=myDB
export ORACLE_SID
su -o oracle -c svrmgrl <<EOF
connect internal
startup
EOF

Thanks
Tomasz

 

[rcurva]

Here's a little twist from your script.

1. Create a script called dbstart.sh, save it in $ORACLE_HOME/bin.

#dbstart.sh
svrmgrl << EOF
connect internal
startup
EOF


2. Replace your script with this one instead.

#!/bin/ksh -
#script for Oracle
su - oracle -c &quot;cd $ORACLE_HOME/bin; export ORACLE_SID=myDB; dbstart.sh&quot;

Hope this one helps.