System.out.println("Hello World");
yesterday I mentioned during “APEX Professional 2025” course I'm not able to define a Rest enabled SQL Service in APEX Version 23.2. I'm working on a Windows 10 Pro x64 - machine using the following installations.
Oracle Database XE 21c (Oracle Database free)
Oracle ORDS 23.3 Service configured setting (restEnabledSql.active=true)
Oracle APEX 23.2
ORDS23.2 installation is running on “https://localhost:8443” and “http://localhost:8080”.
Oracle Database Service 21c XE is running on port localhost:1521.
Everything is running smooth without any error, just a view messages apear in the log window of ORDS. But when I try to store and test the Rest enabled SQL Source in APEX Workspace, I receive an Oracle ERROR message :
→ ORA-24247: network access denied by Access Control List (ACL)
In APEX workspace the Database Type is mentioned as “unknown database type”.
I try to fix the error but until now I do not find any reason for this particular error situation. The Access Control List is part of Oracle Database 21c Configuration.
select *
from dba_host_aces;
results on XEPDB1
results on CDB$ROOT
ORDS configuration is REST enabled : restEnabledSql.active=true
Did anyone mentioned this error before ?
Thank you all in advance.
Best regards
Rudolf
Here the ORDS startup log:
ORDS: Release 23.3 Produktion am Fr. März 07 08:54:05 2025
Copyright (c) 2010, 2025, Oracle.
Konfiguration:
/C:/app/zbook/product/ords23/config/
2025-03-07T08:54:06.369Z INFO HTTP and HTTP/2 cleartext listening on host: 0.0.0.0 port: 8080
2025-03-07T08:54:06.384Z INFO HTTPS and HTTPS/2 listening on host: 0.0.0.0 port: 8443
2025-03-07T08:54:06.522Z INFO The document root is serving static resources located in: C:\app\zbook\product\ords23\config\global\doc_root
2025-03-07T08:54:16.115Z INFO Configuration properties for: |default|lo|
db.servicename=XEPDB1
java.specification.version=21
conf.use.wallet=true
sun.cpu.isalist=amd64
sun.jnu.encoding=Cp1252
standalone.static.context.path=/i
java.class.path=C:\app\zbook\product\ords23\bin\..\ords.war
java.vm.vendor=Oracle Corporation
sun.arch.data.model=64
user.variant=
standalone.static.path=/C:/app/zbook/product/ords23/images/
nashorn.args=--no-deprecation-warning
java.vendor.url=https://java.oracle.com/
resource.templates.enabled=false
user.timezone=UTC
db.port=1521
java.vm.specification.version=21
os.name=Windows 10
sun.java.launcher=SUN_STANDARD
user.country=DE
sun.boot.library.path=C:\app\zbook\product\jdk-21.0.6\bin
sun.java.command=C:\app\zbook\product\ords23\bin\..\ords.war --config C:\app\zbook\product\ords23\config serve
jdk.debug=release
standalone.https.host=localhost
sun.cpu.endian=little
user.home=C:\Users\zbook
oracle.dbtools.launcher.executable.jar.path=C:\app\zbook\product\ords23\ords.war
user.language=de
java.specification.vendor=Oracle Corporation
java.version.date=2025-01-21
database.api.enabled=true
java.home=C:\app\zbook\product\jdk-21.0.6
db.username=ORDS_PUBLIC_USER
file.separator=\
java.vm.compressedOopsMode=Zero based
line.separator=
restEnabledSql.active=true
java.specification.name=Java Platform API Specification
java.vm.specification.vendor=Oracle Corporation
feature.sdw=true
standalone.context.path=/ords
db.hostname=localhost
db.password=******
user.script=
sun.management.compiler=HotSpot 64-Bit Tiered Compilers
security.requestValidationFunction=ords_util.authorize_plsql_gateway
java.runtime.version=21.0.6+8-LTS-188
user.name=zbook
stdout.encoding=cp850
path.separator=;
os.version=10.0
java.runtime.name=Java(TM) SE Runtime Environment
file.encoding=UTF-8
plsql.gateway.mode=proxied
standalone.https.port=8443
java.vm.name=Java HotSpot(TM) 64-Bit Server VM
standalone.doc.root=C:\app\zbook\product\ords23\config\global\doc_root
java.vendor.url.bug=https://bugreport.java.com/bugreport/
java.io.tmpdir=C:\Users\zbook\AppData\Local\Temp\
oracle.dbtools.cmdline.ShellCommand=ords
java.version=21.0.6
user.dir=C:\app\zbook\product\ords23\bin
os.arch=amd64
java.vm.specification.name=Java Virtual Machine Specification
jdbc.MaxLimit=50
oracle.dbtools.cmdline.home=..
sun.os.patch.level=
native.encoding=Cp1252
java.library.path=C:\app\zbook\product\jdk-21.0.6\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32, C:\app\zbook\product\php;C:\app\zbook\product\instantclient21, C:\app\zbook\product\php;C:\app\zbook\product\instantclient21, C:\app\zbook\product\php;C:\app\zbook\product\instantclient21;C:\app\zbook\product\21c\dbhomeXE\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\app\zbook\product\jdk-21.0.6\bin;C:\Users\zbook\AppData\Local\Microsoft\WindowsApps;C:\app\zbook\product\ords23\bin;C:\Users\zbook\AppData\Local\GitHubDesktop\bin;C:\Administrator\Documents\3DDEV\PickupProjekt\project\vb.net\WindowsApplication1\WindowsApplication1\iowkit32;C:\Users\zbook\AppData\Local\Programs\Microsoft VS Code\bin;C:\app\zbook\product\php;C:\app\zbook\product\instantclient21;;C:\app\zbook\product\jdk-21.0.6\bin;.
java.vendor=Oracle Corporation
java.vm.info=mixed mode, sharing
stderr.encoding=cp850
java.vm.version=21.0.6+8-LTS-188
sun.io.unicode.encoding=UnicodeLittle
jdbc.InitialLimit=10
db.connectionType=basic
java.class.version=65.0
2025-03-07T08:54:24.389Z INFO
Mapped local pools from C:\app\zbook\product\ords23\config\databases:
/ords/ => default => VALID
2025-03-07T08:54:24.574Z INFO Oracle REST Data Services initialized
Oracle REST Data Services version : 23.3.0.r2891830
Oracle REST Data Services server info: jetty/10.0.17
Oracle REST Data Services java info: Java HotSpot(TM) 64-Bit Server VM 21.0.6+8-LTS-188