Re: 2nd Instance & TNSNAMES.ORA

Hi

You should first change the LISTENER.ORA file in order for the Listener to listen on the new instance. Once you've done this you're problem should be sorted out.

Hope this helped.

Cheers
akader_at_health.sanlam.co.za

John Steinbach <bach_at_bartlett.com> wrote in article <344409B5.E2C5AEFE_at_bartlett.com>...
> I finally got my second instance up on 7.3.3. However...what changes are
> needed in the TNSNAMEs.ora file? I tried to copying the entry for the
> ORCL instance and changing the SID but this just rendered both instances
> unavailable. Is it the port settings?
>
> Dazed and confused.
> John Steinbach
>
>
Received on Thu Oct 23 1997 - 00:00:00 CDT