topic Re: libraries issue SMC in Administration and Deployment

libraries issue SMC

LalmanVerma — Wed, 01 Nov 2023 11:28:44 GMT

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

Re: libraries issue SMC

sangavis37 — Wed, 01 Nov 2023 12:14:42 GMT

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

Re: libraries issue SMC

LalmanVerma — Wed, 01 Nov 2023 12:16:24 GMT

its a single tier system sas 9.4m6

Re: libraries issue SMC

LalmanVerma — Wed, 01 Nov 2023 12:17:19 GMT

its a single tier system sas 9.4m6

Re: libraries issue SMC

sangavis37 — Wed, 01 Nov 2023 12:30:15 GMT

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

Re: libraries issue SMC

LalmanVerma — Wed, 01 Nov 2023 12:34:20 GMT

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

Re: libraries issue SMC

sangavis37 — Wed, 01 Nov 2023 12:42:52 GMT

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

Re: libraries issue SMC

LalmanVerma — Thu, 02 Nov 2023 06:03:36 GMT

Thaks for your support issue got resolved.

Re: libraries issue SMC

sangavis37 — Thu, 02 Nov 2023 13:10:42 GMT

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.