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: 

Oracle Upgrade from 10.2.0.5 to 11.2.0.2

Go to solution
former_member182034
Active Contributor

on ‎09-10-2012 8:12 PM

0 Kudos

Dear,

I am following below link to upgrade Oracle from 10205 to 11202.

upgrade-to-oracle-database-11g-release-2-11-2-unix-for-sap/

I have downloaded below DVD

51040507 = ORACLE RDBMS 11.2.0.2 LINUX x86_64 1 of 6

and extracted the ORX11264 and paste it in /oracle/stage/112_64. The Oracle 11g successfully installed in /oracle/IDS/11202 but the folder (sap/ora_upgrade/pre_upgrade/) is not created/missing under /oracle/IDS/11202. these scrips(pre_upgrade_status.sql, dbua.sap.sh) are also not showing under 11202 folder

these upgrade scripts (utlu112i.sql, utlu112i_sap.sql) is also mentioned in SAP NOTE 1431793 - Oracle 11.2.0: Upgrade Scripts

from where I can get these scripts for Linux SLES and which are the next steps?

Please guide me?

Regards,


Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎09-11-2012 8:59 AM
0 Kudos

Please read carefully SAP Note 1431793.

"

3. Installing Upgrade Scripts

The upgrade scripts are delivered as SAP-specific generic Oracle database patch (patch 9584028).

  • For Unix/Linux platforms:
    The current version of the upgrade scripts is automatically installed if the current SAP Bundle Patch is installed. No further installation is required.


    To install a newer version of the upgrade scripts -if available-, download the patch from SAP service marketplace and install it:
    https://service.sap.com/swdc
    -> Database Patches
    -> Oracle
    -> Oracle <release>
    -> Database RDBMS
    -> MS Windows platform (32-bit or x64)
    -> p9584028_<release>_Generic.zip

    As the patch is generic, it can be installed on all platforms.

    You can install the patch using mopatch with the following command:
    OS> $ORACLE_HOME/MOPatch/mopatch.sh -s \
        p9584028_<release>_Generic.zip
  • For Windows platforms:
    To install the upgrade scripts patch 9584028 for your target release, download the patch file and run the following commands (see SAP note 1503709):

    OS> unzip p9584028_<release>_Generic.zip
    OS> cd 9584028
    OS> %ORACLE_HOME%/OPatch/opatch apply

    For information how to install a patch with OPatch see note 839182.


Note:

  • SAP-specific database patches are installed in the Oracle Home in subdirectory '<ORACLE_HOME>/sap'.
  • The upgrade scripts are installed in the Oracle Home in directory '<ORACLE_HOME>/sap/ora_upgrade'.


The directory '<ORACLE_HOME>/sap/ora_upgrade' is denoted by <ora_upgrade> within the context of this note.

"

Regards

Roman

Show replies
Show replies
former_member182034
Active Contributor
‎09-11-2012 12:48 PM
0 Kudos

hi Roman,

thanks for reply.

Dear,

Please checked the attached result of scripts specially (pre_upgrade_status.txt) which I executed and guide me which things I have to rectify before run upgrade.

Regards,

pre_upgrade_status.txt.zip
pre_upgrade_tasks.txt.zip
Former Member
‎09-11-2012 1:18 PM
0 Kudos

1. You does not need to remove obsolete parameters. After upgrading your database these parameters will be replaced by diagnostic_dest automatically.

2. You does not need to upgrade the timezone version. After upgrading your database the timezone version will be upgraded automatically.

3. Oracle recommends removing all hidden parameters prior to upgrading. After upgrading your database adjust oracle parameters according to Note 1431798 - Oracle 11.2.0: Database Parameter Settings. See also Note 1171650 - Automated Oracle DB parameter check

Before database upgrade please don't forget to perform backup of your database.

Regards

Roman

former_member182034
Active Contributor
‎09-12-2012 7:05 AM
0 Kudos

Dear Roman,

I am getting below parameter during upgrade..

ORA-32006 REMOTE_OS_AUTHENT initialization parameter has been deprecated'

now I have to Ignore this error or abort?

Regards,

Former Member
‎09-12-2012 7:23 AM
0 Kudos

It depends on what version of SAP kernel you are using. Please read Note 1431798 - Oracle 11.2.0: Database Parameter Settings (search for REMOTE_OS_AUTHENT) and Note 1622837 - New connect method of AS ABAP to Oracle via SSFS

You may ignore this warning during upgrade process.

Regards

Roman

former_member182034
Active Contributor
‎09-12-2012 8:30 AM
0 Kudos

hi Roman,

Oracle successfully updated, please tell me about Environmental Variable ORACLE_HOME.

would you also confirm me those profile files and folder in which I have to change the value.

profile files are exist in below folders

/home/idsadm/.dbenv_sapsuse.csh

or

/oracle/IDS/.dbenv_sapsuse.csh

Regards,

majamil1@gmail.com (please add)

Former Member
‎09-12-2012 8:40 AM
0 Kudos

Point ORACLE_HOME to /oracle/IDS/112_64 (symlink to /oracle/IDS/11202).

You must change values in both folders (/home/idsadm for idsadm user and /oracle/IDS for oraids user) in files .dbenv_sapsuse.csh, .dbenv_sapsuse.sh, .dbenv.csh, .dbenv.sh

Regards

Roman

former_member182034
Active Contributor
‎09-12-2012 10:35 AM
0 Kudos

hi Roman,

thanks for your replies.

Dear, I have to change all the 102_64 to 112_64 or only need to change against ORACLE_HOME.

.dbenv_sapsuse.csh

set ADD=/oracle/client/10x_64/instantclient
set _t=/oracle/IDS/102_64/bin/sqlplus
if ( -r "$_t" || `uname -n` == "$SAPDBHOST"  ) then
    setenv ORACLE_HOME /oracle/IDS/102_64
  endif
else
  setenv ORACLE_HOME     /oracle/IDS/102_64
  set ADD=/oracle/IDS/102_64/lib

Regards,

Former Member
‎09-12-2012 10:44 AM
0 Kudos

Please change all occurences of 102_64 to 112_64. Also change 10x_64 to 11x_64 for instantclient (if you replaced instantclient)

Regards

Roman

former_member182034
Active Contributor
‎09-14-2012 12:53 PM
0 Kudos

hi Roman,

Dear,
I am getting issue when I am trying to apply interim patches,

Please have a look at attached log and guide.

Regards,

mopatch.sh -s SAP_112026_201207_LINX8664.txt.zip
Former Member
‎09-14-2012 1:09 PM
0 Kudos

It seems that you try to start patch applying several times concurrently. Please provide detailed steps how you perform patch applying.

Also provide output from ls -la $ORACLE_HOME/.patch_storage

Regards

Roman

former_member182034
Active Contributor
‎09-15-2012 5:41 AM
0 Kudos

hi Roman,

yes, U r saying right, I tried more than onetime, Now I am sharing the log.

Regards,

.patch_Stoage_ls -la.txt.zip
Former Member
‎09-17-2012 7:54 AM
0 Kudos

Try to apply interim patches again

Regards

Roman

former_member182034
Active Contributor
‎09-19-2012 8:07 AM
0 Kudos

hi Roman,

Dear,

MOPatch:

I was getting issue during MOPatch.

Cannot start MOPatch (already running according to PID file "/oracle/IDS/112_64/.mopatchpid").

OPatch:

now I am getting below warning against all interim patches

Patching component oracle.rdbms.dbscripts, 11.2.0.2.0...

Patch 10357961 successfully applied

OPatch Session completed with warnings.

Log file location: /oracle/IDS/112_64/cfgtoollogs/opatch/opatch2012-09-19_11-57-43AM.log

OPatch completed with warnings.

what do you say about Warning and mopatchpid?

Regards,

Former Member
‎09-19-2012 8:25 AM
0 Kudos

Check if mopatch.sh is active with ps command. If not try to delete /oracle/IDS/112_64/.mopatchpid file and try to start mopatch again.

Please paste lof file for opatch.

Regards

Roman

former_member182034
Active Contributor
‎09-19-2012 8:53 AM
0 Kudos

hi Roman,

the MOPatch issue resolved after below command.

root# mv .mopatchpid .mopatchpid_old

please find attached OPatch and MOPatch log.

while I again get the below error during mopatch.

Processing patch "SAP_112027_201208_LINX8664.zip!9373370"...skipped.

Processing patch "SAP_112027_201208_LINX8664.zip!13923804!13923804"...(15 of 107)

Processing patch "SAP_112027_201208_LINX8664.zip!13923804!13923804"...failed.

Reason: Cannot parse OPatch output and log file.

Processing patch "SAP_112027_201208_LINX8664.zip!8331063"...(16 of 107)

why above patch is failed?

Regards,

OPatchLog.txt.zip
mopatch.sh -s SAP_112027_201208_LINX8664.txt.zip
Former Member
‎09-19-2012 9:32 AM
0 Kudos

Please provide the output of opatch lsinventory command. Have you performed $ORACLE_HOME backup before SBP installation?

Regards

Roman

former_member182034
Active Contributor
‎09-19-2012 10:20 AM
0 Kudos

hi Roman,

Have you performed $ORACLE_HOME backup before SBP installation?

yes...

please find the attached log of opatch lsinventory

Congrats: now you are Active Contributor Bronze

Regards,


opatch lsinventory.txt.zip
Former Member
‎09-19-2012 10:33 AM
0 Kudos

Please restore you backup and try again. Please run mopatch utility only one time (according to upgrade guide).

Warning in your opatch log relate to installing interim patch already installed in oracle.

Regards

Roman

former_member182034
Active Contributor
‎09-19-2012 11:41 AM
0 Kudos

hi

I started the SAP.

would you explain the issue?

why I have to restore the system? which issue may i face and when?

below sequence of patching is Ok. please confirm me.

1. Update OPatch and MOPatch

2. Update Interim patches

3. Update SBP

regards,

Former Member
‎09-19-2012 12:03 PM
0 Kudos

It is your decision to install SBP or not.

Regards

Roman

former_member182034
Active Contributor
‎09-19-2012 12:18 PM
0 Kudos

rightnow.

I had executed MOPatch more then one time and now I can only upgrade MOPatch after restore db.

otherwise, I cant apply SBP. is it right?

Regards,

Former Member
‎09-19-2012 12:45 PM
0 Kudos

You can try to deinstall SBP according to README file and then install it again from scratch.

Regards

Roman

former_member182034
Active Contributor
‎09-19-2012 2:23 PM
0 Kudos

hi Roman,

dear, I did rollback the patches and again applied these Patches, please have a look the attached logs.

would you tell me about below text.

This patch overlays patches

Regards,

majamil1@gmail.com

Message was edited by: M. Abdul Jamil

opatch_lsinventory all.txt.zip
rollback.txt.zip

Answers (0)

Ask a Question