Re: Oracle Discoverer 3.1 won't connect on Windows XP

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: 1 Nov 2006 22:43:42 -0800
Message-ID: <1162449822.205122.4160@i42g2000cwa.googlegroups.com>

On Nov 1, 11:02 pm, "Kydd" <rkud..._at_gmail.com> wrote:
> Sure I've even used the .ora files that do work and copied them over.
> Here are the new trace results:
> niotns: Calling address:
> (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\orant\jre11\bin\java.exe)(HOST=X225A)(USER=Administrator))))

This trace still doesn't have a remote address - with the IP address etc of the server. Is it possible to post the tnsnames.ora and sqlnet.ora that you are using? Also check for the existence of an environment variable TNS_ADMIN (which may be a system environment variable, a per user environment variable or set in the registry key under HKLM\Software\ORACLE on windows). You may not be using the tnsnames.ora (or even the oracle client) that you think you are.

cheers

Niall Litchfield
Oracle DBA
http://www.orawin.info/services Received on Thu Nov 02 2006 - 00:43:42 CST