PM50979: AN "INVALID USER/PASSWORD" ERROR CODE 1017 MAY OCCUR WHEN ACCESSING ORACLE AQ IF CASE SENSITIVE LOGON IS SET TO ON

APAR status

• Closed as program error.

Error description

• An "invalid user/password" error code 1017 may occur when
  accessing Oracle AQ if case sensitive logon set to on.
  
  The Oracle AQ adapter is forcing username and password to all
  uppercase.  In Oracle 11, if password sensitivity is set to
  on then a failure may occur.
  

Local fix

• WTXCQ - WTX00038972
  GK / GK
  Circumvention: None
  

Problem summary

• Users Affected:
  WebSphere Transformation Extender customers using Oracle AQ
  connecting to an Oracle 11g Server.
  
  Problem Description:
  The Oracle Client driver is reporting a login failure to the WTX
  Oracle AQ Adapter.
  
  Platforms Affected:
  ALL
  

Problem conclusion

• The WTX AQ Adapter now retains user name and password case
  sensitivity when logging into the Oracle Server.  Before this
  fix, the Adapter would always change the user name and password
  to uppercase.  In order to work around this problem before
  getting the fix, the customer needs to ensure that the following
  system command is issued:
  alter system set sec_case_sensitive_logon = false;
  
  The current setting can be viewed by using the following
  command:
  show parameter sec_case_sensitive_logon;
  
  After this fix, the above system commands will not need to be
  used.
  
  Delivered in:
  8.1.0.6, 8.2.0.6, 8.3.0.5, 8.4.0.0
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WTX FOR INT SER

• Fixed component ID

  5724M4010

Applicable component levels

• R810 PSY

     UP

• R820 PSY

     UP

• R830 PSY

     UP

• R840 PSY

     UP