数据库在执行shutdown immediate后用非SYS用户登录SQL*Plus报此错;
[oracle@PROD ~]$ sqlplus scott/tiger SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 7 13:42:28 2017 Copyright (c) 1982, 2009, Oracle. All rights reserved. ERROR: 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 Enter user-name:
解决办法:SYS登录启库,其它连接即可用非SYS用户登录SQL*Plus。
会话1
SYS@itkaifang> startup ORACLE instance started. Total System Global Area 830930944 bytes Fixed Size 2217912 bytes Variable Size 507512904 bytes Database Buffers 318767104 bytes Redo Buffers 2433024 bytes Database mounted. Database opened. SYS@itkaifang>
会话2
[oracle@itkaifang ~]$ sqlplus scott/tiger SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 7 13:48:37 2017 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Session altered. SCOTT@itkaifang>