How to enable external authentication for an Oracle connector within DataStage Designer

Troubleshooting

Problem

Within the Oracle connector, one can enable or disable external authentication. If external authentication is enabled, it needs to be set up in Oracle. If it is not set up properly, the following error might be seen. Item #: 68 Event ID: 67 Timestamp: 2011-10-31 15:31:04 Type: Fatal User Name: dsadm Message Id: IIS-CONN-ORA-01004 Message: Oracle_Connector_0: The connector could not establish connection to Oracle server ORATEST1. Method: OCISessionBegin:OCI_CRED_EXT, Error code: 1,017, Error message ORA-01017: invalid username/password; logon denied. (CC_OraConnection::verifyConnection, file CC_OraConnection.cpp, line 3,711)

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"8.5;8.5.0.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

To view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

link to actual document

Was this topic helpful?

Document Information

More support for:
IBM InfoSphere DataStage

Software version:
8.5, 8.5.0.1

Operating system(s):
AIX, HP-UX, Linux, Solaris

Document number:
463879

Modified date:
25 April 2025

UID

swg21571685

IBM Support

Tips