Oracle and Connector not working in 8.1 after migration

[prashantdogra50@gmail.com]

Hi Guys,

1) I am facing a very strange issue and its driving me nuts. We are migrating from 7.5 to 8.1 .The Oracle stages that were working fine in 7.5 are not able to make connection in 8.1. However if i make a serevrjob, the oracle stage is working fine. In case of parrallel job, it fails saying:- Bad Oracle Environment". Not sure why its working fine in server job.

I tried with connector stage also but it is also failing with error:-
The OCI function OraOCIEnvNlsCreate:OCI_UTF16ID returned status -1. Error code: NULL, Error message: NULL. (CC_OraConnection::allocateOCIHandles, file CC_OraConnection.cpp, line 1732)


NLS is disabled for my project.

Will appreciate any help on this.

Thanks
Prashant

[ray.wurlod]

Welcome aboard. Look in the "environment variables" event in the job log to ensure that your Oracle environment variables are correctly set for the user running the job.

[prashantdogra50@gmail.com]

Thanks ray.

I have checked that. Its all correct. And same is able to make connection in server job. I tried by harcoding the parameters too.

[prashantdogra50@gmail.com]

Any Suggestiom guys..?

[prashantdogra50@gmail.com]

ITS resolved. -- Just for information fo others... its was a permission issue. The datastage client user was not given perimission to oracle lib.

[chulett]

Thank you for posting your resolution.