SQLPLUS-->> libhasgen10.so not found

[Former Member]

I'm getting below error after system rebuild with new sid on a sandbox system.

When I login as SIDADM I'm getting following error, but using ORASID it is fine.

Enter user-name:

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

ERROR:

ORA-12547: TNS:lost contact

Please advice.

Thanks

Maddy

[stefan_koehler · Accepted solution]

Hello Maddy,

have you just copied the Oracle binaries from another installation with a different SID? If yes - you need to relink your oracle binaries. If no - you need to check your environment variables (especially SHLIB_PATH or LD_LIBRARY_PATH).

Regards

Stefan

[Former Member · Accepted solution]

SHLIB_PATH is fine and I did compared with other systems.

I think relink all had thrown some errors last time. I might do it but can I do it when the DB is running as ORASID?

Thanks

Maddy.

[Former Member · Accepted solution]

Partially you were right, this is what I did to get rid off the issue:

1. Shutdown SAP and DB including Listener (I haven';t did this before)

2. As ORASID --> CD $ORACLE_HOME/bin

3. relink all

4. analyzed the errors and solved one after the other

5. Bring up the System and tested the ldd oracle using SIDADM it worked

Thanks

Maddy

[Former Member]

pasted above

[volker_borowski2]

Hi,

just some data for us ?

OS Version ?

Oracle Version and Patch level ?

SAP Version and kernel type (i.E. 6.40 EX4 or 7.01 or ...)?

su - sidadm

env

su - orasid

env

Volker

[Former Member]

just some data for us ?

OS Version ? HP UX 11.23

Oracle Version and Patch level ? 10,2,0,2

SAP Version and kernel type (i.E. 6.40 EX4 or 7.01 or ...)? 7

su - sidadm

env

HOME=/home/dv3adm

PATH=/oracle/DV3/102_64/bin:.:/home/dv3adm:/usr/sap/DV3/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/sas/bin:/opt/wbem/bin:/opt/wbem/sbin:/usr/bin/X11:/opt/resmon/bin:/opt/perf/bin:/usr/contrib/kwdb/bin:/opt/graphics/common/bin:/opt/prm/bin:/opt/sfm/bin:/opt/hpsmh/bin:/opt/upgrade/bin:/opt/sec_mgmt/bastille/bin:/opt/drd/bin:/opt/dsau/bin:/opt/dsau/sbin:/opt/firefox:/opt/gnome/bin:/opt/ignite/bin:/opt/mozilla:/opt/perl_32/bin:/opt/perl_64/bin:/opt/sec_mgmt/spc/bin:/opt/ssh/bin:/opt/swa/bin:/opt/thunderbird:/opt/gwlm/bin:/usr/contrib/bin/X11:/opt/hpvm/bin:/opt/hpnpl//bin

LOGNAME=dv3adm

SHELL=/usr/bin/csh

TERM=ansi

COLUMNS=179

LINES=56

MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/VRTS/vxfs4.1/man:/opt/ldapux/share/man:/opt/ldapux/ypldapd/man:/opt/ipf/man:/opt/cifsclient/share/man:/opt/openssl/man:/opt/openssl/prngd/man:/opt/wbem/share/man:/opt/amgr/man:/opt/amgr/man/%L:/usr/dt/share/man:/opt/samba/man:/opt/samba/WTEC_Support_Tools/man:/opt/resmon/share/man/%L:/opt/resmon/share/man:/opt/perf/man/%L:/opt/perf/man:/opt/VRTS/man:/opt/graphics/common/man:/opt/prm/man/%L:/opt/prm/man:/opt/sfmdb/pgsql/man:/opt/sfm/share/man:/opt/sec_mgmt/share/man:/opt/drd/share/man/%L:/opt/drd/share/man:/opt/dsau/man:/opt/gnome/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/perl_32/man:/opt/perl_64/man:/opt/sec_mgmt/share/man/%L:/opt/ssh/share/man:/opt/swa/share/man/%L:/opt/swa/share/man:/opt/gwlm/man/%L:/opt/gwlm/man:/opt/hpvm/man/%L:/opt/hpnpl//man

TZ=CST6CDT

SAPSYSTEMNAME=DV3

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

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

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=DV3

dbs_ora_schema=SAPERP

ORACLE_SID=DV3

DB_SID=DV3

ORACLE_BASE=/oracle

TNS_ADMIN=/usr/sap/DV3/SYS/profile/oracle

ORACLE_HOME=/oracle/DV3/102_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/DV3

su - orasid

env

HOME=/oracle/DV3

PATH=/oracle/DV3/102_64/bin:.:/oracle/DV3:/usr/sap/DV3/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/sas/bin:/opt/wbem/bin:/opt/wbem/sbin:/usr/bin/X11:/opt/resmon/bin:/opt/perf/bin:/usr/contrib/kwdb/bin:/opt/graphics/common/bin:/opt/prm/bin:/opt/sfm/bin:/opt/hpsmh/bin:/opt/upgrade/bin:/opt/sec_mgmt/bastille/bin:/opt/drd/bin:/opt/dsau/bin:/opt/dsau/sbin:/opt/firefox:/opt/gnome/bin:/opt/ignite/bin:/opt/mozilla:/opt/perl_32/bin:/opt/perl_64/bin:/opt/sec_mgmt/spc/bin:/opt/ssh/bin:/opt/swa/bin:/opt/thunderbird:/opt/gwlm/bin:/usr/contrib/bin/X11:/opt/hpvm/bin:/opt/hpnpl//bin

LOGNAME=oradv3

SHELL=/usr/bin/csh

TERM=ansi

COLUMNS=179

LINES=56

MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/VRTS/vxfs4.1/man:/opt/ldapux/share/man:/opt/ldapux/ypldapd/man:/opt/ipf/man:/opt/cifsclient/share/man:/opt/openssl/man:/opt/openssl/prngd/man:/opt/wbem/share/man:/opt/amgr/man:/opt/amgr/man/%L:/usr/dt/share/man:/opt/samba/man:/opt/samba/WTEC_Support_Tools/man:/opt/resmon/share/man/%L:/opt/resmon/share/man:/opt/perf/man/%L:/opt/perf/man:/opt/VRTS/man:/opt/graphics/common/man:/opt/prm/man/%L:/opt/prm/man:/opt/sfmdb/pgsql/man:/opt/sfm/share/man:/opt/sec_mgmt/share/man:/opt/drd/share/man/%L:/opt/drd/share/man:/opt/dsau/man:/opt/gnome/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/perl_32/man:/opt/perl_64/man:/opt/sec_mgmt/share/man/%L:/opt/ssh/share/man:/opt/swa/share/man/%L:/opt/swa/share/man:/opt/gwlm/man/%L:/opt/gwlm/man:/opt/hpvm/man/%L:/opt/hpnpl//man

TZ=CST6CDT

SAPSYSTEMNAME=DV3

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

SHLIB_PATH=/usr/sap/DV3/SYS/exe/run:/oracle/DV3/102_64/lib

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=DV3

dbs_ora_schema=SAPERP

ORACLE_SID=DV3

DB_SID=DV3

ORACLE_BASE=/oracle

ORACLE_HOME=/oracle/DV3/102_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/DV3

Thanks

Maddy