Re: Multiple Instances

I don't know for NT, but in UNIX... I read that you have to change the Oracle_SID
examples (depending on the Unix Shell):

sh - ORACLE_SID XXX; export ORACLE_SID csh - setenv $ORACLE_SID XXX

Please be advised that this is what I was told to do, and I too am not familiar with it myself...Just hoped I could point you to the right direction.
Satar Naghshineh
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 Mon Oct 06 1997 - 00:00:00 CDT