sdg <stefano1_at_att.net> wrote in message news:<3EAC311A.8C812AAE_at_att.net>...
> I get to the startup on the second method, and that is where I use
> startup. My question is why 'not' using a password in the connect string
> gets me an error where using a password in the connect string does not....
> it get me to the connected to idle instance where I enter the startup
> info.
>
>
> Ryan wrote:
>
> > "sdg" <nospan_at_noway.org> wrote in message
> > news:3EABEA99.EB596171_at_noway.org...
> > > Using 8.1.7.0.0
> > >
> > > When I use SQLPlus to start database following happens and I can not
> > > determine if this is correct.
> > >
> > > Connect abc as sysdba
> > > Enter password: ******
> > > ERROR:
> > > ORA-01034: ORACLE not available
> > > ORA-27101: shared memory realm does not exist
> > >
> > > connect abc/password as sysdba
> > > Connected to an idle instance.
> > > SQL>
> > >
> > > Entering the password as opposed to not causes this error and is
> > > correct?
> > >
> > >
> > >
> >
> > you need to startup the database.
> >
> > go to the command line of the server.
> >
> > sqlplus
> > / as SYSDBA
> > startup
> >
> > then try to connect
> >
> > or try sys/change_on_install as SYSDBA
Id have to guess at this one and I may be wrong. possibly because the
instance isnt started so the rules are slightly different for logging
in. dunno. never bothered to figure it out.
Received on Mon Apr 28 2003 - 06:04:37 CDT
