17,377
社区成员
发帖
与我相关
我的任务
分享Oracle(10g)安装正常,计算机重启后就出现ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
求救...如题
在网上查了两天没有结果.我保证装完oracle之后没有修改任何东西,只是测试一下能不能登陆,然后重启计算机,然后就出现问题了.高手救命...
# listener.ora Network Configuration File: E:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bell-xu.apachefootwear.com)(PORT = 1521))
)
)
)
----------------------------------------
# tnsnames.ora Network Configuration File: E:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bell-xu.apachefootwear.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
在网上查了两天没有结果.我保证装完oracle之后没有修改任何东西,只是测试一下能不能登陆,然后重启计算机,然后就出现问题了.高手救命...
# listener.ora Network Configuration File: E:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bell-xu.apachefootwear.com)(PORT = 1521))
)
)
)
----------------------------------------
# tnsnames.ora Network Configuration File: E:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bell-xu.apachefootwear.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
...全文
请发表友善的回复…
发表回复
haozi187 2010-11-22
- 打赏
- 举报
不好意思搞错了·应该是tnsping orcl`
haozi187 2010-11-19
- 打赏
- 举报
SERVICE_NAME=127.0.0.1 竟然是IP···
haozi187 2010-11-19
- 打赏
- 举报
老兄·我和你简直一模一样的情况··
看我用 tnsping 127.0.0.1 结果:
看我用 tnsping 127.0.0.1 结果:
TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 19-11月-
2010 16:51:17
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
D:\oracle\network\admin\sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=127.0.0.1))(ADDRE
SS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
OK (20 msec)
qq2013 2010-08-12
- 打赏
- 举报
请问你的问题解决了吗?
sihai163 2008-06-08
- 打赏
- 举报
真是对不起热心帮助我的朋友!忘记结贴了.问题到目前为止还未到确切地找出原因.甲骨文技术员的建议是内存太低,但我不认同,我觉得有个很值得研究的问题,如果你的系统之前装过一次oracle且版本不同,在注册表内会看到有不同版本的标释,其原理大概是:你之前装了一个oracle,然后删了,再装第二次的时候,注册表依然保留了前版本的信息,所以会引导去之前的位置,但由于找不到文件,所以出错!
到HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\下找到oracle根目录,看看下面是不是有多个版本信息,选择oracle看它引导到哪个版本,如果引导错了,则把它子目录下的正确信息复制到该根目录下即可.
由于oracle只能手动删除,所以一般情况下注册表的信息要清理干净,否则下次重装将发生不可预料错误!
到HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\下找到oracle根目录,看看下面是不是有多个版本信息,选择oracle看它引导到哪个版本,如果引导错了,则把它子目录下的正确信息复制到该根目录下即可.
由于oracle只能手动删除,所以一般情况下注册表的信息要清理干净,否则下次重装将发生不可预料错误!
Delphi_Li 2008-01-16
- 打赏
- 举报
你是否更改了计算机的名字？？？
zhangxf1981 2008-01-16
- 打赏
- 举报
你看看 windows 的服务还在吗？
chenchun_love 2008-01-16
- 打赏
- 举报
出现的问题跟一样，我装的是xp的，找了一整天了，还是不知道问题出在哪，楼主问题解决没？？？
maxinlife 2008-01-16
- 打赏
- 举报
是不是你的操作系统的问题，，，shared memory realm does not exist
系统和内存之间读取的时候出问题了，使你操作系统不能给oracle分配有效的内存空间
系统和内存之间读取的时候出问题了，使你操作系统不能给oracle分配有效的内存空间
hailang_maxu 2008-01-11
- 打赏
- 举报
你是在本机连的,还是客户端
你的服务名配置了吗
你的服务名配置了吗
afen208 2008-01-11
- 打赏
- 举报
有没有高手出来看看嘛,请指点指点哈
yeahgoodboy 2007-12-30
- 打赏
- 举报
我也碰到了同样的情况，请问有没有解决方法？
sihai163 2007-06-14
- 打赏
- 举报
装完oracle是可以正常使用的.只是一重启就不能再用了.会不会跟之前的软件有冲突
sihai163 2007-06-14
- 打赏
- 举报
多谢love_2008(love2008)回答抽空我的问题,这个方法我之前试过了。改完之后我重启一下监听服务OracleOraDb10g_home1TNSListener，然后用PLSQL Developer登陆时提示:
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
sihai163 2007-06-14
- 打赏
- 举报
服务全部正常开启!
我的系统是window2000,之前安装了sql、VB、输入法、解压缩、dreamweaver、photoshop 8.0、金山词霸2002、水晶报表、office2003、AdobeReader、矮人DOS
我的系统是window2000,之前安装了sql、VB、输入法、解压缩、dreamweaver、photoshop 8.0、金山词霸2002、水晶报表、office2003、AdobeReader、矮人DOS
wangzk0206 2007-06-14
- 打赏
- 举报
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)
改为：
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GOLBAL_DBNAME= orcl)
(ORACLE_HOME = E:\oracle\product\10.1.0\Db_1)
(SID_NAME=orcl)
)
)
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)
改为：
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GOLBAL_DBNAME= orcl)
(ORACLE_HOME = E:\oracle\product\10.1.0\Db_1)
(SID_NAME=orcl)
)
)
sihai163 2007-06-14
- 打赏
- 举报
监听状态是
LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 14-6月 -2007 15:5
6:09
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bell-xu.apachefootwear.c
om)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
ction
Start Date 14-6月 -2007 15:03:14
Uptime 0 days 0 hr. 53 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\oracle\product\10.1.0\Db_1\network\admin\listener.o
ra
Listener Log File E:\oracle\product\10.1.0\Db_1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bell-xu.apachefootwear.com)(PORT=152
1)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 14-6月 -2007 15:5
6:09
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bell-xu.apachefootwear.c
om)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
ction
Start Date 14-6月 -2007 15:03:14
Uptime 0 days 0 hr. 53 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\oracle\product\10.1.0\Db_1\network\admin\listener.o
ra
Listener Log File E:\oracle\product\10.1.0\Db_1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bell-xu.apachefootwear.com)(PORT=152
1)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
