Here is a very simple Unix shell script that will start an idle instance. There are more fancy things that can be added...

# START
sqlplus /nolog << EOF > o
connect id/[Email Address Removed] as sysdba;
exit
EOF

z=`grep -c idle o`

if test "$z" = "1"; then
sqlplus /nolog << EOF
connect id/[Email Address Removed] as sysdba;
startup
exit
EOF
fi

rm -fr o > /dev/null
# END


>>> "Tom Lombardi " <oracledba-ezmlmshield-x21355565.[Email address protected] 7/7/2005 3:07:11 PM >>>
Hello,

Does anyone have a script that can check the status of an instance (idle, mounted)
and issue a startup command if the instance is idle?

Thanks,

Tom Lombardi


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page