DataBase Online Or Not - UNIX and Linux Applications

molanfx · #1 (**permalink**) 08-14-2007

Hey every one,

I am new here, and work as DBA ,can I ask if there any tools can installed or command help me to know if the current DB still connected or not ? The DB that work on is so disturbing, your response are highly appreciated,

Note : DB is Oracle and the OS is certain Unix.

Best Regards

zazzybob · #2 (**permalink**) 08-14-2007

I'm a sysadmin, not a DBA (we have our own Oracle DBAs in house), but I know that you can use the lsnrctl command to show if the listeners are active

Code:

$ORACLE_HOME/bin/lsnrctl status

Cheers
ZB

robotronic · #3 (**permalink**) 08-14-2007

Testing if "the current DB still connected or not" doesn't really mean anything. I think you need to know "if the database is open", and so if user's connections are allowed. For that, you can run this simple script on the Oracle server machine:

Code:

USER="myuser"
PASS="mypassword"
$ORACLE_HOME/bin/sqlplus -s ${USER}/${PASS} <<EOF >/dev/null 2>&1
whenever oserror exit 98;
whenever sqlerror exit 99;
exit 140;
EOF

if [ "$?" -ne 140 ]
then
   echo "Oracle is down!"
else
   echo "Oracle is up."
fi

Of course, you can try to run this also on a client machine, although the result will be inaccurate: you may not be able to connect to the database for other problems (i.e. listener down) but the database on the server is up & running.

Hope this helps

vitchi · #4 (**permalink**) 07-21-2008

hi,

you can aslo use the commande:

# ps - ef | grep ora

just to see if all process are up or not.

Not: this can be used as first in order to know if the process which are handling oracle are Up or Not.

Thx.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to reconnect to online database?	vanitham	High Level Programming	1	10-27-2007 06:29 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode