Thursday, October 20, 2011

Oracle 11.2.0.3 patchset

Sometime ago has been released the latest patchset, 11.2.0.3 (so far Linux only). Whether it is still not certified on Oracle Linux 6.x, it is working working fine.
Working in the same environment as I previously created here, Oracle Linux 6.0 and Oracle database 11.2.0.2, I’m doing an out-of-place upgrade.
The installer is complaining about missing RPMs…
Oracle11203_017 
Installing the corresponding RPMs (and remove pdksh if already installed, replaced by ksh) :

[root@orion4:/mnt]# mount /dev/cdrom /mnt/cdrom
mount: block device /dev/sr0 is write-protected, mounting read-only
[root@orion4:/mnt]# cd /mnt/cdrom/
[root@orion4:/mnt/cdrom]# cd Packages/
[root@orion4:/mnt/cdrom/Packages]# rpm -Uvh compat-libcap1-1.10-1.x86_64.rpm
warning: compat-libcap1-1.10-1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:compat-libcap1         ########################################### [100%]
[root@orion4:/mnt/cdrom/Packages]# rpm -Uvh ksh-20100621-2.el6.x86_64.rpm
warning: ksh-20100621-2.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
error: Failed dependencies:
        pdksh conflicts with ksh-20100621-2.el6.x86_64
[root@orion4:/mnt/cdrom/Packages]# rpm -e pdksh
[root@orion4:/mnt/cdrom/Packages]# rpm -Uvh ksh-20100621-2.el6.x86_64.rpm
warning: ksh-20100621-2.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:ksh                    ########################################### [100%]
[root@orion4:/mnt/cdrom/Packages]#
[root@orion4:/mnt/cdrom/Packages]# cd /
[root@orion4:/]# umount /dev/cdrom
[root@orion4:/]#
Then check again and it’s going smoothly :
Oracle11203_018

Oracle11203_021
After changing the ORACLE_HOME setting of oracle user (OS user), upgrading the database successfully as well :
Oracle11203_022
Oracle11203_023
Oracle11203_024 
Oracle11203_025 Oracle11203_026 Oracle11203_027 Oracle11203_028 Oracle11203_029

You can see the new features coming within this patchset in the on-line documentation.

Enjoy,

Nicolas.

No comments: