Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: help connecting to sqlplus

Re: help connecting to sqlplus

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Wed, 20 Nov 2002 21:33:41 GMT
Message-ID: <VcTC9.72$zc7.11493708@newssvr14.news.prodigy.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US