Want to upgrade in Oracle database from 9i to 10g

[Former Member]

Hello Gurus

I want to update my oracle database from 9i to 10g

can any body help me to guide me the process

server details

Oracle 9i - 9.2.0.4.0

Windows Server 2003

SAP Version - 640

Thanks & Regards

Shishir

[Former Member]

Thanks

[Former Member]

Hi Shashi,

you need to do following steps

Oracle Database Upgrade

Installing the Oracle Database Software

Installing the Oracle 10g Server Software

Installing the Oracle 10g Client Software

Copying and Adapting the SQL*Net Files

Saving Archive Log Files

Changing the Environment for User <dbsid>adm

Performing the Database Upgrade

Post-Upgrade Steps

Creating the Oracle TNSListener Service

Changing Environment Variables

Setting Up a Shared Database-Directory in Oracle Home

Changing the Registry Value of Oracle Autostart

Starting the Oracle Services

[Former Member]

You read the above mentioned guide and the notes mentioned in it, also you may find some use information in the Related Notes as well.

[Former Member]

Hello Kaushal

Many thanks for your early reply

Can you tell me step by step process If you have done Oracle upgradation orelse can you guide me is there any recommendation before upgrade i.e. kernel level, support packs etc etc

waiting for your answer

Thanks & Regards

Shishir

[Former Member]

Hi,

check the upgrade document.

https://websmp101.sap-ag.de/~sapdownload/011000358700003520252006E/WIN_ORA_UPG_GUIDE_vers40.pdf

regards,

kaushal

[Former Member]

HI,

check

service.sap.com/instguides -> Installation & Upgrade Guides -> Other Documentation -> Database Upgrades -> Oracle

or

https://websmp101.sap-ag.de/~sapdownload/011000358700003520252006E/WIN_ORA_UPG_GUIDE_vers40.pdf

regards,

kaushal