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

Hello,

  There are several issues here. First, edit the LISTENER.ORA file in the Net8\admin directory, and change the entry with host=Default to host=127.0.0.1. Hopefully, this will allow you to start the listener wo/errors. Second, the SQL*Plus 8.0 client uses the TNSNAMES.ORA and SQLNET.ORA files located in the Net8\admin directory, while both SQL*Plus 3.? and before and the Developer apps use the TNSNAMES.ORA and SQLNET.ORA files in Network\admin. The Net8 files can be modified using a simple text editor or SQL Net8 Easy Configuration, and the SQLNet v2 files can be modified with an editor or SQL Net Easy Configuration. Both sets of files should be configured to allow connections to your local db. In doing so, make sure that the SIDs and port numbers in the TNSNAMES.ORA files match those specified in the LISTENER.ORA file. If you are still unable to connect w/SQL*Plus 3.0 or the Developer apps, e-mail me directly cary_at_nams.net with your LISTENER.ORA, TNSNAMES.ORA, and SQLNET.ORA files and the exact error messages you are getting.

Cheers,
Cary

In article <7b6m1s$2qd_at_bgtnsc03.worldnet.att.net>,   "Sekhar Surapaneni" <surapaneni.s_at_worldnet.att.net> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Feb 26 1999 - 21:18:33 CET