OraFAQ Forum: Server Administration » How to know currently running databases in single server ?

Home » RDBMS Server » Server Administration » How to know currently running databases in single server ? (ORACLE 10g , LINUX / UNIX)

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

How to know currently running databases in single server ? [message #468492]

Fri, 30 July 2010 04:58

satishwithoracle
Messages: 9
Registered: January 2008

Junior Member

Hi,

I have installed three database in MY Linux server. I have started Instance for all database and started database also .

No I want to check my databases status or currently running database How can I know . Or which Dynamic View or Database dictionary I should use ?

pl. Let me know

Thanks

Report message to a moderator

Re: How to know currently running databases in single server ? [message #468497 is a reply to message #468492]

Fri, 30 July 2010 05:10

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

Linux command prompt

Ps -ef | grep oracle

Sqlplus

SQL> desc V$instance;
 Name                                      Null?    Type
 ----------------------------------------- -------- ---------------------------
 INSTANCE_NUMBER                                    NUMBER
 INSTANCE_NAME                                      VARCHAR2(16)
 HOST_NAME                                          VARCHAR2(64)
 VERSION                                            VARCHAR2(17)
 STARTUP_TIME                                       DATE
 STATUS                                             VARCHAR2(12)
 PARALLEL                                           VARCHAR2(3)
 THREAD#                                            NUMBER
 ARCHIVER                                           VARCHAR2(7)
 LOG_SWITCH_WAIT                                    VARCHAR2(15)
 LOGINS                                             VARCHAR2(10)
 SHUTDOWN_PENDING                                   VARCHAR2(3)
 DATABASE_STATUS                                    VARCHAR2(17)
 INSTANCE_ROLE                                      VARCHAR2(18)
 ACTIVE_STATE                                       VARCHAR2(9)
 BLOCKED                                            VARCHAR2(3)

[Updated on: Fri, 30 July 2010 05:12]

Report message to a moderator

Re: How to know currently running databases in single server ? [message #468531 is a reply to message #468492]

Fri, 30 July 2010 10:11

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ps -eaf | grep smon

Then for each one try to connect and query v$instance and v$database to know the actual status.

Regards
Michel

Report message to a moderator

Previous Topic:	table have been update/modify in oracle 9
Next Topic:	When we start database which file is accessed fist.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 22:06:34 CDT 2024