ORACLE NETWORK정리 ; Procotol Address Configuration

리스너 파일이나 local naming 파일을 살펴보다보면 ADDRESS 파라미터안에 PROTOCOL이란 항목이 존재함을 발견할 수 있습니다.

그 PROTOCOL에 대한 포스팅입니다.

참조사이트 : 
http://docs.oracle.com/cd/B28359_01/network.111/b28317/protocoladd.htm#i467969  
http://docs.oracle.com/cd/B19306_01/server.102/b15658/cnfg_net_srv.htm#i38627 

Protocol	Parameter	Description
IPC	PROTOCOL	Specify ipc as the value.
	KEY	Specify a unique name for the service. Oracle recommends using the service name or the Oracle System Identifier (SID) of the service. Example: (PROTOCOL=ipc)(KEY=sales)
Named Pipes	PROTOCOL	Specify nmp as the value.
	SERVER	Specify the name of the Oracle server computer.
	PIPE	Specify the pipe name you used to connect to the database server (the same PIPE keyword you specified on server with Named Pipes). This name can be any arbitrary name. Example: (PROTOCOL=nmp)(SERVER=sales)(PIPE=dbpipe0)
SDP	PROTOCOL	Specify sdp as the value.
	HOST	Specify the host name or IP address of the computer.
	PORT	Specify the listening port number. Example: (PROTOCOL=sdp)(HOST=sales-server)(PORT=1521) (PROTOCOL=sdp)(HOST=192.0.2.204)(PORT=1521) See Also: "Recommended Port Numbers"
TCP/IP	PROTOCOL	Specify tcp as the value.
	HOST	Specify the host name or IP address of the computer.
	PORT	Specify the listening port number. Example: (PROTOCOL=tcp)(HOST=sales-server)(PORT=1521) (PROTOCOL=tcp)(HOST=192.0.2.204)(PORT=1521) See Also: "Recommended Port Numbers"
TCP/IP with SSL	PROTOCOL	Specify tcps as the value.
	HOST	Specify the host name or IP address of the computer.
	PORT	Specify the listening port number. Example: (PROTOCOL=tcps)(HOST=sales-server)(PORT=2484) (PROTOCOL=tcps)(HOST=192.0.2.204)(PORT=2484) See Also: "Recommended Port Numbers"

5.3 Oracle Protocol Support

Oracle protocol support is a component of Oracle Net. It includes the following:

• IPC Protocol Support

• TCP/IP Protocol Support

• TCP/IP with SSL Protocol Support

The IPC, TCP/IP, and TCP/IP with Secure Sockets Layer (SSL) protocol supports each have an address specification that is used in Oracle Net Services configuration files and in the DISPATCHER initialization parameter. The following sections describe the address specifications for each of the protocol supports.

See Also:

• On HP-UX (PA-RISC) and Tru64 UNIX systems, you can use DCE as an Oracle Net protocol, if it is installed. For more information about configuring the DCE protocol support, refer to Oracle Database Advanced Security Administrator's Guide

• Oracle Database Net Services Administrator's Guide for more information about Oracle protocol support

5.3.1 IPC Protocol Support

The IPC protocol support can be used only when the client program and Oracle Database are installed on the same system. This protocol support requires a listener. It is installed and linked to all client tools and the oracle executable.

The IPC protocol support requires an address specification in the following format:

(ADDRESS = (PROTOCOL=IPC)(KEY=key))

The following table describes the parameters used in this address specification.

Parameter	Description
PROTOCOL	The protocol to be used. The value is IPC. It is not case-sensitive.
KEY	Any name that is different from any other name used for an IPC KEY on the same system.

The following is a sample IPC protocol address:

(ADDRESS= (PROTOCOL=IPC)(KEY=EXTPROC))

5.3.2 TCP/IP Protocol Support

TCP/IP is the standard communication protocol used for client/server communication over a network. The TCP/IP protocol support enables communication between client programs and Oracle Database, whether they are installed on the same or different systems. If the TCP/IP protocol is installed on your system, then the TCP/IP protocol support is installed and linked to all client tools and to the oracle executable.

The TCP/IP protocol support requires an address specification in the following format:

(ADDRESS = (PROTOCOL=TCP)(HOST=hostname)(PORT=port))

The following table describes the parameters used in this address specification.

Parameter	Description
PROTOCOL	The protocol support to be used. The value is TCP. It is not case-sensitive.
HOST	The host name or the host IP address.
PORT	The TCP/IP port. Specify the port as either a number or the alias name mapped to the port in the /etc/services file. Oracle recommends a value of 1521.

The following is a sample TCP/IP protocol address:

(ADDRESS= (PROTOCOL=TCP)(HOST=MADRID)(PORT=1521))

5.3.3 TCP/IP with SSL Protocol Support

The TCP/IP with SSL protocol support enables an Oracle application on a client to communicate with remote Oracle Database instances through TCP/IP and SSL. To use TCP/IP with SSL, you must install Oracle Advanced Security.

The TCP/IP with SSL protocol support requires an address specification in the following format:

(ADDRESS = (PROTOCOL=TCPS)(HOST=hostname)(PORT=port))

The following table describes the parameters used in this address specification.

Parameter	Description
PROTOCOL	The protocol to be used. The value is TCPS. It is not case-sensitive.
HOST	The host name or the host IP address.
PORT	The TCP/IP with SSL port. Specify the port as either a number or the alias name mapped to the port in the /etc/services file. Oracle recommends a value of 2484.

The following is a sample TCP/IP with SSL protocol address:

(ADDRESS= (PROTOCOL=TCPS)(HOST=MADRID)(PORT=2484))