OraFAQ Forum: Networking and Gateways » ORA-12504 TNS:listener was not given the SID in CONNECT

Home » RDBMS Server » Networking and Gateways » ORA-12504 TNS:listener was not given the SID in CONNECT_DATA

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12504 TNS:listener was not given the SID in CONNECT_DATA [message #66439]

Tue, 11 June 2002 08:21

Tom Wagner
Messages: 2
Registered: June 2002

Junior Member

the error occurs, when I try to connect to an Ora 7.3.4 DB with an Ora8 Client.
Connecting to the Ora7 DB with an Ora7 Client works well, also the connecting to an Ora8 DB with the Ora8 Client.

I�ve checked the tnsnames on client side and the listener on the network DB Host.
I think, the tnsnames is okay, cause stopping the listener on DB Host, my client says "no listener" and tnsping says also connection is okay.
I assume, the listener on my Ora7 DB host, don�t "understand" the message from my Ora8 Client tnsnames.
What�s the trick to connect to an Ora7DB with an Ora8 Client ?

Tnx
Tom Wagner

Report message to a moderator

Re: ORA-12504 TNS:listener was not given the SID in CONNECT_DATA [message #66575 is a reply to message #66439]

Wed, 07 August 2002 08:43

common
Messages: 1
Registered: August 2002

Junior Member

Hi, guy,

With Oracle 8.1.7 SQL*net connect to Oracle 7.3.4,
I encountered the same thing.

The tnsnames.ora had been checked, and it is OK.

The problem solved yet?

I think you may right, the ora8i is not compatable with Ora734's listener.

Further news, please drop me lines.

Thanks.

Report message to a moderator