libraries issue SMC

[LalmanVerma]

I am able to connect oracle 19c DB through isql but when m going to create library in SMC and trying to register tables m getting below error.

LIBNAME newcore ODBC DATAsrc=ODBC SCHEMA=test USER=dsfrsa PASSWORD=XXXXXXXXX ;
ERROR: CLI error trying to establish connection: [unixODBC][Driver Manager]Can't open lib
'/u01/app/oracle/product/19.0.0/client/lib/libsqora.so.19.1' : file not found
ERROR: Error in the LIBNAME statement.

but  libsqora.so.19.1 file is available as given below.

[root@SVRB5V1 ~]# cd /u01/app/oracle/product/19.0.0/client/lib/
[root@SVRB5V1 lib]# ls -l libsqora.so.19.1
-rwxrwxrwx 1 oracle dba 1070008 Apr 16 2019 libsqora.so.19.1

my ODBC file

[root@SVRB5V1 ~]# cat /etc/odbc.ini
[ODBC]
Driver = /u01/app/oracle/product/19.0.0/client/lib/libsqora.so.19.1
DSN = OracleODBC-19c
ServerName = 192.168.10.109:1521/dashboard
UserID = Sastest
Password = xxxxxxx

[sangavis37]

Do you have multiple compute nodes? If yes, is the file accessible on all of them?

[LalmanVerma]

its a single tier system sas 9.4m6

[LalmanVerma]

its a single tier system sas 9.4m6

[sangavis37]

If you are using unix os, the environment variables might be missing. Check this out
https://documentation.sas.com/doc/en/bicdc/9.4/bidsag/p1w3v98qca3sfzn1rzty2tngrfyq.htm

[LalmanVerma]

this is my env

[root@SVRB5V1 ~]# cat .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

#ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1
#ORACLE_HOME=/u01/app/oracle/product/19.0.0/client
#export ORACLE_HOME
#export LD_LIBRARY_PATH=$ORACLE_HOME/lib
#export PATH=$ORACLE_HOME/bin:$PATH
#export ODBCSYSINI=/etc


PATH=$PATH:$HOME/bin
export PATH
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE
#ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/client
#ORACLE_HOME=$ORACLE_BASE/product/19.0.0/client
ORACLE_HOME=/u01/app/oracle/product/19.0.0/client
export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH
export PATH
PATH=$ORACLE_HOME/bin:$PATH
export PATH
LD_LIBRARY_PATH=/usr/local/lib:$ORACLE_HOME/lib
#LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

[sangavis37]

You should have the environment variables specified in <SASHOME>/SASFoundation/9.4/bin/sasenv_local according to the documentation. Something like below
ODBCINI=/opt/drivers/odbc/odbc.ini
export ODBCINI
ODBCINSTINI=/opt/drivers/odbc/odbcinst.ini
export ODBCINSTINI
ORACLE_HOME=/u01/app/oracle/product/19.0.0/client
export ORACLE_HOME
LD_LIBRARY_PATH=/usr/local/lib:$ORACLE_HOME/lib
export LD_LIBRARY_PATH

Make sure to check the correct path of odbc.ini and odbcinst.ini

[LalmanVerma · Accepted solution]

Thaks for your support issue got resolved.

[sangavis37]

You’re welcome. Was that the solution? If yes, please mark it as solution so that others who have similar issues can make use of it. If not, it would be great if you can share the solution and mark it.