oracle客户端连接mysql数据库_Oracle客户端连接数据库配置

# tnsnames.ora Network Configuration File.

# Generated by Oracle configuration tools.

# Sample:

#DatabaseName =

# (DESCRIPTION =

# (ADDRESS_LIST =

# (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))

# )

# (CONNECT_DATA =

# (SERVER = DEDICATED)

# (SERVICE_NAME = ServiceName)

# (INSTANCE_NAME = InstanceName)

# )

# )

# Modify the following content to fit your own needs.

DummyDatabase =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = DummyService)

)

)

pcidata_hce =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.10.10)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = devorcl)

)

)

FM_DEV=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.10.223)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = testorcl)

)

)

hceorcl = //数据库名称自定义文中唯一值

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.10.123)(PORT = 1521)) //数据库IP及端口号

(CONNECT_DATA =

(SID =orcl) //实例名

)

)

pdatatest =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.10.182)(PORT = 1521))

(CONNECT_DATA =

(SID =pdatatest)

)

)

162ora =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.10.162)(PORT = 1521))

(CONNECT_DATA =

(SID =pdjgorcl)

)

)