Re: help connecting to sqlplus

yes, the instance was not started.
now when the instance has been started i get a different error i have tried doing shutdown immediate and then again startup but still this error comes up.

"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 - 08:29:10 CST