SAPDBA gives error Unable to find library 'libclntsh.sl.8.0'

[Former Member]

Hello All,

I brought up a new QAS system by copying oracle and sap executables, followed by restore from online backup.

i followed the post described below:

The oracle DB is up and running and sap is also up.

When i try to execute sapdba,logged in as both SID<adm> and ora<SID>

I get the follwoing error:

<b>/usr/lib/pa20_64/dld.sl: Unable to find library 'libclntsh.sl.8.0'.

Segmentation fault</b>

other tools like svrmgrl and sqlplus works fine.

Upon investigation i found that, i did not copy /oracle/client and that is causing this error.

I copied the following /oracle directories

/oracle/SID

/oracle/version_number

/oracle/stage

I did not copy the following directories

/oracle/client

/oracle/oraInventory

/oracle/jre

/oracle/oui

Since the system is up and running already , is it ok for me to copy the left out directories now? Also are they all needed essentially or just /oracle/client is enough.

Please help me as this is very urgent task. Any help with be greatly appreciated with points.

Thanks,

Basis learner

[Former Member]

593582 - SAP Note answered the question.

[Former Member]

Stop your SAP system and install oracle client socftware under /oracle/client/<db>

eg /oracle/client/10x_64 and restart the system. also check the enviornmnet variables like SHLIB_PATH /LD_LIBRARY_PATH. whats your SAP version? sapdba dosent work with new release

thanks

Prince Jsoe

[Former Member]

Hello Prince,

I followed your guidelines to build this QA system. Thanks a lot for that. Copied the executables of oracle and sap and restored from online backup.

The System is up and running. Only sapdba command is giving the error message.

I copied the oracle executable from PRD to QAS and i didnot install from scratch.

The SAP version is 4.6B running on Oracle 8.1.7.4 over HP-UX11i

My concern if i bring down both SAP and DB and copy over the /oracle/Client directory from PRD to QAS , will it cause any issue in bringing the system backup?

also this error from sapdba, is it caused due to missing /client directory only?

Oracle Metalink says:

Stop the instance and listener and then recreate LIBCLNTSH.SL.8.0:

1. %cd $OH/bin

2. %genclntsh64

Then relink : relink utilities

But this fix is for the symptom:

<b>symptom: Running SQLLDR gives error</b>

In My case, the symptom is Running sapdba gives this error

what will be the impact if i do so now? any directions will be greatly appreciated.

Please guide.

Thanks in Advance,

Basis Learner