在Oracle中添加数据库

orcl\10.2.0\NETWORK\ADMIN\tnsnames.ora

?

# tnsnames.ora Network Configuration File: e:\orcl\10.2.0\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

?

ORCL_196.128.1.5 =

? (DESCRIPTION =

? ? (ADDRESS_LIST =

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

? ? )

? ? (CONNECT_DATA =

? ? ? (SERVICE_NAME = orcl)

? ? )

? )

?

ORCL_196.128.1.177 =

? (DESCRIPTION =

? ? (ADDRESS_LIST =

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

? ? )

? ? (CONNECT_DATA =

? ? ? (SERVICE_NAME = orcl)

? ? )

? )

ORCL_196.128.1.51 =

? (DESCRIPTION =

? ? (ADDRESS_LIST =

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

? ? )

? ? (CONNECT_DATA =

? ? ? (SERVICE_NAME = orcl)

? ? )

? )

ORCL_192.168.1.13 =

? (DESCRIPTION =

? ? (ADDRESS_LIST =

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

? ? )

? ? (CONNECT_DATA =

? ? ? (SERVICE_NAME = orcl)

? ? )

? )

?

ORCL_196.128.1.3 =

? (DESCRIPTION =

? ? (ADDRESS_LIST =

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

? ? )

? ? (CONNECT_DATA =

? ? ? (SERVICE_NAME = orcl)

? ? )

? )

?

ORCL_196.128.1.8 =

? (DESCRIPTION =

? ? (ADDRESS_LIST =

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

? ? )

? ? (CONNECT_DATA =

? ? ? (SERVICE_NAME = orcl)

? ? )

? )

? ORCL_196.128.1.166 =

? (DESCRIPTION =

? ? (ADDRESS_LIST =

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

? ? )

? ? (CONNECT_DATA =

? ? ? (SERVICE_NAME = orcl)

? ? )

? )

ORCL =

? (DESCRIPTION =

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

? ? (CONNECT_DATA =

? ? ? (SERVER = DEDICATED)

? ? ? (SERVICE_NAME = orcl)

? ? )

? )

?

EXTPROC_CONNECTION_DATA =

? (DESCRIPTION =

? ? (ADDRESS_LIST =

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

? ? )

? ? (CONNECT_DATA =

? ? ? (SID = PLSExtProc)

? ? ? (PRESENTATION = RO)

? ? )

? )

?