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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- sqlplus / as sysdba報錯ORA-01017: invalid username/password; logon deniedSQLGo
- 【YashanDB資料庫】YAS-02143 invalid username/password, login denied資料庫
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:YES)Errorlocalhost
- 報錯”ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)”Errorlocalhost
- 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
- MySQL 8.0.13 密碼問題 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)MySql密碼Errorlocalhost
- vue專案中連線MySQL時，報錯ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'localhost' (using password:YES)VueMySqlErrorlocalhost
- python urllib socks5 auth username password 設定Python
- mysql 1045, "Access denied for user 'root'@'localhost' (using password: NO)"MySqllocalhost
- Error: Permission denied @ apply2filesErrorAPP
- 啟動報錯：Access denied for user 'root'@'localhost' (using password:YES)localhost
- java.sql.SQLException: Access denied for user ‘root‘@‘localhost‘ (using password: YES)JavaSQLExceptionlocalhost
- Ubuntu git pull 出現Permission denied ErrorUbuntuGitError
- SourceTreet提交時顯示remote: Incorrect username or password ( access token )(4種解決辦法)REM
- xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools)ErrorDeveloper
- error creating overlay mount to invalid argument unbuntu系統Error
- error: invalid type argument of unary ‘*‘ (have ‘int‘) *__first = __tmp；Error
- Caused by: java.sql.SQLException: Access denied for user 'dell-pc'@'xxxxx' (using password: YES)JavaSQLException
- SpringBoot中yml配置java.sql.SQLException: Access denied for user ‘root‘@‘localhost‘ (using password: NOSpring BootJavaSQLExceptionlocalhost
- DataPump Export (EXPDP) Fails With Error LPX-216 Invalid CharacterExportAIError
- Navicat遠端連線MySQL 提示1045 - Access denied for user 'root'@'223.74.158.192'(using password：YES)MySql
- Dynamics CRM Error- Creating Entity with an invalid parent. Entity: EmailErrorAI
- Ubuntu18.04：mysql：ERROR 1698 (28000): Access denied for user ‘root‘@‘localhost‘UbuntuMySqlErrorlocalhost
- MySQL系列：Docker安裝 MySQL提示錯誤：Access denied for user'root'@'localhost' （using password:yes）MySqlDockerlocalhost
- 小程式 · 報錯：Error: errCode: -501007 ，errMsg: Invalid Key Name (__keyPath)Error
- Part I Concepts and Administration
- 序號產生器給Keil註冊：ERROR R206: NO REGISTRY ACCESS, ADMINISTRATION RIGHTS REQUIREDErrorUI
- logon觸發器for dbaGo觸發器
- URL username 屬性
- Syntax Error: ValidationError: Invalid options object. Stylus Loader has been initialized using anErrorObjectZed
- mac os x 安裝mysql遇到 Access denied for user ‘root‘@‘localhost‘ (using password: YES)的解決方法MacMySqllocalhost
- Navicat tnt版本提示“failed to save password error code”的解決辦法AIError
- 1、 Getting Stared with Database AdministrationDatabase
- mysql 5.6.25報錯ERROR 1372 (HY000): Password hash 的一點思考MySqlError
- 【Lintcode】1789. Distinguish UsernameNGUI
- PostgreSQL/LightDB copy ERROR: invalid byte sequence for encoding "UTF8": 0x00SQLErrorEncoding
- 1. Getting Stared with Database AdministrationDatabase
- Hybris Administration console功能一覽