添加一个tnsnames.ora的配置
无论是客户端还是即时客户端,都可以进行tnsnames.ora的配置
在客户端的目录里新建文件夹 network ,network里在新建 admin,在admin目录下建一个后缀名为.ora的文件:tnsnames.ora
打开tnsnames.ora,内容添加如下:
# tnsnames.ora Network Configuration File: D:\oracle\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1 )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl )
)
)
test-name =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10 )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
其中下面的一个的 test-name改成你想在登录显示框选择看到的名字,HOST改成你想连到的数据库的 IP,就可以了