Home » RDBMS Server » Networking and Gateways » Database Link Oracle 8i to 9i
Database Link Oracle 8i to 9i [message #67422] Thu, 15 July 2004 00:17 Go to next message
Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta
Member

Hi All

I am having two database at my end.

One is running on Oracle 8i and the Other on Oracle 9i.

I have been able handshake both using Database link.

Howvere I am succesfull in doing that only from 9i to 8i.

The other way round thats logging inside 8i and trying to access 9i data is not possible.

Necessary settings in tn.s ora file for both Datase machines done.

Is there anything else or any special setting in TNS.ora file required for this.

Thanks to all in advance

Regards

Atul
Re: Database Link Oracle 8i to 9i [message #67424 is a reply to message #67422] Thu, 15 July 2004 03:29 Go to previous message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

8i to 9i communication thru DBLink is also possible u just post the exact error which u r getting while connecting.

Along with that also send the output of following command from 8i server:

show parameter global_names

Daljit Singh
Previous Topic: oracle / ms sql distributed architectures:
Next Topic: Service Name - Oracle
Goto Forum:
  


Current Time: Wed May 01 05:11:39 CDT 2024