Oracle解决 ORA-12514
来源:互联网 发布:十天学会单片机 编辑:程序博客网 时间:2024/06/06 19:51
问题:
[oracle@Lee ~]$ sqlplus scott/tiger@orcl
SQL*Plus: Release 11.2.0.4.0 Production on Sun Jul 27 13:21:41 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
[oracle@Lee ~]$ lsnrctl status;
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 27-JUL-2014 13:22:16
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.26.144.100)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 27-JUL-2014 13:13:06
Uptime 0 days 0 hr. 9 min. 10 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/OraHome/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/Lee/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Lee)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfull
解决:
问题原因:数据库实例没注册到listener在listener.ora里面添加了一行SID_LIST_LISTENER =(SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl) (SID_NAME = orcl) ))注:里面的orcl根据你安装的数据库实例名确定,我用此法解决了这个报错。
- Oracle解决 ORA-12514
- Oracle 数据库登录时出现ORA-12514 、ORA-01034、ORA-27101、ORA-01033 错误的解决
- oracle 错误解决 ORA-06502
- ORACLE数据库ORA-00257解决
- ORACLE数据库ORA-00257解决
- Oracle ORA-29538错误解决
- ORACLE ORA-01652 错误解决
- ORACLE ora-00942 错误解决
- ORACLE ORA-01722 错误解决
- ORACLE ORA-12560 错误解决
- ORACLE ORA-00600 错误解决
- oracle ORA-01019错误解决
- 解决Oracle ORA-12505 error
- 解决oracle ORA-09925问题
- 【ORACLE】ORA-01157错误解决
- Oracle错误ORA-29861解决
- oracle--错误解决ORA-12505
- 【oracle错误解决】ORA-01033;ORA-00313;ORA-00312
- 身份验证(公开密钥加密原理简介)
- oracle中char,varchar,VARCHAR2的区别
- 串口乱码
- 多线程下载 断点续传
- linux下安装7z命令及7z命令的使用
- Oracle解决 ORA-12514
- 三层架构—简析
- Java和poi导出excel报表
- 利用GOOGLE CACHE 缓存token
- Java 访问权限的表,总结的比较透彻。
- 仿刮刮乐刮奖效果
- ORACLE 日期函数 MONTHS_BETWEEN
- Android最新的Platform Codenames, Versions, API Levels,NDK Releases
- Curious Robin Hood(简单线段树)