Home > Database > Mysql Tutorial > body text

ORA-01034: ORACLE not available

WBOY
Release: 2016-06-07 17:34:55
Original
1011 people have browsed it

ORA-01034: ORACLE not available

RROR:
ORA-01034: Oracle not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0

遇到一个问题,今天折腾了半个多小时,不注意细节,真是

无非有两个原因

1、服务没有启动

这个原因大家很容易知晓

2、链接监听不对

明明使用as sysdba可以链接,后边加上·服务名就不行,刚开始查找网上资料,神什么原因都有,,最后自己最琢磨了下细心看了监听

一个是

Services Summary...
Service "orcl" has 1 instance(s).
  Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl.localdomain" has 1 instance(s).


将服务名改修改一下就ok了

推荐阅读:

ORA-01172、ORA-01151错误处理

ORA-00600 [2662]错误解决

ORA-01078 和 LRM-00109 报错解决方法

ORA-00471 处理方法笔记

ORA-00314,redolog 损坏,或丢失处理方法

ORA-00257 归档日志过大导致无法存储的解决办法

linux

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template