Extended Oracle agent (rz) connection problem when instance is using SSL authentication

Troubleshooting

Problem

ITCAM Extended Oracle agent does not connect to Oracle instance when the instance is using SSL authentication, ORA-28759 error occurs.

Symptom

Extended Oracle agent is unable to attach to SSL authenticated Oracle instance:
host_rz_<instance>_krzstart_*_01.log shows ORA-28759 error.

(53AC13E3.001E-2:krzocidb.cpp,174,"Ora_Database::innerConnect") env is 100D7510, Connection string is:(DESCRIPTION = (ADDRESS = (PROTOCOL = TCPS)(Host = host)(Port = 1922)) (CONNECT_DATA = (SERVICE_NAME = ORCL.ibm.com) ) ), UserID is:tivmon, error pointer is 1015DF08
(53AC13E3.001F-2:krzocibase.cpp,659,"Ora_ErrorMsg::printOCIError") Oracle error at ServerAttach, Instance is ORCL
(53AC13E3.0020-2:krzocibase.cpp,660,"Ora_ErrorMsg::printOCIError") Status code is -1
(53AC13E3.0021-2:krzocibase.cpp,666,"Ora_ErrorMsg::printOCIError") Oracle error at ServerAttach, error code is:28759, error message is:ORA-28759: failure to open file
(53AC13E3.0022-2:krzocibase.cpp,670,"Ora_ErrorMsg::printOCIError") SQL content is:NULL
(53AC13E3.0023-2:krzreqprocess.cpp,376,"buildIntervalSQLInfo") The database connection for subnode INST-host is not established, database type unknown yet.

[{"Product":{"code":"SS3JRN","label":"Tivoli Composite Application Manager for Applications"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"ITCAM Extended Agent for Oracle Database 5724V09OR v6.3","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.3.1","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in 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 Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Was this topic helpful?

Document Information

More support for:
Tivoli Composite Application Manager for Applications

Software version:
6.3.1

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

Document number:
516569

Modified date:
17 June 2018

UID

swg21678825

IBM Support

Tips