Home » RDBMS Server » Networking and Gateways » ORA-12504 TNS:listener was not given the SID in CONNECT_DATA
ORA-12504 TNS:listener was not given the SID in CONNECT_DATA [message #66439] Tue, 11 June 2002 08:21 Go to next message
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
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 Go to previous messageGo to next message
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.
Re: ORA-12504 TNS:listener was not given the SID in CONNECT_DATA [message #66648 is a reply to message #66439] Wed, 02 October 2002 18:14 Go to previous messageGo to next message
Tammy
Messages: 6
Registered: March 2001
Junior Member
This is awful late, but I changed where it said SERVICE_NAME in the tnsnames.ora to SID and it worked.
Re: ORA-12504 TNS:listener was not given the SID in CONNECT_DATA [message #66677 is a reply to message #66439] Fri, 11 October 2002 04:50 Go to previous message
Anastasia
Messages: 1
Registered: October 2002
Junior Member
That did the trick Tammy. It is strange that it made the connection at one time but it is working now and I am pleased. thanks!
Previous Topic: Installing oracel client
Next Topic: SQL* Net V2 Listener Error
Goto Forum:
  


Current Time: Thu Feb 29 16:56:38 CST 2024