Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: help connecting to sqlplus
I was having this same error yesterday, I just waited a few minutes and
tried again and was connected.
"brian" <brian_dellong_at_yahoo.com> wrote in message
news:a74ee6e1.0211210115.3417bb80_at_posting.google.com...
> i started the instance and now i get this error
> (am on the server box itself)
>
> ERROR: ORA-01033: ORACLE initialization or shutdown in progress
>
>
>
> TurkBear <john.greco_at_dot.state.mn.us> wrote in message
news:<4i0otusholp3t7mefnq7vg4svenkd09rjj_at_4ax.com>...
> > In addition to that, are you sure the INSTANCE is started...
> > The tnsping just tries to contact the host's listener specified in
tnsnames.ora but does not indicate that the Oracle
> > database is actually up and running..
> >
> > Karsten Farrell <kfarrell_at_belgariad.com> wrote:
> >
> > >brian wrote:
> > >> trying to connect to sqlplus and getting an error
> > >> Error: ORA-01034 : Oracle not available
> > >>
> > >> tnsping to global database name is successful
> > >>
> > >> since this is a fresh install i am logging in as
> > >> username: SYSTEM
> > >> passwd : manager
> > >> HostString: global db name (and tnsping to this is successful)
> > >> (all services running, except managememt server service)
> > >Question: Are you and your server on opposite sides of a firewall? When
> > >tnsping works, but sqlplus doesn't, usually the problem occurs after
> > >you've successfully carried out a handshake with the listener (which is
> > >all tnsping really does). The "conversation" with sqlplus takes place
on
> > >a randomly-chosen port (not 1521).
Received on Thu Nov 21 2002 - 06:52:43 CST