help with net8 (tnsnames, onames)

From: Eric Spear <espear_at_deans.umd.edu>
Date: Fri, 18 Jun 1999 14:02:47 -0400
Message-ID: <376A89C7.3C15D194@deans.umd.edu>

I have a situation where I'm using onames for most of my instances, but tnsnames for one particular one, called ois8150. In sqlnet.ora, if I set

NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES) I can access the instance ois8150 just fine ('cause it's in the tnsnames.ora file). However, I can't access any other instance (those that use the name server)! Here is a part of the trace of the successful access of ois8150:

nnfotran: Checking local tnsnames.ora file nncpldf_load_addrfile: initial load of names file
/opt/ois8150/product/8.1.5.0/n

etwork/admin/tnsnames.ora
nncpldf_load_addrfile: success
nnftqnm: Using tnsnames.ora address (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(H
OST = xxxx.xx.xxxxx)(PORT = 1521)) (CONNECT_DATA = (SID = OIS8150))) for nam
e ois8150.world
nnfcraa: entry

Well, get this. If I change the line in sqlnet.ora to:

NAMES.DIRECTORY_PATH = (ONAMES, TNSNAMES) I can access all of the name server instances, but not ois8150! Here is the trace showing this failure:

nnftqnm: Error querying ois8150 of attribute A.SMD errcode 406
nnfgrne: exit
nnfun2a: address for name "ois8150" not found

Please help! What's going on? Received on Fri Jun 18 1999 - 13:02:47 CDT