ORA-27101同时尝试在关机立即登录时

Question

SQL*Plus:发布11.2.0.1.0版的Mon 4月23日19:29:19 2018版权(c) 1982,2010，Oracle。版权所有。输入用户名:系统输入密码:错误: ORA-01034: 27101:共享内存领域不存在进程ID: 0会话ID: 0序列编号:0输入用户名: sysdba输入密码: ERROR: ORA-01034: ORACLE ORA-27101:共享内存域不存在进程ID: 0会话ID: 0会话ID:0序列号:0

Answer 1

我认为您执行了以下步骤并捕获了此错误。

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

尝试启动SQL*PLUS并启动数据库。

[oracle@myserver oracle]$ sqlplus

SQL*Plus: Release 12.2.0.1.0 Production on Tue Apr 24 00:20:59 2018

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Enter user-name: system
Enter password: 
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3701
Additional information: -688980181
Process ID: 0
Session ID: 0 Serial number: 0


Enter user-name: 

Enter user-name: sysdba
Enter password: 
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3701
Additional information: -688980181
Process ID: 0
Session ID: 0 Serial number: 0

Enter user-name: 

问题是数据库尚未开始对这些提供的用户名进行身份验证。

您可以使用as as sysdba作为启动实例的用户名连接到空闲实例。

Enter user-name: sys as sysdba
Enter password: 
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  729808896 bytes
Fixed Size          8797056 bytes
Variable Size         452985984 bytes
Database Buffers      260046848 bytes
Redo Buffers            7979008 bytes
Database mounted.
Database opened.
SQL>