IM - Connection to external DB Oracle
I tried to develop one application in IM to transport some data from IM DB to another DB Oracle of customer but I find some problem. When I tried to connect the external DB Oracle I receive this error:
ora-12638 credential retrieval failed
I tried to modify on sqlnet.ora file the following row:
In this case case, the connection with external DB working but 2 services on 800xA stopping:
1) IM Event Collector Service on 800xA
2) IM Archive Service on 800xA
I use 800xA 18.104.22.168, Oracle 12.1 c, Excel 2016 and I tried 3 methods (Oracle OLE DB, TNSNAMES and ODBC) with the same results.
Do You have any suggestions?
Thanks and BR,
First and foremost, the IM Oracle Database cannot be moved to any other version of Oracle installed in a non-800xA IM PC. The Oracle configuration is specifically designed to work only with the version of Oracle that is shipped with the IM node. Second, under no circumstances should you modify any of the files associated with the IM node in an attempt to make them compatible with any other version of Oracle.
With all that being said, it should also be noted that OLE DB is no longer supported by Microsoft, and therefore, cannot be utilized to extract data from the IM Oracle data base. However, the ODBC interface is a usable function that will allow the user to extract data. I cannot see in your question any indication of whether you are looking for Numeric Log data or for Event data or possibly both. Obviously, a feature embedded into the 800xA System, Excel_DA, (DataDirect), is also one method of getting data into Excel as one option. Additionally, there are also SQL commands that can be formatted to extract data.
As a note, the 800xA CLS license addition of HIST_ODBC, must be added into the system for any non-ABB function that utilize ODBC to function correctly.
I believe your best option now is to create a Support Case via your Regional Support Group which will allow us to track the steps that are necessary to support your request.