一般只有一个文本文件供修改 tnsnames.ora修改格式如下
[自定义名称] =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = [主机IP])(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = [数据库服务名])
)
)
自定义名称和数据库服务名要一样,数据库服务名可以小写。
[自定义名称] =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = [主机IP])(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = [数据库服务名])
)
)
自定义名称和数据库服务名要一样,数据库服务名可以小写。