Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Upgrading oracle db 10.1.0.5 to 10.2.0.2 java issues

Re: Upgrading oracle db 10.1.0.5 to 10.2.0.2 java issues

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Tue, 18 Jul 2006 12:56:15 GMT
Message-ID: <J2Lny4.I28@igsrsparc2.er.usgs.gov>


dugmcgee_at_gmail.com wrote:
> Hi all,
>
> We are upgrading our oracle database from 10.1.0.5 to 10.2.0.2. has
> anyone had previous experience with this that they can point out
> potential pitfalls? I am talking more on the java side than actually
> the installation.
>
> We have a java system talking to the oracle database. One system is
> using hibernate, the other is using a DAO pattern with direct JDBC
> calls. Does anyone know if this change will effect the application and
> what changes we must do to accomadate? For example I know that oracle
> 10.2.0.2 has a different timestamp (oracle.timestamp) than that of it
> predecesor (sql.timestamp)
>
> We have a lot of stored procedures and soem direct JDBC calls to the
> database. Is anyonw aware of pitfalls or what type of testplans we must
> put together to test for issues?
>
> Much appreciated for the assistance.
> Dougless
>

I have not had any problems upgrading 10.1 to 10.2. My upgrades went smoothly. But no matter how *my* upgrades went, *your* upgrades may not be the same since we use different data and different applications. I strongly suggest setting up a test system running Oracle 10.1. Then upgrade that database to 10.2 and exercise your application against the upgraded database. There is no substitute for good testing. Good testing will point out the majority if your problem areas.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
Received on Tue Jul 18 2006 - 07:56:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US