라벨이 dbms인 게시물 표시

[DBMS] Tibero5 client install for centos/redhat

  [Install files] $ ls tibero5-bin-5.0-linux64-72034-opt-tested.tar.gz  $ gunzip tibero5-bin-5.0-linux64-72034-opt-tested.tar.gz  $ tar -xvf tibero5-bin-5.0-linux64-72034-opt-tested.tar  [Setting environment] $ vi .bash_profile export TB_HOME=/home/tibero5_client/tibero5 export TB_SID=tb5 export PATH=$TB_HOME/bin:$TB_HOME/client/bin:$PATH: export LD_LIBRARY_PATH=$TB_HOME/client/lib:$LD_LIBRARY_PATH  [Gen Tip] $ cd $TB_HOME/config $ sh gen_tip.sh Using TB_SID "tb5" /home/tibero5_client/tibero5/config/tb5.tip generated  /home/tibero5_client/tibero5/config/psm_commands generated  /home/tibero5_client/tibero5/client/config/tbdsn.tbr generated.  Running client/config/gen_esql_cfg.sh  Done.  [Delete files] $ cd $TB_HOME $ ls bin client config lib license scripts  $ rm -rf ./config ./lib ./license ./scripts $ ls bin client  [Setting connection] $ TB_HOME/client/config  $ vi tbdsn.tbr  tibero=(...

[DBMS] Postgresql client install for centos/redhat

 [install] libpq-12.4-1.el8_2.x86_64.rpm postgresql96-libs-9.6.19-1PGDG.rhel8.x86_64.rpm postgresql96-9.6.19-1PGDG.rhel8.x86_64.rpm [execute] # psql -h host -U username enter password : 

[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...