Linux下oracle问题RACLE not availableORA-27101: shared memory realm does not exist Linux-x86_64

最新推荐文章于 2024-07-26 07:30:00 发布

悠然大月季

最新推荐文章于 2024-07-26 07:30:00 发布

阅读量1.2k

点赞数

分类专栏：数据库学习文章标签： oracle linux

本文链接：https://blog.csdn.net/weixin_38504735/article/details/124915695

版权

数据库学习专栏收录该内容

20 篇文章 0 订阅

订阅专栏

linux Centos7安装的Oracle 11.2

管理员登录后，shutdown immediate报错，原因是没有启动实例

sqlplus / as sysdba

SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory

解决方法：
第一步

#启动实例
[oracle@data2 ~]$ lsnrctl start
......
Service "orcl" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
#查看实例
[oracle@data2 ~]$ lsnrctl status
.....
Service "orcl" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

第二步

sqlplus / as sysdba
#启动oracle服务
SQL> startup 
ORACLE instance started.

Total System Global Area 2004267008 bytes
Fixed Size                  2214736 bytes
Variable Size            1140851888 bytes
Database Buffers          855638016 bytes
Redo Buffers                5562368 bytes
Database mounted.
Database opened.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.