dbTalk Databases Forums  

SSIS package gives ORA-01019 with one user, works fine with other user

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss SSIS package gives ORA-01019 with one user, works fine with other user in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
eteunisse
 
Posts: n/a

Default SSIS package gives ORA-01019 with one user, works fine with other user - 10-22-2010 , 05:08 AM






I can't figure this one out. On a Windows 2003 server we have a sql
2005 installation. A dtsx package gets data from a Oracle server. The
packge sudenly gave a ora-01019 error. With my sql admin account I
can't connect to the Oracle Server, but with an other user account I
still can.

Read lot of forum posts but none had the answer.
It must be something in the policy or something, but what?



ora-01019: unable to allocate memory in the user side

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.