IBM Support

JR33269: MESSAGE: ORA-01017: INVALID USERNAME/PASSWORD; LOGON DENIED ERROR WITH -DBOPTIONS '{}'

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Oracle jobs use OS Authentication to log onto Oracle.
    That means the Oracle connection is established based on the
    credentials of the User ID that requested the connection.  The
    empty brackets {} have the same effect as logging onto Oracle as
    EXTERNAL, meaning ?use the credentials of the User ID.
    

Local fix

  • This fix is included in 8.0.1 fix pack 3
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    Only users needing OS authentication are effected.
    ****************************************************************
    PROBLEM DESCRIPTION:
    Oracle jobs use OS Authentication to log onto Oracle.
    That means the Oracle connection is established based on the
    credentials of the User ID that requested the connection.  The
    empty brackets {} have the same effect as logging onto Oracle
    asEXTERNAL, meaning ?use the credentials of the User ID.
    ****************************************************************
    RECOMMENDATION:
    apply patch provided.
    This change is included in 8.1 Fix Pack 1.
    ****************************************************************
    

Problem conclusion

  • OS Authentication is now enabled.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR33269

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    753

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-06-07

  • Closed date

    2009-06-26

  • Last modified date

    2010-12-09

  • 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

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • R753 PSN

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
09 December 2010