解决 在ORACLE安装路径下找到 tnsnames.ora
如 我的路径在F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN 文件夹下
打开将 host 改为127.0.0.1 原来应该是你的主机名 如下
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
如 我的路径在F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN 文件夹下
打开将 host 改为127.0.0.1 原来应该是你的主机名 如下
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)