ORA-12514 TNS:listener does not currently know of service requested in connect descriptor报错解决
来源:互联网 发布:c# 多cpu 编程 编辑:程序博客网 时间:2024/06/11 01:03
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor报错问题解决方法
解决方法:
1.停掉监听:
lsnrctl stop
2.编辑监听文件:
vim /u01/oracle/app/product/11.2/dbhome_1/network/admin/listener.ora
我这里的环境是双oracle做的主备,两台oracle服务器IP分别为
150.31.125.113和150.31.125.114
这里的监听文件我设置的主备虚拟IP:150.31.125.115
另外还要加上一句:
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ebank)(SID_NAME=ebank)))
注解:GLOBAL_DBNAME = ebank 把ebank改为自己的实例名。
保存退出;
3.重启监听可以解决问题了。(生产环境,解决问题后就没有拍照),欢迎大家留言交流。
阅读全文
0 0
- ORA-12514 TNS:listener does not currently know of service requested in connect descriptor报错解决
- ERROR - ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- 遭遇ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- ORA-12514: TNS: listener does not currently know of service requested in connect descriptor
- ora-12514:TNS:listener does not currently know of service requested in connect descriptor
- ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- ora-12514:TNS:listener does not currently know of service requested in connect descriptor
- ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- ora-12514:TNS:listener does not currently know of service requested in connect descriptor
- ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- ORA-12514:TNS:listener does not currently know of service requested in connect descriptor
- centos: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- ora-12514:TNS:listener does not currently know of service requested in connect descriptor
- ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- android ZXing 二维码的实现与demo
- java基础-02java运算符与分支结构
- 用正则表达式提取Cookie值
- linux系统redis数据库
- CS231N 笔记2_损失函数和优化器
- ORA-12514 TNS:listener does not currently know of service requested in connect descriptor报错解决
- ECharts详解
- 【codevs 4510】神奇的幻方
- Java修饰符 abstract,static,final 的区别详解
- 文章标题 listview网络请求数据展示
- 菱形
- 2017-11-7每日一练
- JAVA运算符
- 10044---一个web项目web.xml的配置中<context-param>配置作用