Skip to Content

Upgrading from Oracle 9.2.0.6 to Oracle 10.2

Hello

We are starting upgrade from SAP R/3 4.6C on platform Solaris/ Oracle

9.2.0.6 to SAP ECC 6.0 .

First of all, we have to upgrade database Oracle from 9.2.0.6 to Oracle

10.2. We are using Guide "Guide_UX_ORA_UPGRADE_210.pdf".

Following this guide, we can do an upgrade directly, but... In chapter

3.5 Checking SAP system Prerequisites, in point 3, we have seen is

necessary update oracle client software. Note 886783 is referenced.

Reading this note, we have seen that is necessary update Database

server to 9.2.0.7.

So..

... that means is not possible to do an upgrade from 9.2.0.6 to 10.2 in

one only step???

Thanks and regards

Javier

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

13 Answers

  • Mar 21, 2007 at 06:53 PM

    Hello Fidel

    Sorry ,but I don't have nothing clear.. 😉

    My initial doubt, after read documentation and guides, was if is necessary upgrading in 2 steps database oracle : 9.2.0.6 --> 9.2.0.7 --> 10.2.

    Now, I have another one, related to oracle client...

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Javier,

      Regarding the Database, you can upgrade directly from 9.2.06 to 10.2, no problemo 😊

      what is the question about oracle client?

      I've just seen the reply from William Fee :

      <quote>

      > Just a thought...

      >

      > If he is upgrading to SAP ECC 6.0, doesn't this use kernel 700 and kernel 700 only

      > uses Oracle 10.2.0.2.

      >

      >Therefore he doesn't need the 9i client only the new 10g client????

      <quote>

      The upgrade uses tools from the old kernel ( 46D ) and new kernel ( 700 ) for that reason it is recomended to install the new client.

      After the upgrade, to ECC 6.0, it can be removed, as you said, ECC 6.0 uses kernel 700 and this one needs the oracle instant client.

  • avatar image
    Former Member
    Mar 21, 2007 at 04:24 PM

    follow the point 2.1 Checking the Original Version of Your Database

    You need to check the original version of the database you want to upgrade.

    Caution

    This SAP upgrade documentation only covers the standard upgrade from Oracle 9.2.0.4 or later to

    Oracle Database 10g Release 2 (10.2) using the Oracle Database Upgrade Assistant (DBUA).

    If you are upgrading from Oracle 8.1.7 or an earlier release, read the Oracle Database 10g Release 2

    (10.2) upgrade documentation for information on the special steps required. Although Oracle

    supports direct upgrades from Oracle 8.1.7 to Oracle 10.2.0, SAP recommends customers running

    Oracle 8.1.7 to first upgrade to Oracle 9.2.0 and then to Oracle 10.2.0.

    Cheers,

    -Sunil

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Javier Iribarne

      We were on Oracle 9.2.0.6 and went directly to Oracle 10.2.0.2 without upgrading the client to 9207. Or upgrading the server to Oracle 9.2.0.7

      If this is the only instance on the box (no other 9i instance), I believe you do not need the Oracle 9 client. Just install the new Oracle 10 client.

      Our major problem with the Guide (which I really do not think SAP tested) was that it mainly describes the upgrade from Oracle 10.2.0.1 to 10.2.0.2

      First, you must patch the system from 9.2.0.6 to 10.2.0.1 (which was not in the Guide)

      Then, upgrade from 10.2.0.2

      I hope this helps.

  • avatar image
    Former Member
    Mar 21, 2007 at 05:50 PM

    Hello Javier,

    Let me (try to) explain, there are two different things involved here:

    1) Oracle RDBMS

    2) Oracle Client

    In SAP ( on <b><u>UNIX </u></b>) they are two totally different things

    The version of the oracle client you have to use depends on the SAP Kernel version that you are using, not on the RDBMS version.

    Currently you have 4.6C and 9.2.0.6. But I do not know which kernel are you using:

    1) 46D_EXT -> if you are using this kernel then you are using oracle client 9i

    2) 46D ("normal" one)-> if you are using this kernel then you are using oracle client 8i

    After you upgrade the RDBMS from 9.2.0.6 to 10.2, the kernel <b>must </b>be 46D_EXT. As mentioned before, this kernel needs the oracle client 9i ( it does not matter that you have upgraded the RDBMS to 10g, the kernel still uses the same client )

    This client must be ( at least ) 9.2.0.7.

    It can be downloaded from Marketplace and it is independent of the RDBMS version.

    So, the upgrade process could be the following:

    1) install 10.2.0.2 and all recommended patches

    2) Stop SAP

    3) Upgrade DB

    4) install new kernel 4.6D_EXT ( if needed )

    5) install oracle client 9.2.0.7 ( or 9.2.0.8 )

    Review environment variables ( I think it is on the upgrade guide, but just in case )

    Review Oracle parameters

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Just a thought...

      If he is upgrading to SAP ECC 6.0, doesn't this use kernel 700 and kernel 700 only uses Oracle 10.2.0.2.

      Therefore he doesn't need the 9i client only the new 10g client????

  • Mar 21, 2007 at 06:25 PM

    Hello again

    First of all, thanks for your answers., but... we have doubts.

    Let see... Kernel is 4.6D_EXT.

    Current situation:

    SAP R/3 4.6C

    Kernel 4.6D_EXT

    Solaris 2.9

    Oracle Database 9.2.0.6

    Oracle Client 9.2.0.6

    Target situation:

    SAP ECC 6.0

    Kernel 7.0

    Solaris 2.9

    Oracle Database 10.2

    To do upgrade SAP, first I have to upgrade Oracle Database 9.2.0.6 to Oracle 10.2.

    So, in that temporal moment, I will have : 4.6C , kernel 4.6D_EXT, Oracle client 9.2.0.6 and ORacle database 10.2.

    After that, I will upgrade from 4.6C (kernel 4.6D_EXT) to ECC 60 (kernel 7.0)

    My question is: why is necessary upgrade oracle client 9.2.0.6 to 9.2.0.7 during that temporal moment?

    Thanks and regards

    Javier

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Javier,

      I recently upgraded Oracle 9.2.0.6 to 10.2.0.2, and following the Sap guide as first step I updated the <b>oracle client</b> to the latest version (9.2.0.8). I found no problems doing this, and the upgrade was perfect. The reason is that kernels =<640 can't connect to oracle client 10.x, and you are updating DB first, and your Sap will be still 46D_ext.

      The <b>oracle server </b>is not needed to be migrated as a intermediate state to 9.2.0.7. It can upgrade directly to 10g.

      Saludos!

      JC Llanes.

      Message was edited by:

      Juan Carlos Llanes

  • Mar 21, 2007 at 07:03 PM

    Hello

    Gracias Juan Carlos 😉

    But... if you tell me that the first step was upgrade oracle client 9.2.0.6 to 9.2.0.8...

    ... this oracle client can connect to Database Oracle 9.2.0.6???

    Thanks

    Saludos

    Javier

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 21, 2007 at 07:27 PM

    Sorry again, I think my brain is already exhausted 😊

    If I have to update oracle client to 9.2.7 , following 886783 (Installing oracle 9207 unix) note:

    ****************************************************************

    6. For application servers with database instance (DB Server), if the database server is Oracle 9.2 please do the following:

    a. Confirm that /oracle/client/92x_64/lib is a link to /oracle/<DBSID>/920_64/lib

    b. Confirm that /oracle/client/92x_64/jdbc is a link to

    /oracle/<DBSID>/920_64/jdbc

    c. Confirm that /oracle/client/92x_64/ocommon is a link to

    /oracle/<DBSID>/920_64/ocommon

    d. Ensure that the database server is updated to patchset 9.2.0.7

    e. Confirm that one-off patch 3396162 is applied to the database server on top of patchset 9207. You can check if this patch has been applied by executing the following command as the ora<dbsid> user:

    $ORACLE_HOME/OPatch/opatch lsinventory

    f. If at a later stage the database server would be upgraded to Oracle 10.x, you would need to install the Oracle 9.2 client as described in step 5 above.

    ********************************************************************

    To Fidel:

    A oracle client can't be greater than oracle database, isn't??? So, if I have to update oracle client to 9.2.0.7, I am forced to upgraded database server to Oracle 9.2.0.7, isn't??

    To Juan Carlos:

    A R3trans -x can be sucessfully but, could be not enough... After uprading ot Oracle 10, did you upgrade SAP ??

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      After the DB upgrade, SAP still is not upgraded.

      You have two options:

      1) Still run with the "old" SAP version --> You are using kernel 46D_EXT --> it will use the client 9i

      2) You perform the upgrade of SAP to ECC 6.0. During the upgrade <u>both</u> kernels will be used --> Both clients are needed.

      <u><b>After</b></u> the DB upgrade <u><b>and</b></u> SAP upgrade has been done, then you can delete the client 9i.

  • Mar 22, 2007 at 07:51 AM

    Ok guys, after two beers and after sleep...I have the ideas more clears.. 😉

    The steps should be:

    1) Upgrading oracle client from 9.2.0.6 to 9.2.0.7 , because is recommended by SAP in order to avoid dumps later ( using SAP 4.6C and Oracle 10)

    Status: 4.6C, Kernel 4.6D_EXT, Oracle Client 9.2.0.7 , and Oracle Server 9.2.0.6

    2) Upgrade Oracle Server from 9.2.0.6 to Oracle 10.2

    Status: 4.6C, kernel 4.6D_EXT, Oracle client 9.2.0.7, and Oracle server 10.2.

    3) Upgrade SAP from 4.6C to ECC 6.0

    Status: SAP ECC 6.0, kernel 7.0, Oracle client 10, and Oracle Server 10

    Right???

    Thanks

    Javier

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Windows and Unix are very different regarding the oracle client.

      As mentioned before, in UNIX, the oracle client version depends on the kernel version

      On Windows, no. The oracle client version depends on the DB version. For that reason you uninstall the 9.2. clients when you upgrade to 10g, but un Unix, coul dbe that the kernel still uses the 9.2

  • Mar 22, 2007 at 11:00 AM

    Hello guys

    One question more. I'm in the step 4.1.1 Checking and setting the Environment Variables of the guide.

    And I found some topics not clear:

    1) Here, it say say that I can install database sw with SAP and Oracle running... (!?)

    2) Then I must to change certains environment variables of user ora<sid> , as.. NLS_LANG : " set this to the output of the script CHECKS.SQL which you can find .....

    .. .. /oracle/stage/102_64/database/SAP"

    But.. what does it means? Should I execute this scripts to see the result?

    3) ORA_NLS10 must be $ORACLE_HOME/nls/data ... (but this directory is empty yet..)

    Thanks and regards

    Javier

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Javier,

      1) You can begin the upgrade with everything running, so you can reduce the downtime. If you don't worry about this, you don't need to have Sap up (and you'll get more resources for the DB upgrade).

      2) Yes, you must run this script from sqlplus if you're not sure about your DB language setttings.

      3) Yes, it's "filled" during the installation (remind your $ORACLE_HOME now will be /oracle/<SID>/102_64).

      Best Regards,

      JC Llanes.

  • Mar 24, 2007 at 07:43 PM

    Hello guys!

    Just inform you about the results.

    I have done following steps:

    1) Update Oracle client to 9.2.0.7 . Everthing OK

    2) Install Oracle Instant Client 10 (because is necessary for BRTools) . Everything OK.

    3) Upgrade Oracle Server from 9.2.0.6 to Oracle 10.2.0 2. Everything OK.

    So , until now, I have SAP 4.6C , kernel 4.6D_EXT, Oracle Database 10.2.0.2, and Oracle client 9.2.0.7 and Oracle Instant Client 10 , too.

    I have to say the guide is correct, and I didn't have any problem. Maybe the concepts in this guide are not well-clarified (for example: "you can upgrade database software while SAP is still running..." , but the thing is that is not an upgrade of sw, but is a new installation of Oracle 10, in another ORACLE_HOME...etc.etc..)

    But OK, Everyting fine.

    Thanks to everybody for your help.

    Monday: Upgrade of SAP 😊

    Thanks and regards

    Javier

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Javier,

      I'm preparing our test system for the Oracle Upgrade to 10.2.0.2

      We are using SAP R/3 4.6C, kernel 4.6D_EXT, Oracle 9.2.0.5., HP-UX 11.23

      SAPKA46C46, SAPKH46C46, SAPKB46C46, SAPKE46C19.

      Can you please tell me do you had to apply some SAP support packages before the oracle upgrade?

      I found in the note 868681, that SAPKB46C48 supp. pack should be used or import of the attached transport from the note.

      Thanks in advance,

      Regards,

      Ruzica

  • Mar 28, 2007 at 03:07 PM

    Hello Ruzica

    As this OSS note say... you have two possibilities:

    - Apply Support Packages..

    - Apply attached transport

    We choose second option: apply transport ORAREL4XX.SAR (is more quickly and simply)

    Regards

    Javier

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Javier!

      I'll also choose the second option.

      Can you please tell me about the Oracle 9.2.0.7 client?

      Did you test the DB and SAP application after upgrade the oracle client to 9.2.0.7?

      I have test server, HP-UX 11.11 with two different test SAP (4.6C and Oracle 9.2.0.5) instances which are homogenous system copies from two different production systems. I need to perform Oracle 10g upgrade only on one of these SAP DB.

      I'm not sure about the Note which should I follow:

      <b>Note 964783</b> - Updating Oracle client on host with multiple SAP systems

      or

      <b>Note 886783</b> - Installing Oracle 9207 Client Software on UNIX

      If there is no problem with the client 9207 for Oracle server 9.2.0.5 (SAP 4.6C and kernel 46D_EXT) to work fine I will follow the note 886783. But there is something confusing in it: Point 6. d. <u>Ensure that the database server is updated to patchset 9.2.0.7</u>

      Which note did you follow?

      Thanks in advance,

      Many regards,

      Ruzica