connect failed --Oracle error: -2127
Moderators: chulett, rschirm, roy
connect failed --Oracle error: -2127
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
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
A printer consists of 3 main parts: the case, the jammed paper tray and the blinking red light.
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.kumar_s wrote:Are the environmental varialbe SID and USER been defiend in the new environment?
A printer consists of 3 main parts: the case, the jammed paper tray and the blinking red light.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I'm using Oracle Enterprise stage for the Oracle connection in the Datastage job.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?
A printer consists of 3 main parts: the case, the jammed paper tray and the blinking red light.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
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.
A printer consists of 3 main parts: the case, the jammed paper tray and the blinking red light.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.