Re: Accessing non-ORCL instance from SQLNet

Dick Willis wrote:
>
> This should be straightforward, but something is preventing me from
> connecting to an instance named XABC (for example) over SQLNet.
>
> Let's say that my new instance is named XABC. I can connect locally (
> Service name 2:XABC), no problems, but whenever I try to connect from
> another workstation, it comes back with the error
>
> ORA 12505 - TNS:Listener could not resolve SID given in connect
> descriptor.
>
> This is true whether I use the SYS, Internal, SYSTEM or other DBA-granted
> user account, or a CONNECT or RESOURCE-granted user account. It doesn't
> even seem to get to the point of authenticating a user.
>
> SysInfo: ORACLE 7.3
> SQLNet v2.0
> Win NT 4.0
>
> Thanks.

Check that your tnsnames.ora is looking for the correct SID name that corresponds to that which is ste on the machine where the instance is defined.

Nas Received on Wed Oct 08 1997 - 00:00:00 CDT