Can this be caused by using two instances on the same TCP/IP port/socket?
I would suggest to change the socket number to som other value (outside the
'well known range of TCP/IP) in the .ORA files both on server and client and
try to connect again. Please note that you will have to start at least the
instacnce that has a different port number.
Hope this helps!
Jan Willem
Bernd Maierhofer wrote in message <7dqm8j$ard$1_at_orudios.magnet.at>...
>My first database works perfectly well, in connecting to a second one, I
>fail. maybe someone of you can tell me, what I am missing:
>Server: SQLSERVER, 198.12.1.2, WinNT, Oracle 8.05
>Database 1: Name: DB_A, SID: ORCA, Protokoll TCP/IP, Port 1512
>Database 2: Name: DB_B, SID: ORCB, Protokoll TCP/IP, Port 1512
>Both NT services are up and running.
>
>Connecting to DB_B fails with: TNS listener could not resolve given SID. If
>I choose BEQ as protocol, it works ok.
>
>Thank you for any input!
>
>Bernd Maierhofer - dato Denkwerkzeuge
>EDV-Projekte & Consulting
>
>
>
Received on Tue Mar 30 1999 - 11:39:27 CST
