oracle-apex - ORA-20000: 找不到 AOP 服务器。检查它是否在 http://api.apexofficeprint.com/ 上运行

Question

在使用 apex office 插件打印交互式报告期间，我最终收到以下弹出错误消息。

ORA-20000: 找不到 AOP 服务器。检查它是否在http://api.apexofficeprint.com/上运行

标签： oracle-apex

Answer 1

Make sure APEX_050000 or APEX_050100 schema has the rights to connect to APEX Office Print (http(s)://www.apexofficeprint.com for the Cloud version or your local URL in case of the on-premise version). The script to correct the issue can be found here: 

对于 Apex 5.0 https://docs.oracle.com/cd/E59726_01/install.50/e39144/listener.htm#HTMIG29160 对于 Apex 5.1 http://docs.oracle.com/database/apex-5.1/HTMIG/enabling -network-services-in-Oracledb-11g-or-later.htm#HTMIG29160 对于 Apex 18.1 https://docs.oracle.com/database/apex-18.1/HTMIG/enabling-network-services-in-Oracle-db11g -or-later.htm#HTMIG29161 对于 Apex 18.2 https://docs.oracle.com/en/database/oracle/application-express/18.2/htmig/enabling-network-services-in-Oracledb-11g-or-later .html#GUID-8D125731-989A-4A51-AFFE-00181729F87F 对于 Apex 19.1 https://docs.oracle.com/en/database/oracle/application-express/19.1/htmig/enabling-network-services-in-Oracle -db11g-or-later.html 对于 Apex 19.2 https://docs.oracle.com/en/database/oracle/application-express/19.2/htmig/enabling-networkservices-in-Oracle-db-11g-or-later.html 注意：为您的数据库使用正确的脚本版本 - 用于 12c 之前的 XE 更多信息，请访问：https ://www.apexofficeprint.com/docs/ （第 10.6 节）