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

Whatever you type as the HOST name must be pingable. Your host name is most likely your machine name or something that resolves to 127.0.0.1 (the internal loop back address).

Sekhar Surapaneni wrote in message <7b6m1s$2qd_at_bgtnsc03.worldnet.att.net>...
>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 - 20:50:12 CET