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

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.