Re: Multiple Databases

Hi,

    Check the files TNSNAMES.ORA and LISTENER.ORA within \ORANT\NETWORK\ADMIN on the server. Both should have references to the new SID's.

    Check TNSNAMES.ORA that the sid, alias, IP or Host and ports are what you expect. The TNSNAMES.ORA on the client should reflect the same.

    The modifications to LISTENER.ORA can be done by hand by adding a SID to the end of the list. Bounce the listener - start the services.

    Try sqlplus first on the server then the client.     If the client still is a problem. Check it's settings for TNSNAMES.ORA - should be same as server. Then try to TNSPING for the database alias (or IP address) to verify connection. If you don't get it, go back to the server and search for the LISTENER.LOG which should tell you something about how the client resolved the full SQL*Net connect string and attempted to contact the listener. HTH,
    Greg

Mikael Schonenberg wrote:

> Hiyas!
>
> Running 7.3.2.1 on an NT (obviously) and need to set up multiple
> databases. Creating two databases is not a problem, both with unique
> SIDs of course, and both seems to be running just fine (at least
> according to the Instance Manager) but I can't seem to be able to
> connect to the new (second) database in any way. SQLNet complaints
> that "ORA-12505: TNS:listener could not resolve SID given in connect
> descriptor". One would assume now, that I have confed SQLNet
> incorrect, giving it the wrong SID but I have checked that. The SID I
> use is the SID I told the Instance Manager to use when I set up the
> database (and, of course, the SID Instance Manager claims is running
> perfectly too).
>
> I'd be more than grateful for any ideas on how to solve this...
>
> Mikael Schönenberg micke_at_netg.se Growing old is mandatory.
> NetGuide Scandinavia www.netg.se Growing wise is optional.
Received on Tue Jun 30 1998 - 08:09:22 CDT