Re: ORA-1224 TNS

Karim,

Here is the full text for error 12224:

"ORA-12224: TNS:no listener
Cause: The connection request could not be completed because the listener is not running.

Action: Ensure that the supplied destination address matches one of the addresses used by the listener - compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to go by way of an Interchange). Start the listener on the remote machine."

Go to Control Panel/Services and scroll down to see if the listener is running. It should be called something like:

"OracleTNSListener" and the word "Started" should be to the right of it. Sometimes you can "bounce" the listener by stopping then starting the service and get connectivity back.

Also, consider using "SQL*NET Easy Configuration" and/or "NET8 Easy Configuration" to properly setup your TNS.

Email me at Rock_cogar_at_my-deja.com if you need more help.

Rock Cogar
Radian International LLC.
Oak Ridge, TN, USA.

In article <848323$aci$1_at_nnrp1.deja.com>,   kravdjee_at_lemel.fr wrote:
> Hi everybody,
>
> I've got on my NT server IBM Websphere 3.0 (Standard Edition) and I've
> installed Oracle 8.0.
> Everytime I restart my computer the error ORA-12224 TNS (No
> listener)occurs.
> I don't know why :(
> Has someone already encountered this problem ?
>
> Thx a lot
>
> Karim
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 29 1999 - 16:21:03 CET