六月 5th, 2012

ORACLE 数据库tnsnames.ora和listener.ora配置案例

数据库问题解决方案, by 小哥.

tnsnames.ora
# tnsnames.ora Network Configuration File: C:\oracle\ora10\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

192.168.50.246_ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.50.246)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

listener.ora
# listener.ora Network Configuration File: C:\oracle\ora10\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = C:\oracle\ora10)
)
)

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)

Back Top