On Wed, 14 Jun 2006 11:13:52 +1000, Ron Savage wrote: Hi Ron
After some kindly prompting by Job Miller (thanx to all who offered help) and a long tour of Oracle's site and of http://asktom.oracle.com/ I did this: o Changed sqlnet.ora from: SQLNET.AUTHENTICATION_SERVICES = (NTS) to: SQLNET.AUTHENTICATION_SERVICES = (NONE) and connexions are now immediate. Along the way I did this: o Changed tnsnames.ora from: (ADDRESS = (PROTOCOL = TCP)(HOST = ron)(PORT = 1521)) to: (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) but that doesn't make any difference in speed. The first version ('ron') triggers some trace msgs beginning with: (1960) [23-JUN-2006 11:52:33:073] snlinGetAddrInfo: Invalid IP address string ron (1960) [23-JUN-2006 11:52:33:073] nttbnd2addr: looking up IP addr for host: ron as you'd expect. For the record, if anyone wishes to enable tracing, patch sqlnet.ora by adding: TRACE_LEVEL_CLIENT = 4 TRACE_LEVEL_SERVER = 4 TRACE_DIRECTORY_CLIENT = c:\temp TRACE_DIRECTORY_SERVER = c:\temp TRACE_FILE_CLIENT = client TRACE_FILE_SERVER = server -- Cheers Ron Savage, [EMAIL PROTECTED] on 23/06/2006 http://savage.net.au/index.html Let the record show: Microsoft is not an Australian company
