Archive

Posts Tagged ‘patchset’

Not able to update Web service process in APEX 4.1

March 21st, 2012 No comments

Last month I created a simple APEX application with enabled mobile support and latest version of jQuery, which integrates with HP Service Manager through web services. The purpose was to give option for company engineers to open and update incidents through mobile in few easy steps.

The first step was to create form and report by using the web service. At this point web service request process is created where authentication and input parameter are described. The problem appears if you try to change any parameter and update the web service process. This is the error:

 Error error updating web service parameters
ORA-01403: no data found

To fix this, one option is to apply patch 12934733 on top of APEX 4.1. The other option is to apply latest patch set for APEX version 4.1.1, patch number 13331096.

At the time I got the error patch set wasn’t released yet and I went with the patch only to fix this issue. Later I’ve decided to update the APEX to latest version 4.1.1 and I’ll review the update process at glance.

To upgrade to APEX 4.1.1 make sure first to review the release notes here. The process is really simple and takes few minutes.

Before applying the patch make sure to prevent access to the APEX. In my case I’m using Oracle Database 11g Express Edition and I’m using Embedded PL/SQL gateway. Then apply the patch using apxpatch.sql and update the images directory. Because I’m using Express Edition, my images are stored in the XML DB repository and script apxldimg.sql has to be used to upload the new images within the repository.

 

Disabling Oracle XML DB HTTP Server:

SQL> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

GETHTTPPORT
-----------
 0

SQL> EXEC DBMS_XDB.SETHTTPPORT(0);

PL/SQL procedure successfully completed.

SQL> COMMIT;

Commit complete.

SQL> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

GETHTTPPORT
-----------
 0

 

Run apxpatch.sql to patch the system:

SQL> @apxpatch.sql

.......

timing for: Complete Patch
Elapsed: 00:06:25.48

 

Updating the Images Directory When Running the Embedded PL/SQL Gateway:

@apxldimg.sql /tmp/patch

.......

Commit complete.

timing for: Load Images
Elapsed: 00:04:12.56

Directory dropped.

 

Enabling Oracle XML DB HTTP Server:

SQL> EXEC DBMS_XDB.SETHTTPPORT(8080);

PL/SQL procedure successfully completed.

SQL> COMMIT;

Commit complete.

 

APEX is now updated to version 4.1.1

 

Regards,
Sve

Categories: oracle Tags: , , , ,

Oracle Exadata Database Recommended Patch (BP9) came out

July 26th, 2011 No comments

Just a quick note that Oracle Exadata Database Recommended Patch (BP9) came out a week ago. The patch number is 12681774 and it’s available for Solaris x86-64 and Linux x86-64 yet. It seems that Oracle is releasing a BP every month, BP7 came out on May 17 and BP8 came out on June 17. For BP9 patch installation OPatch version must be upgraded to 11.2.0.1.5 and if you haven’t install any BP until now then most probably you need to download and install latest version of opatch, which is available for download with patch 6880880.

This release coincide with release of Critical Patch Update (CPU) July 2011 for 11.2.0.2 and also release of Patch Set Update (PSU) 11.2.0.2.3.

Regards,
Sve

Categories: oracle Tags: , ,

Patch Set 10.2.0.5 for Oracle Database Server re-released on Linux x86

August 9th, 2010 No comments

A week ago Oracle has re-released the patch set 10.2.0.5 for Oracle Database on Linux x86 (32 bit). It seems that some additional bug fixes were added to the patch set, but I was unable to find exactly which one. The patch set is available for download from My Oracle Support with same number 8202632. There is also alert with MOS ID 1156958.1 regarding the re-release of the patch set.

Regards,
Sve

Categories: linux, oracle Tags:

Patch Set 10.2.0.5 for Oracle Database Server

June 9th, 2010 No comments

Just to mention that few days ago patch set 10.2.0.5 was released for HP-UX Itanium and IBM AIX systems. The patch set is available for download from My Oracle Support with number 8202632.

Regards,
Sve

Categories: hp-ux, oracle Tags: