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: ORA-12203, but I can do a tnsping

Re: ORA-12203, but I can do a tnsping

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 29 Nov 2004 17:34:18 +0100
Message-ID: <cofj30$e0f$4@news3.zwoll1.ov.home.nl>


ejsanchez_at_gmail.com wrote:
> Hi everybody!
> I have a singular problem, I can't connect through Forms Developer to
> my
> Oracle Database, I receive the
>
> "ORA-12203: TNS unable to connect to destination"
>
> I already have the listener running.
> The curious thing is that if I stop and restart it again, it seems to
> work for
> a couple of minutes, but after some time this error begins to
> appear....
> I also can tnsping from the machine I'm trying to access the database:
>
> Attempting to contact
> (ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=10.0.0.42)(Port=1521)
> OK (50 msec)
> The listener.log reports the following:
> 29-NOV-2004 09:19:10
> *(CONNECT_DATA=(SID=NUMAR)(CID=(PROGRAM=C:\ORANT\BIN\ifrun60.EXE)(HOST=SJ-ESM)
> (USER=esanchez))) *
> (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.1.147)(PORT=1584))
> * establish * NUMAR * 0
>
> I'm using Oracle 8.1.7 on Redhat 9.
> Any help would be appreciated.
> thanks in advance,
> -eduardo s.m.
>

Well, for one:

- tnsping only checks to see if there's a listener alive.
- I see two different port numbers; one (standard) 1521, one 1584
-- 

Regards,
Frank van Bortel Received on Mon Nov 29 2004 - 10:34:18 CST

Original text of this message

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