Re: Can't TNSPing XE database

From: <rclatorre_at_gmail.com>
Date: Thu, 25 Jun 2015 19:19:57 -0700 (PDT)
Message-ID: <1c109101-d9e2-4df0-98dc-31c20fa6cd38_at_googlegroups.com>


El miércoles, 13 de agosto de 2008, 4:20:53 (UTC-5), Knickerless Parsons escribió:
> Morning all,
> I'm having difficulty getting TNSPING to see my local XE database.
>
> I'm running oracle XE on Vista business. I can connect to the database
> fine using SQL Plus and even SQL Developer
>
> After installing XE, I installed the Oracle tools for .NET from here
> (http://www.oracle.com/technology/software/tech/windows/odpnet/
> index.html)
>
> There are no other oracle products installed on my machine.
>
> I initially noticed the problem when I couldn't see my local database
> from within Visual Studio, Further investigation lead me to TNSPING
> which also doesn't work. My guess is that if I can fix the issue with
> TNSPING, that all will be well in the world of .NET.
>
> Output from TNSPING shown below:
> =========================================================================
> TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production
> on 13-AUG-2008 10:08:32
>
> Copyright (c) 1997, 2005, Oracle. All rights reserved.
>
> Used parameter files:
> C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\sqlnet.ora
>
> TNS-03505: Failed to resolve name
> =========================================================================
>
> Contents of the specified SQLNET.ORA file (above), the path in the
> comment at the top doesn't exist!:
> =========================================================================
> # sqlnet.ora Network Configuration File: C:\oracle\product
> \10.2.0\client_1\network\admin\sqlnet.ora
> # Generated by Oracle configuration tools.
>
> #SQLNET.AUTHENTICATION_SERVICES= (NTS)
> sqlnet.authentication_services = (NONE)
>
> #NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES)
> NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, LDAP)
>
> NAMES.DEFAULT_DOMAIN = world
>
> SQLNET.EXPIRE_TIME = 0
>
> NAME.DEFAULT_ZONE = world
> =========================================================================
>
> TNSNAMES.ORA (slightly modified to preserve anonymity! - asterix's on
> the address line) :
> =========================================================================
> #ifile='C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN
> \tnsnames.ora'
>
>
> XE =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = LB05568.****.****.****.net)
> (PORT = 1521))
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = XE)
> )
> )
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> ORACLR_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
> )
> (CONNECT_DATA =
> (SID = CLRExtProc)
> (PRESENTATION = RO)
> )
> )
> =========================================================================
>
> The oracle tools for .NET seem to have created a second oracle home
> but I can't see a home selector app on my start menu.
>
> I also tried TNSPING XE.WORLD which also doesn't work!
>
> I have tried creating a TNS_ADMIN environment variable (using the set
> command) pointing to the directory which contains the above files:
>
> line of output of set command below
> =========================================================================
> tns_admin = C:\oraclexe\app\oracle\product\10.2.0\server\network\admin
> =========================================================================
>
> I'm sure that this worked ok previously, I recently removed the oracle
> tools for .NET and reinstalled just to be sure of the version I was
> running. The install failed a couple of times before it completed
> successfully.
>
> All suggestions greatly appreciated, give me a shout if I've been a
> bit vague anywhere.
>
> Much appreciated,
> Dave.

Duplicando la entrada XE en TNSNAMES.ORA se supero el problema, al parecer cuando se modifica desde algun programa, p.e TOAD, le agrega algun valor que hace no reconocible esa primera linea. Received on Fri Jun 26 2015 - 04:19:57 CEST

Original text of this message