Board index » delphi » ERROR: ORA-12203: TNS:unable to connect to destination

Marcelo Muzill

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

ERROR: ORA-12203: TNS:unable to connect to destination

USERNAME: demo
PASSWORD: demo
HOST STRING: MyHome.world

Where MyHome.world in the TNSNAMES.ORA is:
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1521)
        )
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1526)
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

When I try to connect via ORACLE SQL *Plus with this parameters this
error occur:

----------------------------------------------------------------------------------------

SQL*Plus: Release 3.3.2.0.1 - Production on Tue Jul 28 17:51:20 1998

Copyright (c) Oracle Corporation 1979, 1994.  All rights reserved.

ERROR: ORA-12203: TNS:unable to connect to destination

Enter user-name:
-----------------------------------------------------------------------------------------

 
Roger Arnese

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:ERROR: ORA-12203: TNS:unable to connect to destination


This is not really a Delphi question, it is a pure Oracle issue.

You should consult appropriate newsgroups for this.

And, to top it all off, there is no way of knowing what is wrong there.
Since this is apparently a Personal Oracle you have installed, and you know
your way around the TNSNAMES file, why don't you just look at the expamples
provided.

Roger

Quote
Marcelo Muzilli wrote in message <35BE3B84.B22E1...@128.1.1.119>...
>USERNAME: demo
>PASSWORD: demo
>HOST STRING: MyHome.world

>Where MyHome.world in the TNSNAMES.ORA is:
>  (DESCRIPTION =
>    (ADDRESS_LIST =
>        (ADDRESS =
>          (COMMUNITY = tcp.world)
>          (PROTOCOL = TCP)
>          (Host = 127.0.0.1)
>          (Port = 1521)
>        )
>        (ADDRESS =
>          (COMMUNITY = tcp.world)
>          (PROTOCOL = TCP)
>          (Host = 127.0.0.1)
>          (Port = 1526)
>        )
>    )
>    (CONNECT_DATA = (SID = ORCL)
>    )
>  )

>When I try to connect via ORACLE SQL *Plus with this parameters this
>error occur:

>---------------------------------------------------------------------------
-------------

>SQL*Plus: Release 3.3.2.0.1 - Production on Tue Jul 28 17:51:20 1998

>Copyright (c) Oracle Corporation 1979, 1994.  All rights reserved.

>ERROR: ORA-12203: TNS:unable to connect to destination

>Enter user-name:
>---------------------------------------------------------------------------
--------------

Randy Ric

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:ERROR: ORA-12203: TNS:unable to connect to destination


Quote
Marcelo Muzilli wrote:

> USERNAME: demo
> PASSWORD: demo
> HOST STRING: MyHome.world

> Where MyHome.world in the TNSNAMES.ORA is:
>   (DESCRIPTION =
>     (ADDRESS_LIST =
>         (ADDRESS =
>           (COMMUNITY = tcp.world)
>           (PROTOCOL = TCP)
>           (Host = 127.0.0.1)
>           (Port = 1521)
>         )
>         (ADDRESS =
>           (COMMUNITY = tcp.world)
>           (PROTOCOL = TCP)
>           (Host = 127.0.0.1)
>           (Port = 1526)
>         )
>     )
>     (CONNECT_DATA = (SID = ORCL)
>     )
>   )

> When I try to connect via ORACLE SQL *Plus with this parameters this
> error occur:

> ----------------------------------------------------------------------------------------

> SQL*Plus: Release 3.3.2.0.1 - Production on Tue Jul 28 17:51:20 1998

> Copyright (c) Oracle Corporation 1979, 1994.  All rights reserved.

> ERROR: ORA-12203: TNS:unable to connect to destination

> Enter user-name:
> -----------------------------------------------------------------------------------------

If you are using personal oracle you need not concern yourself with the
tnsnames.ora, the connect is not made through SQL-net.

If you are connecting to a server, it doesn't appear that you have setup
a database alias through the sqlnet easy configuration.

Email me with more information at t...@iamerica.net and I can walk you
through this.

Other Threads

1. Oracle and Delphi -Ora-12203

2. ORA-12571, TNS Packed writer error.

3. Error Msg 12203 on Oracle 7 and Windows 98 Client

4. ORA 12154 - Could not resolve TNS Names (Help!)

5. ORA-12505 TNS: listener could not resolve SID (with two Oracle instances)

6. Help with error ORA-04031 unable to allocate 740 bytes of shared memory

7. Error ORA-03121 (no interface driver connected)

8. Connecting to Oracle without a TNS Alias

9. Oracle Errors ORA-03113 and ORA-01041

10. ORA-01019: Unable to allocate memory in the user side