topic Re: call sqlplus fails under oracle user in Operating System - HP-UX

call sqlplus fails under oracle user

Kalin Evtimov — Mon, 26 Mar 2007 07:51:44 GMT

Servus!

I have a problem, that is new for me: I am trying to run sqlplus on a SAP-Database, called SP1. I am using user oracle and it fails with the message:
Unable to find library 'libhasgen10.so'.
Library exists under /oracle/SP1/102_64/lib.

There is another, special SAP-DB-user, called orasp1, and under orasp1 the sqlplus works perfect. So I compared both Environments and exported LD_LIBRARY_PATH and SHLIB_PATH under oracle, showing the directory above. But that didn't help. I have no more ideas, perhaps you have?

Thanks!

Re: call sqlplus fails under oracle user

Steven E. Protter — Mon, 26 Mar 2007 08:02:12 GMT

Shalom,

Also check the PATH variable and permissions on binaries.

SEP

Re: call sqlplus fails under oracle user

Rasheed Tamton — Mon, 26 Mar 2007 08:03:15 GMT

man ldd
man chatr

do a "ldd" and "chatr" on the missing libray files

ldd - list dynamic dependencies of executable files or shared libraries

chatr - change program's internal attributes

Regards,
Rasheed Tamton.

Re: call sqlplus fails under oracle user

Hein van den Heuvel — Mon, 26 Mar 2007 08:14:20 GMT

It's likely to be an ownership issue, with +s mode prohibiting SHLIB_PATH being used.

Check out:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=713819

It mentions several good things to check.

In that particual case the problem was resolved with a relink all for oracle using ora

Hein.

Re: call sqlplus fails under oracle user

Kalin Evtimov — Mon, 26 Mar 2007 08:40:43 GMT

That helped, it works now!

Thank you!