# 연결

{% tabs %}
{% tab title="호스트 & 포트로 연결" %}

<figure><img src="https://1362923181-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5PH5ktGI0BWG6g9fvtcn%2Fuploads%2Fmjt4cFxd2U3Fzv2AghAX%2FScreenshot%200006-12-05%20at%206.06.02%E2%80%AFPM.png?alt=media&#x26;token=fc23337a-1ba3-44f5-855d-ba2b6c4e1224" alt="" width="444"><figcaption></figcaption></figure>

<table><thead><tr><th width="133" align="center">필드명</th><th width="288" align="center">설명</th><th align="center">상세</th></tr></thead><tbody><tr><td align="center">호스트</td><td align="center">오라클 데이터베이스 서버 주소</td><td align="center">IP 또는 도메인 주소</td></tr><tr><td align="center">포트</td><td align="center">오라클 데이터베이스 포트번호</td><td align="center">포트번호 (1 ~ 65535)</td></tr><tr><td align="center">SID</td><td align="center">System Identifier</td><td align="center">특정 데이터베이스 인스턴스명</td></tr><tr><td align="center">사용자</td><td align="center">사용자명(username)</td><td align="center"></td></tr><tr><td align="center">비밀번호</td><td align="center">사용자 비밀번호</td><td align="center"></td></tr></tbody></table>
{% endtab %}

{% tab title="TNSNAMES.ORA로 연결" %}

<figure><img src="https://1362923181-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5PH5ktGI0BWG6g9fvtcn%2Fuploads%2FpYSJvAciP39f65Nw6qIe%2FScreenshot%200006-12-05%20at%206.06.21%E2%80%AFPM.png?alt=media&#x26;token=57ff914d-b187-4a48-83a0-123285c7b90a" alt="" width="425"><figcaption></figcaption></figure>

<table><thead><tr><th width="133" align="center">필드명</th><th width="288" align="center">설명</th><th align="center">상세</th></tr></thead><tbody><tr><td align="center">사용자</td><td align="center">사용자명(username)</td><td align="center"></td></tr><tr><td align="center">비밀번호</td><td align="center">사용자 비밀번호</td><td align="center"></td></tr><tr><td align="center">접속 문자열</td><td align="center">TNSNAMES.ORA 내용</td><td align="center">접속문자열 하단 예시 참조</td></tr></tbody></table>

```sql
// 접속 문자열 예시
(DESCRIPTION= 
   (CONNECT_TIMEOUT=5sec)  // 연결 Timeout 필수 입력
   (ADDRESS = (PROTOCOL = TCP)(HOST = dbserver.example.com)(PORT = 1521)) 
   // PROTOCOL : HTTP 프로토콜 연결방법
   // HOST : 서버 주소 
   // PORT : 포트번호 
   (CONNECT_DATA = 
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
   )
   // 연결하려는 데이터베이스 서비스 이름 (또는 SID) 
)   
```

{% endtab %}
{% endtabs %}

{% hint style="info" %}
네트워크에 별도 보안 설정을 지정하신 경우 다음의 IP 주소를 Allowlist 에 추가하세요.&#x20;

IP Range : 34.64.62.217
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.outcode.biz/apps/data-source/oracle-database/connection.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
