1、tnsnames.ora（客户端）

net_service_name= 

 (DESCRIPTION= 

   (ADDRESS=(protocol_address_information))

   (CONNECT_DATA= 

     (SERVICE_NAME=service_name))) 

2、listener.ora（服务器端）

LISTENER=

  (DESCRIPTION=

    (ADDRESS_LIST=

      (ADDRESS=(PROTOCOL=tcp)(HOST=sale-server)(PORT=1521))

      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))

SID_LIST_LISTENER=

  (SID_LIST=

    (SID_DESC=

      (GLOBAL_DBNAME=sales.us.example.com)

      (ORACLE_HOME=/oracle11g)

      (SID_NAME=sales))

    (SID_DESC=

      (SID_NAME=plsextproc)

      (ORACLE_HOME=/oracle11g)

      (PROGRAM=extproc)))