远程通过监听连接报ORA-01034故障处理一例
来源:互联网 发布:小米笔记本如何 知乎 编辑:程序博客网 时间:2024/05/20 05:54
错误如下:
SQL> conn system/test@test
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
1、检查了环境环境变量,查看了监听状态和实例状态都是正常的。
2、tnsping ZSK 也是通的
C:\>tnsping ZSK
TNS Ping Utility for 64-bit Windows: Version 10.2.0.4.0 - Production on 10-FEB-2012 22:51:55
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 12521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = test)))
OK (20 msec)
C:\>
SQL> alter system set local_listener='(ADDRESS =(PROTOCOL=TCP)(HOST=134.224.55.118) (PORT=12521)(SID=ZSK))';
System altered.
SQL> alter system register;
System altered.
SQL> exit
客户端再次测试连接:
C:\>sqlplus system/test@test
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Feb 10 22:54:49 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
- 远程通过监听连接报ORA-01034故障处理一例
- ORA-00054 故障处理一例
- ORA-30009 故障处理一例
- ORA-28547 故障处理一例
- ORA-27102:out of memeory 故障处理一例
- ORA-01994 故障一例
- ORA-27090 故障一例
- Listener已启动,本地可以连接数据库,远程pl/sql工具连接报ora-12541监听不存在错误
- ORA-15041,ORA-01274 故障一例
- oracle11g远程连接报ORA-12541错误
- ORA-12541:TNS:无监听程序 远程连接oracle失败
- PLSQL连接远程Oracle出现ORA-12541: 无监听程序
- ORA-01591故障处理
- ORA-01591故障处理
- ora-3136故障处理
- SSH远程连接故障
- Jdk故障一例处理
- webcdn故障处理一例
- ORACLE中的锁(1)--INSERT
- 简单理解makefile与程序的编译联接
- [U]2.4.3 Cow Tours
- centos vsftp
- J2EE(01) web.xml 配置说明
- 远程通过监听连接报ORA-01034故障处理一例
- 深入理解 javascript
- STL学习系列之五——关联容器
- 惠普中国CEO孙振耀退休感言,男孩看了不用沉默,女孩看了不用哭
- 飞凌6410开发板通过USB Reader读卡器读取IC卡ID(Linux源代码)
- Linux 自学笔记(五)——时间显示与管理&监控网络信息
- http://wiki.hotoo.me/Canvas-SVG-VML.html
- 堆和栈的区别(转过无数次的文章)
- replay attacker