Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UPDATE: ORA-01033: ORACLE initialization or shutdown in progress
In article <38E96A59.8477D3A3_at_erols.com>,
jgitomer_at_erols.com wrote:
> Ken Kinder wrote:
> >
> > Thanks for everyone's suggestions. Overnight (I don't know why), I
don't
> > know why, but it now returns ORA-01033: ORACLE initialization or
> > shutdown in progress when connecting over a TCP/IP listener.
> >
> > I can use sqlplus locally using an IPC listener, and run quieries
fine.
> > When I try adding the user/pass_at_service part, it gives me ORA-01033:
> > ORACLE initialization or shutdown in progress
> >
> > This message is also returned from clients on other machines trying
to
> > connect to the database.
> >
> > If this helps shed some light on why this is happenning, I would
> > appreciate anyone's suggestions. I know the database is running
nicely,
> > as I can run queries on non-TCP connections.
> >
> > Thanks BTW.
> >
> > In article <8c8mpn$b6m$1_at_nnrp1.deja.com>,
> > Ken Kinder <kkinder_at_my-deja.com> wrote:
> > > For some reason, when I connect over TCP/IP listeners, I am
getting
> > > ORA-01034: ORACLE not available
> > > This happened after a reboot. I used dbstart to restart the
database
and
> > > restarted the listener as well. I can connect using sqlplus
directly
on
> > > the server, and run queries, so I know the database is OK. The
problem
> > > is then certainly in the listener.
> > > Yes, the SID is set correctly.
> > > Can anyone give me some direction here?
> > > (oracle8i/RH Linux)
> > > --
> > > Ken Kinder
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> > >
> > --
> > Ken Kinder
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
I agree. Any time a database is the subject of a power loss I always shutdown the instance immediate and start it up again, to make certain that everything is running smoothly. I have experienced a number of complications because an instance did not start cleanly, even hanging on a local SQL*Plus connection; after a shutdown and startup the database connections worked without incident. Shut the instance down, and start it up again.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Apr 04 2000 - 00:00:00 CDT