Oracle

我為 Oracle Apex 實例管理員帳戶提供的管理員密碼有什麼問題?

  • November 12, 2021

我已經在 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] a@b.c
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

該密碼沒有任何問題。但為了確定起見,請檢查變數是否真的包含您輸入的密碼 ( 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] a@b.c
Enter apexadmin's password []
Created instance administrator APEXADMIN.

SYS> print :PASSWORD

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

SYS>

引用自:https://dba.stackexchange.com/questions/274319