不知道怎么回事
pl/sql developer 不能用 每次都报上面的那个错误
sql*plus 控制台都能用
别人都能用 pl/sql developer 连我的数据库
搜了一两天没有一个能解决问题,希望那位高手指点指点# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.zygdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = zygdb)
(SID = zygdb)
)
)zygdb2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = zygdb)
(SID = zygdb)
)
)zygdb3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = zygdb)
)
)# SQLNET.ORA Network Configuration File: D:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (HOSTNAME)
pl/sql developer 不能用 每次都报上面的那个错误
sql*plus 控制台都能用
别人都能用 pl/sql developer 连我的数据库
搜了一两天没有一个能解决问题,希望那位高手指点指点# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.zygdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = zygdb)
(SID = zygdb)
)
)zygdb2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = zygdb)
(SID = zygdb)
)
)zygdb3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = zygdb)
)
)# SQLNET.ORA Network Configuration File: D:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (HOSTNAME)
最开始原来有一个数据库
我把 ip 主机名 改了。
建了一个系统管理员,删除了原来的系统管理员用户。
建了一个新数据库,老数据库就报这种错误。新的没有事
老数据库不能用pl/sql developer 连接,其他电脑也不能连。建了一个数据链路把数据给备份了。
新数据库没有任何问题。
我删除了老数据库。新数据库没有问题。
后来我转了个owb学习。
也正常
后来我不想用那个数据库了,重新安转了oracle,建了一个新数据库,就老报12154那个错误。