on 01-05-2008 10:45 AM
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>
Issue has been resolved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
use user ID oraasb instead....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.