Re: many instances of Oracle on single machine

From: Brian Peasland <oracle_dba_at_nospam.peasland.net>
Date: Thu, 27 Apr 2006 14:59:55 GMT
Message-ID: <IyDyzy.E1n@igsrsparc2.er.usgs.gov>

> I am not sure if I'm correct but it's possible to set up many oracle
> databases on a single machine each will be accessed through different
> net listener , right ?

You can have more than one instance on the server. You do not need multiple listeners as one listener can support multiple instances. You can have multiple listeners, but there is rarely a benefit from this approach.

> how can I enumerate all oracle db running on a machine? is OCI helping?

In Unix/Linux, do as suggested 'ps -ef|grep pmon'.

In Windows, go to Control Panel->Administrative Tools->Services. Look for services with the name OracleServiceSID where SID is your database identifier.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Thu Apr 27 2006 - 09:59:55 CDT