Error connecting DB from DAC ORA-12516: TNS:listener could not find available handler with matching protocol stack

I ran into this error a lot recently when running DAC execution plan, which takes some time to complete. Here is the error details that you can get from Informatica session log when the sessions failed:RR_4036 Error connecting to database [Database driver error...Function Name : LogonORA-12516: TNS:listener could not find available handler with matching protocol stackDatabase driver error...Function Name : ConnectDatabase Error: Failed to connect to database using user [etldw] and connection string [BIQATST].].Upon some researching and some help...

Read More

DAC: Fail to create Index during execution plan run

Hello againHere is something that a beginner may run into every so often when they use DAC to run informatica workflow, which is when the DAC execution plan runs fine except it fails to create table Index after the load. Or it could be shown as the following scenario:The execution plan is completed with several failures of its tasks. We look at the detail of the task and find out that it fails at the last step of creating table Index:We found out...

Read More