Skip to Content
avatar image
Former Member

Migrating from Oracle 10g to 11g

Hi All,

We are having PI 7.1 with Oracle 10g, we are planning to migrate oracle database 10g to 11g.

My query is that what all will be the effects on SAP if we migrate to 11g.

Advise us in this regard.

Thanks,

Sreekanth

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • avatar image
    Former Member
    Oct 17, 2011 at 04:14 PM

    Hi,

    I have only find below log,.

    . 11ginstall.sh - Oracle Database Software Installation Script

    . Version 11.2.0.2.0 Release Date 2011-04-28 Patch Level 028 (rel)

    . Copyright (c) Oracle Corporation 2010, 2011. All Rights Reserved.

    . Reference SAP note: 1524205

    . Supported Oracle Database Release: 11.2.0.2.0.

    . Host : qserv

    . Platform : HP-UX ia64 (64-bit)

    . Date : 2011-10-17 12:18:08

    . User : oraqas

    . Logfile : /oracle/QAS/11ginstall_11202.log.

    . 11ginstall.sh was called with the following options (command line):

    . -oracle_stage /oracle/stage/11202/database -ignoreSysPrereqs -check.

    . Performing pre-installation checks ....

    . (OK) - Got value for <DB_SID> from environment.

    . (OK) - Got location for Oracle base from environment.

    . (OK) - Got location for Oracle stage from '-oracle_stage' option.

    . (OK) - Oracle base = /oracle

    . (OK) - Oracle base location /oracle exists.

    . (OK) - Installation location /oracle/QAS/11202 does not exist.

    . (OK) - Run-time location /oracle/QAS/112_64 does not exist.

    . (OK) - Inventory pointer file /var/opt/oracle/oraInst.loc exists.

    . (OK) - Group dba is defined.

    . (OK) - Group oper is defined.

    . (OK) - OUI version in stage is 11.2.0.2.0.

    . (OK) - New response file /oracle/QAS/.11ginstall_11202.rsp created..

    . Pre-installation checks completed..

    . --- Begin of OUI response file /oracle/QAS/.11ginstall_11202.rsp ---

    ###############################################################################

    1. Copyright (c) Oracle Corporation 2010, 2011. All Rights Reserved.

    ##

    1. Generated by 11ginstall.sh - Oracle Database Software Installation Script

    2. Version 11.2.0.2.0 Release Date 2011-04-28 Patch Level 028

    ##

    1. Reference SAP note: 1524205

    2. Supported Oracle Database Release: 11.2.0.2.0

    3. Platform: HP-UX ia64

    4. Date : 2011-10-17 12:18:08

    ###############################################################################

    oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

    oracle.install.option=INSTALL_DB_SWONLY

    ORACLE_HOSTNAME=qserv

    UNIX_GROUP_NAME=dba

    SELECTED_LANGUAGES=en

    ORACLE_HOME=/oracle/QAS/11202

    ORACLE_BASE=/oracle

    oracle.install.db.InstallEdition=EE

    oracle.install.db.EEOptionsSelection=true

    oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.2.0,oracle.rdbms.rat:11.2.0.2.0

    oracle.install.db.DBA_GROUP=dba

    oracle.install.db.OPER_GROUP=oper

    oracle.install.db.isRACOneInstall=false

    SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

    DECLINE_SECURITY_UPDATES=true

    oracle.installer.autoupdates.option=SKIP_UPDATES

    #INVENTORY_LOCATION=.

    . --- End of OUI response file /oracle/QAS/.11ginstall_11202.rsp ---.

    . Environment settings:

    . DB_SID = QAS

    . DISPLAY = 192.168.51.3:0.0

    . ORACLE_BASE = /oracle

    . ORACLE_STAGE = not set

    . Installation Settings:.

    . Installation log file = /oracle/QAS/11ginstall_11202.log

    . Oracle Release = 11.2.0.2.0

    . Oracle stage location = /oracle/stage/11202/database.

    . Oracle base location = /oracle (exists)

    . Oracle home install. location= /oracle/QAS/11202

    . Oracle home run-time location= /oracle/QAS/112_64

    . Inventory group = dba

    . SYSDBA group = dba

    . SYSOPER group = oper

    . OUI Settings:.

    . OUI version = 11.2.0.2.0

    . OUI temporary directory = /oracle/QAS/.11ginstall_11202.tmp

    . OUI response file = /oracle/QAS/.11ginstall_11202.rsp

    . OUI output log file = /oracle/QAS/.11ginstall_11202.oui

    . OUI options = -waitForCompletion -ignoreSysPrereqs -executePrereqs.

    . Post Installation Settings:.

    . Update OPatch/MOPatch = -opatch_update

    . Check inventory =.

    . --- Oracle Universal Installer command line ---

    . LANG=C TMP=/oracle/QAS/.11ginstall_11202.tmp /oracle/stage/11202/database/runInstaller -responseFile /oracle/QAS/.11ginstall_11202.rsp -waitForCompletion -ignoreSysPrereqs -executePrereqs | tee /oracle/QAS/.11ginstall_11202.oui

    . --- Oracle Universal Installer command line (end) ---.

    . (INFO) - Starting Oracle Universal Installer in interactive mode - please wait ....

    . --- Begin of OUI output ---.

    Starting Oracle Universal Installer...

    Checking Temp space: must be greater than 415 MB. Actual 397192 MB Passed

    Checking swap space: must be greater than 150 MB. Actual 50985 MB Passed

    Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed

    Preparing to launch Oracle Universal Installer from /oracle/QAS/.11ginstall_11202.tmp/OraInstall2011-10-17_05-48-08PM. Please wait .....

    . --- End of OUI output ---

    . (INFO) - Software installation prerequisite checks finished..

    . Performing post-installation clean up tasks ...

    . (OK) - OUI temp. directory /oracle/QAS/.11ginstall_11202.tmp removed successfully.

    . (OK) - OUI output log file /oracle/QAS/.11ginstall_11202.oui removed successfully.

    . (OK) - OUI response file /oracle/QAS/.11ginstall_11202.rsp removed successfully.

    . Post-installation clean up tasks completed.

    . See log file /oracle/QAS/11ginstall_11202.log for details.

    . Exiting with exit code 4..

    . 11ginstall.sh - Oracle Database Software Installation Script

    . Version 11.2.0.2.0 Release Date 2011-04-28 Patch Level 028 (rel)

    . Copyright (c) Oracle Corporation 2010, 2011. All Rights Reserved.

    . Reference SAP note: 1524205

    . Supported Oracle Database Release: 11.2.0.2.0

    . Host : qserv

    . Platform : HP-UX ia64 (64-bit)

    . Date : 2011-10-17 12:51:21

    . User : oraqas

    . Logfile : /oracle/QAS/11ginstall_11202.log

    .

    . 11ginstall.sh was called with the following options (command line):

    . -oracle_stage /oracle/stage/11202/database -ignoreSysPrereqs -check.

    . Performing pre-installation checks ...

    . (OK) - Got value for <DB_SID> from environment.

    . (OK) - Got location for Oracle base from environment.

    . (OK) - Got location for Oracle stage from '-oracle_stage' option.

    . (OK) - Oracle base = /oracle

    . (OK) - Oracle base location /oracle exists.

    . (OK) - Installation location /oracle/QAS/11202 does not exist.

    . (OK) - Run-time location /oracle/QAS/112_64 does not exist.

    . (OK) - Inventory pointer file /var/opt/oracle/oraInst.loc exists.

    . (OK) - Group dba is defined.

    . (OK) - Group oper is defined.

    . (OK) - OUI version in stage is 11.2.0.2.0.

    . (OK) - New response file /oracle/QAS/.11ginstall_11202.rsp created..

    . Pre-installation checks completed..

    . --- Begin of OUI response file /oracle/QAS/.11ginstall_11202.rsp ---

    ###############################################################################

    1. Copyright (c) Oracle Corporation 2010, 2011. All Rights Reserved.

    ##

    1. Generated by 11ginstall.sh - Oracle Database Software Installation Script

    2. Version 11.2.0.2.0 Release Date 2011-04-28 Patch Level 028

    ##

    1. Reference SAP note: 1524205

    2. Supported Oracle Database Release: 11.2.0.2.0

    3. Platform: HP-UX ia64

    4. Date : 2011-10-17 12:51:21

    ###############################################################################

    oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

    oracle.install.option=INSTALL_DB_SWONLY

    ORACLE_HOSTNAME=qserv

    UNIX_GROUP_NAME=dba

    SELECTED_LANGUAGES=en

    ORACLE_HOME=/oracle/QAS/11202

    ORACLE_BASE=/oracle

    oracle.install.db.InstallEdition=EE

    oracle.install.db.EEOptionsSelection=true

    oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.2.0,oracle.rdbms.rat:11.2.0.2.0

    oracle.install.db.DBA_GROUP=dba

    oracle.install.db.OPER_GROUP=oper

    oracle.install.db.isRACOneInstall=false

    SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

    DECLINE_SECURITY_UPDATES=true

    oracle.installer.autoupdates.option=SKIP_UPDATES

    #INVENTORY_LOCATION=.

    . --- End of OUI response file /oracle/QAS/.11ginstall_11202.rsp ---.

    . Environment settings:

    . DB_SID = QAS

    . DISPLAY = 192.168.51.3:0.0

    . ORACLE_BASE = /oracle

    . ORACLE_STAGE = not set

    .

    . Installation Settings:

    .

    . Installation log file = /oracle/QAS/11ginstall_11202.log

    . Oracle Release = 11.2.0.2.0

    . Oracle stage location = /oracle/stage/11202/database

    .

    . Oracle base location = /oracle (exists)

    . Oracle home install. location= /oracle/QAS/11202

    . Oracle home run-time location= /oracle/QAS/112_64

    . Inventory group = dba

    . SYSDBA group = dba

    . SYSOPER group = oper

    .

    . OUI Settings:

    .

    . OUI version = 11.2.0.2.0

    . OUI temporary directory = /oracle/QAS/.11ginstall_11202.tmp

    . OUI response file = /oracle/QAS/.11ginstall_11202.rsp

    . OUI output log file = /oracle/QAS/.11ginstall_11202.oui

    . OUI options = -waitForCompletion -ignoreSysPrereqs -executePrereqs.

    . Post Installation Settings:.

    . Update OPatch/MOPatch = -opatch_update

    . Check inventory =

    .

    . --- Oracle Universal Installer command line ---

    . LANG=C TMP=/oracle/QAS/.11ginstall_11202.tmp /oracle/stage/11202/database/runInstaller -responseFile /oracle/QAS/.11ginstall_11202.rsp -waitForCompletion -ignoreSysPrereqs -executePrereqs | tee /oracle/QAS/.11ginstall_11202.oui

    . --- Oracle Universal Installer command line (end) ---

    .

    . (INFO) - Starting Oracle Universal Installer in interactive mode - please wait ...

    . --- Begin of OUI output ---

    Starting Oracle Universal Installer...

    Checking Temp space: must be greater than 415 MB. Actual 397192 MB Passed

    Checking swap space: must be greater than 150 MB. Actual 50985 MB Passed

    Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed

    Preparing to launch Oracle Universal Installer from /oracle/QAS/.11ginstall_11202.tmp/OraInstall2011-10-17_06-21-21PM. Please wait .....

    . --- End of OUI output ---

    . (INFO) - Software installation prerequisite checks finished.

    .

    . Performing post-installation clean up tasks ...

    . (OK) - OUI temp. directory /oracle/QAS/.11ginstall_11202.tmp removed successfully.

    . (OK) - OUI output log file /oracle/QAS/.11ginstall_11202.oui removed successfully.

    . (OK) - OUI response file /oracle/QAS/.11ginstall_11202.rsp removed successfully.

    . Post-installation clean up tasks completed.

    . See log file /oracle/QAS/11ginstall_11202.log for details.

    . Exiting with exit code 4.

    .

    . 11ginstall.sh - Oracle Database Software Installation Script

    . Version 11.2.0.2.0 Release Date 2011-04-28 Patch Level 028 (rel)

    . Copyright (c) Oracle Corporation 2010, 2011. All Rights Reserved.

    . Reference SAP note: 1524205

    . Supported Oracle Database Release: 11.2.0.2.0

    .

    . Host : qserv

    . Platform : HP-UX ia64 (64-bit)

    . Date : 2011-10-17 15:49:27

    . User : oraqas

    . Logfile : /oracle/QAS/11ginstall_11202.log

    .

    . 11ginstall.sh was called with the following options (command line):

    . -oracle_stage /oracle/stage/11202/database -ignoreSysPrereqs -executePrereqs

    .

    .

    . Performing pre-installation checks ...

    .

    . (OK) - Got value for <DB_SID> from environment.

    . (OK) - Got location for Oracle base from environment.

    . (OK) - Got location for Oracle stage from '-oracle_stage' option.

    . (OK) - Oracle base = /oracle

    . (OK) - Oracle base location /oracle exists.

    . (OK) - Installation location /oracle/QAS/11202 does not exist.

    . (OK) - Run-time location /oracle/QAS/112_64 does not exist.

    . (OK) - Inventory pointer file /var/opt/oracle/oraInst.loc exists.

    . (OK) - Group dba is defined.

    . (OK) - Group oper is defined.

    . (OK) - OUI version in stage is 11.2.0.2.0.

    . (OK) - New response file /oracle/QAS/.11ginstall_11202.rsp created.

    .

    . Pre-installation checks completed..

    . --- Begin of OUI response file /oracle/QAS/.11ginstall_11202.rsp ---

    .

    ###############################################################################

    1. Copyright (c) Oracle Corporation 2010, 2011. All Rights Reserved.

    ##

    1. Generated by 11ginstall.sh - Oracle Database Software Installation Script

    2. Version 11.2.0.2.0 Release Date 2011-04-28 Patch Level 028

    ##

    1. Reference SAP note: 1524205

    2. Supported Oracle Database Release: 11.2.0.2.0

    3. Platform: HP-UX ia64

    4. Date : 2011-10-17 15:49:27

    ###############################################################################

    oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

    oracle.install.option=INSTALL_DB_SWONLY

    ORACLE_HOSTNAME=qserv

    UNIX_GROUP_NAME=dba

    SELECTED_LANGUAGES=en

    ORACLE_HOME=/oracle/QAS/11202

    ORACLE_BASE=/oracle

    oracle.install.db.InstallEdition=EE

    oracle.install.db.EEOptionsSelection=true

    oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.2.0,oracle.rdbms.rat:11.2.0.2.0

    oracle.install.db.DBA_GROUP=dba

    oracle.install.db.OPER_GROUP=oper

    oracle.install.db.isRACOneInstall=false

    SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

    DECLINE_SECURITY_UPDATES=true

    oracle.installer.autoupdates.option=SKIP_UPDATES

    #INVENTORY_LOCATION=

    .

    . --- End of OUI response file /oracle/QAS/.11ginstall_11202.rsp ---.

    . Environment settings:

    .

    . DB_SID = QAS

    . DISPLAY = 192.168.51.3:0.0

    . ORACLE_BASE = /oracle

    . ORACLE_STAGE = not set

    .

    . Installation Settings:

    .

    . Installation log file = /oracle/QAS/11ginstall_11202.log

    . Oracle Release = 11.2.0.2.0

    . Oracle stage location = /oracle/stage/11202/database

    .

    . Oracle base location = /oracle (exists)

    . Oracle home install. location= /oracle/QAS/11202

    . Oracle home run-time location= /oracle/QAS/112_64

    . Inventory group = dba

    . SYSDBA group = dba

    . SYSOPER group = oper

    .

    . OUI Settings:

    .

    . OUI version = 11.2.0.2.0

    . OUI temporary directory = /oracle/QAS/.11ginstall_11202.tmp

    . OUI response file = /oracle/QAS/.11ginstall_11202.rsp

    . OUI output log file = /oracle/QAS/.11ginstall_11202.oui

    . OUI options = -waitForCompletion -ignoreSysPrereqs -executePrereqs

    .

    . Post Installation Settings:

    .

    . Update OPatch/MOPatch = -opatch_update

    . Check inventory =

    .

    . --- Oracle Universal Installer command line ---

    . LANG=C TMP=/oracle/QAS/.11ginstall_11202.tmp /oracle/stage/11202/database/runInstaller -responseFile /oracle/QAS/.11ginstall_11202.rsp -waitForCompletion -ignoreSysPrereqs -executePrereqs | tee /oracle/QAS/.11ginstall_11202.oui

    . --- Oracle Universal Installer command line (end) ---

    .

    . (INFO) - Starting Oracle Universal Installer in interactive mode - please wait ...

    .

    Please tell me if any logs will be available in other locations.

    Regards,

    Sreekanth

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 31, 2011 at 06:21 AM

    Hi Sreekanth,

    At the SAP business logic point of view, nothing will be changed. From Oracle RDBMS point of view, there are some new features. Please find the foremost features, below;

    • Advanced compression

    • Oracle Direct Network File System Client

    • Transparent tablespace encryption

    • Less memcpy calls and support for async network I/O calls (it has a positive effect on BI systems)

    • Offline redolog compression during log shipment

    • Flashback data archives

    Best regards,

    Orkun Gedik

    Edited by: Orkun Gedik on May 31, 2011 9:27 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 31, 2011 at 06:41 AM

    Hi,

    Thanks for the quick reply. I just want to know what will be effect on existing PI 7.1 like any problems if migrated to 11g or what steps to be taken before migrating to 11g.

    Thanks,

    Sreekanth

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I can share one of my experience after I upgraded Oracle 10 to 11. After the respective upgrade, I faced with a performace problem, because of the table compression. After I corrected the segment, the problem is solved. I didn't face with a further problem after the upgrade.

      Before the upgrade, take an offline backup of your existing system and apply the steps in readme.htm of the upgrade package.

      Best regards,

      Orkun Gedik

  • avatar image
    Former Member
    Oct 04, 2011 at 08:04 AM

    Hi,

    We have planned to upgrade Oracle 10g to 11g. Our environment is HP-UX 11.31, ECC 6.0 and oracle 10.2.0.4. Our production is in cluster environment. Can u please suggest me the steps for oracle upgrade in cluster environment. Like Prerequisites and so on.

    Thanks & Regards,

    Sreekanth

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 11, 2011 at 07:34 AM

    Hi Markus,

    I have checked the notes and the documents, they haven't mentioned about the oracle upgrade in Cluster environment. Can you please where i can get the steps.

    Regards,

    Sreekanth

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello sreekanth,

      For cluster environment you need to make the below canges on both the nodes:

      1. Install client software and related configuration.

      2. Change user environment.

      3. Updating BRTOOLS

      Regards.

      Nirmal.K

  • avatar image
    Former Member
    Oct 11, 2011 at 01:03 PM

    Hi,

    Also when i checked in the software download center i found only RDBMS software oracle 11.2.0.2 for IA64 but i am not able to find RDBMS software oracle 11.2.0.2 for PA-RISC.

    And also i found oracle 11.2.0.2 for 64bit. We have Development server is on PA-RISC and Quality on IA64.

    Please suggest, and also check previous reply.

    Regards,

    Sreekanth

    Add comment
    10|10000 characters needed characters exceeded

    • > Also when i checked in the software download center i found only RDBMS software oracle 11.2.0.2 for IA64 but i am not able to find RDBMS software oracle 11.2.0.2 for PA-RISC.

      11.2 is released on PA-RISC, it is 64bit only.

      > And also i found oracle 11.2.0.2 for 64bit. We have Development server is on PA-RISC and Quality on IA64.

      For future updates on that platform read

      Note 1575609 - Future HPUX support for SAP on Oracle databases

      Markus

  • avatar image
    Former Member
    Oct 12, 2011 at 11:41 AM

    Hi,

    I have read the notes for Future HPUX support for SAP on Oracle databases. I have checked the Download center, the DVD no

    51040893 ORACLE RDBMS 11.2.0.2 HPUX 64bit is it correct DVD for Oralce 11.2.0.2 fro PA-RISC 64 bit.

    Please suggest me,

    Regards,

    Sreekanth

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sreekanth

      Also make sure that BRTOOLs is updated to 7.20 version with avialable latest patch.

      regards to BRTOOLs versions refer to SAP Note : 12741

      Hope it helps

      BR

      Venkat

  • avatar image
    Former Member
    Oct 14, 2011 at 03:38 AM

    Hi,

    Thanks for all, i have one more query.

    When i am checking the notes for Oracle upgrade. I found out that BR*Tools version 700 is not supported to Oracle 11g ( limited support ) according to the note: 1430669.

    Our environment is ECC 6.0 on oracle 10.2 and we are having BRTools version 700 patch 52. So can we upgrade to 11g and install BRTools 700. Or can we install BR*Tools 710

    Is BR*Tools 710 is compatible for SAP 700 kernel because we are having Kernel 700 in our landscape.

    Regards,

    Sreekanth

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      BR*Tools 7.10 works and supported with SAP NW 700 and it is supported for both - 10g/9i

      BR*Tools 7.20 works and supported for SAP NW 700 and it is supported for both - 10g and 11g.

      So when you upgrade from 10g to 11g, please install BR*Tools 7.20.

      Read the Note 12741 - Current versions of BR*Tools and SAPDBA

      The BR*Tools 7.00/7.10 can be used for all SAP releases that run with an Oracle 10g database, or an Oracle 9.2
      The BR*Tools 7.20 can be used with all SAP releases that run with an Oracle 10g or 11g.

      Thanks

  • avatar image
    Former Member
    Oct 17, 2011 at 03:27 PM

    Hi All,

    I have started the oracle 11g software installation. I copied software to server and extracted. I have copied lates installation scripts also and i given full permission to the dum also, But when i started the prerequisite check through the command ,/RUNINSTALLER -check with the orasid user the output screen shows all the points are failed.

    It shows the Physical Memory, orasid failed but 16 GB of RAM and i logged on as orasid.

    Please suggest me to solve this.

    Regards,

    Sreekanth

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      If the problem is New then better to close the old thread and open a new thread. Responses may be be quicker.

      What are the errors, please paste here the log.

      Thanks