Database Upgrade

Microsoft Windows
1) 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? 2) Eventually I will be upgrading the application server to 10G as well. Is there anything specific I need to change in order to run Forms and Reports (all forms and reports reside on a shared server) under the new version? What are the files that I need to update? Help!

Answer Wiki

Thanks. We'll let you know when a new response is added.

As far as your database server migration, it sounds like you’re on the right track. TNSName entry mods are essential ofcourse. Ensure that your destination tablespaces have similar storage capacities as your source so you won’t get import errors. Make sure you’ve got the same Oracle schema/users setup on your destination Oracle database server, and you should be good.

Also, in reference to your future intention of upgrading and/or migrating to 10G App Server, the Upgrade Assistant utility should prove to be helpful. Check it out.

This forum should be very helpful too:

An asktom webpage also has good material:

Good luck!

Discuss This Question: 2  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Kurthp
    I just went through a similar exercise from 8i to 9i on Windows so I can only comment on question 1. Going to a new server is great cause you can set things up exactly as you want. Do alot of prep work. In my case, I had no DB creation scripts for 14 existing DBs. I used TOAD with DBA option to reverse engineer existing DBs. Then went through generated scripts and adjusted tablespace sizes etc. based on existing usage, available space, and potential growth. I also consolidated down to 12 DBs. I used original init.ora files and modified them to utilize 9i features and new file structures. Once this was all in place and file structures were created on new server, used the OraDim utility to create the new DB service. Then connect as SYS after setting your ORACLE_HOME and ORACLE_SID and run the create DB script: Startup Nomount pfile=F:oracleadminXXpfileinit.ora Run the Create Database script i.e. F:oracleadminXXcreatecreatedb.sql Then Run Catalog.sql and Catproc.sql Then create additional tablespaces and change default passwords for SYS and SYSTEM. Then run E:oracleora92sqlplusadminpupbld.sql; as SYSTEM. Then did full exports from old and full imports into new DBs. Then check for any invalid objects. For TNSNames entries, I instituted new names which was great because it allowed us to have both old and new in existence for testing. During a test window, old ones could be removed to ensure that apps were going where we thought they were going. DB servers continued to have both so that I could go back and forth and investigate any anomolies. Should also upgrade the Oracle client on the webserver to 10g. I know this is not 10g spcific but I hope it helps.
    195 pointsBadges:
  • Database Upgrade (Q/A) | Seek The Sun Slowly
    [...] Address: (0) Comments Read [...]
    0 pointsBadges:

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: