Re: Error 12203- TNS -unable to establish connection

hi,

   thanx. it is working fine now.
aruna l

In article <7cj990$u86$1_at_nnrp1.dejanews.com>,   cary_at_nams.net wrote:
> Hello,
>
> First, add shin to the SID LIST in your LISTENER.ORA file. You must
> restart the listener for the changes to take effect. If this still does not
> do the trick, doublecheck that the IP address corresponding to app_19_95w is
> really 192.168.98.12. Is the IP address for the machine w/Oracle Server
> 7.3.x fixed? If you put app_19_95w instead of 192.168.98.12 in your
> TNSNAMES.ORA file, can you resolve the IP? You can test this w/tnsping.
> Hope this helps.
>
> Cary
>
> 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
>

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