Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> REPOST: Re: TNSNAMES - Listener problem
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...Received on Fri Jan 25 2002 - 11:02:30 CST
> 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???
>
>
========= WAS CANCELLED BY =======: From: "Pete Sharman" <peter.sharman_at_oracle.com> Control: cancel <Tag48.8$If3.146_at_inet-nntp1.oracle.com> Subject: cmsg cancel <Tag48.8$If3.146_at_inet-nntp1.oracle.com> Date: Mon, 28 Jan 2002 02:10:17 GMT Message-ID: <cancel.Tag48.8$If3.146_at_inet-nntp1.oracle.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!news.belwue.de!news.uni-ulm.de!rz.uni-karlsruhe.de!blackbush.xlink.net!blackbush.de.kpnqwest.net!netnews.web.de!newsfeed01.sul.t-online.de!t-online.de!fr.clara.net!heighliner.fr.clara.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40722713 This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.