OraFAQ Forum: Server Administration » How to find database status

Home » RDBMS Server » Server Administration » How to find database status

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to find database status [message #300907]

Mon, 18 February 2008 11:54

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.

Report message to a moderator

Re: How to find database status [message #300909 is a reply to message #300907]

Mon, 18 February 2008 12:01

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: How to find database status [message #300922 is a reply to message #300907]

Mon, 18 February 2008 13:15

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

Report message to a moderator

Re: How to find database status [message #300923 is a reply to message #300922]

Mon, 18 February 2008 13:22

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Did you have a look at v$database and v$instance?

Regards
Michel

Report message to a moderator

Re: How to find database status [message #300927 is a reply to message #300923]

Mon, 18 February 2008 13:50

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

Report message to a moderator

Re: How to find database status [message #300928 is a reply to message #300907]

Mon, 18 February 2008 14:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Look at the tail end of the alertSID.log file

Report message to a moderator

Re: How to find database status [message #300929 is a reply to message #300927]

Mon, 18 February 2008 14:20

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

if datase is not open these views are are not working

Did you check it?

Regards
Michel

Report message to a moderator

Re: How to find database status [message #300932 is a reply to message #300927]

Mon, 18 February 2008 14:28

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: How to find database status [message #300933 is a reply to message #300932]

Mon, 18 February 2008 14:40

itguru
Messages: 19
Registered: July 2007

Junior Member

Thanks

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

Report message to a moderator

Re: How to find database status [message #300970 is a reply to message #300933]

Mon, 18 February 2008 20:13

trantuananh24hg
Messages: 744
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!

Report message to a moderator

Re: How to find database status [message #302807 is a reply to message #300907]

Wed, 27 February 2008 01:16

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;

Report message to a moderator

Re: How to find database status [message #302812 is a reply to message #302807]

Wed, 27 February 2008 01:32

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What don't you like in the demo I made?

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 23:43:28 CST 2024