Re: Again tns 12154

From: Kevin J Barnes <kbarnes_at_airmail.net>
Date: 1997/03/09
Message-ID: <3324011d.40535000@news.airmail.net>#1/1

Your TNSNAMES.ora file looks werid. Why is there a listener entry in it? Here is a copy of my TNSNAMES.ora file for connecting from a PC to my NT server. Notice the .world entries.

12154 means unable to find the name (TEST) in the tnsnames.ora file. How did you create the tnsnames.ora entries? I have had problems when editing the file by hand and adding entries at the end of the file. Lotsa times it does not like it. I usually will insert new entries in the middle or change the sample entries and copy the same file over.

Kevin

tnsnames.ora

nttcp.world =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = tcp.world)

          (PROTOCOL = TCP)

          (Host = 10.0.0.4)

          (Port = 1521)

        )
        (ADDRESS = 


          (COMMUNITY = tcp.world)

          (PROTOCOL = TCP)

          (Host = 10.0.0.4)

          (Port = 1526)

        )

    )
    (CONNECT_DATA = (SID = ivy)
    )
  )

On Fri, 07 Mar 1997 09:09:11 +0100, axime <axime_at_ipf.de> wrote:

>Yes, again tns 12154...

>
>> cat $ORACLE_HOME/network/admin/tnsnames.ora
>LISTENER=
>(DESCRIPTION =
>  (ADDRESS_LIST =
>   (ADDRESS = 
>    (PROTOCOL = IPC)
>    (KEY = TEST)
>   )
>  )
> (CONNECT_DATA =
>   (SID = TEST)
> )
>)
>TEST=
>(DESCRIPTION =
>  (ADDRESS_LIST =
>   (ADDRESS = 
>    (PROTOCOL = TCP)
>    (HOST = 192.1.1.1)
>    (PORT = 1529)
>   )
>  )
> (CONNECT_DATA =
>   (SID = TEST)
> )
>)
>
>
>
>lsnrctl
>
>LSNRCTL for IBM/AIX RISC System/6000: Version 2.3.2.1.0 - Production on
>07-MAR-97 09:01
>:03
>
>Copyright (c) Oracle Corporation 1994.  All rights reserved.
>
>Welcome to LSNRCTL, type "help" for information.
>
>LSNRCTL> status TEST
>Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=192.1.1.1)(PORT=1529))
>STATUS of the LISTENER
>------------------------
>Alias                     TEST
>Version                   TNSLSNR for IBM/AIX RISC System/6000: Version
>2.3.2.1.0 - Pro
>duction
>Start Date                06-MAR-97 17:09:45
>Uptime                    0 days 15 hr. 51 min. 23 sec
>Trace Level               off
>Security                  OFF
>SNMP                      ON
>Listener Parameter File  
>/oracle/app/oracle/product/7.3.2/network/admin/listener.ora
>Listener Log File        
>/oracle/app/oracle/product/7.3.2/network/log/test.log
>Services Summary...
>  TEST         has 1 service handler(s)
>The command completed successfully
>>

Received on Sun Mar 09 1997 - 00:00:00 CST