一、 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
报错
2
[oracle@t1 ~]$ export ORACLE_SID=racdb1
dba
conn strmadmin/strmadmin
不报错