We have a 9i database runiing on machine A. We have 9IAS running on Machine B. We only use the oracle http server and mod_plsql in that server.
We want to upgrade to 11g. I would like to get some ideas/steps for testing the application.
1. Do you usually run upgrade script on the existing 9i db server or install a new 11g server and export schemas out from 9i and import into 11g. Which is better method?
2. Do we need to set up a file system also that is similar to the one used by production on the new test machine? I assume yes.
3. How do you roughly estimate the time for testing the application?