OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Number of instance

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

Number of instance [message #239243]

Mon, 21 May 2007 17:40

sskdba2005
Messages: 7
Registered: June 2005
Location: Bangalore

Junior Member

I am using Oracle 9i and i want to know how to find the 'number of instance running on windows and unix'. Need help on this to find out answer.

Thanks in advance

Saravanan

Report message to a moderator

Re: Number of instance [message #239247 is a reply to message #239243]

Mon, 21 May 2007 17:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

number is 42

Report message to a moderator

Re: Number of instance [message #239249 is a reply to message #239247]

Mon, 21 May 2007 18:10

sskdba2005
Messages: 7
Registered: June 2005
Location: Bangalore

Junior Member

Number 42?... I could not get.

Could you please provide the steps to follow.

- Saravanan

Report message to a moderator

Re: Number of instance [message #239251 is a reply to message #239249]

Mon, 21 May 2007 18:15

sweetness
Messages: 10
Registered: May 2005
Location: Pasadena

Junior Member

Saravanan,

The previous reply of "42" was a bad joke. It was a reference to the cult classic "Hitchhiker's Guide to the Galaxy".

Ignore it.

Joe

Report message to a moderator

Re: Number of instance [message #239252 is a reply to message #239251]

Mon, 21 May 2007 18:18

sskdba2005
Messages: 7
Registered: June 2005
Location: Bangalore

Junior Member

ok fine np.

Can i have the answer for my question.

-- Saravanan

Report message to a moderator

Re: Number of instance [message #239265 is a reply to message #239252]

Mon, 21 May 2007 20:48

saibal
Messages: 111
Registered: March 2007
Location: India

Senior Member

query the view v$instance

Report message to a moderator

Re: Number of instance [message #239267 is a reply to message #239265]

Mon, 21 May 2007 20:58

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

FOR RAC Gv$INSTANCE

Report message to a moderator

Re: Number of instance [message #239402 is a reply to message #239243]

Tue, 22 May 2007 04:53

Brayan
Messages: 315
Registered: June 2002

Senior Member

In unix,

ps -ef | grep pmon

Brayan.

Report message to a moderator

Previous Topic:	ORA-01041: internal error. hostdef extension doesn't exist
Next Topic:	undo_tablespace - rollback segment OFFLINE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 25 06:17:16 CST 2025