为质量而战!为胜利而战!

tnsnames.ora和listener.ora配置

上一篇 / 下一篇 2008-06-16 15:51:45 / 个人分类：Oracle和DB2

文件所在路径:

oracle\product\10.2.0.1\db_1\network\admin\

(1)服务端listener.ora
LISTENER   =
      (DEscrīptION_LIST   =
          (DEscrīptION   =
              (ADDRESS_LIST   =
                  (ADDRESS   =   (PROTOCOL   =   TCP)(HOST = ip)(PORT = 1521))
              )
          )
      )

(2)客户端tnsnames.ora
SID   =
      (DEscrīptION   =
          (ADDRESS_LIST   =
              (ADDRESS   =   (PROTOCOL   =   TCP)(HOST   =   ip)(PORT   =   1521))
          )
          (CONNECT_DATA   =
              (SID   =   net_ser_name)
          )
      )