Re: Many databases on one NT box

At work we have several small Oracle 7.3 databases running on a single NT machine using a single listener.
When using a single listener: are the other listeners and corresponding services stopped ?
Do you use TCP/IP as transfer protocol ? Then make sure that the listener.ora and and the entries in TNSNAMES.ORA use the same port.

When starting the graphical tools: In the login popup window there should be a field named "server" or "service" where you can enter the name of the service.

kind regards
Jens Waldorff

Bill Buchan <bbuchan_at_ossian.net> skrev i artiklen <6s4ade$1vl$1_at_phys-ma.sol.co.uk>...
> Hi,

  >
> I am trying to run several small Oracle databases on a single NT machine.
> They run fine from the command prompt but I would like to use the OEM
tools
> without having to keep changing ORACLE_SID in the registry. I thought
that
> the easiest thing to do would be to configure Net8 services for each of
the
> databases. However, regardless of whether I use a single listener with
many
> database services or one listener per instance, I get "ORA-12505 TNS:
> listener could not resolve SID given in connect descriptor" for all but
the
> first instance I set up (which connects okay). The other databases
appear
> in the tnsnames.ora and listener.ora files on the server.
>
> Which is the correct approach (multiple databases per listener, or
multiple
> listeners - one per database), and how might I get round this error?
>
> Alternatively, is there any other way to access different databases
through
> the graphical tools without having to modify the registry?
>
> Any help would be very much appreciated,
>
> Thanks
>
> - Bill.
>
>
>
>
Received on Sat Sep 19 1998 - 06:58:47 CDT