I have access to a new 12c ODI server, however I do NOT have admin access nor do I have access to the web logic console.
That said, I noticed this ODI 12c server does not appear configured correctly for SQLLDR mappings
When we try to run this SQLLDR-based loading knowledge module: "LKM SQL to Oracle (Built-In)" the relevant mappings get this error:
SQL*Loader: Release 12.2.0.1.0 - Production on Fri Mar 9 09:42:34 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12541: TNS:no listener
The relevant agent on this ODI 12c server is "supposed" to have been configured from inside weblogic/fusion middle as I understand.
I have access to another development ODI server which runs a standalone agent, that CAN INDEED run the same sqlldr LKM SUCCESSFULLY.
So my questions are these:
Where can I tell the admin to look to correct the new ODI 12c server to fix this tns issue?
I suspect the ODI 12c server needs the TNSNAMES.ORA file setup with proper entries, however I am not sure where it is trying to look for that file.
I am also unsure where the various agent parameters are set inside of web logic
I welcome thoughts/guidance
Thank you