This discussion is archived
3 Replies Latest reply: Oct 16, 2012 12:12 PM by mhathi RSS

Oracle 11g XE: Cannot tnsping xe

mhathi Newbie
Currently Being Moderated
Hello,

I have the following installed on Windows 7 64 bit:
------------------------------------------------------------------------------------------------------------------------
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
PL/SQL Release 11.2.0.2.0 - Production
"CORE     11.2.0.2.0     Production"
TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
------------------------------------------------------------------------------------------------------------------------

Now, from a cmd window, when I do: tnsping xe, I am getting the following:

------------------------------------------------------------------------------------------------------------------------
TNS Ping Utility for 32-bit Windows: Version 11.2.0.2.0 - Production on 16-OCT-2
012 11:32:22

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:
C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name
------------------------------------------------------------------------------------------------------------------------

I can connect using SQL Developer without any problem.

What could be the issue? I was trying to connect from OBIEE BI Publisher 11g when I realized this issue.

Thanks,

Manish
  • 1. Re: Oracle 11g XE: Cannot tnsping xe
    Justin Cave Oracle ACE
    Currently Being Moderated
    What is in the tnsnames.ora and sqlnet.ora files in the C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\ directory?

    Justin
  • 2. Re: Oracle 11g XE: Cannot tnsping xe
    mhathi Newbie
    Currently Being Moderated
    --------------------------------------------------------------------------------------------------------------------------------------------------------------
    tnsnames.ora:
    -------------------

    XE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = CPWS107074-ORCL.mydomain.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = XE)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    ORACLR_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
    (SID = CLRExtProc)
    (PRESENTATION = RO)
    )
    )
    --------------------------------------------------------------------------------------------------------------------------------------------------------------

    listener.ora:
    -----------------
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (SID_NAME = CLRExtProc)
    (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
    (PROGRAM = extproc)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    (ADDRESS = (PROTOCOL = TCP)(HOST = CPWS107074-ORCL.mydomain.com)(PORT = 1521))
    )
    )

    DEFAULT_SERVICE_LISTENER = (XE)
    --------------------------------------------------------------------------------------------------------------------------------------------------------------

    sqlnet.ora:
    ---------------
    # This file is actually generated by netca. But if customers choose to
    # install "Software Only", this file wont exist and without the native
    # authentication, they will not be able to connect to the database on NT.

    SQLNET.AUTHENTICATION_SERVICES = (NTS)

    Edited by: mhathi on Oct 16, 2012 11:37 AM
  • 3. Re: Oracle 11g XE: Cannot tnsping xe
    mhathi Newbie
    Currently Being Moderated
    Nevermind. It was my own stupidity. In my zeal to fix the issue, I had created a TNS_ADMIN, changed my hosts file etc. etc. I methodically went back and reset everything and then rebooted my windows workstation...you guess it, reboot always works on windows :)

    Thanks.

    Manish

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points