虚拟机里面“无法解析连接描述符中指定的SID” 用Vmware安装了一个windows 2003。。 装了 oracle 10G, 昨天安装创建数据库之后用client连接正常。。今天再用client连接的时候提示 “无法解析连接描述符中指定的SID” 我看到服务都启动了。。监听也有。。不知道是什么问题。求大神指教。。纯菜鸟 ~~还望指点 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 百度一下吧。 看看是不是tnsnames.ora配错了 。另外 以后错误信息里面的 ora -错误号贴上来,大家更好针对性的查找问题 TNSNAMES# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora# Generated by Oracle configuration tools.ORCL_127.0.0.1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SID = orcl) (SERVER = DEDICATED) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )Listener# listener.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\oracle\product\10.2.0\client_1) (PROGRAM = extproc) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) )sqlnet# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)因为昨天能登。。今天重启下虚拟机就不行了。。比较奇怪 - - 我也是在虚拟机上安装了oracle10G,装好的时候能用,把电脑重启一下就提示无法解析连接描述符中指定的SID,今天早上发现有个服务没有启动,手动启动之后就好了,下午把电脑重启之后又是一样的错误,检查了 服务,TNS和监听都没有问题,但就是解决不了我尝试用过sqlplus可以登录数据库,tnsping 也正常,等待高人 求几个视图介绍!! oracle的SQL为何慢于国产数据库 Oracle 触发器更新本表 求列的总数 在oracle的sqlplus中怎样能把结果保存在c:\a.txt中 数据库突然出现错误~提示 英文版Oracle问题,请帮我看看 散分!哪个表里存放了所有表字段的信息? 小白求教老旧Oracle优化或升级 oracle中序列每隔一天就重新循环 怎么弄? 搜索 如何查询Oracle的这些东东——访问量,在线时长,系统工作时间 100分求一个完整SQL
另外 以后错误信息里面的 ora -错误号贴上来,大家更好针对性的查找问题
# Generated by Oracle configuration tools.
ORCL_127.0.0.1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)Listener
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\client_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
sqlnet
# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
因为昨天能登。。今天重启下虚拟机就不行了。。比较奇怪 - -
今天早上发现有个服务没有启动,手动启动之后就好了,下午把电脑重启之后又是一样的错误,检查了 服务,TNS和监听都没有问题,但就是解决不了
我尝试用过sqlplus可以登录数据库,tnsping 也正常,
等待高人