Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SeattleDBA

    How to check if db instance is working?

    Within pl/sql you will need to do some error handling by using SQLERRM and/or SQLCODE... since I am not a developer I will leave the actual syntax in your hands but they are well documented. select status from v$thread (should return OPEN) good luck.
  2. SeattleDBA

    How to check if db instance is working?

    If you are looking for a simple way to have some assurance that the database started and is functioning I would suggest two things. 1.) ps -ef | grep smon (the database wont run without this process) 2.) actively monitor the alert_log file for the instance.

Part and Inventory Search

Back
Top