日期:2014-05-16  浏览次数:20351 次

oracle 连接局域网配置

C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN

?tnsnames.ora 文件添加:

?

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

?

LISTENER_ORCL =

? (ADDRESS = (PROTOCOL = TCP)(HOST = MICROSOF-FBBB67)(PORT = 1522))

?

?

ORCL =

? (DESCRIPTION =

? ? (ADDRESS = (PROTOCOL = TCP)(HOST = MICROSOF-FBBB67)(PORT = 1522))

? ? (CONNECT_DATA =

? ? ? (SERVER = DEDICATED)

? ? ? (SERVICE_NAME = orcl)

? ? )

? )

?

EXTPROC_CONNECTION_DATA =

? (DESCRIPTION =

? ? (ADDRESS_LIST =

? ? ? (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))

? ? )

? ? (CONNECT_DATA =

? ? ? (SID = PLSExtProc)

? ? ? (PRESENTATION = RO)

? ? )

? )

?

?

?

添加内容------------------------------

hx_core2 =

? (DESCRIPTION =

? ? (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.88.231)(PORT = 1521))

? ? (CONNECT_DATA =

? ? ? (SERVER = DEDICATED)

? ? ? (SERVICE_NAME = banking)

? ? )

) ?

?