Oracle Support Update

bloatdecorumSoftware and s/w Development

Oct 30, 2013 (3 years and 7 months ago)

123 views

<Insert Picture Here>

Oracle Support Update



Phil Davies

2

<Insert Picture Here>

Agenda



Major Releases


Oracle Database


Enterprise Manager


Patch Set Releases


Life Time Support Policy


Extended Dates


Recent Alerts & Issues


Questions


Appendix


Patch terminology





3

The following is intended to outline our general
product direction. It is intended for information
purposes only, and may not be incorporated into any
contract. It is not a commitment to deliver any
material, code, or functionality, and should not be
relied upon in making purchasing decisions.

The development, release, and timing of any
features or functionality described for Oracle’s
products remains at the sole discretion of Oracle.

4

RDBMS Releases


Oracle 11gR2 (11.2.0.1)


Linux x86


Linux x86
-
64


Solaris(SPARC) 64
-
bit


Solaris (X86
-
64)


AIX(PPC64)


HP
-
UX Itanium


HP
-
UX PA
-
RISC


Microsoft Windows 32 bit


Microsoft Windows 64 bit


zLinux64 (11.2.0.2 full release)






http://www.oracle.com/technology/software/products/database/index.html



5

RDBMS Releases


Oracle 11gR1 (11.1.0.7)


Windows Server 2008 32 & 64 bit


Oracle 11gR1 (11.1.0.6)


Linux x86


Linux x86
-
64


Windows 32
-
bit, 64
-
bit


Solaris(SPARC) 64
-
bit


AIX(PPC64)


HP
-
UX Itanium


HP
-
UX PA
-
RISC






http://www.oracle.com/technology/software/products/database/index.html



6

Enterprise Manager Releases


12.1.0.2 Cloud Control



for Linux x86 (32
-
bit)



for Linux x86
-
64 (64
-
bit)



for Solaris Operating System (SPARC)


for Solaris Operating System (x86
-
64)


for IBM AIX on POWER Systems (64
-
bit)


for Windows x86
-
64




11.1.0.1.0 Grid Control


Linux x86, Linux x86
-
64,


Solaris
Sparc
(64 bit),


HP
-
UX PA
-
RISC, HP
-
UX Itanium


AIX 5L


Windows 32 bit


http://www.oracle.com/technetwork/oem/grid
-
control/downloads/index.html






7

RDBMS Patch Set Releases


11gR2 11.2.0.3


Linux x86, x86
-
64


Solaris x86
-
64


Solaris(SPARC) 64
-
bit


AIX(PPC64)


HP
-
UX Itanium, HP
-
UX PA
-
RISC


Microsoft Windows 32 bit, 64 bit


Linux on System z


S/390 based Linux


Client only Solaris x86
-
32 Solaris
Sparc

32 bit, HP
-
UX
Itanium 32 bit, AIX 32 bit


Patch
10404530


Full install, does not require base release
Note 1189783.1


8

RDBMS Patch Set Releases


11gR1 11.1.0.7 (Terminal release)





HP
-
UX Itanium


HP
-
UX PA
-
RISC


MS Windows 32bit, 64 bit


Sun
Sparc

64 bit


Linux x86


Linux x86
-
64


IBM AIX



Patch
6890831




9

RDBMS Patch Set Releases


10gR2 10.2.0.5 (Terminal release)



Linux 32 Bit, Linux 64 Bit


Linux system z


Solaris X86
-
64 bit


Solaris (SPARC) 64 bit


HP
-
UX Itanium, HP
-
UX PA
-
RISC(64 bit)


IBM AIX on Power Systems ( 64 bit)


Windows (32 bit) ( 64 bit) + Itanium


Fujitsu BS2000/OSD (SX Series)



Patch
8202632











10

Enterprise Manager Patch Set Releases

Release Schedule of EM Releases / Patch Sets

Note 793512.1


Enterprise Manager recommended patches

Note 822485.1


Latest release 12.1.0.2


12.1.0.1



OMS
-

see Note
1395505.1





Unix Agent
-

see Note
1395505.1


11.1.0.1 PSU7


OMS Patch 13711705





Unix Agent Patch 9346282











11


Patch Set Update (PSU) Availability


Oracle Database Support Newsletter
-

Issue Sept, 2012 Volume 20









Note

230.1


Quick Reference to
Patchset

/ PSU Numbers


Note

753736.1



Reference List of Critical Patch Update Availability(CPU) and Patch Set
Update (PSU) Documents For Oracle Database and Fusion Middleware
Product







Note
783141.1




PSU
Patchset

updates





Note
854428.1



Oracle Recommended Patches
--

Oracle Database


Note
756671.1



Database PSU
-
CPU Cross
-
Reference List


Note
1119703.1











12

Life Time Support Policy


RDBMS Life Time Support Policy


11.2


Premier: Jan 2015, Extended: Jan 2018


Free Extended Support to Jan 2016


11.1


Premier:
Aug 2012
, Extended: Aug 2015


10.2.0


Premier: 31
-
Jul
-
2010,Extended: 31
-
Jul
-
2013


Free Extended Support ended July 2011


10.1.0.x


Premier: 31
-
Jan
-
2009,Extended:
31
-
Jan
-
2012




9.2.0.x


Premier: 31
-
Jul
-
2007,Extended: 31
-
Jul
-
2010


Sustaining: Indefinite

applies to all above







New Lifetime support policy

http://www.oracle.com/us/support/lifetime
-
support/index.html

Note 9i P1 fixes until July2012

13

Itanium Processor and Oracle Database Software


After multiple conversations with Intel senior management
Oracle has decided to discontinue all software
development on the Intel Itanium microprocessor. Intel
management made it clear that their strategic focus is on
their x86 microprocessor and that Itanium was nearing the
end of its life.



Press Release


Oracle Software and Support for Itanium
-
Based Servers








Note 1313431.1

14

Support Update
-

Status Notes


Generic Server Support Status Notes



11.2.0



Note
880782.1


11.1.0



Note
454507.1


10.2.0



Note:
316900.1


10.1.0



Note:
263719.1


9.2



Note:
189908.1

15

Support Update
-

Recent Alerts


Install and Upgrade



Essential Steps to take before Upgrading to 11.2.0.3 Grid
Infrastructure/ASM/
Exadata



Note
1363369.1



ORA
-
600 [KKPO_RCINFO_DEFSTG:OBJNOTFOUND] On 11.2
Databases After Upgrade




Note
1308400.1



11.2.0.2 Roothas.pl or Rootcrs.pl fails



Note
1268390.1



11.2.0.2 Patches not found upgrading Grid Infrastructure








Bug
10036834



MRP0 ORA
-
328 on switchover to standby after upgrade to 11.2.0.2

Fixed in 11.2.0.2.3




Note 11664046.8





































16

Support Update
-

Recent Alerts


Install and Upgrade




11.2.0.1 DBUA
Shared_Pool

Too Small ( Sun
sparc
)

Bug
9406095



11.1.0.7 Ora
-
1578 Blocks misplaced in ASM..compatible.asm < 11


and existing
datafile

resized









Note
965751.1



11.1.0.7 ASM rolling upgrade to 11.1.0.7 fails on RAC

Note
742647.1



11.1.0.6 Various ora
-
600 errors during upgrade to 11g

Note
579523.1















17

Support Update
-

Recent Alerts


Database



ORA
-
600 [ktbsdp1] ORA
-
600 [
kghfrempty:ds
]. Corruption in Rollback with
Clusterwide

Global Transactions in RAC

11.2.0.3




Note 13605839.8




PMON block recovery loop
-

instance hang


11.2.0.3





Note 13645917.8



wrong results / OERI:[
kkooqb
:
bsj

not used] with star transformation


11.2.0.3





Note 13384397.8



Hang / SGA memory corruption / ORA
-
7445:[kglic0] with
CURSOR_SHARING using multiple shared pool
subpools


11.2.0.2 /3







Note 13550185.8













































18

Support Update
-

Recent Alerts


Database





Join of temp and permanent tables in RAC might cause corruption of
permanent table



11.2.0.3

fixed in .3 PSU



Note 13467683.8



ORA
-
604 ORA
-
959 on object with Deferred Segment Creation


11.2.0.3






Note
1390632.1





Ora
-
600
or Data Corruption possible during shutdown
normal/transactional/immediate of RAC instances in a rolling fashion


11.2.0.2







Note
1318986.1



ORA
-
600 [2015] during transaction rollback in undo block for COMPRESS
table


11.1.0.6 to 11.2.0.2





Note 1191474.1





















19

Support Update
-

Recent Alerts


Database



Intermittent logical corruption of LOB data during recovery



10.1 to 11.2 Fixed in 11.2.0.2



Note

1206814.1




Segment
header corruption if extent allocation operation is interrupted



9.2 to 11.2


Fixed in 11.2.0.2



Note
1229669.1



OERI[25027] or [4097] in plugged
datafile

after CREATE CONTROLFILE



11.1.0.6 to 11.2.0.1


Fixed in 11.2.0.2




Note 1066229.1



RFS in standby with a wrong location for archive log
corruption/overwriting
datafiles

when
max_connections

> 1
10.2 to 11.2


Fixed in 11.2.0.2



Note 1081961.1

















20

Other notes




Pre 11.2 Database Issues in 11gR2 Grid Infrastructure Environment









Note

948456.1



Data Guard Standby
-
First Patch Apply (Doc ID 1265700.1)











Note

1265700.1




SQL :
-

High Version Count Issues











Note

296377.1













21

Q&A

Q U E S T I O N S

A N S W E R S

22

Oracle Support


GCS



Global Customer Support; the analysts within Oracle Support
that own and work on Service Requests



BDE



Bug Detection and Escalation; also part of Oracle Support,
these are engineers who have access to the source code to check for or
confirm the existence of a bug



Sustaining Engineering



formerly known as DDR; the team within
Development that creates patches



Base Development



the developers who work on the current and
future versions of the software, each owning a small section of code



ACS
-

Advanced Customer Services; mission critical support services
for complex IT environments to help maximize performance, achieve
higher availability and reduce risk


23

Terminology


CPU



a Critical Patch Update; in essence a CPU is a bundle which is released quarterly and only
includes security
-
related fixes. CPUs are cumulative, so a later CPU will contain all of the fixes from an
earlier CPU for the same
patchset
. CPUs are “molecular” which means groups of related fixes (“molecules”)
can be excluded if they conflict with existing patches.


PSU



a Patch Set Update; another bundle released every quarter, the PSU contains critical bug fixes
for its intended
patchset
. Again they are cumulative, so they contain all fixes from previous PSUs for the
same
patchset



they also include the CPU released on the same date. So for example PSUApr2010
includes CPUApr2010. There are very specific rules about which fixes can be included in a PSU; nothing
that affects optimizer query plans can be included, nor anything that requires a configuration change. Port
-
specific bugs also cannot be included. Application of a PSU will increment the last digit of the release
number, e.g. PSUApr2010 for 10.2.0.4 results in the version becoming 10.2.0.4.4



Overlay Patch



when a one
-
off interim patch conflicts with a PSU, an overlay patch is
required. This is basically a merge of the patch you want and the PSU; Development aim to provide these
automatically so they shouldn’t actually be as much work as they sound.



24

Terminology


Interim Patch
this is the official name for a one
-
off patch



Conflict



two or more
bugfixes

which modify the same source code files; if this is the case then only
one can be applied, otherwise the code for the fixes will need to be “merged” to produce a new label



Merge



a combination of labels; if for example you have two
bugfixes

which touch the same files then
you would need to have those fixes merged together, producing one new patch with a new label



Backport



also known as an OOB or One
-
Off
Backport
, this is a change or fix in a later piece of
code which is then retrospectively applied as a patch to an earlier level of the code e.g. a fix in 11.1.0.7
might then be
backported

on top of 10.2.0.5 and made available as an interim patch



Patchset

-

A
patchset

is a tested and integrated set of product fixes. Patch sets provide bug fixes
only; they do not include new functionality and they do not require certification on the target system”…


but that has changed in 11.2.0.2 see later slides