Tags

, , ,

IBM AIX 5.3
Oracle Enterprise Ed 11.2.0.3
The patch is available on Metalink. (Patch 13612575)

Actually the semptoms can vary but, after migration/upgrade processes we encountered the bug which was fixed in 11.2.0.4
Hopefully, there was a one-off-patch available for this case.

ORA-00600: …: [15419], [severe error during PL/SQL execution], [], [], [], [], [], [], [], [], [], []
ORA-06544: PL/SQL: …: [78402], [], [], [], [], [], [], []
ORA-06553: PLS-801: … [78402]
Incident details in: /xxx_ora_852220_i6250.trc
See Note 411.1 at My Oracle Support for error and packaging details.
Thu May 17 13:57:24 2012
Sweep [inc][6250]: completed
Sweep [inc2][6250]: completed

Here is the patching information:

oracle@server:/oracle/patch >echo $ORACLE_HOME
/oracle/oracle/11203
oracle@server:/oracle/patch >echo $PATH
/oracle/oracle/11203/bin:/usr/sbin:/usr/bin:/bin:/usr/ccs/bin:/usr/vac/bin:/usr/ucb:/usr/local/bin:/opt/gnu/bin:.:/data3/oracle/utldir:/data3/oracle/mntdir:/oracle/oracle/11203/OPatch
oracle@server:/oracle/patch >opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.

Oracle Home : /oracle/oracle/11203
Central Inventory : /oracle/oraInventory
from : /oracle/oracle/11203/oraInst.loc
OPatch version : 11.2.0.3.0
OUI version : 11.2.0.3.0
Log file location : /oracle/oracle/11203/cfgtoollogs/opatch/opatch2012-05-18_16-16-31PM_1.log

Lsinventory Output file location : /oracle/oracle/11203/cfgtoollogs/opatch/lsinv/lsinventory2012-05-18_16-16-31PM.txt


Installed Top-level Products (2):

Oracle Database 11g 11.2.0.3.0
Oracle Database 11g Examples 11.2.0.3.0
There are 2 products installed in this Oracle Home.

Interim patches (1) :

Patch 13696216 : applied on Wed May 09 15:16:57 EEST 2012
Unique Patch ID: 14628258
Patch description: “Database Patch Set Update : 11.2.0.3.2 (13696216)”
Created on 8 Apr 2012, 21:52:22 hrs PST8PDT
Sub-patch 13343438; “Database Patch Set Update : 11.2.0.3.1 (13343438)”
Bugs fixed:
12950644, 12960925, 12923168, 12834027, 12612118, 12764337, 13772618
13420224, 12894807, 13742435, 12829021, 13742434, 13742433, 10350832
13742438, 13742437, 13742436, 12905058, 12998795, 12588744, 13528551
13503598, 9873405, 12582664, 13632717, 13343438, 12861463, 12620823
12849688, 13041324, 13696216, 13492735, 13742464, 13466801, 12917230
13332439, 13036331, 12938841, 13035804, 12656535, 13499128, 13362079
12662040, 9703627, 11063191, 11877623, 12845115, 13070939, 12748240
12847466, 12718090, 12780098, 13354082, 12797765, 12919564, 12780983, 13554409


OPatch succeeded.
oracle@server:/oracle/patch >ps -ef|grep pmon
oracle 450690 1 0 May 11 – 2:01 ora_pmon_YTRMDEV
oracle 577578 942082 0 16:19:22 pts/0 0:00 grep pmon
oracle@server:/oracle/patch >sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri May 18 16:19:27 2012

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate;
SP2-0717: illegal SHUTDOWN option
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> !ps -ef|grep pmon

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
oracle@server:/oracle/patch >ps -ef|grep pmon
oracle 270480 942082 1 16:20:58 pts/0 0:00 grep pmon
oracle@server:/oracle/patch >cd 13612575
oracle@server:/oracle/patch/13612575 >ls -lrt
total 24
drwxr-xr-x 3 oracle dba 256 Feb 17 08:11 files
drwxr-xr-x 4 oracle dba 256 Feb 17 08:11 etc
-rw-rw-r– 1 oracle dba 8905 Feb 17 08:11 README.txt
drwxr-xr-x 4 oracle dba 256 Feb 17 08:11 online
oracle@server:/oracle/patch/13612575 >opatch apply
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.

Oracle Home : /oracle/oracle/11203
Central Inventory : /oracle/oraInventory
from : /oracle/oracle/11203/oraInst.loc
OPatch version : 11.2.0.3.0
OUI version : 11.2.0.3.0
Log file location : /oracle/oracle/11203/cfgtoollogs/opatch/13612575_May_18_2012_16_21_45/apply2012-05-18_16-21-43PM_1.log

Applying interim patch ‘13612575’ to OH ‘/oracle/oracle/11203’
Verifying environment and performing prerequisite checks…
Patch 13612575: Optional component(s) missing : [ oracle.precomp.lang, 11.2.0.3.0 ]
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/oracle/oracle/11203’)

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…

Patching component oracle.precomp.common, 11.2.0.3.0…

Patching component oracle.rdbms, 11.2.0.3.0…

Patching component oracle.rdbms.rman, 11.2.0.3.0…

Patching component oracle.rdbms.rsf, 11.2.0.3.0…

OPatch found the word “warning” in the stderr of the make command.
Please look at this stderr. You can re-run this make command.

OPatch found the word “warning” in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ld: 0711-773 WARNING: Object /oracle/oracle/11203/lib//libgeneric11.a[sdbgrfu.o], imported symbol timezone
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-783 WARNING: TOC overflow. TOC size: 68320 Maximum size: 65536
Extra instructions are being generated for each reference to a TOC
symbol if the symbol is in the TOC overflow area.

Verifying the update…
Patch 13612575 successfully applied
OPatch Session completed with warnings.
Log file location: /oracle/oracle/11203/cfgtoollogs/opatch/13612575_May_18_2012_16_21_45/apply2012-05-18_16-21-43PM_1.log

OPatch completed with warnings.
oracle@server:/oracle/patch/13612575 >opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.

Oracle Home : /oracle/oracle/11203
Central Inventory : /oracle/oraInventory
from : /oracle/oracle/11203/oraInst.loc
OPatch version : 11.2.0.3.0
OUI version : 11.2.0.3.0
Log file location : /oracle/oracle/11203/cfgtoollogs/opatch/opatch2012-05-18_16-28-01PM_1.log

Lsinventory Output file location : /oracle/oracle/11203/cfgtoollogs/opatch/lsinv/lsinventory2012-05-18_16-28-01PM.txt


Installed Top-level Products (2):

Oracle Database 11g 11.2.0.3.0
Oracle Database 11g Examples 11.2.0.3.0
There are 2 products installed in this Oracle Home.

Interim patches (2) :

Patch 13612575 : applied on Fri May 18 16:27:29 EEST 2012
Unique Patch ID: 14584074
Created on 16 Feb 2012, 22:11:48 hrs PST8PDT
Bugs fixed:
13612575

Patch 13696216 : applied on Wed May 09 15:16:57 EEST 2012
Unique Patch ID: 14628258
Patch description: “Database Patch Set Update : 11.2.0.3.2 (13696216)”
Created on 8 Apr 2012, 21:52:22 hrs PST8PDT
Sub-patch 13343438; “Database Patch Set Update : 11.2.0.3.1 (13343438)”
Bugs fixed:
12950644, 12960925, 12923168, 12834027, 12612118, 12764337, 13772618
13420224, 12894807, 13742435, 12829021, 13742434, 13742433, 10350832
13742438, 13742437, 13742436, 12905058, 12998795, 12588744, 13528551
13503598, 9873405, 12582664, 13632717, 13343438, 12861463, 12620823
12849688, 13041324, 13696216, 13492735, 13742464, 13466801, 12917230
13332439, 13036331, 12938841, 13035804, 12656535, 13499128, 13362079
12662040, 9703627, 11063191, 11877623, 12845115, 13070939, 12748240
12847466, 12718090, 12780098, 13354082, 12797765, 12919564, 12780983, 13554409


OPatch succeeded.
oracle@server:/oracle/patch/13612575 >sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri May 18 16:29:21 2012

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

Connected to an idle instance.

SQL> startup;
ORACLE instance started.

Total System Global Area 2555592704 bytes
Fixed Size 2224128 bytes
Variable Size 1241513984 bytes
Database Buffers 1291845632 bytes
Redo Buffers 20008960 bytes
Database mounted.
Database opened.

Advertisements