1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

cSnet Tracker tracking exception ORA-12154: TNS: could not resolve (Windows 7 client

Discussion in 'SQL PL/SQL' started by sdeas34, Feb 23, 2011.

  1. sdeas34

    sdeas34 Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    cSnet Tracker tracking exception ORA-12154: TNS: could not resolve the connect identifier (Windows 7 client) I followed a previous thread with this issue and pulled my LSNRCTL status and it seems to have conflicting information when it comes to the ip address and domain name

    LSNRCTL for 32-bit Windows: Version 10.1.0.5.0 - Production on 23-FEB-2011 08:46
    :06

    Copyright (c) 1991, 2004, Oracle. All rights reserved.

    Welcome to LSNRCTL, type "help" for information.

    LSNRCTL> HELP
    The following operations are available
    An asterisk (*) denotes a modifier or extended command:

    start stop status
    services version reload
    save_config trace change_password
    quit exit set*
    show*

    LSNRCTL> STATUS
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.18.10)(PORT=1521)
    ))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 10.1.0.5.0 - Produ
    ction
    Start Date 06-JAN-2011 09:06:07
    Uptime 47 days 23 hr. 40 min. 15 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File D:\Oracle\Ora10g\network\admin\listener.ora
    Listener Log File D:\Oracle\Ora10g\network\log\listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.18.10)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SYNAPPS01.SCDPS.net)(PORT=8080))(Pre
    sentation=HTTP)(Session=RAW))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SYNAPPS01.SCDPS.net)(PORT=2100))(Pre
    sentation=FTP)(Session=RAW))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "snet.world" has 1 instance(s).
    Instance "snet", status READY, has 1 handler(s) for this service...
    Service "snetXDB.world" has 1 instance(s).
    Instance "snet", status READY, has 1 handler(s) for this service...
    The command completed successfully
    LSNRCTL>
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Re: cSnet Tracker tracking exception ORA-12154: TNS: could not resolve (Windows 7 cli

    Not sure what is actually the issue from your description. Following quote could be useful.

     
  3. sdeas34

    sdeas34 Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Re: cSnet Tracker tracking exception ORA-12154: TNS: could not resolve (Windows 7 cli

    Thanks for the response in regards to my inquiry, I have verified all this information and the tns.ora and sqlnet.ora files are fine. I have installed the application that needs to connect to the oracle 10g database on a windows xp machine without any errors but when I install the same software application on a windows 7 64 bit machine it gives me cSnet Tracker tracking exception: ORA-12154 and the company that created this product states they don't support windows 7. I know it can be resolved it seems to be some type of connection problem to the server which is a windows 2003 server. Do you have any suggestions again thanks
     
  4. Re: cSnet Tracker tracking exception ORA-12154: TNS: could not resolve (Windows 7 cli

    java exception:
    ORA-12154: TNS: could not resolve (Windows 7 )
     
  5. Re: cSnet Tracker tracking exception ORA-12154: TNS: could not resolve (Windows 7 cli

    ORA-12154: TNS: could not resolve (Windows 7 cli
    send me steps easily
     
  6. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Re: cSnet Tracker tracking exception ORA-12154: TNS: could not resolve (Windows 7 cli

    Is there actually a space in the IP address?

    (HOST=172.16.1 8.10)
    -------------------^

    I believe it should report

    (HOST=172.16.18.10)

    Check your hosts file and network configuraton as the IP address appears to be incorrectly formatted.