Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

oracle instance status check

ra.Jun 24 2008 — edited Oct 4 2010
Hai,

This is my scenario. I am having 50 production database servers.
My oracle database is 8i,9i and 10g in Windows and Linux environmnet.

My question is, From remote network place, I need to check whether the instance in up or not for all the 50 production servers. Do not reply like just connect using username and password or using TNSPING. Tell the way to check database status is open or not. Because i am using script to check whether database is opeb or not.


TNSPING will check only listener is up or not. It won't check instance is up or not.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2010
Added on Jun 24 2008
#general-database-discussions
16 comments
40,574 views