當SID=racdb時 當sys system 分別 報錯 ORA-27101: shared memory realm does not exist
來源：互聯網
上載者：User
一、 system使用者 [oracle@t1 ~]$ sqlplus system/manager@racdb1
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Sep 2 15:07:29 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> conn strmadmin/strmadmin ERROR: ORA- 01034: ORACLE not available ORA- 27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory
Warning: You are no longer connected to ORACLE. SQL> ho [oracle@t1 ~]$ env | grep ORA ORACLE_SID=racdb ORACLE_BASE=/u1/oracle ORACLE_HOME=/u1/oracle/product/10.2.0/db_1
bash: exot: command not found
二、 sys使用者 [oracle@t1 ~]$ sqlplus sys/sys@racdb1 as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Sep 2 15:08:49 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> conn strmadmin/strmadmin ERROR: ORA- 01034: ORACLE not available ORA- 27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory
Warning: You are no longer connected to ORACLE.
SQL> conn strmadmin/strmadmin ERROR: ORA- 01034: ORACLE not available ORA- 27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory
Warning: You are no longer connected to ORACLE. SQL> conn strmadmin/strmadmin ERROR: ORA- 01034: ORACLE not available ORA- 27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory
SQL> show user USER is "" SQL> exit 上面這種方法 可以這樣解決不 1 export ORACLE_SID=racdb sqlplus system/manager@racdb1 報錯
