I would bet that the LD_LIBRARY_PATH needs to point to DataStage first. This path is usually pointing to Oracle first. The order is important. It usually is set in dsenv.
We are using HP-UX B.11.11 as the server. Hence I think there is no problem with the variable as such, but is th path setting OK?
Also the file (on which there is an erro) is there in the DS lib directory, but the error still persists. Do I have to change the order of libraries, viz. put Oracle path first?
SHLIB_PATH is correct for HP/UX, it's what we run here. You need to make a small correction to your settings as you seem to have the classic problem of pointing to the 64bit Oracle libraries rather than the 32bit libraries first. Try it like this:
(I put some returns in to keep it from becoming one long line, you'll need to take them back out if you cut-and-paste this)
Tack all the new information on the front of the current SHLIB_PATH by mentioning it last. Ditch the hard-coded Oracle information and stick with the $ORACLE_HOME you should have set above this in the file. I don't believe you need the 'rdbms' libs, but you do need to have the 'lib32' one first. This is what ours looks like running 7.0.1 on HP/UX 11.11. I had to change it slightly on our 7.5 test server but that's a whole 'nuther story.
Make that change, restart the server and let us know what happens.
-craig
"You can never have too many knives" -- Logan Nine Fingers