Oracle APEX + ORDS 22 Deployed on Weblogic

 

Install APEX - 23.1
cd E:\APEX_HOME\APEX\apex
    @apexins.sql sysaux sysaux temp /i24/
    @apxchpwd.sql
    @apex_rest_config.sql

cd E:\APEX_HOME\APEX\35895964
    @catpatch.sql

ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Oracle#123 ACCOUNT UNLOCK;

Update ACL if needed,

BEGIN
    DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
        host => '*',
        ace => xs$ace_type(privilege_list => xs$name_list('connect'),
                           principal_name => 'APEX_230100',
                           principal_type => xs_acl.ptype_db));
END;
/

Install Weblogic 14c
Install JDK 11 [ https://www.oracle.com/kw/java/technologies/javase/jdk11-archive-downloads.html ]
	C:\java\jdk

 Install Weblogic 14c
		E:\WEBLOGIC14c>java -jar fmw_14.1.1.0.0_wls.jar 
		
			Installation Directory	:	E:\WEBLOGIC14c\middleware\Oracle_Home
			

 Create Domain
			Installation Directory	:	E:\WEBLOGIC14c\middleware\Oracle_Home
			Domain Home			:   E:\WEBLOGIC14c\middleware\Oracle_Home\user_projects\
                                                    domains\apex_domain
			Domain Name				:	apex_domain
			Admin URL				:	http://localhost:7001/console
			Managed server			:	apx_srv1 / 7003

 Start Services

Install ORDS Version 22
[ Ords 22 needs minimum jdk version 11 ]

--> Update the PATH variable to point - E:\WEBLOGIC14c\APEX_HOME\ords\bin
	C:\Windows\system32>echo %path%
							C:\Program Files\Common Files\Oracle\Java\javapath;E:\oracle\app\product\19c\dbhome\bin;C:\Windows\system32;
							C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;
							E:\WEBLOGIC14c\APEX_HOME\ords\bin;
							C:\Users\dbadmin\AppData\Local\Microsoft\WindowsApps


set _JAVA_OPTIONS=-Dconfig.url=E:\WEBLOGIC14c\APEX_HOME\ords\config
cd E:\WEBLOGIC14c\APEX_HOME\ords\bin
ords install

Prepare Deployment of ORDS Version on Weblogic
https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/22.4/ordig/deploying-and-monitoring-oracle-rest-data-services.html#GUID-63AD5B59-CD6A-47A6-BBB4-0D614090C51F

Create Directory Structure & Needed config Under ORDS_HOME [ E:\WEBLOGIC14c\APEX_HOME\ords ] 

CREATE FOLDERS  --> E:\WEBLOGIC14c\APEX_HOME\ords\static\WEB-INF 

Under WEB-INF   --> Create these 2 .xml files [ web.xml / weblogic.xml ]


web.xml
*******

<?xml version="1.0" encoding="UTF-8"?>
 <!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/j2ee/dtds/web-app_2_3.dtd">
 <web-app>
 <!-- This Web-App leverages the alternate doc-root functionality in WebLogic to serve static content
      For WebLogic refer to the weblogic.xml file in this folder
  -->
</web-app>

weblogic.xml
*************
<weblogic-web-app xmlns="http://www.bea.com/ns/weblogic/weblogic-web-app">
 <!-- This element specifies the context path the static resources are served from -->
 <context-root>/i24</context-root>
 <virtual-directory-mapping>
  <!-- This element specifies the location on disk where the static resources are located -->
  <local-path>E:\WEBLOGIC14c\APEX_HOME\apex23\apex\images</local-path>
  <url-pattern>/*</url-pattern>
 </virtual-directory-mapping>
</weblogic-web-app>

Create a Web Application with the web.xml and weblogic.xml files
set JAVA_OPTIONS="-Dconfig.url=E:\WEBLOGIC14c\APEX_HOME\ords\config" 
 cd E:\WEBLOGIC14c\APEX_HOME\ords\static
 C:\java\jdk\bin\jar cMf i24.war WEB-INF/web.xml WEB-INF/weblogic.xml
	****** This creates a file i.war or i24.war under E:\WEBLOGIC14c\APEX_HOME\ords\static Location.
	****** This will be used to deploy APEX Images on Weblogic

**** To set the config.url system property, before starting WebLogic Server, run this command: 
	export JAVA_OPTIONS="-Dconfig.url=/scratch/my_ords_config"
	set JAVA_OPTIONS="-Dconfig.url=E:\WEBLOGIC14c\APEX_HOME\ords\config"
	OR 
	Set the values on Managed Server Arguments
	--> Select the Mangaed Server --> Server start --> Arguments --> -Dconfig.url=E:\WEBLOGIC14c\APEX_HOME\ords\config
	

 --> Deploy the Images on Weblogic Managed Server apx_srv1.
 
 --> Deploy the ords.war
 
 --> restart the MAnaged Server
 
 --> Access APEX  	http://localhost:7003/i24/apex_version.txt
					http://localhost:7003/ords

 Configuring WebLogic to Handle HTTP Basic Challenges Correctly
By default WebLogic Server attempts to intercept all HTTP Basic Authentication challenges.
This default behavior needs to be disabled for Oracle REST Data Services to function correctly.


e:
cd E:\WEBLOGIC14c\middleware\Oracle_Home\oracle_common\common\bin
wlst.cmd
connect('weblogic','weblogic123','t3://localhost:7001')
cd('SecurityConfiguration')
cd('apex_domain') 
ls()
disconnect()
exit ()

If the domain settings displayed, contains the following entry, Then you must set this entry to false.

	[[ 	-r--   EnforceValidBasicAuthCredentials             true  ]]
	


e:
cd E:\WEBLOGIC14c\middleware\Oracle_Home\oracle_common\common\bin
wlst.cmd
connect('weblogic','weblogic123','t3://localhost:7001')
edit()
startEdit()
cd('SecurityConfiguration')
cd('apex_domain')   
set('EnforceValidBasicAuthCredentials','false')
save()
activate()
disconnect()
exit()


Restart the Weblogic Servers.