Can't Connect with / as sysdba
605891May 29 2009 — edited May 30 2009Hi guys
i got 2 node RAC cluster running on RHEL 5.0 with oracle version 10.2.0.4 .. i can connect to database with sys and system but when ever i try to connect with conn / as sysdba it always says Connected to an idle instance and when i take sid in export and run the sqlplus with username and password its same problem but when i use connection string it work well.. any hint or idea where i am wrong..
[oracle@eregtest1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Fri May 29 15:04:01 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
[oracle@eregtest1 ~]$ sqlplus sys/eregtest
SQL*Plus: Release 10.2.0.4.0 - Production on Fri May 29 15:05:24 2009
Copyright (c) 1982, 2007, 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
SQL> exit
Disconnected
[oracle@eregtest1 ~]$ sqlplus sys/eregtest@eregtest1 as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Fri May 29 15:04:07 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL>