Database Link Oracle 8i to 9i [message #67422] |
Thu, 15 July 2004 00:17 |
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 |
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
|
|
|