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,
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:
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
Last edited by robotronic; 08-22-2007 at 01:57 PM..
I have a reseller account with hostgator, which means i have WHM and Cpanel. I have set up a staging environment for one of my wordpress installations (client website), which is essentially sitting at staging.domain.com (live site is at domain.com). The staging website is a complete copy of the... (1 Reply)
HI,
I am using perl LWP for connecting to online databases.
some times i will get connection fail.
I want to keep track of that error and again i want to connect.
i.e when i get connection fail the program should not stop it should
try to connect.
I can check connection fail has... (1 Reply)