Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Application written in Perl and Java. Right steps for db upgrade testing?

849425May 11 2011 — edited Oct 15 2014

I am oracle dba and in test of upgrade 10g db to 11gr1.

I did every steps and upgraded the db instance.

However when I asked the developer to test their part, I was told they cannot test because: because a application environment was not setup prior to the database upgrade.

Then the developer gave me his version of steps for him to do successful upgrade:

1. Copy perl from prod server
2. Install Oracle 10.2.0.2.0
3. Copy /u1/app from prod server
4. Install basic database objects for app JPL
5. Test and make sure it works.
6. Upgrade Oracle to desired version
7. Upgrade perl to talk to new Oracle
8. Make sure JPL still works.

Plus he emphasis that all the ORACLE_HOME should be same exact structure /name as the prod server.

Are those sounds right?

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 30 2011

Added on May 11 2011

#database-connectivity-discussions

5 comments

159 views