Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: clients can't connect to second instance!
One listener process can do the job as long as it is listening for both
SIDs. In listener.ora, the SID_LIST can have multiple SID_DESC entries.
Cheers,
Rich
In article <bai_2.2102$yr2.992_at_news.indigo.ie>,
"D. Oakley" <no-one_at_nowhere.com> wrote:
>
> Hi there, we have a basic Oracle 7.3 installation based on NT. I had
no
> problems setting up the NT clients with SQL Net Easy Config to
connect to
> the orcl instance. However, I have now added a second instance. I can
> connect to this instance from the oracle server machine (using
bequeath) ,
> but not from any of the clients! I used SQL Net Easy Config as before.
>
> I notice that there is only one TNS Listener process running on the
server
> machine - should there be one listener for each instance? Do i need to
> configure something else on the server side??
>
> Any advice would be appreciated,
> TIA.
>
>
--
Rich Goldkamp, Consultant, OCP RJGoldka_at_dcss.com Digital Consulting & Software Services (504) 523-5005 x2736
--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 12 1999 - 13:22:28 CDT