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: William O'Neill <wfoneill_at_mindspring.com>
Date: Fri, 25 Jan 2002 16:10:47 -0800
Message-ID: <a2sl8s$qbq$1@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???
> >
> >
>
>
Received on Fri Jan 25 2002 - 18:10:47 CST

Original text of this message

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