搜索找到tnsnames.ora文件,添加参数
打开文件
添加参数,格式如下:
DBSAP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 远程地址)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DBSAP)
)
)
保存,链接数据库
选好链接名,输入账号密码,登录
搜索找到tnsnames.ora文件,添加参数
打开文件
添加参数,格式如下:
DBSAP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 远程地址)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DBSAP)
)
)
保存,链接数据库
选好链接名,输入账号密码,登录