Brian Peasland wrote:
>> 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
>
>
Or install Cygwin, and do as suggested :)
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Thu Apr 27 2006 - 12:59:26 CDT
