From: ddf_dba@my-deja.com
Subject: Re: UPDATE: ORA-01033: ORACLE initialization or shutdown in progress
Date: 2000/04/04
Message-ID: <8cdfcn$j0e$1@nnrp1.deja.com>#1/1
References: <8c8mpn$b6m$1@nnrp1.deja.com> <8cb2d1$uf6$1@nnrp1.deja.com> <38E96A59.8477D3A3@erols.com>
X-Http-Proxy: 1.1 x36.deja.com:80 (Squid/1.1.22) for client 38.197.71.100
Organization: Deja.com - Before you buy.
X-Article-Creation-Date: Tue Apr 04 19:22:16 2000 GMT
X-MyDeja-Info: XMYDJUIDddf_dba
Newsgroups: comp.databases.oracle.server
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)


In article <38E96A59.8477D3A3@erols.com>,
jgitomer@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@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@nnrp1.deja.com>,
> > Ken Kinder <kkinder@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.