Home » RDBMS Server » Server Administration » How to check the status of database (oracle 9.2.0,in Rhel 4)
How to check the status of database [message #307186] Tue, 18 March 2008 01:50 Go to next message
ahmed.nsa
Messages: 12
Registered: March 2008
Location: bangalore
Junior Member
Hi Senior's

How can I check the status of the database whether it has been started in Mount, nomount, read only, read write or open states?
Please help me out???????
Re: How to check the status of database [message #307190 is a reply to message #307186] Tue, 18 March 2008 01:57 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
v$database
v$instance

Regards
Michel
Previous Topic: Unable to drop user after upgrade
Next Topic: ora-01194 after creating control file
Goto Forum:
  


Current Time: Tue Dec 06 16:09:01 CST 2016

Total time taken to generate the page: 0.12604 seconds