Tuesday 4 December 2018

Sybase sybctrl: connect to DB fails error

Tags


Symptom

On Linux / Unix sybctrl cannot connect to database.
The error message is similar to:
Could not load SYB library libsybdrvodb.so. No database connection possible.
Other Terms

sybctrl sybxctrl

 
Reason and Prerequisites

If sybctrl has the s-bit set and runs as a setuid program, LD_LIBRARY_PATH will be ignored by operation system for security reasons.
Shared libraries will not to be found and load of odbc driver will fail.
 
Solution

Use sybxctrl which is a copy of sybctrl without the s-bit set.

sybxctrl will be created if the database is stopped using stopsap script or stopdb script.

Otherwise create sybxctrl by executing as user adm:
 
cd /usr/sap//SYS/exe/run
 

cp sybctrl sybxctrl




More details refere Snote : 2719763


EmoticonEmoticon

Note: only a member of this blog may post a comment.