OCI plugin error-ACESS DENIED

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Poornagirija
Participant
Posts: 65
Joined: Fri Nov 19, 2004 12:00 am

OCI plugin error-ACESS DENIED

Post by Poornagirija »

HI Folks,

Im working in DataStage 7.5 server edition.
Our DS server is in windows 2003 and our DS

client is in windows2000 professional.

I have desinged one job of extracting the data

from siebel source on oracle DB and populating

the same to Oracle DB using OCI stage.

While trying to view the data im getting the following error
ds_loadlibrary: Win32 error in LoadLibrary of oraoci9.dll - Access is denied.
Neglecting the error i can compile the job but while running ,my job gets aborted showing the same error message.

The same job is working fine in another server.

could you please help me in sorting out the issue.

Many thanks in advance.

with regards,
poornagirija.
loveojha2
Participant
Posts: 362
Joined: Thu May 26, 2005 12:59 am

Post by loveojha2 »

Try compiling/running the same job with administrator.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Hi,
The same job is working fine in another server.
You mean to say another machine or with another datastage server :?:

regards
kumar
Poornagirija
Participant
Posts: 65
Joined: Fri Nov 19, 2004 12:00 am

Post by Poornagirija »

Hi,
Thanks for your Response.

Its actually a privilege issue.We have rectified that.

with regards,
Poornagirija.
maffan76
Participant
Posts: 110
Joined: Tue Aug 23, 2005 5:27 am

Post by maffan76 »

Hi Poornagirija ,
Can you please specify that what previliges you set to get rid of this problem.

Thanks in advance.
Regards,
Affan
"Questioning is Half Knowledge"
Post Reply