Home » RDBMS Server » Server Administration » How to find database status
How to find database status [message #300907] Mon, 18 February 2008 11:54 Go to next message
itguru
Messages: 19
Registered: July 2007
Junior Member
how to find database status Eg.in nomount , mount or open stage.


If database/instance in nomount stage & how to close instabce.

If shutdown command is given it close instance but gives error database is open.

from mount stage is it possible to take it in nomount stage.
Re: How to find database status [message #300909 is a reply to message #300907] Mon, 18 February 2008 12:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Check administrators guide.
http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/start.htm#8918
Re: How to find database status [message #300922 is a reply to message #300907] Mon, 18 February 2008 13:15 Go to previous messageGo to next message
itguru
Messages: 19
Registered: July 2007
Junior Member
still loooking forward for way to find out instance mode.


how to find database status Eg.in nomount , mount or open stage
Re: How to find database status [message #300923 is a reply to message #300922] Mon, 18 February 2008 13:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you have a look at v$database and v$instance?

Regards
Michel
Re: How to find database status [message #300927 is a reply to message #300923] Mon, 18 February 2008 13:50 Go to previous messageGo to next message
itguru
Messages: 19
Registered: July 2007
Junior Member
Michel Cadot wrote on Mon, 18 February 2008 13:22
Did you have a look at v$database and v$instance?

Regards
Michel




if datase is not open these views are are not working

oracle 9.0.1 windows xp
Re: How to find database status [message #300928 is a reply to message #300907] Mon, 18 February 2008 14:14 Go to previous messageGo to next message
BlackSwan
Messages: 25038
Registered: January 2009
Location: SoCal
Senior Member
Look at the tail end of the alertSID.log file
Re: How to find database status [message #300929 is a reply to message #300927] Mon, 18 February 2008 14:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
if datase is not open these views are are not working

Did you check it?

Regards
Michel
Re: How to find database status [message #300932 is a reply to message #300927] Mon, 18 February 2008 14:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> startup mount
ORACLE instance started.
Total System Global Area  209715200 bytes
Fixed Size                  1289748 bytes
Variable Size             142606828 bytes
Database Buffers           62914560 bytes
Redo Buffers                2904064 bytes
Database mounted.
SQL> select open_mode from v$database;
OPEN_MODE
----------
MOUNTED

1 row selected.

Regards
Michel
icon14.gif  Re: How to find database status [message #300933 is a reply to message #300932] Mon, 18 February 2008 14:40 Go to previous messageGo to next message
itguru
Messages: 19
Registered: July 2007
Junior Member
Thanks Smile


Michel Cadot wrote on Mon, 18 February 2008 14:28
SQL> startup mount
ORACLE instance started.
Total System Global Area  209715200 bytes
Fixed Size                  1289748 bytes
Variable Size             142606828 bytes
Database Buffers           62914560 bytes
Redo Buffers                2904064 bytes
Database mounted.
SQL> select open_mode from v$database;
OPEN_MODE
----------
MOUNTED

1 row selected.

Regards
Michel


Re: How to find database status [message #300970 is a reply to message #300933] Mon, 18 February 2008 20:13 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Do you understand about the underline tables, fixed tables? Find it in the link http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/start.htm#8918

that Mahesh Rajendran gave before!
Re: How to find database status [message #302807 is a reply to message #300907] Wed, 27 February 2008 01:16 Go to previous messageGo to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

Hi,

You can check the database status whether it is mounted or open mode from v$database view:-

sql> select open_mode from v$database;

again if the database in nomount statge, and the shut command is not working you can make it in mount statge:-

sql> startup force mount;
sql>shutdown immediate;
Re: How to find database status [message #302812 is a reply to message #302807] Wed, 27 February 2008 01:32 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What don't you like in the demo I made?

Regards
Michel
Previous Topic: how to see the list of installed patches
Next Topic: Network acls problem on 11g
Goto Forum:
  


Current Time: Mon Dec 05 13:03:12 CST 2016

Total time taken to generate the page: 0.20951 seconds