ETL Error - TNS:listener could not find available handler for requested type of server

Hello All,

If your ETLs are failing with the error, "TNS:listener could not find available handler for requested type of server" you will have to increase the processes in the Database by using the following commands.

alter system set processes=300 scope=spfile;    

alter system set sessions=300 scope=spfile;

This change requires a DB bounce. So, please bounce your DB server once done.

Appicable for: Oracle Only

Cheers,

Siva