Oracle REST 数据服务 apex_pu
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/30196252/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle REST Data Service apex_pu
提问by Calin Cioanta
I tried to install Oracle REST Data Service and I got this error:
(on java -jar ords.war install)
我尝试安装 Oracle REST 数据服务，但出现此错误：（上java -jar ords.war install）
SEVERE: The pool named: apex_pu is not correctly configured,
error: ORA-01017: invalid username/password; logon denied
oracle.dbtools.common.jdbc.ConnectionPoolException:
The pool named: apex_pu is not correctly configured,
error: ORA-01017: invalid username/password; logon denied
at oracle.dbtools.common.jdbc.ConnectionPoolException.badConfiguration(ConnectionPoolException.java:88)
at oracle.dbtools.common.config.db.DatabasePools.badConfiguration(DatabasePools.java:198)
回答by Kris Rice
The pool mentioned "apex_pu" is contained in the file conf/apex_pu.xml This file is for ORDS_PUBLIC_USER.
提及“apex_pu”的池包含在文件 conf/apex_pu.xml 中。该文件用于 ORDS_PUBLIC_USER。
The error could be from 1 of 2 reasons.
错误可能来自 2 个原因之一。
1 - ORDS_PUBLIC_USER account passwd has changed or expired. Change it and edit the apex_pu.xml file and place a ! in front of the password. This will trigger ORDS to encode the password at next startup.
1 - ORDS_PUBLIC_USER 帐户密码已更改或已过期。更改它并编辑 apex_pu.xml 文件并放置一个 ! 在密码前面。这将触发 ORDS 在下次启动时对密码进行编码。
<entry key="db.password">!NewPASSWORD</entry>
2 - The DB also throws this error if the proxy grant has been revoke from the user to execute the REST call as. If this has happened the grant can be reissued with the following
2 - 如果代理授权已从用户处撤销以执行 REST 调用，则 DB 也会引发此错误。如果发生这种情况，可以通过以下方式重新发放补助金
alter user USERNAME grant connect through ords_public_user
回答by Calin Cioanta
I solved the problem by changing "Default tablespace" for user APEX_PUBLIC_USER.
我通过更改用户 APEX_PUBLIC_USER 的“默认表空间”解决了这个问题。
java -jar ords.war uninstall
then again
然后再
java -jar ords.war install
回答by Olafur Tryggvason
The new ORDS 3 doesn't necessarily need APEX to function.
新的 ORDS 3 不一定需要 APEX 才能运行。
ORDS 3 can connect to it's own schemas without the use of APEX, it can also connect to Oracle NOSQL Database: Oracle REST Enables Oracle Database and Oracle NoSQL
ORDS 3 可以在不使用 APEX 的情况下连接到它自己的模式，它还可以连接到 Oracle NOSQL 数据库：Oracle REST Enables Oracle Database and Oracle NoSQL
Basically you now have two methods to set up ORDS
基本上你现在有两种方法来设置 ORDS
With APEX
java -jar ords.war setup
与顶点
java -jar ords.war 设置
Say no (2) for verify/install Oracle REST Data Services schema
对 (2) 说不 verify/install Oracle REST Data Services schema
Say yes (1) for PL/SQL Gateway(APEX, you still get REST through apex_rest_public_user)
对PL/SQL Gateway(APEX, you still get REST through apex_rest_public_user)说 yes (1 )
This uses the APEX Public users. (APEX_PUBLIC_USER, APEX_LISTENER, APEX_REST_PUBLIC_USER)
这使用 APEX 公共用户。（APEX_PUBLIC_USER、APEX_LISTENER、APEX_REST_PUBLIC_USER）
Oracle REST Data services
java -jar ords.war install
Oracle REST 数据服务
java -jar ords.war 安装
This creates the ORDS schemas (ORDS_PUBLIC_USER, ORDS_METADATA)
这将创建 ORDS 模式（ORDS_PUBLIC_USER、ORDS_METADATA）
java -jar ords.war setup
Say Yes (1) for verify/install Oracle REST Data Services schema
说是 (1) 为 verify/install Oracle REST Data Services schema
Say No (2) for PL/SQL Gateway(Apex)
对PL/SQL Gateway（Apex）说不（2 ）
You are probably giving the APEX password to the ORDS user.
您可能将 APEX 密码提供给 ORDS 用户。
Hope this clarifies.
希望这能澄清。
回答by Andrey
Change username, password in the file apex_pu.xml to values in the apex.xml.
将文件apex_pu.xml 中的用户名、密码更改为apex.xml 中的值。
回答by searching9x
You need to change APEX_PUBLIC_USER password:
您需要更改 APEX_PUBLIC_USER 密码：
java -jar ords.war user APEX_PUBLIC_USER
And re enter password.
并重新输入密码。
回答by Carlos Ramírez
After you have installed Oracle REST Data Services, you have to run the script @apex_rest_config.sql, in order to create APEX_LISTENER and APEX_REST_PUBLIC_USER accounts.
安装 Oracle REST 数据服务后，您必须运行脚本 @apex_rest_config.sql，以创建 APEX_LISTENER 和 APEX_REST_PUBLIC_USER 帐户。
