AD Administration error:ORA-01017: invalid username/password; logon denied

dakulaDL發表於2012-12-27
EBS資料庫升級到11g後在appsTier執行adadmin遇到另外一個問題
AD Administration 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.
這種情況一般有兩種原因:
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


這個引數是11g的新特性,密碼大小寫敏感,看來是EBS系統不支援這個特性導致,萬惡的oracle阿。
 
修改init.ora把sec_case_sensitive_logon改成FALSE
 
 

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/11289933/viewspace-751724/,如需轉載,請註明出處,否則將追究法律責任。

相關文章