When I run ODI scenario I get the below error :
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found The Connection descriptor used by the client was:
Any help is greatly appreciated.
Something has changed, thats for sure...
Couple of pointers:
1.) What is the agent that you are using to execute the scenarios ? Could the ORACLE_HOME of the agent have changed ?
2.) Was any new install of Oracle home created on the machine on which the agent runs ?
Did you have any joy on this?
I'm investigating it myself at the moment. We're running Oracle 126.96.36.199.0 64bit, ODI 188.8.131.52.0, Weblogic Server 10.3.5.0.
I think I know what the problem is but seeing how we can go about resolving it. It doesn't seem to be a DB issue but moreso the way weblogic manages the connections to the DB...