Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Cannot connect as internal.
From a command prompt issue the following command 'set oracle_sid=123' then start server mgr within the same command window. The sid will remain in effect for this window only, however you can start sql*plus from the command prompt as well as server manager. If you start sql*plus from the start menu the sid used will be the one set in the NT registry.
kif_at_worldnet.att.net wrote in article
<624s4q$eua_at_bgtnsc02.worldnet.att.net>...
> I have 3 instances running on Oracle 7.3/ Win NT 4.0. I have set the
Oracle
> sid as 'ABC' in the NT registry. When I try to connect as internal it
connects
> to instance 'ABC'.
> To access the other instance I change the instance at svrmgr> by giving
the
> command 'set instance <instance name>', and then try to connect as
internal.
> I am not able to connect as internal in this case. But if I change the
> instance name in the NT registry it works.
> Is there a way to connect as internal without changing the instance name
in
> the registry.
>
> Thanks in advance
>
Received on Thu Oct 16 1997 - 00:00:00 CDT