I am migrating a database to 10g (from 9i) to a new server. The database is the backend for Forms and Reports (currently running 9iAS). How will moving the database to a new server and upgrading affect the current application server environment? Other than changing the TNS entry on the Web server to point to the new database, what other changes do I need to make?

    Requires Free Membership to View

    Login

Migrating the backend database from 9i to 10g should be pretty painless. The application server, Forms and Reports are all certified for both databases. I would highly recommend that you set up a test environment and ensure that your application will work with the 10g database. Sometimes it goes without a hitch; other times some of the SQL needs to be tweaked. As far as changes to see the new server, you will need to update the TNSnames of course, DADs on the OHS, and if you have JDBC connections, those also need to be updated as the thin connection does not normally use TNSnames. My experience migrating the database to 10g has been easy, but there is always a gotcha, so test first.

This was first published in October 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top