Re: ORA - 12203: TNS : Unable to connect to destination

Hi Sekhar,
General question: Do you have your \windows\hosts file properly set up ? You should have the following line in it
127.0.0.1 localhost
If you don't find it, copy the hosts.sam in the same directory to hosts. (so without extension) and verify whether the localhost line is in it. Also it looks like your listener.ora is incorrect. It is now expecting a host default, which should be localhost.
Please verify both your listener.ora and tnsnames.ora for the correct host name.

This should resolve your problem.

Hth,

Sybrand Bakker, Oracle DBA

Sekhar Surapaneni wrote:

> Hi,
>
> I bought a trial version of Personal Oracel 8.0 for windows 95 and Developer
> 2000 for windows 95 rel 2.1. I have installed them in my computer. Before i
> was not able to connect to the database either via SQL*Plus 8.0 or SQL*Plus
> 3.0. When i tried to connect to the database from Developer 2000 forms i got
> "ORA- 03121- No interface driver connected- function not performed." error
> message.
>
> But afterwards i made some changes like at the DOS prompt i typed SVRMGR30
> and i was able to mount the database using internal/oracle. So now i am able
> to connect to the database via SQL*Plus 8.0 using system/manager or
> scott/tiger. This is working properly now.
>
> Then i created a database alias using SQL *Net easy configuration. And the
> Protocol Adaptor that i selected was TCP/IP and i entered "localhost" for
> the TCP/IP Host name. i was able to create a database alias.
>
> Then from the DOS prompt I started the listener. Here i got some errors:
>
> C:\ORAWIN95>lsnrctl80
>
> LSNRCTL80 for 32-bit Windows: Version 8.0.4.0.0 - Production on 26-FEB-99
> 11:12:
> 38
>
> (c) Copyright 1997 Oracle Corporation. All rights reserved.
>
> Welcome to LSNRCTL, type "help" for information.
>
> LSNRCTL> start
> Starting tnslsnr80: please wait...
>
> TNSLSNR80 for 32-bit Windows: Version 8.0.4.0.0 - Production
> System parameter file is C:\ORAWIN95\net80\admin\listener.ora
> Log messages written to C:\ORAWIN95\net80\log\listener.log
> Trace information written to C:\ORAWIN95\net80\trace\listener.trc
> Attempted to listen on:
> (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)
> (Host=Default)(Port=1521)))
> TNS-12545: Connect failed because target host or object does not exist
> TNS-12560: TNS:protocol adapter error
> TNS-00515: Connect failed because target host or object does not exist
> 32-bit Windows Error: 1004: Unknown system error
>
> Again i tried to connect to the database via Developer 2000 forms i got this
> error message: "ORA - 12203: TNS : Unable to connect to destination.".
>
> Now i am stuck here. I would really appreciate any help.
>
> Thanks in advance.
>
> Jyotsna

Received on Fri Feb 26 1999 - 13:12:23 CST