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

From: Kydd <rkudyba_at_gmail.com>
Date: 2 Nov 2006 11:12:15 -0800
Message-ID: <1162494735.790580.150170@h54g2000cwb.googlegroups.com>

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
# Generated by Oracle Net8 Assistant

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)

  )

MA_SS.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 131.107.2.199)(PORT = 1521))
(CONNECT_DATA =

      (SID = SSMA)
    )
  )

TCPEXAMPLE.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Production1)(PORT = 1521))
(CONNECT_DATA =

      (SID = ORCL)
    )
  )

NMPEXAMPLE.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = NMP)(Server = FinanceServer1)(Pipe =
ORAPIPE))
(CONNECT_DATA =

      (SID = ORCL)
    )
  )

EXTPROC_CONNECTION_DATA.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0))
(CONNECT_DATA =

      (SID = extproc)
    )
  )

BEQ-LOCAL.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle80)(ARGV0 =
oracle80ORCL)(ARGS =
'(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))'))
(CONNECT_DATA =

      (SID = ORCL)
    )
  )

FMC_SS.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 131.107.2.199)(PORT = 1521))
(CONNECT_DATA =

      (SID = FMCI)
    )
  )

SPXEXAMPLE.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = SPX)(Service = Server_lsnr))
(CONNECT_DATA =

      (SID = ORCL)
    )
  )

NCM_SS.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 131.107.2.199)(PORT = 1521))
(CONNECT_DATA =

      (SID = ORCL)
    )
  )

TCP-LOOPBACK.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 131.107.2.199)(PORT = 1521))
(CONNECT_DATA =

      (SID = ORCL)
    )
  )

---

SQLNET.ORA: TRACE_DIRECTORY_CLIENT = C:\orant\DISCVR31

LOG_FILE_CLIENT = rksqlnet.log

NAME.DEFAULT_ZONE = world

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)

---

LISTENER.ORA is empty Received on Thu Nov 02 2006 - 13:12:15 CST