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

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: