APEX Installation on Windows in Pluggable DB 19C

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

APEX Installation on Windows in Pluggable DB 19C

Post by admin »

Oracle APEX 19.2 or below installation on Pluggable Database 12C or greater version of Oracle database,

1. Download and install the Oracle 19C database
2. Install APEX 19.2
3. Go inside APEX folder Login from sqlplus as sys/sysdba
4. show pdbs and switch to ORCLPDB
SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE NO
SQL> alter pluggable database all save state; << this will bring PDBs to above status when you will restart database.
SQL> alter session set container=ORCLPDB;

5. @apexins.sql sysaux sysaux temp /i/
6. @apex_epg_config.sql d:\db_home
7. Change admin password @apxchpwd.sql
8. check and set port if already 0
SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

If it is 0 change to 8090 or 8080

EXEC DBMS_XDB.SETHTTPPORT(8090);

9. Login from another sqlplus and this time don't change to ORCLPDB and execute the following to unlock anonymous with a password.

DECLARE
l_passwd VARCHAR2(40);
BEGIN
l_passwd := DBMS_RANDOM.string('a',10) || DBMS_RANDOM.string('x',10) || '1#';
-- Remove CONTAINER=ALL for non-CDB environments.
EXECUTE IMMEDIATE 'ALTER USER anonymous IDENTIFIED BY ' || l_passwd || ' ACCOUNT UNLOCK CONTAINER=ALL';
END;

10. Use chrome to login with URL http://localhost:8090/apex/apex_admin << here use the password you had set in step 7 above and create your first workspace.

NOTE: From APEX 20.1 onward following installations are not supported,

6.1.2 Deprecated Web Listeners
As of this release, support for the following web listeners is deprecated:

A - Oracle HTTP Server (mod_plsql)
Embedded PL/SQL Gateway
In the future, Application Express will only support Oracle REST Data Services.

https://docs.oracle.com/en/database/oracle/application-express/20.1/htmrn/index.html#HTMRN-GUID-12877F22-DA1F-45F2-91D9-103817AD659A
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests