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?
This question posed on 19 October 2005
Answer:
Migrating the back end 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
insure 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 needs 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.
