[DBMS] oracle client install for centos/redhat
[install] libaio-0.3.110-12.el8.x86_64.rpm oracle-instantclient18.5-basic-18.5.0.0.0-3.x86_64.rpm oracle-instantclient18.5-sqlplus-18.5.0.0.0-3.x86_64.rpm --------------------------------------- [error] sqlplus : error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory [cause] 라이브러리가 설정되어져 있지 않음. [solution] # vi /etc/ld.so.conf.d/oracle.conf /usr/lib/oracle/12.1/client64/lib/ # sudo chmod o+r /etc/ld.so.conf.d/oracle.conf # sudo ldconfig ------------------------------------------ [error] sqlplus : error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or directory [cause] # rm -qa | grep libnsl libnsl 2-1.2.0-2.20180605git4a062cf.el8.x86_64 libnsl2가 설치되어져 있고 libnsl1이 없음 [solution] # cd /usr/lib64 # sudo ln -sf libnsl.so.2 libnsl.so.1 libnsl2를 libnsl1으로 링크를 준다. ------------------------------------------ [tnsnames.ora] 원격접속을 위한 설정 # cd $TNS_ADMIN # vi tnsnames.ora...