1)找到 tnsnames.ora 此文件在oracle安装目录文件夹,我的安装目录是D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN
2)打开该文件并添加如下:(Database数据库名,ipaddress:ip地址,1521是端口),如我的目录是 D:\Oracle\product\10.2.0\db_1\NETWORK\ADMIN
Database =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IPAddress)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Database_Name)
)
)