call sqlplus fails under oracle user

[Kalin Evtimov]

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!

[Steven E. Protter · Accepted solution]

Shalom,

Also check the PATH variable and permissions on binaries.

SEP

[Rasheed Tamton]

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.

[Hein van den Heuvel]

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.

[Kalin Evtimov]

That helped, it works now!

Thank you!