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

From: Sekhar Surapaneni <surapaneni.s_at_worldnet.att.net>
Date: 26 Feb 1999 17:35:56 GMT
Message-ID: <7b6m1s$2qd_at_bgtnsc03.worldnet.att.net>



Hi,

[Quoted] [Quoted] I bought a trial version of Personal Oracel 8.0 for windows 95 and Developer [Quoted] 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 [Quoted] "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 [Quoted] 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 [Quoted] 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 - 18:35:56 CET

Original text of this message