Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

call sqlplus fails under oracle user

SOLVED
Go to solution
Kalin Evtimov
Regular Advisor

call sqlplus fails under oracle user

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!
4 REPLIES
Steven E. Protter
Exalted Contributor
Solution

Re: call sqlplus fails under oracle user

Shalom,

Also check the PATH variable and permissions on binaries.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Rasheed Tamton
Honored Contributor

Re: call sqlplus fails under oracle user

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
Honored Contributor

Re: call sqlplus fails under oracle user

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
Regular Advisor

Re: call sqlplus fails under oracle user

That helped, it works now!

Thank you!