REPOST: Re: TNSNAMES - Listener problem

Thank you, Pete, for responding. I mucked around, and think that I have solved the problem, at least for time being. I can now connect successfully to my DB.
Bill...

"Pete Sharman" <peter.sharman_at_oracle.com> wrote in message news:4rl48.16$If3.279_at_inet-nntp1.oracle.com...
> I can't find a similar issue logged as a bug, so turn tracing on for the
> listener and see if you get any more information from the trace file.
>
> --
> 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:a2sl8s$qbq$1_at_slb6.atl.mindspring.net...
> > Problem arises when I attempt to 'connect' from OEM console. When I get
> the
> > error message, I check 'Services' to see if the Listener is still in the
> > 'started' position, and it isn't, so I have to manually restart it
again.
> > Then, I toggle back to the OEM console, and I then connect, but within
> > seconds, I get the error message again. Its a real 'PITA.' Any
> suggestions
> > on how to correct this?
> >
> > "Pete Sharman" <peter.sharman_at_oracle.com> wrote in message
> > news:Tag48.8$If3.146_at_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???
> > > >
> > > >
> > >
> > >
> >
> >
>
>

• WAS CANCELLED BY =======: From: "William O'Neill" <wfoneill_at_mindspring.com> Control: cancel <a2tctq$gpd$1_at_slb7.atl.mindspring.net> Subject: cmsg cancel <a2tctq$gpd$1_at_slb7.atl.mindspring.net> Date: Mon, 28 Jan 2002 01:00:46 GMT Message-ID: <cancel.a2tctq$gpd$1_at_slb7.atl.mindspring.net> 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.ruhr-uni-bochum.de!news-koe1.dfn.de!news-fra1.dfn.de!newsfeed.hanau.net!fr.clara.net!heighliner.fr.clara.net!news.tele.dk!small.news.tele.dk!209.98.98.64!news-out.visi.com!hermes.visi.com!nntp5.savvis.net!nntp.cifnet.net!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:40721134

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Sat Jan 26 2002 - 00:54:29 CST