TNS:name lookup failure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: TNS:name lookup failure

  1. #1
    Join Date
    Apr 2001
    Posts
    69
    HI,

    We have recently installed Oracle817 on VMS. When I try to connect to the database using sqlplus or oracle forms, I get 'ORA-12545:TNS:name lookup failure' error. Entries in tnsnames.ora and listener.ora are ok. ping and tnsping work fine. However, if I include an entry for this server with the IP address in the /etc/hosts file on the local client machine, it works fine. But there are no entries in this hosts file for other servers (we have 3 servers) which work fine. I would appreciate your help.

    These are the listener.ora and tnsnames.ora file entries:

    listener.ora
    ========
    LISTENER=
    (ADDRESS_LIST=
    (ADDRESS=(COMMUNITY=TCP.WORLD)(PROTOCOL=tcp)(HOST= ... )(PORT=1526))
    )
    SID_LIST_LISTENER=
    (SID_LIST=
    (SID_DESC=
    (SID_NAME=NEWFLT)
    (PROGRAM = ORACLE$DISK:[ORACLE8.ORACLE817.network.admin]orasrv_netv2_NEWFLT.com)
    (prespawn_max=20)
    (prespawn_list=
    (prespawn_desc=
    (protocol=tcp)
    (pool_size=15)
    (TIMEOUT = 5)
    )
    )
    )
    )

    tnsnames.ora
    =========
    RF1.WORLD =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(HOST = ... )(PORT = 1526))
    )
    (CONNECT_DATA = (SID = NEWFLT))
    )

    ==

    Since the sql connection was slow, I have included prespawn settings in the listener.ora file.

    SPN


    NOTE: Edited out the IP address for security reasons.
    Sam


    [Edited by sambavan on 12-25-2001 at 09:37 PM]

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What is the service name of your instance. In the tnsnames.ora file, you might want to consider specifying the service_name instead of the SID_NAME. Can you make a client connection to the server using sqlplus

    Code:
           sqlplus username/password@rf1.world
    Regarding the hostname recognetion. consult with your system adminstrator(s) about the DNS looks up configureation and etc.

    How did you come to a conclusion that the sqlnet is slow?

    To make the regular connection try

    Code:
         SID_LIST_LISTENER= 
             (SID_LIST= 
                 (SID_DESC= 
                    (SID_NAME=NEWFLT) 
                    (PROGRAM = ORACLE$DISK:[ORACLE8.ORACLE817.network.admin]orasrv_netv2_NEWFLT.com) 
                     (prespawn_max=20) 
                     (prespawn_list= 
                            (prespawn_desc= 
                                 (protocol=tcp) 
                                 (pool_size=15) 
                                 (TIMEOUT = 5) 
                            ) 
                      )
                  ) 
     
                  (SID_DESC= 
                     (GLOBAL_DBNAME = ... )
                     (ORACLE_HOME = ...)
                     (SID_NAME=NEWFLT)  
                   )  
              ) 
    
    
    tnsname.ora
    
       RF1.WORLD = 
        (DESCRIPTION = 
            (ADDRESS_LIST = 
               (ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(HOST = ... )(PORT = 1526)) 
             ) 
             (CONNECT_DATA = (SERVICE_NAME = NEWFLT)) 
         ) 
    
    
    
       RF2.WORLD = 
        (DESCRIPTION = 
            (ADDRESS_LIST = 
               (ADDRESS = (PROTOCOL = TCP)(HOST = ... )(PORT = 1526)) 
             ) 
             (CONNECT_DATA = (SERVICE_NAME = NEWFLT)) 
         ) 
    
    Also Could you post the sqlnet.ora file also.
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width