1、Oracle中添加了数据库,但在PLSQL Developer中 显示不出来时:
找到以下路径:E:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN
打开文件tnsnames.ora
将原有的信息类似于:
TYSYZHENGSHIKU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 129.1.4.83)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = tysi)
)
)
复制后修改为:
ta3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ta3)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 129.1.4.83)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = tysi)
)
)
复制后修改为:
ta3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ta3)
)
)
上面改为下面,上面为原有的 下面为新加的 这样的话ta3就显示出来了