Home » RDBMS Server » Server Administration » Number of instance
Number of instance [message #239243] Mon, 21 May 2007 17:40 Go to next message
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
Re: Number of instance [message #239247 is a reply to message #239243] Mon, 21 May 2007 17:45 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
number is 42
Re: Number of instance [message #239249 is a reply to message #239247] Mon, 21 May 2007 18:10 Go to previous messageGo to next message
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
Re: Number of instance [message #239251 is a reply to message #239249] Mon, 21 May 2007 18:15 Go to previous messageGo to next message
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
Re: Number of instance [message #239252 is a reply to message #239251] Mon, 21 May 2007 18:18 Go to previous messageGo to next message
sskdba2005
Messages: 7
Registered: June 2005
Location: Bangalore
Junior Member

ok fine np.

Can i have the answer for my question.

-- Saravanan
Re: Number of instance [message #239265 is a reply to message #239252] Mon, 21 May 2007 20:48 Go to previous messageGo to next message
saibal
Messages: 111
Registered: March 2007
Location: India
Senior Member
query the view v$instance
Re: Number of instance [message #239267 is a reply to message #239265] Mon, 21 May 2007 20:58 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
FOR RAC Gv$INSTANCE
Re: Number of instance [message #239402 is a reply to message #239243] Tue, 22 May 2007 04:53 Go to previous message
Brayan
Messages: 315
Registered: June 2002
Senior Member
In unix,

ps -ef | grep pmon


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


Current Time: Thu Dec 05 00:05:26 CST 2024