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

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

"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 Sat Apr 14 2001 - 20:03:00 CDT