<div>
Hi,<br />
When you upgrade your oracle server from 9.2.0.2 to 9.2.0.8, you apply the patchset using the runinstaller but you have also to upgrade after the instances that already exist. <br />
It is also recommanded to take a backup of the db and the Oracle Home before running the upgrade.<br />
Cheers<br />

</div>


<div>
The readme.txt file (which will be provided with the patchset) will give you all the instructions you need for running the upgrade. All the functionnalities in your client application and stored procedures should continue to work after the upgrade but it doesn't prevent you to test them at the end of the operation.
</div>


<div>
ANy ideas how long it takes to do this? <br />
<br />
Are you patching teh database or the instance?<br />
<br />
I guess we still have to test everyghing to make sure it runs. right?
</div>


<div>
<div class="content wysiwyg-content">
Couple of question on upgrading oracle 9.2.0.2 to 9.2.0.8<br />
<br />
1) Is it simply just applying a patch set to the server?<br />
2) Do we have to retest every functionality in our client applictions and stored procedures afer upgrade?
</div>
</div>


Couple of question on upgrading oracle 9.2.0.2 to 9.2.0.8

1) Is it simply just applying a patch set to the server?
2) Do we have to retest every functionality in our client applictions and stored procedures afer upgrade?

Hi,
When you upgrade your oracle server from 9.2.0.2 to 9.2.0.8, you apply the patchset using the runinstaller but you have also to upgrade after the instances that already exist. 
It is also recommanded to take a backup of the db and the Oracle Home before running the upgrade.
Cheers


The readme.txt file (which will be provided with the patchset) will give you all the instructions you need for running the upgrade. All the functionnalities in your client application and stored procedures should continue to work after the upgrade but it doesn&amp;#39;t prevent you to test them at the end of the operation.

ANy ideas how long it takes to do this? 

Are you patching teh database or the instance?

I guess we still have to test everyghing to make sure it runs. right?

UpgradiingOracleDB9iR2

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.