Oracle Upgrade to 10g

[Former Member]

Ihi Guys

I am in the process of Oracle database upgrade.

Oracle 9i to Oracle 10g(10.2.0.4)

SAP: 4.70, Windows 2000

DB have been installed and now need to apply the patch to level 4(10.2.0.4).

In the Oracle documentaion for Oracle Patches, i can see sectioon 7.1 and section 7.2 talks about .

7.1 Review Known Preinstallation Issues

Review the information in the following sections. If any of the issues apply to the Oracle installation, follow the instructions before installing the patch set.

Upgrading Oracle E-Business Suite Databases

Upgrading Installations that use Physical or Logical Standby Databases

Upgrading Installations that use Java Virtual Machine or Oracle interMedia

Upgrading Oracle Clusterware

Notes to Oracle OLAP Users

Disabling Oracle Database Vault

7.2 Identify the Oracle Database Installation

This is not a complete software distribution. You must install it in an existing Oracle Database 10g Oracle home. To identify Oracle home directories, view the/etc/oratab file.Use Oracle Universal Installer to identify Oracle home directories. From the Welcome screen, click Installed Products, then click the Environment tab. You should then cross-check this by executing

opatch lsinventory -all

Do we have to perform these activities as well, or we can ignore these steps and continue with next steps onward?

Regards

[stefan_koehler]

Hello Ricky,

> Upgrading Oracle E-Business Suite Databases

Not needed.

> Upgrading Installations that use Physical or Logical Standby Databases

Only needed if you have a standby database for your productive database. Standby databases can be maintained/created with Oracle Data Guard or manually.

> Upgrading Installations that use Java Virtual Machine or Oracle interMedia

Not used in a standard SAP environment

> Upgrading Oracle Clusterware

Only needed if you use Oracle RAC

> Notes to Oracle OLAP Users

You have an OLTP.. not an OLAP

> Disabling Oracle Database Vault

Not used in a standard SAP environment (pilot phase)

> 7.2 Identify the Oracle Database Installation

You should perform these step and check it.

Regards

Stefan

[Former Member]

Hi Stefan

If it isnot aclusterware system then Do we need to install Oracle Process Manager service?

Regards

[stefan_koehler]

Hello Ricky,

sorry but where did you read something about the "Oracle Process Manager".

The OPMN is used in an Oracle Application Server environment. You could also check the glossary about this:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14190/glossary.htm#sthref991

Regards

Stefan