Here is how to install APEX 4.2 on Oracle 11g:
Download Apex 4.0.2:
http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html
in C:\apps\Apex
Download Apex Listener:
http://www.oracle.com/technetwork/developer-tools/apex-listener/downloads/index.html
in C:\apps\Apex_Listener
Make a shortcut to SQL Plus 11:
C:\Oracle\product\11.2.0\dbhome_1\BIN\sqlplus.exe /nolog
named: Apex SQL Plus 11 wirh working directory C:\apps\Apex and argument /nolog
Start Apex SQL Plus 11:
CONNECT SYS as SYSDBA
@apexins SYSAUX SYSAUX TEMP /i/
Change password for ADMIN and write it down:
Start Apex SQL Plus 11:
CONNECT SYS as SYSDBA
@apxchpwd
ALTER USER APEX_040200 PROFILE MONITORING_PROFILE ACCOUNT UNLOCK;
Change the Password for the APEX_PUBLIC_USER Account:
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY xxxxx PROFILE MONITORING_PROFILE ACCOUNT UNLOCK;
Install Java JDK if not present on your system
Download and install OC4J:
http://www.oracle.com/technetwork/middleware/ias/downloads/utilsoft-090603.html
in Z:\Software\Oracle\OC4J
Extract the Zip-file to C:\OC4J
Start oc4j
Copy Oracle Application Express Images:
1. Create folder i in C:\OC4J\j2ee\home\default-web-app (C:\OC4J\j2ee\home\default-web-app\i)
2. Copy all files and its folders from Oracle Application Express images directory C:\Apex \images to C:\OC4J\j2ee\home\default-web-app\i.
http://localhost:8888/em
(if the configured http port on oc4j is 8888)
Login: oc4jadmin/xxxxx
Create roles:
1. On the OC4J Home page, click on the Administration tab.
2. Expand Security node.
3. Click on the Security Providers Go To Task.
4. Click on the Instance Level Security button. The Instance Security Level page is displayed.
5. Click on the Realms tab.
6. Use an existing realm (jazn.com).
7. Click on the selected realm’s Roles number. The Roles page is displayed.
8. Click on the Create button. On the Name field enter Admin. Click OK.
9. Click on the Create button. On the Name field enter Manager. Click OK.
10. On the top page, click on the Instance Security Level link.
Create Users:
You will need to create users and assign roles to access the APEX Listener Administration page and Status page.
1. In the Instance Security Level page, click on jazn.com’s Users number. The Users page is displayed.
2. Click on the Create button.
3. On the Name field enter adminlistener and specify its password.
4. Select Admin for the Selected Roles. Click OK.
5. Click on the Create button.
6. On the Name field enter managerlistener and specify its password.
7. Select Manager for the Selected Roles. Click OK.
8. On the top page, click on OC4J:home link.
Deployment:
1. On the OC4J Home page, click on the Applications tab. The Applications page is displayed.
2. Click on the Deploy button. The Deploy: Select Archive page is displayed.
3. Select Archive is present on local host. Upload the archive to the server where Application Server Control is running.
4. Specify the file location of the apex.war file: C:\Apex\Listener\apex.war
Click Next.
6. The Deploy: Application Attributes page is displayed. In the Application Name field, enter apex.
7. Click Next.
8. The Deploy: Deployment Settings is displayed. In the Deployment Tasks, click on Configure Class Loading’s Go To Task.
9. The Deployment Settings: Configure Class Loading page is displayed.
a. In the Import Shared Libraries, uncheck the box for Inherit parent application’s shared library imports. The APEX Listener contains its own libraries in the apex.war file and does not use the OC4J Shared Libraries. Also, verify that the Import column checkboxes for all the Shared Library is unchecked (not selected).
b. Click OK.
10. Click on the Deploy button.
11. The Confirmation page is displayed. A message should display a success message:
The Application “apex” has been successfully deployed.
12. Click on the Return button which returns you to the Applications page.
13. Verify that the apex is listed on the Applications and the Status displays a green up-arrow indicating that it is Active (Up).
http://localhost:8888/apex/listenerConfigure
or java -jar apex.war
How to configure a workspace:
/apex/ and /apex/admin
http://localhost:8888/apex/f?p=4550:1:7320529234973
http://localhost:8888/apex/apex_admin
ADMIN/<APEX ADMIN password>
change password to:
ADMIN/<APEX ADMIN changed password>
The first workspace created automatically is the INTERNAL
-> Manage Workspaces -> create workspace: SWKB
created workspace: SWKB with user nista/nista123 (admin/<APEX ADMIN password> can also enter)