Hello,
I Installed Oracle apex 21.1 on Oracle Database 18c xe with standalone mode on windows server 2019 datacenter.
grant permission to user to access UTL_HTTP
create ACL
BEGIN
DBMS_NETWORK_ACL_ADMIN.append_host_ace (
host => 'www.orders.XXXXXXX.com',
lower_port => null,
upper_port => null,
ace => xs$ace_type(privilege_list => xs$name_list('http'),
principal_name => 'XXXXXXX',
principal_type => xs_acl.ptype_db));
END;
/
I have to fetch data from API, so i create REST data source, but got error
ORA-28759: failure to open file
Create wallet to store certificate.
mkstore -create -wrl C:\oracle\app\Administrator\product\18.0.0\wallet
mkstore -wrl C:\oracle\app\Administrator\product\18.0.0\wallet -create Credential xepdb1 username passwod
add certificate in wallet using wallet manager
---------------------------------------------------------------------------------------------
changes in following files
sqlnet.ora
WALLET_LOCATION =
(SOURCE = (METHOD = file)
(METHOD_DATA = (DIRECTORY="C:\oracle\app\Administrator\product\18.0.0\wallet")))
SSL_SERVER_DN_MATCH=yes
---------------------------------------------------------------------------------------------
tnsnames.ora
orassl =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCPS)
(HOST = vmi657897)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED) (SERVICE_NAME = xepdb1))
(SECURITY= (SSL_SERVER_CERT_DN="CN=cPanel\, Inc. Certification Authority,O=cPane\,L=Houston,ST=TX,C=US")) )
Can you please guide me step by step to configure the REST data services.