Re: How to check if the database is active

Gilberto,

I have done this in unix using a script. The code goes as follows:

sqlplus @ex << EOF
user/password
^M
^M

EOF
if [ $? -ne 0 ]
then
  .... database not up ....
else
  ... database is up ....
fi

Create a file ex.sql with this one line : exit;

Note: To type in the ^M in vi type ^V and then ^M

Hope this helps,
Abhijit Bhattacharya Received on Tue Jul 29 1997 - 00:00:00 CDT