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!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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.- SeattleDBA
- Post #7
- Forum: Oracle: All versions
-
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.- SeattleDBA
- Post #5
- Forum: Oracle: All versions
