Skip to Content
avatar image
Former Member

Incorrect database version in CHECK-OS-DB-VERSION

We are performing an upgrade to NetWeaver 7.3 on a Java-only stack that is running Portal components.

We have started at NetWeaver 7.0 EhP1, on LINUX RH-EL 5 and ORACLE 11.2.0.1. We got stuck on the database check. The system reported that our database version was too low. Since the installation is distributed with the ORACLE 11.2.0.2 kit and since we had planned to upgrade ORACLE anyway, I upgraded ORACLE at this point to 11.2.0.2.

We are still getting the message the database version is too low when the installation performs the OSDB check:

The log from /usr/sap/<SID>/SUM/sdt/log/SUM/CHECK-OS-DB-VERSION_nn.LOG shows:

<! LOGHEADER[START]/ >

<! HELP[Manual modification of the header may cause parsing problem!]/ >

<! LOGGINGVERSION[2.0.7.1006]/ >

<! NAME[/usr/sap/<SID>/SUM/sdt/log/SUM/CHECK-OS-DB-VERSION_03.LOG]/ >

<! PATTERN[CHECK-OS-DB-VERSION_03.LOG]/ >

<! FORMATTER[com.sap.tc.logging.TraceFormatter(%d [%6s]: %m)]/ >

<! ENCODING[UTF8]/ >

<! LOGHEADER[END]/ >

May 27, 2011 1:30:07 PM [Info ]: Operating system version is LINUXX86_64 2.6.18, database version is ORA 11.1.0.0.0.

May 27, 2011 1:30:07 PM [Info ]: Configuration file /usr/sap/<SID>/SUM/sdt/config/CheckOSDB.xml not found.

May 27, 2011 1:30:07 PM [Info ]: Configuration file /usr/sap/<SID>/SUM/sdt/config/CheckOSDB_UNX.xml not found.

May 27, 2011 1:30:07 PM [Info ]: Reading configuration file /usr/sap/<SID>/SUM/sdt/config/CheckOSDB_ORA.xml.

The log is reporting our ORACLE version as ORA 11.1.0.0.0. We never installed that version directly. When we upgraded to ORACLE 11, we went from ORACLE 10.2.0.4 directly to ORACLE 11.2.0.1.

Does anyone know where the system getting this information on the ORACLE version and how can we correct that information to reflect the true installed version of ORACLE?

Thank-you,

Deb Nugent.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    May 29, 2011 at 11:24 PM

    HI,

    After upgrade you have to start database in upgrade mode and run catupgrade.sql script which resides in $ORACLE_HOME/rdbms

    then shutdown database and start normally it will pick the new version

    catpatch.sql and util112i.sql check these ones aswell

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank-you for the suggestion. I had previously run the catupgrd.sql script as a part of the ORACLE upgrade process. Since it can normally be run more than once, I reran it again when this error appeared after I had upgraded ORACLE. It reports that the database is already at 11.2.0.2

      Deb Nugent.

  • avatar image
    Former Member
    May 30, 2011 at 06:02 AM

    Hi,

    Make sure that you have also upgraded the oracle client version, I faced teh similar issue and upgraded the oracle client as well to version ORACLE Client V5 10.2.0.4 ( 51039412 ). Please update the same and then it should reflect the correct version.

    Regards,

    Sarita

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      As apart ofhte upgrade to OARCLE 11.2.0.2, it requires you to also upgrade the ORACLE client. I have previously upgrade the ORACLE client to the latest released version from SAP, 11.2. As a precaution, I have also renamed my original ORACLE client directory so that it cannot be accessed (in case I missed something in my isntallation of the client).

      I do not know how to test the version of my ORACLE client. I can run BRTOOLS successfully and using that I also checked my database version which correctly shows 11.2.0.2.

      Deb Nugent.

  • avatar image
    Former Member
    May 30, 2011 at 06:40 AM

    Hi,

    During initial database and OS check in preparation phase of the upgrade, tool store database version information in the log files, that might be one of the reason it is picking wring information.

    I would suggest you to start upgrade again.

    Thanks

    Sunny

    Add comment
    10|10000 characters needed characters exceeded

    • Hello,

      during Upgrade a Java System to 731 I got the same error with SUM. But in my system the switch to Oracle Client 11.2 wasn't complete. I had to change the line "rdbms.driverLocation=/oracle/client/11x_64/instantclient/ojdbc14.jar" in the file "../j2ee/cluster/bootstrap/bootstrap.properties" and after a restart of SUM it works.

      Joerg