Re: help connecting to sqlplus

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 Wed Nov 20 2002 - 15:46:54 CST