How to upgrade Oracle apex 4.1 to 4.2.1 , 4.2.2 on 11g XE

 

 

How to Install or Upgrade Oracle apex 4.1 to 4.2.2 on 11g XE

1. Download and Unzip Oracle application express 4.2.2

2. Make sure the Oracle 11g XE services are running.

3. Open cmd and move to the directory where oracle apex unzipped files are       located.

I am considering files lies in D drive in the folder (apex). You can also name your extracted folder as apex this will help you while uploading images in apex.

4. connect with sys in sqlplus

5. d:\>@apexins.sql sysaux sysaux temp /i/

apexins.sql script needs 4 parameters: the name of the tablespace for the APEX user (i am using > sysaux), the name of the tablespace for the FLOWS_FILES user (i am using > sysaux), the name of the TEMP tablespace (i am using: temp) and the name of the virtual image directory ( "/i/"). 

Below script will take around 20-40 minutes. depend upon system performance.

After your script has finished you can query the status for your installation by query the following and as shown in picture

sql> select status from dba_registry where comp_id = 'APEX';

6. d:\>@apxldimg d:\

apex by default have apex folder in its script , so if your folder is named apex then you don't need to the full path.

7. SQL > @apxchpwd 

Now you can change apex password here by using the following script as shown in picture. In the previous release you can set the password just as you want in any case by now its also restricted in the list i have shown the error as well . 

If you want to know or check the apex version or release you can query the following

 http://127.0.0.1:8080/apex/f?p=4550:1:0:::::