Search Oracle Blogs

List of Blogs maintained by Paweł Barut.

Sunday, April 20, 2008

Oracle CPUApr2008 for DB: patch set and first install

Written by Paweł Barut
To my surprise CPUApr2008 is not available for latest patch-set of Oracle 10gR2 ( that was released in first quarter 2008. In note that goes together with patch 6810189:
The following are the updated components of this patch set:
  * Up to January 2008 CPU is included in this patch set
Based on this I was expecting that CPUApr2008 will be also available for patch-set. In note 552248.1 you will find then:

1.3 Database Patch Set

The Database Patch Set includes the CPUApr2008 content.

So the CPUApt2008 was available to all at least month before official release and was included in patch set! Is this situation secure?

Anyway I had to install CPUApr2008. It's good that there is no need to recompile views this time. I've sucessfully installed it on test server, with minor problem. In installation log I've found one problem:

BEGIN emd_maintenance.recompile_invalid_objects; END;

ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package body "SYSMAN.EMD_MAINTENANCE" has been
ORA-06508: PL/SQL: could not find program unit being called:
ORA-06512: at line 1

Hmm... After reconnecting, this commend run without errors:
SQL> conn / as sysdba
SQL> BEGIN sysman.emd_maintenance.recompile_invalid_objects; END;

PL/SQL procedure successfully completed.
After all, server runs ok, and I do not find any problems within applications running on this.

Cheers Paweł

Related Articles on Paweł Barut blog:

No comments:


Copyright © Paweł Barut
Printing from DOS to USB Printer