Hi,
Server OS - Linux
Initially got the error "orchoracle" not found in the default path i.e. LD_LIBRARY_PATH. After reading posts on similar thread, I added the path home/dsadm/Ascential/DataStage/PXEngine/lib to dsenv. Then I found that there was no orchoracle.so but there were
orchoracle9i.so ->liborchoracle9ii686.so
orchoracle10g.so->liborchoracle10gi.so
Therefore, I made another link
$cd Ascential/DataStage/PXEngine/lib
$ln -s liborchoracle9ii686.so orchoracle.so
and deleted the orchoracle9i.so
but now I get a different error main_program:
Error loading "orchoracle": Could not load "orchoracle": libclntsh.so.9.0: cannot open shared object file: 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
Can anybody help me.
Thanks,
orchoracle not found
Moderators: chulett, rschirm, roy
orchoracle not found
Lalitha
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ray and Eric,
Thanks for your suggestions.
The problem was that the oracle path was missed in the dsenv. I added that to dsenv and got rid of the orchoracle error, but I have a new error
Location_table: connect failed for env: cats, user: train1, password: *****
Oracle error: -12705
ORA-12705: invalid or unknown NLS parameter value specified
where Location_table is the name of the Oracle Stage and cats is the server name and train1 is the user name...These were working fine till we upgraded the OS. After upgardation, we re-installed the DS and I am having many stumble blocks. Help is appreciated.
Thanks,
Thanks for your suggestions.
The problem was that the oracle path was missed in the dsenv. I added that to dsenv and got rid of the orchoracle error, but I have a new error
Location_table: connect failed for env: cats, user: train1, password: *****
Oracle error: -12705
ORA-12705: invalid or unknown NLS parameter value specified
where Location_table is the name of the Oracle Stage and cats is the server name and train1 is the user name...These were working fine till we upgraded the OS. After upgardation, we re-installed the DS and I am having many stumble blocks. Help is appreciated.
Thanks,
Lalitha
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Again it's an Oracle error not a DataStage error, though probably another missing environment variable such as LANG or NLS_LANG. Make sure these are set in dsenv file.
At the operating system prompt on the server execute the command oerr ORA 12705 - it might reveal additional information.
At the operating system prompt on the server execute the command oerr ORA 12705 - it might reveal additional information.
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.
Thanks Again Ray and Eric!!!
I have a doubt here, While installing the plug-ins, We did not install the NLS character set. But, I chose English as the language. Later on reading the document, found that if you choose English then you need to install NLS. So, I guess I have to install NLS.
The Oracle database has NLS_LANG=American_America.AL32UTF8.
After I install the NLS plugin, I have to add it to the dsenv and I think I will be fine from there...what say you gurus???:roll: Have to wait till trow as I dont know the root password.
Thanks,
Lalitha
I have a doubt here, While installing the plug-ins, We did not install the NLS character set. But, I chose English as the language. Later on reading the document, found that if you choose English then you need to install NLS. So, I guess I have to install NLS.
The Oracle database has NLS_LANG=American_America.AL32UTF8.
After I install the NLS plugin, I have to add it to the dsenv and I think I will be fine from there...what say you gurus???:roll: Have to wait till trow as I dont know the root password.
Thanks,
Lalitha
Lalitha