cancel
Showing results for 
Search instead for 
Did you mean: 

Error while executing Sqlplus

Former Member
0 Kudos

Hi Friends ,

I am currently using SAP version ECC 6

Database : Oracle 10g release 2

Operating System : HP - UX

Now when I am trying to execute sqlplus from one of the application server with the user asbadm , then I am getting the error as shown below

rueccasb:asbadm 50> pwd

/home/asbadm

rueccasb:asbadm 51> sqlplus /nolog

/usr/lib/hpux64/dld.so: Unable to find library 'libsqlplus.so'.

Killed

rueccasb:asbadm 52>

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Issue has been resolved

former_member204746
Active Contributor
0 Kudos

use user ID oraasb instead....

Former Member
0 Kudos

Hi Stefan ,

Thanks for ur reply.

The database server and application server are same. Can you suggest me the settings so that I am able to execute sqlplus through the user asbadm.

Regards

Gaurav

stefan_koehler
Active Contributor
0 Kudos

Hello Gaurav,

i don't understand why you want that, but the only thing you have to do is to include the oracle library path to the environment of <sid>adm.

It depends on the shell, that you are using:

> export SHLIB_PATH=$SHLIB_PATH:/oracle/<SID>/102_64/lib

> setenv SHLIB_PATH=$SHLIB_PATH:/oracle/<SID>/102_64/lib

or

> export LIBPATH =$LIBPATH :/oracle/<SID>/102_64/lib

> setenv LIBPATH =$LIBPATH :/oracle/<SID>/102_64/lib

I am not sure on HP-UX which environment variable is used, but you can check it with:

> env | grep -i lib

This shows you the variable which you have to extent with "/oracle/<SID>/102_64/lib".

If your <SID>adm user is in the correct os groups (dba) - a "sqlplus / as sysdba" should also work.

Regards

Stefan

stefan_koehler
Active Contributor
0 Kudos

Hello Gaurav

>> Now when I am trying to execute sqlplus from one of the application server with the user asbadm

That's normal.

The user <sid>adm has not set the environment (LIBPATH) for the oracle libraries, which are needed for sqlplus. Sqlplus should only be run as user ora<SID>.

This will also only work if you run sqlplus on the database server or you have mounted the <ORACLE_HOME> directory on your application servers. But please remember a "sqlplus / as sysdba" will not work from your application servers because the database is not running local - you have to go over SQLNET by using "sqlplus SAPR3@<TNS_NAME>".

Regards

Stefan