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

[Former Member]

Hi,

Can you please help me on this, I tried all the ways which i know, am unable to solve the problem.

Preblem Description: From sidadm user am uable to login sqlplus prompth, due to this am unable install java on it.

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

I tried resetting permissions.

checked host file entry,

checked groups,

checked oratab,

checked permission on oracle home and for brtools also...

please help me how to solve this problem..... it is connecting from orasid user, not connecting from sidadm user. sapinst is looking sidadm to install java..

Please help me..

[former_member227283 · Accepted solution]

Hi Sravan,

phgp0197(dv2d12) z11adm /sapmnt/Z11/exe %> sqlplus "/as sysdba"
/usr/lib/hpux64/dld.so: Unable to find library 'libsqlplus.so'.
Killed

if you have sap system in landscape with same version , pls do the following steps.

1. take backup of file 'libsqlplus.so'

2. get a file 'libsqlplus.so' from other system and replace with the existing file i.e on the system where you are getting error.

3. check the permission.

then try to login with sqlplus.

Thanks

Anil

[Former Member · Accepted solution]

Thank you Anil,

ftp> cd /oracle/D12/102_64/lib

250 CWD command successful.

ftp> dir libsqlplus*

200 PORT command successful.

150 Opening ASCII mode data connection for /usr/bin/ls.

-rw-rr 1 orad12 dba 3467774 Feb 27 2008 libsqlplus.a

-r-xr-xr-x 1 orad12 dba 1744632 Feb 27 2008 libsqlplus.so

226 Transfer complete.

ftp> get libsqlplus.so

200 PORT command successful.

150 Opening BINARY mode data connection for libsqlplus.so (1744632 bytes).

226 Transfer complete.

Presently its having same permission as in source, do i need to change pemissions on this ....?,

phgp0197:oraz11 10> ll libsqlplus.so

-rw-rr 1 oraz11 dba 1744632 Jan 13 22:18 libsqlplus.so

Thanks,

Sravan

[Former Member · Accepted solution]

Have you tried the below workarround ?

It solved my problem, in the past... Hope, will work for you also...

Hi,

its seems somehow permissions has been changed on ORACLE_HOME...

just try to execute the following script, which will fix any permissions issues on ORACLE_HOME...

(As recommeded by ORACLE... ORACLE installer use this script to set the permissions on ORACLE_HOME)

/oracle/SID/102_64/install/changePerm.sh

then post the result...

In case of any problem, make sure that the following directory has proper permissions/ownership

1. ll -ld /oracle/<SID>/102_64/sqlplus/mesg

drwxr-x--- 2 ora<sid> dba 1024 Oct 28 15:12 /oracle/<SID>/102_64/sqlplus/mesg

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Thank you rajesh,

Please find above details,

do i need to change permissions for mesg dir..... if so what are the permissions I have to give, is it 644 or 755 permi?

Thanks,

Sravan

[Former Member · Accepted solution]

Hi,

permission should be 755 for "mesg" directory... inside it, it has different permissions...

see below for your reference..

#oracle/<SID>/102_64/sqlplus/mesg # ls -l
total 386
-rw-r--r--   1 orasid     dba           4096 Feb 27  2008 cpyus.msb
-rw-r-----   1 orasid     dba           4369 Jun 17  2005 cpyus.msg
-rw-r--r--   1 orasid     dba          11776 Feb 27  2008 sp1us.msb
-rw-r-----   1 orasid     dba          17273 Jun 17  2005 sp1us.msg
-rw-r--r--   1 orasid     dba          31744 Feb 27  2008 sp2us.msb
-rw-r-----   1 orasid     dba         126498 Jun 17  2005 sp2us.msg

check onemore thing...

check if SIDADM and ORASID are member of dba group

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Thank you very much Rajesh,

phgp0197:oraz11 4> cd 102_64/sqlplus/mesg

phgp0197:oraz11 5> ls -l

total 386

-rwxrwxr-x 1 oraz11 dba 4096 Feb 27 2008 cpyus.msb

-rwxrwxr-x 1 oraz11 dba 4369 Jun 17 2005 cpyus.msg

-rwxrwxr-x 1 oraz11 dba 11776 Feb 27 2008 sp1us.msb

-rwxrwxr-x 1 oraz11 dba 17273 Jun 17 2005 sp1us.msg

-rwxrwxr-x 1 oraz11 dba 31744 Feb 27 2008 sp2us.msb

-rwxrwxr-x 1 oraz11 dba 126498 Jun 17 2005 sp2us.msg

phgp0197:oraz11 6> chmod 644 cpyus.msb sp1us.msb sp2us.msb

phgp0197:oraz11 7> ls -l

total 386

-rw-rr 1 oraz11 dba 4096 Feb 27 2008 cpyus.msb

-rwxrwxr-x 1 oraz11 dba 4369 Jun 17 2005 cpyus.msg

-rw-rr 1 oraz11 dba 11776 Feb 27 2008 sp1us.msb

-rwxrwxr-x 1 oraz11 dba 17273 Jun 17 2005 sp1us.msg

-rw-rr 1 oraz11 dba 31744 Feb 27 2008 sp2us.msb

-rwxrwxr-x 1 oraz11 dba 126498 Jun 17 2005 sp2us.msg

phgp0197:oraz11 8> chmod 640 cpyus.msg sp1us.msg sp2us.msg

phgp0197:oraz11 9> ls -l

total 386

-rw-rr 1 oraz11 dba 4096 Feb 27 2008 cpyus.msb

-rw-r----- 1 oraz11 dba 4369 Jun 17 2005 cpyus.msg

-rw-rr 1 oraz11 dba 11776 Feb 27 2008 sp1us.msb

-rw-r----- 1 oraz11 dba 17273 Jun 17 2005 sp1us.msg

-rw-rr 1 oraz11 dba 31744 Feb 27 2008 sp2us.msb

-rw-r----- 1 oraz11 dba 126498 Jun 17 2005 sp2us.msg

phgp0197:oraz11 10>

mesg dir is having 755 permissions only....

phgp0197:oraz11 17> ls -ld mesg

drwxr-xr-x 2 oraz11 dba 1024 May 29 2006 mesg

phgp0197:oraz11 18> pwd

/oracle/Z11/102_64/sqlplus

phgp0197:oraz11 19>

I have changed required permissions, still not working, no idea why its happening... strange problem...:(

Thanks,

Sravan

[Former Member · Accepted solution]

Have you checked the group membership as I said earlier...

Rajesh

[Former Member · Accepted solution]

Yes Rajesh,

I have checked it, everything is good in group.

phgp0197:z11adm 22> id

uid=13109(z11adm) gid=12003(sapsys) groups=12005(dba),12009(oper),12016(sapinst)

phgp0197:z11adm 23>

Thank you

Sravan

[Former Member · Accepted solution]

Hi,

Then finally you can do onething, please relink all oracle binaries ..

$ORACLE_HOME/bin/relink all;

can you tell us, how the problem occurs suddenly, I mean what went wrong now...

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Thats Awesome Rajesh,

Its working now, might be there is problem with links, now it is connecting,

Thank you very much,

Thanks a lot,

Actually I was doing system copy, after rename process, doing java installation at the JAVA DB installation we strucked up,

Thanks buddy, Thank you very much..

Thanks,

Sravan

[Former Member · Accepted solution]

Glad to know that you came out from the hell...

just keep helping other...

cheers..

Rajesh Narkhede

[Former Member · Accepted solution]

Sure, Thank you very much....

Thanks,

Sravan

[Former Member · Accepted solution]

Hi Rajesh,

Thank's for this.

"/$ORACLE_HOME/bin/relink all" executed by oraSID save me in the same issue after a system copy and a rename instance :

     oraSID was able to execute sqlplus but SIDadm not, with same message as Sravan

after relink, it's ok. So just to tell : This work in 11g too

Hervé

[Former Member]

Hello Sravan,

i have faced similar issue in our landscape major things you have to identified are follows:

1) Check the oracle client either is points to correct one where your environment variable are:

export SHLIB_PATH =/usr/sap/SID/SYS/exe/run:/oracle/client/10x_64/instantclient---> Oracle 10g

export SHLIB_PATH =/usr/sap/SID/SYS/exe/run:/oracle/client/11x_64/instantclient---> Oracle 11g

2) Make sure the soft links are in place compare with any other where brstats is running, paths you have to concentrate as follows:

/oracle/client/11x_64/instantclient/

/oracle/SID/112_64/lib/

/usr/lib/hpux64/

3) Copy the files (libclntsh.so.10.1 and libnnz10.so) from  /oracle/client/11x_64/instantclient_11202 to /usr/lib/hpux64 and keep the 755 permission and keep owner and group as bin.

Please let me know if you are still facing the same issue.

Thanks & Regards,

Mohammed Rafi.

[former_member227283]

Hi,

after replacing the file , compare the permision of source and target system , it should be same.

let to execute the command and let us know the output.

Thanks

Anil

[former_member227283]

Hi,

pls paste the enviromet varible present for user sidadm.

Tha nks

Anil

[Former Member]

Thank you very much Anil,

This is the environment for SIDADM,

phgp0197:z11adm 21> env

HOME=/home/z11adm

PATH=/oracle/Z11/102_64/bin:.:/home/z11adm:/usr/sap/Z11/SYS/exe/run:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/opt/ipf/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/fcms/bin:/opt/sec_mgmt/bastille/bin:/opt/resmon/bin:/opt/gnome/bin:/opt/perf/bin:/usr/bin/X11:/usr/contrib/kwdb/bin:/opt/mozilla:/opt/wbem/bin:/opt/wbem/sbin:/opt/graphics/common/bin:/opt/mx/bin:/opt/prm/bin:/opt/sec_mgmt/spc/bin:/opt/upgrade/bin:/opt/ignite/bin:/opt/cfg2html:/opt/langtools/bin:/usr/sbin:/opt/hpnpl//bin:/opt/java1.4/bin:/opt/omni/bin:/opt/dsau/bin:/opt/dsau/sbin:/usr/contrib/bin/X11:/usr/storapi/bin:/opt/sfm/bin:/opt/hpsmh/bin:/opt/ssh/bin

LOGNAME=z11adm

SHELL=/usr/bin/csh

TERM=vt100

COLUMNS=156

LINES=52

MANPATH=/opt/ipf/man:/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/mx/share/man:/opt/sec_mgmt/share/man:/usr/dt/share/man:/opt/gnome/man:/opt/perf/man/%L:/opt/perf/man:/opt/openssl/man:/opt/openssl/prngd/man:/opt/wbem/share/man:/opt/graphics/common/man:/opt/perl/man:/opt/prm/man/%L:/opt/prm/man:/opt/sec_mgmt/share/man/%L:/opt/ssh/share/man:/opt/VRTS/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/ansic/share/man/%L:/opt/ansic/share/man:/opt/langtools/share/man/%L:/opt/langtools/share/man:/opt/hpnpl//man:/opt/audio/share/man:/opt/image/share/man:/opt/imake/man:/opt/omni/lib/man:/opt/EMCpower/share:/opt/dsau/man:/opt/resmon/share/man/%L:/opt/resmon/share/man:/opt/sfm/share/man:/opt/sfmdb/pgsql/man

TZ=CST6CDT

SAPSYSTEMNAME=Z11

DIR_LIBRARY=/usr/sap/Z11/SYS/exe/run

SHLIB_PATH=/usr/sap/Z11/SYS/exe/run:/oracle/client/10x_64/instantclient

JAVA_HOME=/opt/java1.4

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=Z11

dbs_ora_schema=SAPDAT

ORACLE_SID=Z11

DB_SID=Z11

ORACLE_HOME=/oracle/Z11/102_64

ORACLE_BASE=/oracle

TNS_ADMIN=/oracle/Z11/102_64/network/admin

ADD=/oracle/client/10x_64/instantclient

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/Z11

phgp0197:z11adm 22>

Thanks,

Sravan

[Former Member]

Is user <sid>adm a member of group dba ?

(You may use command id to find out.)

[Former Member]

Hi Anil,

phgp0197:z11adm 22> id

uid=13109(z11adm) gid=12003(sapsys) groups=12005(dba),12009(oper),12016(sapinst)

phgp0197:z11adm 23>

Thanks,

Sravan

[Former Member]

Thank you Joe Bo,

Please find below details,

phgp0197:z11adm 22> id

uid=13109(z11adm) gid=12003(sapsys) groups=12005(dba),12009(oper),12016(sapinst)

phgp0197:z11adm 23>

thanks,

Sravan

[Former Member]

Check whether there is a file /oracle/<SID>/102_64/lib/libsqlplus.so

and make sure it is readable by <sid>adm.

[Former Member]

Thank you very much Joe,

the file is there.

phgp0197:oraz11 7> pwd

/oracle/Z11/102_64/lib

phgp0197:oraz11 8> ll libsqlplus*

-rwxr-xr-x 1 oraz11 dba 3467774 Feb 27 2008 libsqlplus.a

-rwxr-xr-x 1 oraz11 dba 1744632 Jan 10 01:58 libsqlplus.so

phgp0197:oraz11 9>

Thanks,

Sravan

[Former Member]

Looks good.

One more thing to check:

what is the output of:

ls -ld /oracle/Z11/102_64/lib

[Former Member]

Thank you Joe,

phgp0197:oraz11 13> ls -ld /oracle/Z11/102_64/lib

drwxr-xr-x 4 oraz11 dba 6144 Jan 13 03:32 /oracle/Z11/102_64/lib

phgp0197:oraz11 14>

Thanks,

Sravan

[Former Member]

One more similar question:

You wrote you already checked files im mesg directory,

as suggested in the link provided by Anil above.

Did you also check the output of:

ls -ld /oracle/Z11/102_64/mesg

[Former Member]

thanks Joe,

phgp0197:z11adm 21> ls -ld /oracle/Z11/102_64/mesg

drwxr-xr-x 2 oraz11 dba 96 May 29 2006 /oracle/Z11/102_64/mesg

phgp0197:z11adm 22>

Thanks,

Sravan

[Former Member]

very strange....

One more try, just to make sure.

Please try this as user z11adm:

file $ORACLE_HOME/lib/libsqlplus.so

And do you still get the error message from your first post?

Or has something changed in the meantime?

[ImtiazKaredia]

Hi,

As <sid>adm, go to /sapmnt/<SID>/exe

then give command

ldd dboraslib.so

and paste the output.

[Former Member]

Thank you Joe,

I have not changed anything from starting.

phgp0197(dv2d12) z11adm[ /home/z11adm ]%> file $ORACLE_HOME/lib/libsqlplus.so

/oracle/Z11/102_64/lib/libsqlplus.so: ELF-64 shared object file - IA64

phgp0197(dv2d12) z11adm[ /home/z11adm ]%>

Thanks,

Sravan

[Former Member]

Thank you very much Imtiaz,

phgp0197:z11adm 21> cd /sapmnt/Z11/exe

phgp0197(dv2d12) z11adm[ /sapmnt/Z11/exe ]%> ldd dboraslib.so

libnsl.so.1 => /usr/lib/hpux64/libnsl.so.1

libpthread.so.1 => /usr/lib/hpux64/libpthread.so.1

libclntsh.so.10.1 => /oracle/client/10x_64/instantclient/libclntsh.so.10.1

libnnz10.so => /oracle/client/10x_64/instantclient/libnnz10.so

libc.so.1 => /usr/lib/hpux64/libc.so.1

libxti.so.1 => /usr/lib/hpux64/libxti.so.1

libnnz10.so => /oracle/client/10x_64/instantclient/libnnz10.so

librt.so.1 => /usr/lib/hpux64/librt.so.1

libnss_dns.so.1 => /usr/lib/hpux64/libnss_dns.so.1

libdl.so.1 => /usr/lib/hpux64/libdl.so.1

libm.so.1 => /usr/lib/hpux64/libm.so.1

libpthread.so.1 => /usr/lib/hpux64/libpthread.so.1

libunwind.so.1 => /usr/lib/hpux64/libunwind.so.1

libnsl.so.1 => /usr/lib/hpux64/libnsl.so.1

libdl.so.1 => /usr/lib/hpux64/libdl.so.1

libuca.so.1 => /usr/lib/hpux64/libuca.so.1

phgp0197(dv2d12) z11adm[ /sapmnt/Z11/exe ]%>

Thanks,

Sravan

[Former Member]

Hi,

Can you check the environment variable below ? for orasid and sidadm both.

# echo $SHLIB_PATH
/usr/sap/SID/SYS/exe/run:/oracle/SID/102_64/lib

($SHLIB_PATH for HPUX and $LD_LIBRARY_PATH for Linux)

There may be some problem in environment variable settings.

Regards.

Rajesh Narkhede

[Former Member]

Thank you Rajesh,

I tried that one, i have checked SIDADM env files there is no problem, even i have checked other systems env alo evrything looks same..

phgp0197(dv2d12) z11adm[ /sapmnt/Z11/exe ]%> echo $SHLIB_PATH /usr/sap/Z11/SYS/exe/run:/oracle/Z11/102_64/lib

/usr/sap/Z11/SYS/exe/run:/oracle/client/10x_64/instantclient /usr/sap/Z11/SYS/exe/run:/oracle/Z11/102_64/lib

phgp0197(dv2d12) z11adm[ /sapmnt/Z11/exe ]%> sqlplus "/as sysdba"

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

Killed

phgp0197(dv2d12) z11adm[ /sapmnt/Z11/exe ]%>

Thanks,

Sravan

[Former Member]

Hi,

its seems somehow permissions has been changed on ORACLE_HOME...

just try to execute the following script, which will fix any permissions issues on ORACLE_HOME...

(As recommeded by ORACLE... ORACLE installer use this script to set the permissions on ORACLE_HOME)

/oracle/SID/102_64/install/changePerm.sh

then post the result...

In case of any problem, make sure that the following directory has proper permissions/ownership

# ll -ld /oracle/<SID>/102_64/sqlplus/mesg
drwxr-x---   2 ora<sid>     dba           1024 Oct 28 15:12 /oracle/<SID>/102_64/sqlplus/mesg

Regards.

Rajesh Narkhede

[Former Member]

Thank you,

i ran the script,

Please find details,

phgp0197:oraz11 1> cd /oracle/Z11/102_64/install

phgp0197:oraz11 2> ./changePerm.sh

-

---

Disclaimer: The purpose of this script is to relax permissions on some of the

files in the database Oracle Home so that all clients can access them.

Please note that Oracle Corporation recommends using the most restrictive file

permissions as possible for your given implementation. Running this script

should be done only after considering all security ramifications.

-

---

-n Do you wish to continue (y/n) [n]:

y

Spooling the error log /tmp/changePerm_err.log...

Finished running the script successfully

phgp0197:oraz11 3> ls -ld /oracle/Z11/102_64/mesg

drwxr-xr-x 2 oraz11 dba 96 May 29 2006 /oracle/Z11/102_64/mesg

phgp0197:z11adm 22> ls -ld /oracle/Z11/102_64/lib

drwxr-xr-x 4 oraz11 dba 6144 Jan 13 22:18 /oracle/Z11/102_64/lib

phgp0197:z11adm 23>

i tried again, same problem coming....

phgp0197:z11adm 21> sqlplus "/as sysdba"

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

Killed

phgp0197:z11adm 22>

thanks,

Sravan,

[former_member227283]

Hi,

Refer to below , same problem faced by one of the conusltant.

Thanks

Anil

[Former Member]

Thanks Anil for prompt reply,

earlier I tried that one also, checked permissions and environment also not worked...

in /oracle/Z11/102_64/sqlplus/mesg, i have given 775 permissions, and tried, still same problem.

pls find below permission info.

-rwxrwxr-x 1 oraz11 dba 4096 Feb 27 2008 cpyus.msb

-rwxrwxr-x 1 oraz11 dba 4369 Jun 17 2005 cpyus.msg

-rwxrwxr-x 1 oraz11 dba 11776 Feb 27 2008 sp1us.msb

-rwxrwxr-x 1 oraz11 dba 17273 Jun 17 2005 sp1us.msg

-rwxrwxr-x 1 oraz11 dba 31744 Feb 27 2008 sp2us.msb

-rwxrwxr-x 1 oraz11 dba 126498 Jun 17 2005 sp2us.msg

Thanks a lot in advance,

Thanks,

Sravan