Error 12203- TNS -unable to establish connection

From: <arunal_at_hotmail.com>
Date: Mon, 15 Mar 1999 10:10:37 GMT
Message-ID: <7cimap$eeb$1_at_nnrp1.dejanews.com>

[Quoted] [Quoted] 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.
[Quoted] #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 [Quoted] 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 Received on Mon Mar 15 1999 - 11:10:37 CET