Install Oracle Apex 18.1 on premises Windows 18.3.0 Database using Oracle HTTP server 12.1.3.0.0

Installation Requires:-

Oracle Application Express release 18.1 requires an Oracle Database release 11.2.0.4 or later, including Enterprise Edition and Express Edition (Oracle Database XE).

Download APEX 18.1 software Here and check its certified with Windows server 2012 R2

Click Accept button and download the Oracle APEX 18.1.0 software.

APEX 18c Installation :-

Step 1:- Extract the APEX 18.1.0.00.45 software.


Step 2:-Create a new APEX tablespace,

Step 3:- Check the Oracle Application Express  is installed.

Step 4:- Start the APEX 18.1 Installation.

SQL> @apexins APEX APEX TEMP /i/

Where:
apex_tbs – name of the tablespace for the APEX user.
apex_files_tbs – name of the tablespace for APEX files user.
temp_tbs – name of the temporary tablespace.
images – virtual directory for APEX images. Define the virtual image directory as /i/ for future updates. */

Step 5:- Change ADMIN user password

Step 6:- Check the VERSION and STATUS is installed.

Step 7:- Check the account_status and unlock it.

Install Oracle HTTP server 12.1.3.0.0 :-

Step 1:- Extract the Oracle HTTP 12.1.3 software

Step 2:- Open OHS folder and run the setup_fmw_12.1.3.0.0_ohs_win64.exe

 

Step 3:-  Click Next to start the Oracle 12.1.3.0.0 HTTP server installation.

Step 4:- Provide the location to install Oracle HTPP server.

Step 5:- Install Standalone HTTP server.

Step 6:- Skip the email address for security updates.

Step 7:- Click Install option to configure below components.

Step 8:- After clicking Finish button,OHS 12.1.3.0.0 installation got completed successfully.

Creating Domain :-

Step 9:- Start configuration wizard and configure Oracle Http server in standalone mode

Step 10:- Start the configuration wizard                                                                            ” D:\Oracle\Middleware\Oracle_Home\ohs\common\bin\config.cmd”

Step 11:- Check the Oracle HTTP server(standalone)-12.1.3.0(ohs) and Click Next

Step 12:- Provide the port for admin and listening port for APEX.

Step 13:- Provide the Node Manager Credentials.

Step 14:- Click Create button to create system component ohs1.

Step 15:- Click Next button and domain created successfully.

Step 16:- Click Finish button and note the Domain location.

Step 17:- Goto DOMAIN_HOME location.Under DOMAIN_HOME/bin directory,Check the batch files is present to start and stop the Nodemanager and Components.

Step 18:- Start NodeManger.NodeManager default port is 5556.

Step 19:- After starting Nodemanager,Start the OHS component ohs1

Configure Apex 18c  with Oracle HTTP server:-

Step 1:-After both Nodemanager and OHS component started successfully.Copy the APEX images folder from apex 18c directory to paste to the Middleware location D:\Oracle\Middleware\Oracle_Home\user_projects\domains\ohs_domain\config\fmwconfig\components\OHS\ohs1

Step 2:- Modify dads.conf file

  • Change Alias image location /i/ as per the image apex/images folder copied
  •  PlsqlDatabaseConnectString
  • PlsqlDatabasePassword
  • Location /apex is called up using apex console.
===================================================================
# mod_plsql DAD Configuration File 
===================================================================

Alias /i/ "D:\Oracle\Middleware\Oracle_Home\user_projects\domains\ohs_domain\config\fmwconfig\components\OHS\ohs1\images\"

<Location /apex>
Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlDatabaseConnectString 192.168.1.148:1521:prod
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
PlsqlAuthenticationMode Basic
SetHandler pls_handler
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDefaultPage apex
PlsqlDatabasePassword Oracle$123
PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
PlsqlPathAlias i
PlsqlPathAliasProcedure wwv_flow.resolve_friendly_url
Allow from all
</Location>

Step 3:- Refresh the APEX login page link or Browse the below APEX login page.

APEX login page link :- http://192.168.1.148:7777/apex

You have successfully logged into the Oracle APEX 18.1

Catch Me On:- Hariprasath Rajaram

LinkedIn:                  https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:                 https://www.facebook.com/HariPrasathdba
Facebook Group:   https://www.facebook.com/groups/894402327369506/
Facebook Page:      https://www.facebook.com/dbahariprasath/?
Twitter:                     https://twitter.com/hariprasathdba

Oracle Application Express 18.1 Installation

                                              Oracle Application Express 18.1 Installation

Installation Requires:-

Oracle Application Express release 18.1 requires an Oracle Database release 11.2.0.4 or later, including Enterprise Edition and Express Edition (Oracle Database XE).

Download APEX 18.1 software Here 

Click Accept button and download the Oracle APEX 18.1.0 software.

Step 1:-Unzip the APEX 18.1.0.00.45 software:

unzip apex_18.1.zip -d /oradb/

Step 2:-Create a new APEX tablespace,

CREATE TABLESPACE APEX DATAFILE ‘/oradb/app/oracle/oradata/clone/apex01.dbf’ SIZE 1G;

Step 3:-Check the Oracle Application Express  is installed:

SELECT comp_name, version, status FROM dba_registry WHERE comp_id=’APEX’;

no rows selected

Step 4:-Installation of APEX 18.1:-

SQL> @apexins APEX APEX TEMP /i/

Where:
apex_tbs – name of the tablespace for the APEX user.
apex_files_tbs – name of the tablespace for APEX files user.
temp_tbs – name of the temporary tablespace.
images – virtual directory for APEX images. Define the virtual image directory as /i/ for future updates. */

The above script create some SCHEMA on Database, you can test by querying view ALL_USERS.

SQL> select username,created from all_users where USERNAME like ‘%APEX%’;

USERNAME                                                         CREATED
—————————————-
APEX_PUBLIC_USER                                    29-MAY-18
APEX_180100                                                    29-MAY-18
APEX_INSTANCE_ADMIN_USER          29-MAY-18

Step 5:-Check the VERSION and STATUS is installed,

SELECT comp_name, version, status FROM dba_registry WHERE comp_id=’APEX’;

COMP_NAME                                   VERSION           STATUS
——————————————-
Oracle Application Express      18.1.0.00.45             VALID

Step 6:-Check APEX RELEASE VERSION:

select * from apex_release;

VERSION_NO             API_COMPAT        PATCH_APPL
———- ———- ———————
18.1.0.00.45                 2018.04.04                     APPLIED

Configuring APEX:
Step 7:-Run the Embedded PL/SQL Gateway configuration (EPG)

This script will load the Application Express images into XDB,
@apex_epg_config.sql <parent of apex directory>

SQL> @apex_epg_config.sql /oradb

Step 8:-Make sure that the following accounts are unlocked:

ALTER USER anonymous ACCOUNT UNLOCK;
ALTER USER xdb ACCOUNT UNLOCK;
ALTER USER apex_public_user ACCOUNT UNLOCK;
ALTER USER flows_files ACCOUNT UNLOCK;

Step 9:-Configure database parameters for APEX:

SHOW PARAMETER job_queue_processes

NAME                                    TYPE                 VALUE
———————————–
job_queue_processes integer                4000

SHOW PARAMETER shared_servers

NAME                                 TYPE                  VALUE
———————————–
max_shared_servers integer
shared_servers              integer                      1

Change the shared_servers parameter:

ALTER system SET shared_servers=5 scope=both;

Step 10:-Used to perform the final configuration steps for Oracle Application Express, including setting the XDB HTTP listener port and Application Express ADMIN password.

To user, you can use ADMIN by default, and email can be skipped.

Also you can change the HTTP port.But default port is 8080.

SQL>@/oradb/apex/apxconf.sql

PORT
———-
8080

Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user.
Default values are in brackets [ ].
Press Enter to accept the default value.

=========================================================
This script can be used to change the password of an Application Express
instance administrator. If the user does not yet exist, a user record will be
created.
=========================================================
Enter the administrator’s username [ADMIN]
User “ADMIN” does not yet exist and will be created.
Enter ADMIN’s email [ADMIN]
Enter ADMIN’s password []
Created instance administrator ADMIN.

Enter a port for the XDB HTTP listener [ 8080]
…changing HTTP Port

APEX configuration has been completed.

Step 11:-Check the HTTP port:

SQL> select dbms_xdb.gethttpport from dual;

GETHTTPPORT
———–
8080

Step 12:-Check the listener status and HTTP port is enabled,

[oracle@clone:apex clone] lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 – Production on 29-MAY-2018 19:20:08

Copyright (c) 1991, 2016, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=clone.localdomain.com)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 – Production
Start Date 25-MAY-2018 21:52:41
Uptime 3 days 21 hr. 27 min. 26 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oradb/app/oracle/product/12.2.0.1/db_1/network/admin/listener.ora
Listener Log File /oradb/app/oracle/diag/tnslsnr/clone/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=clone.localdomain.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=clone.localdomain.com)(PORT=5500))(Security=(my_wallet_directory=/oradb/app/oracle/admin/CLONE/xdb_wallet))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=clone.localdomain.com)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary…
Service “CLONE.localdomain.com” has 1 instance(s).
Instance “clone”, status READY, has 1 handler(s) for this service…
Service “cloneXDB.localdomain.com” has 1 instance(s).
Instance “clone”, status READY, has 1 handler(s) for this service…
The command completed successfully

Administration Services login page:

Step 13:-In Browser,Login as a ADMIN user:-

http://clone.localdomain.com:8080/apex/apex_admin

You have successfully logged into the Oracle APEX 18.1

 

Catch Me On:- Hariprasath Rajaram

LinkedIn:                  https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:                 https://www.facebook.com/HariPrasathdba
Facebook Group:   https://www.facebook.com/groups/894402327369506/
Facebook Page:      https://www.facebook.com/dbahariprasath/?
Twitter:                     https://twitter.com/hariprasathdba