1、Oracle中添加了数据库,但在PLSQL Developer中显示不出来时:
找到以下路径:D:\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