[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

libnsl2-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

ORCL =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = database-2.c52tfjxpzfls.ap-northeast-2.rds.amazonaws.com)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = ORCL)

    )

  )

[connection full path]

# sqlplus id/password@ip:port/SID

# sqlplus admin/00tkdydwk@database-2.c52tfjxpzfls.ap-northeast-2.rds.amazonaws.com:1521/ORCL

[connection using tnsnames.ora]

# sqlplus id/password@SID

# sqlplus admin/00tkdydwk@ORCL