设置pl/sql连接数据库方法tnsnames.ora

最新推荐文章于 2024-06-27 13:14:09 发布

yaxf999

最新推荐文章于 2024-06-27 13:14:09 发布

阅读量1.5k

点赞数

分类专栏：软件安装文章标签：数据库 service server tcp list network

本文链接：https://blog.csdn.net/yaxf999/article/details/7294224

版权

软件安装专栏收录该内容

10 篇文章 0 订阅

订阅专栏

#########D:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN

XE =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = PC2008072813klv)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
)

#0115测试数据库
CSNGBIL =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 132.80.211.214)(PORT = 1122))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ngbil)
    )
)

CSNGACT =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 133.80.241.214)(PORT = 11523))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ngact)
    )
)

csNGCRM =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 133.80.241.214)(PORT = 11521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ngcrm)
    )
)

CSNGSTA =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 133.80.241.214)(PORT = 11524))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ngsta)
    )
)