Hi,
We have a consultant working on setting up a process to transfer data from SQL Server to Oracle. When he tries to use a connection manager to Oracle in SSIS, he gets the error "Test connection failed because of error in initializing provider. ORA-01019; unable to allocate memory in the user side." The connection works fine for me.
I'm assuming this is a permission issue, but I don't work to grant him admin rights on our server. Is there anything else I can do?
Thanks.