Re: UPDATE: ORA-01033: ORACLE initialization or shutdown in progress

From: Ken Kinder <kkinder_at_my-deja.com>
Date: 2000/04/05
Message-ID: <8cfcjq$m9p$1@nnrp1.deja.com>#1/1

I've restarted the database several times. Is there anything I should to specifically to make sure the database files are intact?

Something tells me it's in the listener, as IPC SQL*Plus seems to work though...

In article <8cdfcn$j0e$1_at_nnrp1.deja.com>,   ddf_dba_at_my-deja.com wrote:
> 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.
> >
> > Have you bounced the database since your restarted it after the
> > power loss? The ORA-1033 leads me to suspect that Oracle did not
> > come up cleanly, yeah I know it really should be okay, but when
> > you get a power loss funny things can happen -- and the message
> > changing from ORA-1034 to ORA-1033 is suspicious.
> >
> > --
> > Jerry Gitomer
> > Once I learned how to spell DBA, I became one
> >

>

> 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.

>

--
Ken Kinder


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Wed Apr 05 2000 - 00:00:00 CDT