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

Home -> Community -> Usenet -> c.d.o.server -> Re: TNSNAMES - Listener problem

Re: TNSNAMES - Listener problem

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Fri, 25 Jan 2002 09:02:30 -0800
Message-ID: <Tag48.8$If3.146@inet-nntp1.oracle.com>


When you say you attempt to log on from the console, what exactly do you mean? The OEM console? The only problem I've found is Bug:1745498, where TNSPING returns a no listener error but SQL*Plus actually connects. Have you tried a straight SQL*Plus connection?

--
HTH.  Additions and corrections welcome.

Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

"William O'Neill" <wfoneill_at_mindspring.com> wrote in message
news:a2qvaf$jgj$1_at_slb4.atl.mindspring.net...

> Am using Oracle 9i(Enterprise) on WIN2K at home, in a non-networked
> environment. It seems that with increasing frequency, I'm getting this
error
> message, particularly when I attempt to logon from the console, eg. ORA -
> 12541 - TNS: no listener. I then have to leave the Console and start the
> listener service manually. I know that the listener has been started
before
> I access the Console, because I've checked it. Seems that this error only
> happens when I'm in the Console. Other than that, the DB works great.
Any
> ideas???
>
>
Received on Fri Jan 25 2002 - 11:02:30 CST

Original text of this message

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