Re: error: ora-27101 shared memory realm does not exist

Acid wrote:
>
> Sorry to sound stupid, kind of new to oracle, but when you say enter / as
> Sysdba, that doesn't make sense.
>
> I can enter a user/pass_at_oracleserve name, then when I press enter to move
> on, it gives the error:
>
> ORA-01034: Oracle not available
> ORA-27101: shared memory realm does not exist
>
> Then, it just gives me the prompt back for username/pass/host string box to
> login.
>
> I can't get to the sqlplus> to do a startup
>
> Thanks,
> Keith
>

Keith,

Sorry that I was not more clear.
in the sql*plus login window
(Start >> Programs >> Oracle - Orahome81 >> Application Development >> sql*plus

in the top field enter - / as sysdba

provided that you only have one database that you want to connect to, and that the value of ORACLE_SID is populated. To set this environment variable, go into the control panel >> system >> advanced >> Environment Variables.
This variable can be set system-wide, or specific to the current user. In the lower panel you will see "System variables". If the variable ORACLE_SID already exists, check to see that the value is current.
If it does not exist, click "New".
For the Variable Name: - enter ORACLE_SID For the Vairable Value: - enter <your_sid> (e.g. DEV) click OK.
click ok
click ok.

close any open Command Prompt windows, as they have not inherited the change yet.
try again to connect via sqlplus with the login string "/ as sysdba"

hth,

Paul

> "Paul Drake" <paled_at_home.com> wrote in message
> news:3AD55433.6AFE2ED6_at_home.com...
> > Acid wrote:
> > >
> > > error: ora-27101 shared memory realm does not exist
> > >
> > > While installing on 2K box, it gave a few strange memory errors, but I
> > > ignored like a good engineer and it continued to the finish.
> > >
> > > Now, after setup, when trying to connect with SQL*PL, I get that above
> > > error. First, I get the Oracle not available message, followed by the
 one
> > > above.
> > >
> > > Is there a web site for support and knowledge base to search for this
 kind
> > > of stuff? I went to technet.support.com, it didn't have anything,
 pretty
> > > much unnavigable to me. Maybe it's late, but I wonder about these so
 called
> > > gurus and their site layouts and support.
> > >
> > > Anyway, any ideas appreciated.
> > >
> > > Keith
> >
> >
> > Most likely, the NT Service was started, but the Oracle instance was
> > not.
> > startup sql*plus and connect as sysdba:
> >
> > in the user field, enter / as sysdba
> > you should get the banner in the sql*plus window.
> >
> > type
> >
> > SQLPLUS> startup
> >
> > and you should see the instance come up.
> >
> > if not, you may have to specify the full path to the init<SID>.ora file,
> > e.g.
> >
> > SQLPLUS> startup pfile='D:\Oracle\Admin\DEV\initDEV.ora'
> >
> > hth,
> >
> > Paul
> >
Received on Sun Apr 15 2001 - 13:58:35 CDT