Re: where to put TNS_ADMIN var in registry for 817 client?

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 13 May 2002 17:28:32 GMT
Message-ID: <3cdff6a2.6040465@news.globix.com>

On Mon, 13 May 2002 18:35:26 +0200, Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:

>3 not running a sqlnet trace

I take my words back.. tracing indeed helped: It turns out 8.1.7 names aren't compatible w/ 805 names (not that I ever given it much thought).

For whatever reason, I used to have to add .world to each tnsname, and it would be ignored by 805 client (or used somehow).

With 8.1.7 client, it seems like I actually have to use tnsname.world as the whole string..

Anyway, i don't think I am going to look into docs, it might be some parameter that needs to be changed. (domain.. or something).

I never had this problem no UNIX w/ any client.

• TRACE CONFIGURATION INFORMATION FOLLOWS --- New trace stream is c:\temp\ora_trace.log.trc New trace level is 16
• TRACE CONFIGURATION INFORMATION ENDS ---
• PARAMETER SOURCE INFORMATION FOLLOWS --- Attempted load of system pfile source c:\orant817\network\admin\sqlnet.ora Parameter source loaded successfully

Attempted load of local pfile source c:\orant817\bin\sqlnet.ora Parameter source was not loaded

 -> PARAMETER TABLE LOAD RESULTS FOLLOW <- Successful parameter table load
 -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-

  TRACE_DIRECTORY_CLIENT = c:\temp
  TRACE_FILE_CLIENT = ora_trace.log
  TRACE_LEVEL_CLIENT = 16

--- PARAMETER SOURCE INFORMATION ENDS ---

• LOG CONFIGURATION INFORMATION FOLLOWS --- Log stream will be "c:\orant817\bin\sqlnet.log" Log stream validation not requested
• LOG CONFIGURATION INFORMATION ENDS ---

nigini: entry
nigini: Count in NI global area now: 1
nigini: Count in NI global area now: 1
nrigbi: entry
nrigbni: entry

nrigbni: Unable to get data from navigation file tnsnav.ora nrigbni: exit
nrigbi: exit
nigini: exit
niqname: Using nnfsn2a() to build connect descriptor for (possibly remote) database.
nnfgiinit: entry

nnftboot: entry
nnftboot: exit
nnfoboot: entry
nnfoboot: exit
nnfoboot: entry
nnfoboot: exit
nnfhboot: entry
nnfhboot: exit
nnfnboot: entry
nnfnboot: exit
nnfnboot: entry
nnfnboot: exit

nnflcls: entry
nnflcls: exit
nncpmlf_make_local_addrfile: construction of local names file failed nncpmsf_make_sys_addrfile: system names file is \\Bill\users\technology\database\nt\tnsnames.ora nncpcin_maybe_init: first request sent to name server will have ID 26640
nncpcin_maybe_init: initial retry timeout for all name servers is 1500 csecs

nncpcin_maybe_init: max request retries per name server is 1
nngsini_init_streams: initializing stream subsystem, cache size is 10
nngtini_init_msg: initializing PDU subsystem, initial pool size is 2
nncpcin_maybe_init: default name server domain is [root]

nnfun2a: entry
nlolgobj: entry
nnfgrne: entry
nnfgrne: Installing read path
nnfgsrsp: entry
nnfgsrsp: Obtaining path parameter from names.directory_path or native_names.directory_path
nnfgsrsp: Parmeter names.directory_path not found, setting path to compiled in default

nnfgspd: entry
nnfgspd: setting element DCE
nnfgspd: setting element CDS
nnfgspd: setting element TNSNAMES
nnfgspd: setting element ONAMES
nnfgspd: setting element ONRS
nnfgspd: setting element HOSTNAME
nnfgspd: setting element NOVELL
nnfgspd: setting element NDS
nnfgspd: setting element LDAP
nnfgspd: Path set
nnfgspd: exit
nnfgrne: Going though read path adapters
nnfgrne: Switching to DCE adapter
nnfgrne: Original name: vcrs_live
nnfgrne: Name did not qualify, skipping to next adapter
nnfgrne: Switching to CDS adapter
nnfgrne: Original name: vcrs_live
nnfgrne: Name did not qualify, skipping to next adapter
nnfgrne: Switching to TNSNAMES adapter
nnfgrne: Original name: vcrs_live
nnftqnm: entry
nnfcagmd: entry
nnfcagmd: Attempting to find metadata for type a.smd 
nnfcagmd: Attribute name a.smd is a predefined meta type, syntax is 4.
nnfcagmd: exit

nnfotran: Checking local tnsnames.ora file nnfotran: Checking local tnsnames.ora file nncpldf_load_addrfile: initial load of names file \\Bill\users\technology\database\nt\tnsnames.ora nncpldf_load_addrfile: success
--- \\Bill\users\technology\database\nt\tnsnames.ora TABLE HAS THE
FOLLOWING CONTENTS ---
....

<a large list of db's here, all ending w/ " .world">

....

• END \\Bill\users\technology\database\nt\tnsnames.ora TABLE --- nnfotran: tnsnames.ora entry for name "vcrs_live" not found ....... We use Oracle 8.1.7.3 on Solaris 2.7 boxes remove NSPAM to email

Received on Mon May 13 2002 - 12:28:32 CDT