cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Migrating from Oracle 10g to 11g

Former Member

on ‎05-31-2011 6:42 AM

0 Kudos

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

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (9)

Answers (9)

Former Member
‎10-17-2011 5:14 PM
0 Kudos

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

Show replies
Show replies
Former Member
‎10-17-2011 4:27 PM
0 Kudos

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

Show replies
Show replies
Former Member
‎10-17-2011 4:47 PM
0 Kudos

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

Former Member
‎10-14-2011 4:38 AM
0 Kudos

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

Show replies
Show replies
Former Member
‎10-14-2011 5:59 AM
0 Kudos

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

Former Member
‎10-12-2011 12:41 PM
0 Kudos

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

Show replies
Show replies
markus_doehr2
Active Contributor
‎10-12-2011 1:12 PM
0 Kudos

> 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.

Yes, that is the proper one.

Markus

former_member213250
Active Participant
‎10-14-2011 12:02 AM
0 Kudos

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

Former Member
‎10-11-2011 2:03 PM
0 Kudos

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

Show replies
Show replies
markus_doehr2
Active Contributor
‎10-11-2011 2:25 PM
0 Kudos

> 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

Former Member
‎10-11-2011 8:34 AM
0 Kudos

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

Show replies
Show replies
nirmal_konchada
Active Contributor
‎10-12-2011 8:13 AM
0 Kudos

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

Former Member
‎10-04-2011 9:04 AM
0 Kudos

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

Show replies
Show replies
markus_doehr2
Active Contributor
‎10-04-2011 11:00 AM
0 Kudos

There are database upgrade guides available:

http://service.sap.com/instguides

--> Database Upgrades

--> Oracle

Read them and check the notes mentioned in that guide. This should answer all your questions.

Markus

Former Member
‎05-31-2011 7:41 AM
0 Kudos

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

Show replies
Show replies
Former Member
‎05-31-2011 7:47 AM
0 Kudos

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

Former Member
‎05-31-2011 7:21 AM
0 Kudos

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

Show replies
Show replies
Ask a Question