Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: help connecting to sqlplus
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:33:41 CST
![]() |
![]() |