Home » RDBMS Server » Networking and Gateways » Connecting 9i to Oracle 7 - ORA-12560 TNS Protocol Adapter Error
Connecting 9i to Oracle 7 - ORA-12560 TNS Protocol Adapter Error [message #67509] Fri, 03 September 2004 01:42 Go to next message
Gert Willemsens
Messages: 15
Registered: September 2004
Location: Belgium
Junior Member
Hello,

One of our software developers encountered a problem at a customers site.

He has Oracle 9i installed on his laptop (9.2.0.1.0) and tries to connect to the customers database server. The server is the Oracle 7 Workgroup Server (7.3.4.0.0).

Our developer tries to make a connection using the Net Configuration Assistant of his Oracle 9, but the connection test fails with error ORA-12560 TNS Protocol Adapter Error.

I advised him to copy the connection info from tnsnames.ora on a working PC (running Oracle 7), but apparently this has no effect.

Does anyone know if there is a compatibility issue here, or is there another reason for the failure?

FYI: the server is pingable from the laptop.

 

Kind regards,

Gert Willemsens
Re: Connecting 9i to Oracle 7 - ORA-12560 TNS Protocol Adapter Error [message #67510 is a reply to message #67509] Sat, 04 September 2004 03:11 Go to previous messageGo to next message
Tak Tang
Messages: 142
Registered: May 2004
Senior Member
Hola,

An Oracle 9.2 client cannot talk to an Oracle 7.3.4 database.

Install an Oracle 9.0, or Oracle 8.1 client.

Tak
Re: Connecting 9i to Oracle 7 - ORA-12560 TNS Protocol Adapter Error [message #67633 is a reply to message #67509] Sat, 27 November 2004 01:14 Go to previous message
Isabel
Messages: 2
Registered: August 2002
Junior Member
I'm very new at this things but try to check if the service OracleServiceORCL is connected (start > control panel > administrative tools > services).
Previous Topic: ORA-01810: format code appears twice, followed by ORA-12560 !
Next Topic: Auto DB Start in Sun Solaris
Goto Forum:
  


Current Time: Fri Nov 22 03:16:27 CST 2024