Installation of Oracle Apex 5.0
Instance
Name : APDBA
Installation
Path : $ORACLE_HOME/apex
Software
: apex_5.0_en.zip
ords.3.0.1.177.18.02.zip
Summary of the
Installation Process steps:-
A. Installation Of base APEX Software (Ver:- 5.0)
B. Choosing Apex Web Listener (Embedded PL/SQL gateway in our case):-
1. Oracle REST Data Services
(formerly Oracle Application Express Listener).
2. Oracle HTTP Server
3. Embedded PL/SQL gateway
Install Apex with Embedded
PL/SQL Gateway and Oracle XML DB Protocol Server
(All these software is
available in /ora/APDBA/home/product/11.2.0)
Steps
1. Checking Version of Database
Col Comp_name Format a22
Col Status Format a12
Select Comp_name,
status, Version from Dba_Registry Order by Comp_name;
2. Installing Full development environment.
Connect as sys
SQL> @apexins.sql
SYSAUX SYSAUX TEMP /i/
@apxchpwd
Enter a password for the
ADMIN user Oracleapex$123
4. Unlocking and changing the password APEX_PUBLIC_USER
ALTER USER
APEX_PUBLIC_USER ACCOUNT UNLOCK
ALTER USER
APEX_PUBLIC_USER IDENTIFIED BY APEX_PUBLIC_USER;
5. Installing the Apex listener using Embedded PL/SQL
Gateway (EPG) Configuration
Run the
"apex_epg_config.sql" script, passing in the base directory of the
installation software as a parameter.
SQL> CONN sys@pdb1 AS
SYSDBA
SQL>
@apex_epg_config.sql /ora/APDBA/home/product/11.2.0
Unlock
the ANONYMOUS account.
SQL> ALTER USER
ANONYMOUS ACCOUNT UNLOCK;
If this is an upgrade to
an existing APEX installation, you will also have to run the following script,
to update the images.
SQL> @apxldimg.sql
/ora/APDBA/home/product/11.2.0
Check the port setting
for XML DB Protocol Server.
SQL> SELECT
DBMS_XDB.gethttpport FROM DUAL;
GETHTTPPORT
-----------
0
1 row selected.
If it is set to
"0", you will need to set it to a non-zero value to enable it.
SQL> EXEC
DBMS_XDB.sethttpport(8080);
PL/SQL procedure
successfully completed.
6. Execute the
below to provide Network ACL privilege to APEX owner
SQL> DECLARE
2 ACL_PATH VARCHAR2(4000);
3 BEGIN
4 -- Look for the ACL currently assigned to '*' and give APEX_050000
5 -- the "connect" privilege if APEX_050000 does not have the
privilege yet.
6
7 SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS
8 WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;
9
10 IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_050000',
11 'connect') IS NULL THEN
12 DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,
13 'APEX_050000', TRUE, 'connect');
14 END IF;
15
EXCEPTION
16 17 -- When no ACL has been assigned to '*'.
18 WHEN NO_DATA_FOUND THEN
19 DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('power_users.xml',
20 'ACL that lets power users to connect to everywhere',
21 'APEX_050000', TRUE, 'connect');
22 DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');
END;
23 24 /
COMMIT;
PL/SQL procedure successfully completed.7. Set the following init parameters for XDB protocol registration with the Listener
*.dispatchers=(PROTOCOL=TCP)(SERVICE=APDBAXDB)
*.LOCAL_LISTENER
= (ADDRESS=(PROTOCOL=TCP)(HOST=APDBA-APDBA1.global.internal)(port=1542))
8. Recycle the APDBA
services(application + database + listener)
9. Verify the XDB
dispatchers are running
lsnrctl status APDBA
Listening Endpoints
Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCAPDBA)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=APDBA-APDBA1.global.internal)(PORT=1542)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=APDBA-APDBA1.global.internal)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=APDBA-APDBA1.global.internal)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "APDBA"
has 2 instance(s).
Instance "APDBA",
status UNKNOWN, has 1 handler(s) for this service...
Instance "APDBA",
status READY, has 1 handler(s) for this service...
Service "APDBAXDB"
has 1 instance(s).
Instance "APDBA",
status READY, has 1 handler(s) for this service...
Service
"PLSExtProc" has 1 instance(s).
Instance
"PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed
successfully
10. Verify if the port
8080 is listening -
[obdev@APDBA-APDBA1
dbs]$ netstat -plan|grep 8080
(Not all processes could
be identified, non-owned process info
will not be shown,
you would have to be root to see it all.)
tcp
0 0
:::8080
:::*
LISTEN 13373/tnslsnr
11. Access the below
links
To access Application
Express administration services, use -
http://APDBA-APDBA1.global.internal:8080/apex/apex_admin
Administrator username: admin
Password: apdbapex$123
Link to the
Application Express development interface is as follows:
http://APDBA-APDBA1.global.internal:8080/apex
References:
How to Setup XDB
Protocol Server: FTP, HTTP, WebDAV (Doc ID 362540.1)
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment
Note: only a member of this blog may post a comment.