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?
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.
Dig deeper on Oracle Application Server
I get the ORA-12541 error message when I try to connect through
Forms6i and Reports6i Builder. I've started the listener. I have
no problems ...continue reading
We are using Oracle Database. In our client site, we have 500 users
using the database at one time. Sometimes the database objects
become invalid ...continue reading
I am facing the ORA-04076 error. I googled the error but was unable
to understand it. What exactly do I need to do to solve this? I am using Toad.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.