DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, January 7, 2016

APEX UPGRADE FROM 5.0 to 5.0.1

STEP:1
              Download PATCH:21364820 for Upgrading from 5.0 to 5.0.1
 https://support.oracle.com/epmos/faces/PatchSearchResults?_adf.ctrl-state=w60shktvs_9&_afrLoop=354215820387694

STEP:2
  After downloading UNZIP the PATCH
         $unzip <PATCH>

STEP:3
  Connect tp SQL by
  Sqlplus / as sysdba

STEP-4:
  Disable the HTTP port number.
SQL>EXEC DBMS_XDB.SETHTTPPORT(0);
SQL>COMMIT;

STEP-5
 After disabling the port we have to run the @apxpatch.sql in the patch location.
     SQL>@apxpatch.sql

STEP-6
To update the images,run the @apxldimg.sql in the patch location.
SQL> @apxldimg.sql /home/oracle

STEP-7
Enable the HTTP port after updating the image.
SQL>EXEC DBMS_XDB.SETHTTPPORT(8080);
SQL>COMMIT;

STEP-8
Verify the port number by using following command.
SQL>SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

STEP-9
 All steps are over now we can open the APEX-5.0.1 using URL and PORT no.
Eg:http://192.168.1.114:8080/apex

COMMANDS:
To check APEX version:

SQL>SELECT VERSION_NO FROM APEX_RELEASE;

No comments: