虚拟机里面“无法解析连接描述符中指定的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 也正常,等待高人 关于Linux的su命令 字段为空的时候才更新,怎么写? 怎样实现ORACLE 数据库跨网段访问??? 请问使用delete从一个表里删除记录后,能否恢复删除数据,怎么恢复?恢复成功再送100,谢谢! 如何将应用程序与oracle服务器端一起打包 急求update语句,在线等! 如何查找一个用户所使用的表空间 心情不好,散分!!!!! 如何连接oracle7.3的数据库!!!急 oracle中如何在后台执行一条sql语句? 如何查询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 也正常,
等待高人