Oracle Update

[Former Member]

Hello,

I'm trying to update my Oracle DB 11.2.0.3 with the SBP patch SAP11203P_1309-20009977.ZIP

I've changed the oracle_home variable to -->  setenv ORACLE_HOME /oracle/<DBSID>/11203

I´ve executed correctly the MOPatch in documentation mode.

Then when I want to execute MOPatch to install. I´ve declared:

-ORACLE_HOME = /oracle/SID/112_64

-There must be no processes running from the Oracle Home

-slibclean

I get this first error and after that I cannot update the different patches.

Processing patch "SAP11203P_1309-20009977.zip!SBP_112037_201309!16619892!13343438"...(1 of 98)
Processing patch "SAP11203P_1309-20009977.zip!SBP_112037_201309!16619892!13343438"...failed.
Reason: Cannot parse OPatch output and log file.

[Reagan]

20009977.zip!SBP_112037_201309!16619892!13696216"...failed.
Reason: Cannot parse OPatch output and log file.

Check this SAP note

841728  - 10.2: Solutions for installation and upgrade problems

Regards

RB

[Reagan]

To stop listener.

su - orasid

lsnrctl stop

Also provide me the output of this command.

ls -la /oracle/SID

Regards

RB

[Former Member]

-Listener

> lsnrctl stop

LSNRCTL for IBM/AIX RISC : Version 11.2.0.3.0 - Production on 18-NOV-2013 17:48:05

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   IBM/AIX RISC  Error: 79: Connection refused

ls -la /oracle/SID

sapr3:orasid 13> ls -la /oracle/SID

total 504

drwxr-xr-x   17 orasid   dba            4096 Nov 18 17:48 .

drwxr-xr-x   10 orasid   dba             256 Nov 18 14:45 ..

-rw-r-----    1 orasid   dba            1765 Nov 12 17:29 .cshrc

-rw-r-----    1 orasid   dba            1530 Nov 12 17:28 .cshrc.1

-rw-r-----    1 orasid   dba            5828 Nov 12 17:29 .dbenv.csh

-rw-r-----    1 orasid   dba            5600 Nov 12 17:29 .dbenv.sh

-rw-r-----    1 orasid   dba            5828 Nov 12 17:29 .dbenv_sapr3.csh

-rw-r-----    1 orasid   dba            5600 Nov 12 17:29 .dbenv_sapr3.sh

drwxr-xr-x    3 orasid   dba             256 Nov 14 09:25 .java

-rwxr-----    1 orasid   dba            1992 Nov 12 17:29 .login

-rwxr-----    1 orasid   dba             227 Nov 12 17:25 .login.1

-rwxr-----    1 orasid   dba            1757 Nov 12 17:28 .login.2

drwxr-xr-x    3 orasid   dba             256 Nov 14 09:31 .oracle

-rw-r-----    1 orasid   dba            1624 Nov 12 17:29 .profile

-rw-r-----    1 orasid   dba            1297 Nov 12 17:28 .profile.1

-rw-r-----    1 orasid   dba            9951 Nov 12 17:28 .sapenv.csh

-rw-r-----    1 orasid   dba            9124 Nov 12 17:28 .sapenv.sh

-rw-r-----    1 orasid   dba            9951 Nov 12 17:28 .sapenv_sapr3.csh

-rw-r-----    1 orasid   dba            9124 Nov 12 17:28 .sapenv_sapr3.sh

-rw-r-----    1 orasid   dba            1530 Nov 12 17:28 .sapsrc.csh

-rw-r-----    1 orasid   dba            1297 Nov 12 17:28 .sapsrc.sh

-rw-r-----    1 orasid   dba            1530 Nov 12 17:28 .sapsrc_sapr3.csh

-rw-r-----    1 orasid   dba            1297 Nov 12 17:28 .sapsrc_sapr3.sh

-rw-------    1 root     system          544 Nov 14 16:47 .sh_history

-rw-------    1 orasid   dba              47 Nov 18 16:11 .vi_history

lrwxrwxrwx    1 root     system            6 Nov 14 17:11 11203 -> 112_64

drwxr-xr-x   79 orasid   dba            4096 Nov 18 17:24 112_64

-rw-rw-r--    1 orasid   dba           76414 Nov 15 12:50 11ginstall_11203.log

drwxr-xr-x    2 orasid   dba            4096 Nov 18 17:24 Patch_11203

drwxr-xr-x    2 root     system          256 Oct 30 12:25 lost+found

-rw-r--r--    1 orasid   dba               0 Nov 18 17:48 lsnrctl

drwxr-xr-x    3 orasid   dba             256 Oct 30 12:50 mirrlogA

drwxr-xr-x    3 orasid   dba             256 Oct 30 12:50 mirrlogB

drwxr-xr-x    4 orasid   dba             256 Nov 11 17:07 oraarch

drwxr-xr-x    3 orasid   dba             256 Oct 30 13:08 origlogA

drwxr-xr-x    3 orasid   dba             256 Oct 30 13:09 origlogB

drwxr-xr-x    3 orasid   dba             256 Oct 30 13:09 sapdata1

drwxr-xr-x    3 orasid   dba             256 Oct 30 13:09 sapdata2

drwxr-xr-x    3 orasid   dba             256 Oct 30 13:09 sapdata3

drwxr-xr-x    3 orasid   dba             256 Oct 30 13:10 sapdata4

drwxr-xr-x    3 orasid   dba             256 Oct 30 12:51 sapreorg

-rwxr-xr-x    1 orasid   dba           15648 Sep 17 23:46 startdb

-rwxr-xr-x    1 orasid   dba           12381 Jun 14 15:30 stopdb

[ashish_vikas]

lrwxrwxrwx    1 root     system            6 Nov 14 17:11 11203 -> 112_64

drwxr-xr-x   79 orasid   dba            4096 Nov 18 17:24 112_64

generally i link the other way 🙂

[Reagan]

The symbolic link is created in the opposite way.

You may apply the patch as I have suggested above.

Regards

RB

[Former Member]

Then I must to change the direction of symbolic link? How can change? When I was reading the man I thought this was the best way.

Could you verify me that the lsnrctl is stopped correctly? I´ve executed the script stopdb to stop db.

[ashish_vikas]

just check if any Listener  process is running..

ps -aef | grep LIS

ps -aef | grep ora<sid>

OR with command : lsnrctl status

best regards

ashish

[Reagan]

Then I must to change the direction of symbolic link? How can change? When I was reading the man I thought this was the best way.

Dont change that now. I believe that /oracle/SID/112_64 is a file system.

df -g /oracle/SID/112_64

Could you verify me that the lsnrctl is stopped correctly? I´ve executed the script stopdb to stop db.

For sure there is not listener running under that user but for you to be sure check it from the OS level.

ps -ef | grep -i tnslsnr

Regards

RB

[Former Member]

Yes, it´s a filesystem. It`s doesn't matter the direction?

I´ve executed ps -ef | grep -i tnslsnr and I get -->

orasid 8519688 8913044   0 19:01:29  pts/0  0:00 grep -i tnslsnr

I must to kill the process 8519688 it's not?

[Reagan]

There is no listener running.

As suggested you may continue with the bundle patch installation.

Regards

RB

[Former Member]

I´ve tried again but I'm getting the same error:

Processing patch "SAP11203P_1309-20009977.zip!SBP_112037_201309!16619892!13343438"...(1 of 98)
Processing patch "SAP11203P_1309-20009977.zip!SBP_112037_201309!16619892!13343438"...failed.
Reason: Cannot parse OPatch output and log file.

Processing patch "SAP11203P_1309-20009977.zip!SBP_112037_201309!9656644"...(2 of 98)
Processing patch "SAP11203P_1309-20009977.zip!SBP_112037_201309!9656644"...skipped.
Reason: Already installed.

Processing patch "SAP11203P_1309-20009977.zip!SBP_112037_201309!9584028"...(3 of 98)
Processing patch "SAP11203P_1309-20009977.zip!SBP_112037_201309!9584028"...skipped.
Reason: Already installed.

Processing patch "SAP11203P_1309-20009977.zip!SBP_112037_201309!9458152"...(4 of 98)
Processing patch "SAP11203P_1309-20009977.zip!SBP_112037_201309!9458152"...skipped.
Reason: Already installed.

Processing patch "SAP11203P_1309-20009977.zip!SBP_112037_201309!16619892!13696216"...(5 of 98)
Processing patch "SAP11203P_1309-20009977.zip!SBP_112037_201309!16619892!13696216"...failed.
Reason: Cannot parse OPatch output and log file.

Patches marked with a "@" were skipped since they are online
patches and MOPatch is running in offline mode.  For each online
patch there is a usually a corresponding offline patch that fixes
the same problem.  Check whether the corresponding offline
patches were successfully installed.

Please check the listed patches and, if required, install them
manually according to their installation instructions.

Skipped 3 of 98 patches since they were already installed:
  SAP11203P_1309-20009977.zip!SBP_112037_201309!9656644
  SAP11203P_1309-20009977.zip!SBP_112037_201309!9584028
  SAP11203P_1309-20009977.zip!SBP_112037_201309!9458152

Patch Inventory Status:
-----------------------
Patches installed in Oracle Home /oracle/SID/112_64:
+ 9458152 (sql)
+ 9584028 (sql)
+ 9656644 (sql)

[Reagan]

Stop Oracle database and listener.

su - orasid

setenv ORACLE_HOME /oracle/SID/112_64

cd to the location of SAP11203P_1309-20009977.ZIP

/bin/sh $ORACLE_HOME/MOPatch/mopatch.sh -v -s SAP11203P_1309-20009977.ZIP

Regards

RB

[Former Member]

Hello Reagan,

It's necessary to stop oracle database and listener, I´m installing the oracle database and update them in the middle of an installation.

[ashish_vikas]

yes, no oracle should be running including listener.

best regards

ashish

[Reagan]

If the database is running under a different ORACLE_HOME (eg: /oracle/SID/102_64) then there is no need to stop the database and listener.

Regards

RB

[Former Member]

The database is running in ORACLE_HOME  /oracle/SID/112_64, then I need to declare the oracle_home to  /oracle/SID/11203?

I´ve tried to stop listener with lsnrctl status

and the database with stopsap db

[ashish_vikas]

there should be a link.. where does /oracle/SID/112_64 points ?  11023 ?

if yes, its same thing.

you need to stop everything under ORACLE_HOME means database & linstener.

lsitener is stopped with command : lsntctl stop <LISTENER_NAME>

best regards

ashish

[Reagan]

The path /oracle/SID/112_64 should be a symbolic link to /oracle/SID/11203

In your case you will need to stop the database and listener to patch the bundle patches.

Regards

RB

[former_member188883]

Hi Ruben,

It looks to me as a problem with the zip file SAP11203P_1309-20009977.zip.

Could you download one more time and copy the same in binary format to the server.

Hope this helps.

Regards,

Deepak Kori

[ashish_vikas]

you should use updated version of OPatch and MOpatch.

unzip SAP11203P_1309-20009977.zip in a separate directory. This will contain new OPatch & MOpatch directories. please take a backup of your old OPatch+MOpatch and replace those with new one.

after this, start Mopatch again.

best regards

ashish

[Former Member]

Thanks ashish,

I´ve updated the MOPatch and Opatch with the last patch from SMP, and I backup the previous version.