Error missing ORA.DLL

JandeBeer · Post by **JandeBeer** » Fri Dec 01, 2006 12:36 am

I get this messsage in the log when running an old job designed using oracle 7 plugin the job aborts. Please help

kumar_s · Post by **kumar_s** » Fri Dec 01, 2006 2:03 am

Welcome Aboard :D !!!

Was it a new server/ installaion? Where you able to see the stages in designer? If it was the existing and the same server where the code been developed, check if any change in permission one user id and the filesystem been changed.

ArndW · Post by **ArndW** » Fri Dec 01, 2006 2:24 am

What version is your current Oracle?

JandeBeer · Post by **JandeBeer** » Fri Dec 01, 2006 3:02 am

No . What happened is we had a virus and datastage was acting strangly so we cleaned the machine uninstalled datastage and re-installed it. After importing the datastage jobs the problem started.
All the other jobs are working well we have client oracle 8 installed on the machine.

JandeBeer · Post by **JandeBeer** » Fri Dec 01, 2006 3:09 am

Kumar I initialy saw a wall plug that was'nt plugged in after regestring all the plugins I can see a oracle 7 icon bot no grid/table/database detail.

chulett · Post by **chulett** » Fri Dec 01, 2006 8:11 am

JandeBeer wrote:All the other jobs are working well we have client oracle 8 installed on the machine.

Sounds like you used to have an Oracle 7 client installed as well, and it no longer exists after you 'cleaned' the pc. Can you reinstall the 7 client? Or perhaps covert the jobs to use a different stage? I'm assuming you are talking about the 'Oracle 7 Load' stage...

kumar_s · Post by **kumar_s** » Sun Dec 03, 2006 5:53 pm

Perhaps you can try to reinstall the plugings using dspackinst in $DSHOME/bin.