11g EX SSIS Pkg Runs in development Gets ORA-12516
991939Feb 19 2013 — edited Feb 19 2013I have an SSIS package (VB2008) that creates and loads an Oracle 11g Express data from an XML and XSD files. It works fine in the development mode. When I try to run the package by double clicking on the dtsx file (launches the Execute Package Utility), I get a ORA-1256 error -"TNS: Listner counld not find available handle with matching protocol stack"
There were instances were executing the package worked. However, it did not conistently work.
I tried increasing the number of processes using the DBA account and the following sql statement.
alter system set processes=1000 scope=spfile;
This did not seem to change anything.
I'm very new to Oracle.
Frankly I'm stumped.
Any help would be appreciated.
John