Oracle的tnsnames.ora文件以便plsql/developer 访问

最新推荐文章于 2024-06-25 08:00:00 发布

skytalemcc

最新推荐文章于 2024-06-25 08:00:00 发布

阅读量479

点赞数

分类专栏： PL/SQL 文章标签： oracle list tcp service server database

本文链接：https://blog.csdn.net/skytalemcc/article/details/5261970

版权

PL/SQL 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

####################################
# TNSNAMES.ORA Configuration File:D:/Oracle_now/NETWORK/ADMIN/tnsnames.ora 文件位置
# Generated by Oracle Enterprise Manager V2
# Date..........: Tue Jan 26 20:05:00 CST 2010
####################################

TEST1.TCSGEGDC.COM =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = tcp)(HOST = 3.242.164.83)(PORT = 1521))
    )
    (CONNECT_DATA = (SID = orcl))
)

TRAINING.TCSGEGDC.COM =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 3.242.164.113)(PORT = 1521))
    )
    (CONNECT_DATA = (SERVICE_NAME = trgdata))
)

ICAMCH2.TCSGEGDC.COM =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = CNHZPD-64KW82X)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ICAMCH2)
    )
)

ORCL_3.242.164.125 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 3.242.164.125)(PORT = 1521))
    )
    (CONNECT_DATA = (SID = orcl)(SERVER = DEDICATED))
)

TESTSID_3.242.164.125 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 3.242.164.125)(PORT = 1521))
    )
    (CONNECT_DATA = (SID = TESTSID)(SERVER = DEDICATED))
)

# rep/rep
# TNSNAMES.ORA Network Configuration File: D:/oracle/ora90/NETWORK/ADMIN/tnsnames.ora

plsql/develop

username:ICAM2USER1

password:

database:ICAMCH2

connected to:normal