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

You need to assign a name to your computer ( Either a friendly name like "mycomputer" or a ip address "10.1.1.20"

Once you have done this edit the tnslistener file to reflect the host name
ie HOST=mycomputer or HOST=10.1.1.20

I am not that familiar with personal oracle but that's the way it works with the full blown oracle

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 - 16:59:24 CST