I have to continue maintaining an Oracle 8i database that receives information (about 20 Inserts and Updates a day) from a 9i database. I am upgrading the 9i database to 11g which does not support database links to 8i.
The plan is to link from Oracle 11g to Oracle 10 XE and then to the 8i and hope that one day I won’t have to do this.
I have already found articles noting that installing XE after any other version is not recommended.
Has anyone installed XE and another Oracle version side by side? What order was used and what problems were encountered?
Edit: @George3 some forum posts indicate that you can use JDBC drivers to connect 11g and 8i. Please add some detail and post it as answer.
It appears that you don’t need to worry too much.
Install XE first. You don’t get to choose the database name (XE) or the port (1521).
Next, install 11g to the default app folder.
Modify the TNSNAMES.ora files for both databases so they know about each other. Test connections and create database links and you are good to go.
Could you write a script on the 8i database that exports the data to a flat file? Then copy those flat files to the 11g database to import them?