本文主要是介绍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 访问的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!