Oracle : 오라클 원격 접속 허용

• Client Configuration

1. ora파일을 확인하기

• \network\admin\tnsnames.ora

======================================================

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

#굵은 글씨로 표시된 부분을 복사해서 붙여넣는다.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = [Client_IP_Addr])(PORT = 1521))
    (CONNECT_DATA =
      # (SERVER = DEDICATED)
      # 윗 부분은 삭제한다.
      (SERVICE_NAME = orcl)
      # 접속할 Service name을 입력한다.
    )
  )

=================================================================

2. 클라이언트에서 접속되는지 확인

Client OS : Windows 7 Ultimate

=================================================================
>sqlplus [user_id]/[user_password]@[service_name]
=================================================================

예 >> sqlplus scott/tiger@orcl