ORA-28860: 致命 SSL 错误,无法创建 REST 数据源或发送电子邮件
我已经安装了Oracle databese 18c XE和Oracle APEX 21.2.0, 在尝试为 APEX 应用程序
“ORA-24247:网络访问被访问控制列表(ACL)拒绝”
(创建 REST 数据源)时,我收到以下错误:在做了一些研究后,我使用 SQL Plus 将 sys 作为 sysdba 连接,然后执行以下:
ALTER SESSION SET CONTAINER = XEDBA1;
之后我执行了以下命令:
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect', 'resolve'),
principal_name => 'APEX_210200',
principal_type => xs_acl.ptype_db));
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect', 'resolve'),
principal_name => 'MDS_SCHEMA',
principal_type => xs_acl.ptype_db));
END;
/
其中: APEX_210200 是内部工作区架构 MDS_SCHEMA 是构建应用程序的工作区的架构
时收到错误“ORA-28860:致命 SSL 错误”
现在,我在尝试创建 REST 数据源创建 REST 数据源 ORA-28860
我无法发送电子邮件,因为 SMTP 服务器设置正确,
请帮忙我可以创建 REST 数据源并通过我的 APEX 应用程序发送电子邮件
I have installed Oracle databese 18c XE, and Oracle APEX 21.2.0,
I was getting the below error when trying to (Create REST Data Source) for APEX Application
"ORA-24247: network access denied by access control list(ACL)"
after doing some research I connected sys as sysdba using SQL Plus, and then executed the below:
ALTER SESSION SET CONTAINER = XEDBA1;
after that I executed the below commands:
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect', 'resolve'),
principal_name => 'APEX_210200',
principal_type => xs_acl.ptype_db));
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect', 'resolve'),
principal_name => 'MDS_SCHEMA',
principal_type => xs_acl.ptype_db));
END;
/
where:
APEX_210200 is the INTERNAL workspace schema
MDS_SCHEMA is the schema for the workspace which the application was build
Now I'm getting the error "ORA-28860: Fatal SSL error" when trying to create REST Data Source
Create REST Data Source
ORA-28860
And I can't send emails knowing that SMTP server is set correctly
Please help so I can Create REST Data Source and send Emails through my APEX application
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论