| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Discoverer 3.1 won't connect on Windows XP
Kydd schreef:
> I'm going to check the possibility of environmental variables but this
> is a new installation/new machine. But it does appear that Easy Net
> Config as well as Discoverer are not even hitting our internal IP
> address, so SOMETHING is redirecting it. Here are the file contents:
>
> TNSNAMES.ORA:
>
> # C:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configuration
> File:C:\orant\net80\admin\tnsnames.ora
Are you sure this file is used?
> # Generated by Oracle Net8 Assistant
Loose this one - it's an example:
>
> CMEXAMPLE.WORLD =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = CM_SERVER)(PORT = 1610))
> (ADDRESS = (PROTOCOL = TCP)(HOST = LSNR_SERVER)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = ORCL)
> )
> (SOURCE_ROUTE = YES)
> )
Looks like one of your machines...
> MA_SS.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 131.107.2.199)(PORT = 1521))
> (CONNECT_DATA =
> (SID = SSMA)
> )
> )
>
Loos this, too:
> TCPEXAMPLE.WORLD =
and this:
> NMPEXAMPLE.WORLD =
and:
> EXTPROC_CONNECTION_DATA.WORLD =
as well as:
> BEQ-LOCAL.WORLD =
[snip]
one of yours?
>
> FMC_SS.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 131.107.2.199)(PORT = 1521))
> (CONNECT_DATA =
> (SID = FMCI)
> )
> )
Loose it:
>
> SPXEXAMPLE.WORLD =
Yours, I presume?
> NCM_SS.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 131.107.2.199)(PORT = 1521))
> (CONNECT_DATA =
> (SID = ORCL)
> )
> )
Loose it!
> TCP-LOOPBACK.WORLD =
> ----------------------
> SQLNET.ORA:
>
> TRACE_DIRECTORY_CLIENT = C:\orant\DISCVR31
>
> LOG_FILE_CLIENT = rksqlnet.log
>
> NAME.DEFAULT_ZONE = world
The following point towards a names server. Do you actually use one? If you do, that will resolve the tns alias!
> NAMES.PREFERRED_SERVERS =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 131.107.2.199)(PORT = 1521))
> )
>
> NAMES.DEFAULT_DOMAIN = world
>
> LOG_DIRECTORY_CLIENT = C:\orant\DISCVR31
>
> TRACE_FILE_CLIENT = trace.log
>
> TRACE_LEVEL_CLIENT = ADMIN
>
> LOG_DIRECTORY_SERVER = 131.107.2.199/tmp
>
> #sqlnet.authentication_services = (NONE)
>
> SQLNET.EXPIRE_TIME = 0
>
> SQLNET.ENCRYPTION_SERVER = requested
>
> SQLNET.ENCRYPTION_CLIENT = requested
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)
OK - you do not use a names server. Loose the names.preferred_servers!
>
> ------------------------
> LISTENER.ORA is empty
>
As to be expected - to be used on a server
Now, assuming you use ncm_ss.world (or just ncm_ss) for tns alias, that should resolve in 131.107.2.199:1521:ORCL
If these configuration files are from your faulty PC, all that can be wrong is that these files are not being used.
Try this:
- open the command line interface (CLI; Start, Run, cmd) - tnsping ncm_ss (and post the results) - tnsping ncm_ss.world (and post the results) - set tns_admin=C:\ORANT\NET80\ADMIN - tnsping ncm_ss (and post the results) - tnsping ncm_ss.world (and post the results)The output of the path command would be helpful as well.
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Fri Nov 03 2006 - 02:04:24 CST
 |
 |