RE: Database link 11g to 8i
- From: "Dunbar, Norman" <norman.dunbar@xxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <Jed_Walker@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 25 May 2010 10:55:04 +0100
Morning Jed,
>> Does anyone know of a way to get a database link from 11g to
>> 8i to work?
Yes, I think I do.
>> The only solution that sounds feasible is to have an
>> intermediate database at 10g and link 11g->10g, 10g->8i.
We had a 9i database that used to need to talk to a 734 database via a
link. What we did was set the system up so that there was a pair of
listeners on the 9i server. One running under 9i which was listening for
normal connections to the 9i database.
The other was an 8i listener which was listening for connections coming
from the 9i database (link) and connecting to the 734 database.
As far as I remember we had 8i installed on the database server where
the 9i database lived. We had a special listener running under the 8i
ORACLE_HOME with an entry in the 9i databases spfile for
*.local_listener. If I remember correctly, it was something like:
*.local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=9i_database_
server)(PORT=1234)))'
The database links from the 9i database to the 734 database were set up
with a USING option that took them to tnsnames.ora where the details
were set to use this 8i listener.
I'm sorry that I don't have all the full details but we had to do this
only once, it was a while back and isn't used now. Most of the evidence
is long gone!
It was most definitely the higher (9i) database talking down to the 734
database via database links though - that much I do remember.
You don't need a middle-ware database with database links in it, just a
middleware listener, running under a "common" version of Oracle. I
suspect that your 11g database could use a 10g listener to chat with the
8i database.
And one last thing, Oracle do not and will not support this arrangement
- they told us so!
Good luck.
Cheers,
Norman.
Information in this message may be confidential and may be legally privileged.
If you have received this message by mistake, please notify the sender
immediately, delete it and do not copy it to anyone else. We have checked
this email and its attachments for viruses. But you should still check any
attachment before opening it. We may have to make this message and any reply to
it public if asked to under the Freedom of Information Act, Data Protection Act
or for litigation. Email messages and attachments sent to or from any
Environment Agency address may also be accessed by someone other than the
sender or recipient, for business purposes. If we have sent you information
and you wish to use it please read our terms and conditions which you can get
by calling us on 08708 506 506. Find out more about the Environment Agency at
www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged.
If you have received this message by mistake, please notify the sender
immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should
still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under
the Freedom of Information Act, Data Protection Act or for litigation. Email
messages and attachments sent to or from any Environment Agency address may
also be accessed by someone other than the sender or recipient, for business
purposes.
If we have sent you information and you wish to use it please read our terms
and conditions which you can get by calling us on 08708 506 506. Find out more
about the Environment Agency at www.environment-agency.gov.uk
--
//www.freelists.org/webpage/oracle-l
Other related posts:
