connect failed --Oracle error: -2127

salil · Post by **salil** » Mon Apr 24, 2006 11:20 pm

I've exporeted a job from my development environment to production.The job which used to run fine in DEV is throwing some error in the production.

The job design is as follows

Ora_TAB1------>TRANSFORMER------>FlatFile

The necessary priveleges are given to the datastage user in Oracle.
The error says:

Ora_TAB1: connect failed for env: SID, user: USER, password: *****
Oracle error: -2127

Help at the earliest truly appreciated,

Thanks in advance

bandish · Post by **bandish** » Tue Apr 25, 2006 12:01 am

Hi,

SQL-02127 Precompiler/SQLLIB version mismatch

Cause: The program was linked to an older version of SQLLIB, which is
incompatible with this release of the Oracle Precompilers.

Action: Relink the program with a newer version of SQLLIB

IHTH

Thanks
Bandish[/b]

kumar_s · Post by **kumar_s** » Tue Apr 25, 2006 12:25 am

Are the environmental varialbe SID and USER been defiend in the new environment?

salil · Post by **salil** » Tue Apr 25, 2006 12:33 am

kumar_s wrote:Are the environmental varialbe SID and USER been defiend in the new environment?

Yes The SID ,USER and PWD are defined well.We are able to import metadata using these credentials,but it gives trouble while View-Data as well as Insert/Update.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 25, 2006 1:11 am

Check that your Oracle client software is at the same version as your Oracle server.
What stage type are you using in your DataStage job?

salil · Post by **salil** » Tue Apr 25, 2006 1:52 am

ray.wurlod wrote:Check that your Oracle client software is at the same version as your Oracle server.
What stage type are you using in your DataStage job?

I'm using Oracle Enterprise stage for the Oracle connection in the Datastage job.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 25, 2006 5:00 pm

DataStage is just another client application as far as Oracle is concerned. Oracle client software must be correctly installed and configured on the machine(s) from which DataStage is to request service from Oracle. This client software must be at an appropriate version for connecting to the Oracle database server.

salil · Post by **salil** » Wed Apr 26, 2006 3:41 am

Hi,
The Oracle client Version is 9.0.1 and Oracle Server Version is 9.2.0.7(64 bit).Could it be a probable reason?

salil · Post by **salil** » Wed Apr 26, 2006 5:14 am

main_program: Error loading "orchoracle": Could not load "orchoracle": ld.so.1: osh: fatal: libclntsh.so: open failed: No such file or directory.
Could not locate operator definition, wrapper, or Unix command for "oraread"; please check that all needed libraries are preloaded, and check the PATH for the wrappers

This is the latest error message I'm getting now.Any idea on what it says??I serached inthe lib and 'libclntsh.so' which is being mentioned is already present there.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 26, 2006 3:48 pm

Libraries are definitely a problem. DataStage is a 32-bit application (except on Itanium) so you need to ensure that the shared library search path that DataStage uses (set up in the dsenv script) has the Oracle 32-bit library directory ahead of the Oracle 64-bit library directory.