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

本文主要是介绍Oracle的tnsnames.ora文件 以便plsql/developer 访问，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

####################################
# 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

这篇关于Oracle的tnsnames.ora文件 以便plsql/developer 访问的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---