pl/sql developer 远程连接服务器数据库方法
在oracle安装目录下
例如:D:\mywork\oracle\product\instantclient_11_2\NETWORK\ADMIN\tnsnames.ora
修改
其中ORCL为原有,我本地的配置
115.ORCL为新添加配置
HOST处填写服务器ip地址,SERVICE_NAME 填写数据库全局实例名
是否可以连接成功与本机服务有没有启动没有关系
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oracle)
)
)
115.ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 115.28.208.123)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
在oracle安装目录下
例如:D:\mywork\oracle\product\instantclient_11_2\NETWORK\ADMIN\tnsnames.ora
修改
其中ORCL为原有,我本地的配置
115.ORCL为新添加配置
HOST处填写服务器ip地址,SERVICE_NAME 填写数据库全局实例名
是否可以连接成功与本机服务有没有启动没有关系
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oracle)
)
)
115.ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 115.28.208.123)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)