Re: Newbee: ORA-27101: shared memory realm does not exist

From: Christian Ruediger <ruediger_at_rbg.informatik.tu-darmstadt.de>
Date: Tue, 20 Jan 2004 16:32:09 +0100
Message-ID: <bujk65$lu0$1_at_news.tu-darmstadt.de>


Christian Ruediger wrote:
> Hello folks,
>
> i am new to oracle so i'm sorry if my question is trivial.
> I have Installen Oracle 8.1.7 successful on a SUN SOLARIS System.
> Now i would like create a new database manually as describes in the
> Administrators Manual. Thus i am trying to get connectet with sqlplus.
> So here is my Problem:
> Each time I'd like to connect in sqlplus I get the following
> Error-Message:
> ERROR:
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> SVR4 Error: 2: No such file or directory
>
> I discovered that I get this Message independent of the username and
> password i inserted before. So i assumed that my user password
> combination is not known to oracle.
> How do get get to know which users exist for oracle administration?
> Or has anyone an Idea why i cant connect.
>
> I've searched the net for answers but i havent found any matches yet.
>
> This is what i did to connect:
>
> bash-2.03$ ./sqlplus /nolog
>
> SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jan 20 16:18:28 2004
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> SQL> connect userX As sysdba
> Enter password:
> ERROR:
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> SVR4 Error: 2: No such file or directory
>

My Question is already answered.
I didnt start the instance.
The following lines fixed that:

sqlplus /nolog

   connect / as sysdba
   startup
   exit Received on Tue Jan 20 2004 - 16:32:09 CET

Original text of this message