主页 / dba / 问题 / 274319
Accepted
alvarez
Asked: 2020-08-26 05:59:31 +0800 CST

我为 Oracle Apex 实例管理员帐户提供的管理员密码有什么问题？

  • 772

我已经在 Oracle Linux 7.8 上安装了 Oracle Database 19c 企业版。我现在正在尝试安装Apex 20.1。

进入“5.4.2.3 运行apxchpwd.sql”章节设置实例管理员密码。执行@apxchpwd.sql命令，它询问我用户名、电子邮件和密码，但随后它给出了一个错误，好像密码没有足够的复杂性，尽管我提供的密码是字面意思H29dN8%Ih^^IV$Y3$j4Mx。尝试了各种其他密码，似乎没有什么可以接受的。

可能是什么问题？

这是我遇到错误的方法：

[oracle@oraclemachine apex]$ sqlplus /nolog

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Aug 25 09:50:03 2020
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

SQL> connect sys as sysdba
Enter password:
Connected.
SQL>
SQL> @apxchpwd.sql
...set_appun.sql
================================================================================
This script can be used to change the password of an Application Express
instance administrator. If the user does not yet exist, a user record will be
created.
================================================================================
Enter the administrator's username [ADMIN] apexadmin
User "apexadmin" does not yet exist and will be created.
Enter apexadmin's email [apexadmin] [email protected]
Enter apexadmin's password []
--------------------------------------------------------------------------------
PASSWORD_COMPLEXITY_ERROR
* PASSWORD_ONE_ALPHA_ERR
* PASSWORD_ONE_PUNCTUATION_ERR
* PASSWORD_ONE_UPPER_ERR
* PASSWORD_ONE_LOWER_ERR
--------------------------------------------------------------------------------
declare
*
ERROR at line 1:
ORA-20001: Password validation failed.
ORA-06512: at line 30
ORA-06512: at "APEX_200100.WWV_FLOW_FND_USER_INT", line 3744
ORA-06512: at line 20
oracle password

1 个回答

  1. Best Answer

    该密码没有任何问题。但为了确定起见，请检查变量是否真的包含您输入的密码 ( print :PASSWORD)：

    Thank you for installing Oracle Application Express 20.1.0.00.13

Oracle Application Express is installed in the APEX_200100 schema.

The structure of the link to the Application Express administration services is as follows:
http://host:port/pls/apex/apex_admin (Oracle HTTP Server with mod_plsql)
http://host:port/apex/apex_admin     (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)
http://host:port/apex/apex_admin     (Oracle REST Data Services)

The structure of the link to the Application Express development interface is as follows:
http://host:port/pls/apex (Oracle HTTP Server with mod_plsql)
http://host:port/apex     (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)
http://host:port/apex     (Oracle REST Data Services)

timing for: Phase 3 (Switch)
Elapsed: 00:00:06.97
timing for: Complete Installation
Elapsed: 00:05:01.54

PL/SQL procedure successfully completed.





1 row selected.

...null1.sql

    然后：

    SYS> @apxchpwd.sql
...set_appun.sql
================================================================================
This script can be used to change the password of an Application Express
instance administrator. If the user does not yet exist, a user record will be
created.
================================================================================
Enter the administrator's username [ADMIN] apexadmin
User "apexadmin" does not yet exist and will be created.
Enter apexadmin's email [apexadmin] [email protected]
Enter apexadmin's password []
Created instance administrator APEXADMIN.

SYS> print :PASSWORD

PASSWORD
--------------------------------------------------------------------------------
H29dN8%Ih^^IV$Y3$j4Mx

SYS>
    • 0

相关问题