I don't know if this issue came for discussion in this forum, my search resulted in different topics.
We recently installed DS7.5.1 on a new HPUX server as our current current server which holds DEV, SIT, UAT, PROD and 10 other projects became more conjested. Our target Db is Oracle10g. Our old box has Oracle 9i client and DS was installed without NLS. For some reason, they installed NLS on the new box and Oracle10g client along with it.
Today I tried run a server job(using oracle OCI stage) and a paralel job (using oracle ent stage) to test oracle read and it failed with the following error for parallel job:
Code: Select all
Ora_TABLEX: connect failed for env: abcd, user: xyz, password: *****
Oracle error: -12154
Error while trying to retrieve text for error ORA-12154
Code: Select all
Error while trying to retrieve text for error ORA-12154
I checked the ORACLE_HOME and TNS_ADMIN variable values and every thing was good. Initially we used to get an error "unable to load driver libclntsh.so.9.0"(Not the exact error msg). We then created a soft link
Code: Select all
libclntsh.so.9.0 -> $ORACLE_HOME/lib/libclntsh.so.10.1
I have one more question:
Does Oracle 10g client work with DS 7.5.1? Or do we need to have 9i client installed to access Oracle 10g server?
Thanks in advance!!