This content has been marked as final. Show 6 replies
Make sure you able to ping or connect ORA_R12
And also you test the connection successfully at Physical Data Source
Once you done with these make sure you have same
Connection(in dac Physical Data Source) name and that matches with Workflow Manager connection name
If helps pls mark
No Issues connecting to ORA_R12 or all connections test sucessfully
Checked all passwords are correct in Workflow Manager and DAC.
I tried restarting EP (Execution Plan) stuck at Creating connection pool. : ORA_R12
Nothing being written to log file.
Strange thing I noticed if I try to abort the ETL still nothing is updated in the log file and it doesnt abort in dac client only way to abort its is to reboot dac server.
Any ideas, happened again yesterday only way to resolve was to create a new EP
Seems to happen when ETL's fail for what ever reason could be not getting cleared somewhere after DAC restarted?