Home » SQL & PL/SQL » SQL & PL/SQL » is the database UP ?
is the database UP ? [message #2099] Thu, 20 June 2002 13:39 Go to next message
Antonio
Messages: 12
Registered: October 2001
Junior Member
I need to make sure that the database is UP; we have many instances where the smon and pmon daemons stay up but the tablespaces are full and do not allow anybody to access the db. My dileman, is to ensure the database is UP by not looking at the smon/pmon daemons.
thank you
./antonio/.

Report message to a moderator

Re: is the database UP ? [message #2100 is a reply to message #2099] Thu, 20 June 2002 13:50 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you can use tnsping, whcih looks for both listener and DB.
tnsping <dbname/hostring>

Report message to a moderator

Previous Topic: PL/SQL ?
Next Topic: what is the resulting value when no row is selected
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 08:57:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.