4

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.

4
  • 1
    Could a regularly scheduled job using JDBC take data from staging table(s) on 11g and insert/update 8i instead?
    – George3
    Sep 18, 2012 at 1:33
  • 1
    What about setting up a VM for 10XE? Or must these run on the same machine? Sep 21, 2012 at 12:56
  • It's easier if they run on the same machine. It could be done with a regular 10g and 11i so it seems possible with express.
    – kevinskio
    Sep 21, 2012 at 14:12
  • @George3 I'm not sure whether you've seen the edit for you in this post. Could you answer that question? Oct 27, 2012 at 8:58

2 Answers 2

1

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.

0

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?

1
  • I could create a folder on the 8i machine and then map that as a directory for the 11g database and then write csv files to it but this is not an optimal solution. You would need extra tables to log what was entered. Unfortunately I have views of tables on the 8i database that I did not mention that are used for other transactions on the 11g.
    – kevinskio
    Sep 27, 2012 at 12:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.