Pros and Cons af Oracle 10g upgrade to 11g

[Former Member]

Hi Basis Expert,

We have an requirement of SAP upgrade which includes BW 3.5, CRM and R/3 (4.7).

These components needs to be upgraded to the latest version

BW 3.5 to BI 7.0

R/3 (4.7) to ECC 6.0

and also CRM upgrade to the new version

The OS used is AIX and DB used is oracle 10g.

Can anybody share the pros and cons of oracle DB upgrade from 10g to 11g after SAP upgrade.

Regards,

Anil.

[Former Member · Accepted solution]

Read and follow the standard Inst/Upg guide, it tells you step by step in detail.

Installation guide tells you that you need 3 .SAR files to upgrade your database from 10g to 11gR2 (Re-check and follow).

Installation guide says that you don't need to have a softlink if you are on AIX (Re-check and follow).

Regards,

Nick Loy

[Former Member · Accepted solution]

Hi Nick,

Thanks for your reply.

In Installation Guide it is given that

For a single-instance database upgrade, you only need to extract the database software. The database components are packed in the files OR111264.SAR and OR211264.SAR. If you only use a single instance database, these 2 SAR files alone are sufficient. In this case, you do not need to extract any other SAR files.

Our host has single database and we dont have any other instance running in this host.

So therefore i conclude that i will use OR111264.SAR and OR211264.SAR.

Please correct me if i am wrong.

Regards,

Anil Shenoy.

[Former Member · Accepted solution]

> So therefore i conclude that i will use OR111264.SAR and OR211264.SAR.
> 
> Please correct me if i am wrong.

Not wrong.

Thanks

[Former Member · Accepted solution]

Hi DatabaseSAP /Nick and others,

Thanks for your reply.

As per SAP Upgrade guide

Make sure the following environment variables are not set:

TWO_TASK

ORA_NLS

ORA_NLS32

ORA_NLS33

ORA_NLS10

But in our system when i did echo $ORA_NLS33 it is giving output as /oracle/DBW/102_64/ocommon/nls/admin/data. But remaining environment variables it doesnt give output.

How do i unset ORA_NLS33 ? is it using unset ORA_NLS33 or do i need to manually change it in .dbev.csh, .dbenv.sh , .sapenv.sh, .sapenv.csh from ora<sid> and <sid>adm.

Please help me.

Regards,

Anil Shenoy.

[Former Member · Accepted solution]

Hi Anil,

If you need to remove the parameter for temporary time period (only for that logged on session) then you use unset command for that particular user with which you are working. Otherwise, please remove the variable from .dbev.csh etc. for permanent change.

Thanks

[Former Member · Accepted solution]

Hi DatabaseSAP and others,

I really appreciate the response and help from you Guys.

Soon i will be starting with the Oracle 11g upgrade.

Had a query before starting. I have uploaded the OR111264.SAR and OR211264.SAR in the server inside /spare directory where we take our backup and also dump some software.

1)After uploading the OR111264.SAR and OR211264.SAR file the owner of this file is dbwadm and group is sapsys. Please let me know what permission, owner and group this file should have.

command would be login as <orasid> and goto /spare directory and give SAPCAR -xvf OR111264.SAR /oracle/stage/112_64.

SAPCAR -xvf OR211264.SAR /oracle/stage/112_64

2)Also i would like to know permission of SAP_112023_201109_AIX.zip and even i have kept this under /spare directory.

Regards,

Anil Shenoy.

[Former Member · Accepted solution]

Hi Anil,

The owner for all Oracle related files should be 'orasid' with group 'sapsys'. So, it applies to both of your cases here.

Since you have to extract the files using SAPCAR, so please keep the 'permissions' as 777.

Similarly the 'directory' /oracle/stage/112_64 should be better with 777 and the owner 'orasid'.

Thanks

[Former Member · Accepted solution]

Hi DatabaseSAP and others,

Thanks for your reply.

My OR111264.SAR and OR211264.SAR are in /spare directory.

Can i do the extraction like this

OS> logon as ora<sid>

OS> cd /spare

OS>SAPCAR -xvf OR111264.SAR /oracle/stage/112_64 and SAPCAR -xvf OR211264.SAR /oracle/stage/112_64.

Just wanted to know whether SAPCAR -xvf will work with ora<sid> coz i have used SAPCAR -xvf only with <sid>adm.

Regards,

Anil Shenoy.

[Former Member · Accepted solution]

> Can i do the extraction like this
> 
> OS> logon as ora<sid>
> OS> cd /spare
> OS>SAPCAR -xvf OR111264.SAR /oracle/stage/112_64 and SAPCAR -xvf OR211264.SAR /oracle/stage/112_64.

Hi Anil,

You can do the extraction in either way - by sidadm or by orasid.

Either you logon via sidadm and uncar the .SAR package but keep .SAR files with 777 permissions before. Then the extracted files created might be with the owner 'sidadm'. Then you can update the owner of all the extracted files in a particular directory in one go just by running the command chown -R /path/to/dir - For e.g. chown -R orasid:sapsys 112_64 (when you are already inside /oracle/stage).

Or, you log on via orasid and use kernel path to SAPCAR to extract the SAR files with orasid itself.

OS> logon as orasid

OS> cd /spare

OS> /sap kernel path/SAPCAR -xvf ... (Just type full path to kernel here itself, do not use command cd)

For e.g. OS> /sapmnt/SID/exe/SAPCAR -xvf ...

Thanks

[Former Member · Accepted solution]

Hi DatabaseSAP and others,

Thanks for your reply

I started with the Oracle 11g software installer. But it gave an error during 71%. Error is

Error in invoking target 'rat_on part_on dm_on olap_on sdo_on' of makefile '/oracle/DBW/112_64/rdbms/lib/ins_rdbms.mk'.

See '/oracle/DBW/oraInventory/logs/installActions2011-10-10_12-04-03PM.log' for details.

Abort Retry Continue

But when i was going thorough the installActions2011-10-10_12-04-03PM.log . I could find that there are 7 arguments which is failed.

Below are the argument details

1)INFO: Hard Limit: maximum user processes: This is a prerequisite condition to test whether the hard limit for "maximum user processes" is set to at least 16384.

INFO: Severity:IGNORABLE

INFO: OverallStatus:VERIFICATION_FAILED

INFO: -

---

Verification Result for Node:p19849dev136

INFO: Expected Value:1024

INFO: Actual Value:9223372036854775807

INFO: -

---

INFO: *********************************************

INFO: Hard Limit: maximum user processes: This is a prerequisite condition to test whether the hard limit for "maximum user processes" is set to at least 16384.

INFO: Severity:IGNORABLE

INFO: OverallStatus:VERIFICATION_FAILED

INFO: -

---

INFO: Verification Result for Node:p19849dev136

INFO: Expected Value:16384

INFO: Actual Value:3048

INFO: Error Message:PRVF-4354 : Proper hard limit for resource "maximum user processes" not found on node "p19849dev136" [Expected = "16384" ; Found = "3048"]

INFO: Cause: Hard limit for the resource does not meet the requirement on the specified node.

INFO: Action: Modify the resource limits to meet the requirement.

2)INFO: OS Kernel Parameter: ncargs: This is a prerequisite condition to test whether the OS kernel parameter "ncargs" is properly set.

INFO: Severity:IGNORABLE

INFO: OverallStatus:VERIFICATION_FAILED

INFO: -

---

INFO: Verification Result for Node:p19849dev136

INFO: Expected Value:128

INFO: Actual Value:6

INFO: Error Message:PRVF-7543 : OS Kernel parameter "ncargs" does not have proper value on node "p19849dev136" [Expected = "128" ; Found = "6"].

INFO: Cause: Kernel parameter value does not meet the requirement.

INFO: Action: Modify the kernel parameter value to meet the requirement.

3)INFO: OS Kernel Parameter: tcp_ephemeral_low: This is a prerequisite condition to test whether the OS kernel parameter "tcp_ephemeral_low" is properly set.

INFO: Severity:IGNORABLE

INFO: OverallStatus:VERIFICATION_FAILED

INFO: -

---

INFO: Verification Result for Node:p19849dev136

INFO: Expected Value:9000

INFO: Actual Value:32768

INFO: Error Message:PRVF-7543 : OS Kernel parameter "tcp_ephemeral_low" does not have proper value on node "p19849dev136" [Expected = "9000" ; Found = "32768"].

INFO: Cause: Kernel parameter value does not meet the requirement.

INFO: Action: Modify the kernel parameter value to meet the requirement.

4)INFO: OS Kernel Parameter: tcp_ephemeral_high: This is a prerequisite condition to test whether the OS kernel parameter "tcp_ephemeral_high" is properly set.

INFO: Severity:IGNORABLE

INFO: OverallStatus:VERIFICATION_FAILED

INFO: -

---

INFO: Verification Result for Node:p19849dev136

INFO: Expected Value:65500

INFO: Actual Value:65535

INFO: Error Message:PRVF-7543 : OS Kernel parameter "tcp_ephemeral_high" does not have proper value on node "p19849dev136" [Expected = "65500" ; Found = "65535"].

INFO: Cause: Kernel parameter value does not meet the requirement.

INFO: Action: Modify the kernel parameter value to meet the requirement.

5)INFO: OS Kernel Parameter: udp_ephemeral_low: This is a prerequisite condition to test whether the OS kernel parameter "udp_ephemeral_low" is properly set.

INFO: Severity:IGNORABLE

INFO: OverallStatus:VERIFICATION_FAILED

INFO: -

---

INFO: Verification Result for Node:p19849dev136

INFO: Expected Value:9000

INFO: Actual Value:32768

INFO: Error Message:PRVF-7543 : OS Kernel parameter "udp_ephemeral_low" does not have proper value on node "p19849dev136" [Expected = "9000" ; Found = "32768"].

INFO: Cause: Kernel parameter value does not meet the requirement.

INFO: Action: Modify the kernel parameter value to meet the requirement.

INFO: -

---

6)INFO: OS Kernel Parameter: udp_ephemeral_high: This is a prerequisite condition to test whether the OS kernel parameter "udp_ephemeral_high" is properly set.

INFO: Severity:IGNORABLE

INFO: OverallStatus:VERIFICATION_FAILED

INFO: -

---

INFO: Verification Result for Node:p19849dev136

INFO: Expected Value:65500

INFO: Actual Value:65535

INFO: Error Message:PRVF-7543 : OS Kernel parameter "udp_ephemeral_high" does not have proper value on node "p19849dev136" [Expected = "65500" ; Found = "65535"].

INFO: Cause: Kernel parameter value does not meet the requirement.

INFO: Action: Modify the kernel parameter value to meet the requirement.

7)INFO: Users With Same UID: This test checks that multiple users do not exist with user id as "0".

INFO: Severity:CRITICAL

INFO: OverallStatus:VERIFICATION_FAILED

INFO: -

---

INFO: Verification Result for Node:p19849dev136

WARNING: Result values are not available for this verification task

INFO: Error Message:<CV_VAL>root,|super,|zero,|</CV_VAL><CV_ERES>0</CV_ERES>

INFO: Cause:Cause Of Problem Not Available

INFO: Action:User Action Not Available

INFO: *********************************************

Please let me know what is the 7th (last one) argument.

Regards,

Anil Shenoy

[Former Member · Accepted solution]

Hello,

First error is for maximum user processes - rectify it and set maxuprc = 16384

Another one is for udp_ephemeral_high, set it to 65500

Last one is Users With Same UID, this can be ignored.

If you are not able to, then ask your Unix team to set those parameters for you. Read Note 1431796 - Oracle 11.2.0: Troubleshooting the Software Installation as well.

Thanks

[Former Member · Accepted solution]

Hi DatabaseSAP and others,

Thanks for your reply.

During Oracle 11g software installation i have noticed that Installation location(Software location) by default it came as /oracle/DBW/11202. But i have created /oracle/DBW/112_64 as my oracle home directory. So when i selected /oracle/DBW/112_64 as software location. System gave an message that "The selected Oracle home contains directories or files. Are you sure you want to continue". I said yes and it continued further.

Please let me know is this correct?

Regards,

Anil Shenoy.

[Former Member · Accepted solution]

Hello Anil,

You have to read the Note 1524205 - Oracle 11.2.0: Database Software Installation for 'installation location' and 'Run-time location'

Thanks

[Former Member · Accepted solution]

Hi DatabaseSAP and others,

I have started with Database Upgrade Assistant and since 35-40 mins it is in getting database information screen.

The last line is the logs says that Starting Database Upgrade Assistant in interactive mode.

Just wanted to know does this take time?

Regards,

Anil Shenoy.

[Former Member · Accepted solution]

Hi Anil,

It should not take that much time in initial screen itself. Check if some other log file is available and verify the environment variables.

Thanks

[Former Member · Accepted solution]

Hi DatabaseSAP and others,

Thanks for helping me.

I completed oracle 11g upgrade.

But i wanted to know why are we creating 11202 and 112_64 in oracle 11g and pointing 11202->112_64. I have read the SAP Note for this.

But in 10g we didnt had this kind of installation.

Regards,

Anil Shenoy.

[Former Member]

Go through the standard Upgrade guide which tells you the requirements of resources and patches.

Regards,

Nick Loy

[Former Member]

Hi Nick and others,

Thanks for your reply.

I had gone through the SAP oracle 11g upgrade guide and now i am preparing document of my own.Here i would like to know about the software. We are on AIX 5.3 and DB is 10.2.0.4

From service market place i could found that following are the software which are required in an oracle 11g upgrade (oracle 11.2 64bit)

Oracle 11.2.0.2 Installation - ?

Oracle 11g patch bundle - SAP_112023_201109_AIX.zip

Oracle 11 instant client - ZIP 51038966 (Oracle client 11.2)

Brtools - ?

Please let me know the media name for oracle 11.2.0.2 installation and brtools version from SAP Service market place and also confirm whether Oracle 11g patch bundle and Oracle 11 instant client is correct.

Regards,

Anil.

[Former Member]

Hello,

Following will be the 11g RDBMS DVDs, you can navigate to search them in for e.g. NW 7.3 installation path.

EXE 51040503_1 ORACLE RDBMS 11.2.0.2 AIX 64bit 1 of 8 Info 976563 18.04.2011

RAR 51040503_2 ORACLE RDBMS 11.2.0.2 AIX 64bit 2 of 8 Info 976563 18.04.2011

RAR 51040503_3 ORACLE RDBMS 11.2.0.2 AIX 64bit 3 of 8 Info 976563 18.04.2011

RAR 51040503_4 ORACLE RDBMS 11.2.0.2 AIX 64bit 4 of 8 Info 976563 18.04.2011

RAR 51040503_5 ORACLE RDBMS 11.2.0.2 AIX 64bit 5 of 8 Info 976563 18.04.2011

RAR 51040503_6 ORACLE RDBMS 11.2.0.2 AIX 64bit 6 of 8 Info 976563 18.04.2011

RAR 51040503_7 ORACLE RDBMS 11.2.0.2 AIX 64bit 7 of 8 Info 976563 18.04.2011

RAR 51040503_8 ORACLE RDBMS 11.2.0.2 AIX 64bit 8 of 8 Info 288095 18.04.2011

For 11g, the recommended version of BRTools is 7.2, go through the following SAP Notes and download the correct version from kernel download path,

Note 1430669 - BR*Tools support for Oracle 11g

Note 12741 - Current versions of BR*Tools and SAPDBA

Both of these are correct -

Oracle 11g patch bundle - SAP_112023_201109_AIX.zip

Oracle 11 instant client - ZIP 51038966 (Oracle client 11.2)

Thanks

[Former Member]

Hi All,

Thanks for your reply.

After extracting all the 8 files from 51040503_part1 to 51040503_part8 Oracle RDBMS 11.2.0.2 AIX64 bit.

I could found that one folder by name 51040503 is created and the content in the folder is as below

CDLABEL.ASC

CDLABEL.EBC

COPY_TM

COPY_TM

LABEL.ASC

LABEL.EBC

MD5FILE

OR111264.SAR

OR211264.SAR

OR311264.SAR

OR411264.SAR

OR511264.SAR

OR611264.SAR

OR711264.SAR

SHAFILE

VERSION.ASC

VERSION.EBC

Please let me know which .SAR file i need to extract.

Also from the SAP Note 1430669 BR*Tools support for Oracle 11g. Here it is mentioned that

Note 1:

-

---

To be able to use BR*Tools under Oracle 11g on Unix platforms (except for

AIX), you must set up the following soft link in $ORACLE_HOME/lib:

> > cd $ORACLE_HOME/lib

> ln -s libnnz11.so libnnz10.so

Note the following:

The soft link is no longer required for the version of BR*Tools 7.20 that

is delivered with SAP Kernel 7.20_EXT. You can only use these tools as of

certain operating system versions (see Product Availability Matrix (PAM), for example, for IBM AIX as of Version 6.1).

We are on AIX 5.3 so do we need to create this symbolic link?

Regards,

Anil

[Former Member]

> Note 1:
> -
> To be able to use BR*Tools under Oracle 11g on Unix platforms (except for
> AIX), you must set up the following soft link in $ORACLE_HOME/lib:
> > > cd $ORACLE_HOME/lib
> > ln -s libnnz11.so libnnz10.so
> Note the following:
> The soft link is no longer required for the version of BR*Tools 7.20 that
> is delivered with SAP Kernel 7.20_EXT. You can only use these tools as of
> certain operating system versions (see Product Availability Matrix (PAM), for example, for IBM AIX as of Version 6.1).
> 
> We are on AIX 5.3 so do we need to create this symbolic link?
> 
> Regards,
> Anil

No, link requirement is not for AIX.

Thanks

[Former Member]

I sign with this.

Oracle extended support (Chargable) started from 1st of August 2011, So better to plan your database upgrade before starting with your Apps upgrade.

Regards,

Nick Loy

[Former Member]

Hi All,

Thanks for your reply

Suppose if we upgrade oracle first than is there any OS patches which we have to update before starting DB upgrade.

Our OS is AIX.

Can you guys please let me know information on this.

Regards,

Anil.

[Former Member]

Hello,

What is the AIX version ?

We faced a problem on AIX 6.1 and referred to the Note 1380818 - Oracle Installer Detects Java Process Running on ORACLE_HOME

Now AIX 7.1 is supported as well. Please try to refer some SAP notes and go through some 11g collective notes too.

Note 1541935 - Using SAP systems with AIX 7.1

Note 1137862 - Using SAP systems with AIX 6.1

Note 1458918 - Support for AIX 7.1

Thanks

[nicholas_chang]

Hi,

Please refer as below:

1) Oracle 10.2.0.5 will be chargeable and extended support until july 2013 where oracle 11g will be on free standard support until Jan 2015

2) Stable with upgrade and normal operation

3) Many new features are support by oracle 11g such as ASM & compression. For detail information on each new features & enhancement, refer to:

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d053aa41-75b6-2d10-95b5-9a961a5ae...

Thanks,

Nicholas Chang

[lbreddemann]

ahm... you mean cons like

'with Oracle 11g you would be using the only currently supported version of Oracle'?

regards,

Lars

[Former Member]

I don't see any cons (disadvantage) in going for upgrade from 10g to 11g. There should not be any except a bit of sap downtime

Whether you want to upgrade oracle before sap upgrade or after sap upgrade, that's your and project call. However, considering the extended paid support for 10g, better you upgrade the oracle before sap upgrade.