This document describes how to configure APEX and APEX Listener with Oracle EBS R12.

Architecture

Oracle Database (11.2.0.3) — On a separate node
Oracle Applications (12.1.3) — On a separate node
APEX Version : 4.2.1
APEX Listener Version : 2.0.1

Glassfish Version : 3.1.2.2

Download location :
http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html
http://www.oracle.com/technetwork/developer-tools/apex-listener/downloads/index.html
http://www.oracle/com/technetwork/middleware/glassfish/downloads/index.html

APEX installation with Oracle Applications Database 11gR2

Download and unzip the directory in a temp folder on your database server

mkdir apex_testing
unzip apex_4.2.1.zip
cd apex

Source the database environment file

cd $ORACLE_HOME
. SID_HOST.env
cd /home/oracle/apex_testing
sqlplus / as sysdba
@apexins.sql SYSAUX SYSAUX TEMP /i
@apxldimg.sql

The above installation will take more that 30-40 minutes depending on the resources you have on the server i.e CPU Cores, RAM
After the installation is completed unlock the following users

SELECT username,account_status FROM dba_users WHERE username LIKE 'APEX%';
ALTER USER APEX_PUBLIC_USER account UNLOCK;
ALTER USER APEX_040200 account UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY apex1234;

Glassfish Installation on Application Server

Download and unzip glassfish software

mkdir ogs_testing
unzip ogs-3.1.2.2.zip
cd /home/applmgr/ogs_testing

Unzip the software here, it will create a directory “glassfish3”
Start the glassfish service

cd /home/applmgr/ogs_testing/glassfish3/bin
./asadmin start-domain
Launch the URL
http://localhost:4848
OR
http://serverip:4848

Glassfish Login
Login as admin
Create Users for Apex Listener management
Navigate on the left panel as shown in the screen shot
Configurations — server-config — Security — Realms
Apex_Realm_User
Create a new realm with the name apex-realm OR any of your choice
Click on Manage Users and then click new
Create 2 users
1) administrator — Group : Manager
2) adminlistener — Group : Admin
Admin_Users
Now we are ready to deploy Apex listener with glassfish

mkdir apexlist_testing
cd /home/applmgr/apexlist_testing
unzip apex_listener.2.0.1.64.14.25.zip

Go to glassfish home and create an image directory as show below

cd /home/applmgr/ogs_testing/glassfish3/glassfish/domains/domain/docroot
mkdir i
cd /home/applmgr/apexlist_testing
java -jar apex.war static /home/applmgr/ogs_testing/glassfish3/glassfish/domains/domain/docroot/i

The above command will generate web archive file “i.war”

Going back to the 1st step where we install apex 4.2 on our oracle 11gr2 database, we need to copy the images to the application server node in the “i” directory create under the glassfish installation area

cd /home/oracle/apex_testing/apex
cd images
scp -rp * applmgr@IP:/home/applmgr/ogs_testing/glassfish3/glassfish/domains/domain/docroot/i
Deploy Apex listener with Glassfish
cd /home/applmgr/ogs_testing/glassfish3/bin
./asadmin deploy /home/applmgr/apexlist_testing/i.war
./asadmin deploy /home/applmgr/apexlist_testing/apex.war

Login to glassfish application and verify the deployment
Verify Apex deployment
Launch the apex application
http://localhost:8080/apex
OR
http://serverip:8080/apex
Apex_Listener_LoginPage

Tagged with →  
Share →
0 comments
Skip to toolbar