[Client 접속 설정] 오라클 Client 설치 및 설정

[Client 접속 설정] 오라클 Client 설치 및 설정

(1). Oracle Client 설치

1. 다운로드 : https://www.oracle.com/kr/database/technologies/oracle19c-windows-downloads.html

- WINDOWS.X64_193000_client_home.zip

2. 압출풀기 : C:\OracleBase\app\oracle\product\19.3.0\client_home

- 압출파일 자체가 Oracle Client app 이므로 해당 위치에 압축을 푼다.

3. 설치 진행

- Oracle 홈 사용자 지정

- 설치 위치 지정

- 필요 조건 검사 수행

- 요약

- 제품 설치

- 완료

(2). Oracle Client 접속 정보 설정

- 접속 방식 설정 : C:\OracleBase\app\oracle\product\19.3.0\client_home\NETWORK\ADMIN\sqlnet.ora

# sqlnet.ora Network Configuration File: C:\OracleBase\app\oracle\product\19.3.0\client_home\NETWORK\ADMIN\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

- Client 접속 별칭(Alias) : C:\OracleBase\app\oracle\product\19.3.0\client_home\NETWORK\ADMIN\tnsnames.ora

# This file contains the syntax information for 
# the entries to be put in any tnsnames.ora file
# The entries in this file are need based. 
# There are no defaults for entries in this file
# that Sqlnet/Net3 use that need to be overridden 
#
# Typically you could have two tnsnames.ora files
# in the system, one that is set for the entire system
# and is called the system tnsnames.ora file, and a
# second file that is used by each user locally so that
# he can override the definitions dictated by the system
# tnsnames.ora file.

# The entries in tnsnames.ora are an alternative to using
# the names server with the onames adapter.
# They are a collection of aliases for the addresses that 
# the listener(s) is(are) listening for a database or 
# several databases.

# The following is the general syntax for any entry in 
# a tnsnames.ora file. There could be several such entries 
# tailored to the user's needs.



CDBORCL_MYWEB=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.11.10)(PORT=1521))
    )
    (CONNECT_DATA=
      (SERVICE_NAME=CDBORCL)
    )
  )

PDBORCL_MYWEB=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.11.10)(PORT=1521))
    )
    (CONNECT_DATA=
      (SERVICE_NAME=PDBORCL)
    )
  )


PDBORCL2_MYWEB=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.11.10)(PORT=1521))
    )
    (CONNECT_DATA=
      (SERVICE_NAME=PDBORCL2)
    )
  )   

- 접속 확인 : tnsping 서비스이름 또는 SID이름

Microsoft Windows [Version 10.0.19042.985]
(c) Microsoft Corporation. All rights reserved.

C:\Users\kang-PC10>tnsping CDBORCL_MYWEB

TNS Ping Utility for 64-bit Windows: Version 19.0.0.0.0 - Production on 17-5월 -2021 23:25:56

Copyright (c) 1997, 2019, Oracle. All rights reserved.

사용된 매개변수 파일:
C:\OracleBase\app\oracle\product\19.3.0\client_home\network\admin\sqlnet.ora


별칭 분석을 위해 TNSNAMES 어댑터 사용
(DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.11.10)(PORT=1521))) (CONNECT_DATA= (SERVICE_NAME=CDBORCL)))에 접속하려고 시도하는 중
확인(10밀리초)

C:\Users\kang-PC10>