AD Administration error:ORA-01017: invalid username/password; logon denied
EBS資料庫升級到11g後在appsTier執行adadmin遇到另外一個問題
AD Administration error:
The following ORACLE error:
The following ORACLE error:
ORA-01017: invalid username/password; logon denied
occurred while executing the SQL statement:
CONNECT SYSTEM/*****
AD Administration error:
Unable to connect to 'SYSTEM'; password may be invalid.
Unable to connect to 'SYSTEM'; password may be invalid.
這種情況一般有兩種原因：
1.system被鎖定，用sql*plus直接用system登陸正常，排除這種可能
2.資料庫引數sec_case_sensitive_logon預設設定成TRUE
metalink上的解釋
As per the Note 216205.1
Title: Database Initialization Parameters for Oracle Applications Release 11i
#########
#
# Database Password Case Sensitivity (new with Oracle Database 11g)
#
# Database password case sensitivity is a new feature available with 11g.
# Oracle E-Business Suite does not currently integrate with this feature,
# so the parameter must be set to FALSE.
#
#########
sec_case_sensitive_logon = FALSE #MP
Title: Database Initialization Parameters for Oracle Applications Release 11i
#########
#
# Database Password Case Sensitivity (new with Oracle Database 11g)
#
# Database password case sensitivity is a new feature available with 11g.
# Oracle E-Business Suite does not currently integrate with this feature,
# so the parameter must be set to FALSE.
#
#########
sec_case_sensitive_logon = FALSE #MP
這個引數是11g的新特性,密碼大小寫敏感，看來是EBS系統不支援這個特性導致，萬惡的oracle阿。
修改init.ora把sec_case_sensitive_logon改成FALSE
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/11289933/viewspace-751724/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ORA-01017：invalid username/password; logon deniedGo
- sqlplus / as sysdba報錯ORA-01017: invalid username/password; logon deniedSQLGo
- 遠端登入sys使用者報錯：ORA-01017: invalid username/password; logon deniedGo
- SYS使用者遠端登入報錯：ORA-01017: invalid username/password; logon deniedGo
- ORA-01017: invalid username/password; logon denied ORA-02063: preceding line from TESTGo
- RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password;ErrorUXDatabase
- 【YashanDB資料庫】YAS-02143 invalid username/password, login denied資料庫
- 【DG】搭建DG時報錯：ORA-01017、ORA-17627、ORA-17629 invalid username/password
- The password supplied with the username Domain\UserName was not correct. Verify that it was entered ...AI
- ConfigureGC.pl Reports - Invalid Username/Password. (文件 ID 602750.1)GC
- nagios監控windows 報NSClient - ERROR: Invalid passwordiOSWindowsclientError
- MYSQL解決error: 'Access denied for user 'root'@'localhost' (using password:MySqlErrorlocalhost
- ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)Errorlocalhost
- WCF Security:authentication based on Username/Password - Part I
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:YES)Errorlocalhost
- EBS在測試時報 APP-FND-01516: Invalid application username,password,or database.APPDatabase
- 報錯”ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)”Errorlocalhost
- ERROR 1045 (28000): Access denied for user 'root'@'127.0.0.1' (using password: YES)Error127.0.0.1
- vue專案中連線MySQL時，報錯ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'localhost' (using password:YES)VueMySqlErrorlocalhost
- Access denied for user 'root'@'localhost' (using password: NO)localhost
- Linux錯誤 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)LinuxErrorlocalhost
- 解決Mysql:ERROR 1045 (28000):Access denied for user ‘root‘@‘localhost‘ (using password: NO)的方法MySqlErrorlocalhost
- python urllib socks5 auth username password 設定Python
- WCF Services Sample: Authenticate Silverlight Client based on UserName and Passwordclient
- MySQL 8.0.13 密碼問題 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)MySql密碼Errorlocalhost
- Oracle RAC AdministrationOracle
- #1045 - Access denied for user 'root'@'localhost' (using password: NO)localhost
- linux安裝MySQL出現ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)LinuxMySqlErrorlocalhost
- mysql 1045, "Access denied for user 'root'@'localhost' (using password: NO)"MySqllocalhost
- DBReader/Classes/LogonGo
- SAPconnect Administration (Transaction SCOT)
- ICA Client Error 1043: Invalid Parameter with a Towitoko CHIPDRIVE SIM Card ReaderclientError
- 761637-Logon restrictions prevent TMSADM logonGoREST
- Error: Permission denied @ apply2filesErrorAPP
- Ubuntu git pull 出現Permission denied ErrorUbuntuGitError
- ERROR 1045 (28000): Access denied for userError
- ORA-01045: user HR lacks CREATE SESSION privilege; logon deniedSessionGo
- 啟動報錯：Access denied for user 'root'@'localhost' (using password:YES)localhost