Re: Multiple Databases

From: <mpir_at_compuserve.com>
Date: Mon, 29 Jun 1998 20:36:04 GMT
Message-ID: <6n8trk$k$1@nnrp1.dejanews.com>

1 Does your client tnsnames.ora include an entry for the second db

2 Has your listener been restarted to include the second db from its modified control file?

In article <Pine.LNX.3.96.980629113003.13525A-100000_at_valdez.netg.se>, Mikael Schonenberg <micke_at_netg.se> 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).=20
>
> I'd be more than grateful for any ideas on how to solve this...
>
> Mikael Sch=F6nenberg=09micke_at_netg.se=09Growing old is mandatory.
> NetGuide Scandinavia=09www.netg.se=09Growing wise is optional.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Jun 29 1998 - 15:36:04 CDT