Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TNSNAMES - Listener problem
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...Received on Fri Jan 25 2002 - 17:01:07 CST
> 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???
> > >
> > >
> >
> >
>
>