Re: help connecting to sqlplus

Do a shutdown abort - then a startup nomount then a shutdown normal, startup pfile=yourinit<sid>.ora - If this does not help, ( I do not remember if you are on Windows, but if so, set the Oracle services to Manual first) , reboot and try again after manually starting the Listener then the OracleInstance service ).. Ig=f thta takes care of it, reset the services to Automatic ( make the Oracle one dependent on the Listener) - again assuming Windows

If it stills gives that error, contact Oracle support to help debug your init<sid>.ora file as something there may be causing the 'hang'

brian_dellong_at_yahoo.com (brian) wrote:

>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:49:17 CST