Question:  I am migrating a database to (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?

Answer:  Migrating the backend database from 9i to 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 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 has been easy, but there is always a gotcha, so test first.