ORA-27101: shared memory realm does not exist

[Vimala]

Can someone identify the problem in from the below....This is solaris flatform. Problem in short is...if I login to sqlplus as oracle(os user) then, it works without connect string, if I login to sqlplus as another OS user, it works with connect string but not without connect string.


psdevfm1 21: su - oracle
Password:
Sun Microsystems Inc. SunOS 5.8 Generic Patch October 2001
[oracle@psdevfm1] $ sqlplus eastdev1/eastdev1

SQL*Plus: Release 8.1.7.0.0 - Production on Tue May 11 16:23:45 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
[oracle@psdevfm1] $ exit
logout
psdevfm1 22: sqlplus eastdev1/eastdev1

SQL*Plus: Release 8.1.7.0.0 - Production on Tue May 11 16:24:09 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory


Enter user-name: ^C
psdevfm1 25: sqlplus eastdev1/eastdev1@efmdev1

SQL*Plus: Release 8.1.7.0.0 - Production on Tue May 11 16:24:32 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SQL>


I would really appreciate if someone can figure it out.

Thanks,
Vimala

[marist89]

Either your environment is setup wrong or you aren't a member of the DBA group.