Re: Error 12203- TNS -unable to establish connection

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 Received on Mon Mar 15 1999 - 16:33:51 CET