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