Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Multiple Instances

Re: Multiple Instances

From: Kluged <kluged_at_ix.netcom.com>
Date: 1997/10/09
Message-ID: <343DB642.4EAF@ix.netcom.com>#1/1

check your tnsnames.ora, listener.ora and sqlnet.ora files on both client and server. the problem is most likely that you only have the name defined on one side of the connection.

Brian Camper wrote:
>
> Sorry for the newbie question, but we have to learn somehow. I am running
> into a problem of wanting to run multiple instances concurrently on our
> server. We have an instance ORCL, and FRA. ORCL is the default instance
> and I have no problem with that one. Both services are up and running and
> I can connect to the FRA when I am on actual server. The connect string I
> have to use is 2:fra. The next step I tried was creating a SQL Easy Net
> Config alias for the instance. I created it called cdtfra. When I try
> logging in remotely or local with SQL Easy Net Config, it comes back with:
>
> ERROR: ORA-12505: TNS:listener could not resolve SID given in connect
> descriptor
>
> If anyone can help, I would appreciate it very much. Thanks in advance.
> By the way, this is Oracle 7.3.3.0.0 on a Window NT network.
>
> Brian Camper
>
> brianc_at_cmhc.com
  Received on Thu Oct 09 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US