Oracle
我為 Oracle Apex 實例管理員帳戶提供的管理員密碼有什麼問題?
我已經在 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>