| Re: how to start Oracle thru unix shell [message #96973] |
Fri, 05 October 2001 07:39 |
bharat
Messages: 11
Registered: February 2000
|
Junior Member |
|
|
hi shiva,
here is the script:
cd $ORACLE_HOME/dbs
if [[ -f sgadefDEVP.dbf ]]
then
echo "database up"
sqlplus -s scott/tiger<<!
var x number;
exec :x := 5;
print x
exit
!
else
echo "database down! about to start!!!"
sqldba lmode=y<<!
connect internal
startup
exit
!
fi
if any problem please contact...
bharat
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
