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

Leave a Reply

Your email address will not be published. Required fields are marked *