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

Try this it worked for me.

Patrick Flahan
flahan_at_earthlink.net

Installing Personal Oracle 8.0x:

When you install PO8 you have to install 'Oracle Networking Products 2.3.4.0.2'. This option includes 'SQL*Net 2.3.4.0.2' and the 'Oracle Protocol Adapters' (Named Pipes, SPX & TCP/IP). At the end you should have installed SQL*Net 8.0.x & 2.3.4.0.2 and Oracle Protocol Adapters 8.0.x & 2.3.4.0.0.

Installing Developer 2.1:

SQL*Net is still installed and therefore it will not be installed when you p.e. install FORMS 5 (the SQL*Net-version on the Developer-CD is an older version). You shouldn't install SQL*Net yourself!!

Now you should be able to connect from Developer 2.1 (FORMS 5, REPORTS 3, SQL*Plus 3.3) to the Oracle 8-database.

Sekhar Surapaneni <surapaneni.s_at_worldnet.att.net> wrote in message news: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 Tue Mar 02 1999 - 16:45:56 CET