cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 9.2.0.4 > 10.2.0.2 upgrade

Former Member
0 Kudos

Our BASIS guys are having problems upgrading to Oracle

10.2.0.2 as a pre- requisite to our BI 2004s upgrade.

Has anyone upgraded directly to 10.2 from 9.2 and encountered major issues?

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

After installing 10.2 & the 10.2.0.2 patchset, I am now trying to install the patches.

I run this:

opatch version

and get this error:

java.lang.NoClassDefFoundError: oracle/sysman/oii/oiii/OiiiOneoffException

at oracle.opatch.OPatchSession.<clinit>(OPatchSession.java:269)

at oracle.opatch.OPatch.<clinit>(OPatch.java:121)

This looks like a java error????

The java version is:

java version "1.4.2.03"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2.03-040401-16:07)

Java HotSpot(TM) Server VM (build 1.4.2 1.4.2.03-040401-18:59-PA_RISC2.0 PA2.0 (aCC_AP), mixed mode)

Any suggestions on getting opatch to work?

Former Member
0 Kudos

I re-installed th eOracle binaries and the error went away.

Former Member
0 Kudos

Nice to hear that everything is working now

thanks

Prince Jose

Former Member
0 Kudos

In the document "Upgrade to Oracle Database 10g Release 2 (10.2): UNIX" it says to run the SQL script updDBSTATC10.sql.

Where do I get the script updDBSTATC10.sql ????

Former Member
0 Kudos

Hi,

You will get it in either /oracle/stage/102_64/database/SAP or /oracle/stage/102_64/database/Disk1/SAP directory.

Regards,

Cherry

Former Member
0 Kudos

Thanks.

I found it those directories after I unzipped RDBMS_SAP_64.zip

Former Member
0 Kudos

Check the vesion also in file init<SID>.ora.

Somewere says COMPATIBLE = 9.2.0.

Former Member
0 Kudos

We also are having problems upgrading from 9.2.0.6 directly to 10.2.0.2.

Did you find anything incorrect in SAP's Upgrade Guide.

You said you had to upgrade to 10.1 first????

Did is not in the SAp Guide.

Former Member
0 Kudos

You can directly upgrade oracle 9.2.0.4 to 10.2.0.2. If you are in 9.2.0.1/2/3 you need to upgade to patchset 4 before starting upgrade. In your case I dont see any issue for upgrading to 10.2.0.2

thanks

Prince

Former Member
0 Kudos

But there are issues. When I use the SAP 10.2.0.2 downloads and upgrade from 9.2.0.6 to 10.2.0.2, the binaries do not get installed and it never asks me to run root.sh.

Do I need to install Oracle 10.1 first?

Former Member
0 Kudos

You have to install 10.2 and apply patchset 2 to make it 10.2.0.2 .

thanks

Prince Jose

Former Member
0 Kudos

Where do I get 10.2?

Only 10.2.0.2 is available at https://websmp205.sap-ag.de/swcenter-3pmain for Oracle (64Bit) HP-UX

Former Member
0 Kudos

Did you read the Data Base upgrade guide " Upgrade to Oracle Database 10g Release 2 (10.2):Unix ? if not download it from https://websmp105.sap-ag.de/instguides --> Other documentation -->Database Upgrade -->Oracle .

For getting 10.2 CD go to http://service.sap.com/swdc --> Installation and Upgrade --> select any --> Installation and upgrade --> HP --> Oracle -->DVD ORACLE RDBMS 10.2 HPUX_IA64 . Download that 7 CDs after downloading extract it using winrar . it will give you 2 folder ( if i remembr correctly ) and from that folder select OR110264.SAR file and ftp to unix server.for upgrade you require only this file.

Please go through the Installation guide for rest of the steps and also make sure you have met all the prerequisites .

thanks

Prince Jose

Former Member
0 Kudos

I read the current guide: "Upgrade to Oracle Database 10g Release 2 (10.2): UNIX (Document version: 2.1 08/28/2006)" and I do not find anywhere it says to intsall 10.2 first or where to get 10.2.

I am now downloading the 7th CD and will go from there.

I'll let you know how it works.

Former Member
0 Kudos

Thats the correct document. Check page 10 --> Procedure --> 1 b)

the link you tried before https://websmp205.sap-ag.de/swcenter-3pmain is for downloading patchset and opatches . After installing the binaries you have to go to https://websmp205.sap-ag.de/swcenter-3pmain and down load Patchset_10202 ( 4 files ) to make it 10.2.0.2 and also apply required opatches.

thanks

prince jose

Former Member
0 Kudos

Where do I get winrar?

Former Member
0 Kudos

rarlab.com

Former Member
0 Kudos

Nick

I am still strubbeling with this issue:

Before I can upgrade EP6 to EP7 I needed to upgrade my (as I believed than) Oracle 9.2.0.6 to Oracle 10.2.0.1 and patch that one to 10.2.0.2.

All the pre steps went OK even the OUI, but when I started the DBUA for upgrading the database, it gave me the message:

ORA-200000: Upgrade not supported from version 9.2.0.1

ORA-06512: at "SYS.VERSION_SCRIPT", line52

But when I check my oracle version in the v$version I get the following:

SQL> select * from V$version;

BANNER

-


Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production

PL/SQL Release 9.2.0.6.0 - Production

CORE 9.2.0.6.0 Production

TNS for HPUX: Version 9.2.0.6.0 - Production

NLSRTL Version 9.2.0.6.0 - Production

SO I am stuck on what to do, cause the DBUA tells me I need first to go to a minimum of 9.2.0.4 but my Oracle tells me that I am already on version 9.2.0.6

Any ideas on where the DBUA checks versions? (which files or tables)

Chris

SanjayKulkarni
Employee
Employee
0 Kudos

Hello Chris,

When you do a select on V$VERSION you are seeting the version of the binaries.

Please try the following via SQLPLUS

SQL> select comp_id, version, status from dba_registry;

Most probably you should see Oracle 9.2.0.1. If this is the case then its likely that you did not complete the patchset post-installation steps when you installed Oralce 9.2.0.6. Please complete those and then restart the DBUA.

Regards, Sanjay

Former Member
0 Kudos

Unfortunately that is not it (hoped it was so I could proceed)

SQL*Plus: Release 9.2.0.6.0 - Production on Tue Nov 7 09:33:11 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production

With the Partitioning option

JServer Release 9.2.0.6.0 - Production

SQL> select comp_id, version, status from dba_registry;

COMP_ID VERSION STATUS

-


-


-


CATALOG 9.2.0.6.0 VALID

CATPROC 9.2.0.6.0 VALID

SQL>

all 9.2.0.6

Former Member
0 Kudos

Have you tried the manual ugprade (not using DBUA)

SanjayKulkarni
Employee
Employee
0 Kudos

Hello Nick,

The database upgrade from Oracle 9.2 to Oracle 10.2 is described in the SAP Database Upgrade guide which you can find at

http://service.sap.com/instguides

Other Documentation -> Database Upgrades -> Oracle

Could you be a bit more specific in what problems are you facing in performing the database upgrade ?

Regards, Sanjay

Former Member
0 Kudos

Hi,

We are on the plan to upgrade.

Minimum Version of the database that can be directly upgraded to Oracle 10g Release 2

8.1.7.4 -> 10.2.X.X.X

9.0.1.4 or 9.0.1.5 -> 10.2.X.X.X

9.2.0.4 or higher -> 10.2.X.X.X

10.1.0.2 or higher -> 10.2.X.X.X

PREREQUISITES

=============

Install Oracle 10g Release 2 in a new Oracle Home.

Install the latest available patchset from Metalink.

Install the latest available Critical Patch Update.

Either take a cold or hot backup for your database.

Make sure to take a backup of Oracle Home and Central Inventory.

Central inventory can be located by the contents of oraInst.loc files.

"oraInst.loc" is available in the following locations on various platforms

/var/opt/oracle/oraInst.loc -- Solaris

/etc/oraInst.loc -- other operating systems

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\inst_loc -- On windows Platform.

Verify kernel parameters are set according to the 10gR2 Installation Guide.

Verify that all O/S packages and patches are installed as per the Installation Guide.

Hope this will help you to proceed.

Vinod

Former Member
0 Kudos

This SAP note may help: Note 841728 - Oracle Database 10g: Software installation problems 10.2.0.

We will be upgrading to Oracle 10g in 1 or 2 months, so this thread will be interesting! We are starting to plan now.