Re: Error 12203- TNS -unable to establish connection

In sqlnet.ora set

TRACE_LEVEL_CLIENT=16 You'll receive a huge sqlnet.trc file, but it'll show you all errors which actually happened, including the real one. 12203 is only the tip of the iceberg...

In article <7cimap$eeb$1_at_nnrp1.dejanews.com>,   arunal_at_hotmail.com wrote:
> Hi, Environment:Windows 95,Oracle server 7.3.x ,Forms 5.0 When I connect from
> forms5.0 to the database I get an error ORA:12203 TNS unable to connect to
> destination. I get the same error when i am trying to connect from sqlplus
> 3.3 also.
>
> This is my Listener.ora
> LISTENER =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (Host = app_19_95w)
> (Port = 1521)
> )
> (ADDRESS =
> (PROTOCOL = TCP)
> (Host = 127.0.0.1)
> (Port = 1521)
> )
> # (ADDRESS =
> # (PROTOCOL = SPX)
> # (Service = app_19_95w_lsnr)
> # )
> )
> STARTUP_WAIT_TIME_LISTENER = 0
> CONNECT_TIMEOUT_LISTENER = 10
> TRACE_LEVEL_LISTENER = OFF
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = ORCL)
> )
> )
>
> THis is my tnsnames.ora
>
> #This is a SQL*Net Configuration file generated by SQL*Net Easy
Configuration.
> #Attention: Do not modify this file yourself.
> #If you do, your SQL*Net Easy Configuration may not function properly.
>
> Example1.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = Production1)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = SID1)
> )
> )
> Example2.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = spx.world)
> (PROTOCOL = SPX)
> (Service = Server_lsnr)
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
> Example3.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = nmp.world)
> (PROTOCOL = NMP)
> (Server = FinanceServer1)
> (Pipe = ORAPIPE)
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
> Tcp-loopback.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = 127.0.0.1)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
> Beq-Local.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = beq.world)
> (PROTOCOL = BEQ)
> (PROGRAM = oracle73)
> (ARGV0 = oracle73ORCL)
> (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
> orcl.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = 192.168.1.85)
> (Port = 1521)
> )
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = 192.168.1.85)
> (Port = 1526)
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
> shin.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = 192.168.98.12)
> (Port = 1521)
> )
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = 192.168.98.12)
> (Port = 1526)
> )
> )
> (CONNECT_DATA = (SID = SHIN)
> )
> )
>
> My sqlnet.ora
>
> TRACE_LEVEL_CLIENT = OFF
> names.directory_path = (TNSNAMES)
> names.default_domain = world
> name.default_zone = world
> names.default_domain=world
>
> I have to connect to database instance with SID - SHIN. I tried including
shin
> in listener.ora, but i am not able to solve the problem..
> Could anyone help me on this???
>
> thanks in advance,
> aruna
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 16 1999 - 03:13:31 CET