Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!c03.atl99!rip!news.webusenet.com!router1.news.adelphia.net!news1.news.adelphia.net.POSTED!not-for-mail From: "Mladen Gogala" Subject: Re: Oracle 8i login is very slow User-Agent: Pan/0.13.4 (She had eyes like strange sins.) Message-Id: Newsgroups: comp.databases.oracle.server References: <2fcf2d80.0304120212.46794e29@posting.google.com> <2fcf2d80.0304120919.5c1de5e1@posting.google.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Lines: 51 Date: Sat, 12 Apr 2003 21:13:52 GMT NNTP-Posting-Host: 68.68.128.32 X-Complaints-To: abuse@adelphia.net X-Trace: news1.news.adelphia.net 1050182032 68.68.128.32 (Sat, 12 Apr 2003 17:13:52 EDT) NNTP-Posting-Date: Sat, 12 Apr 2003 17:13:52 EDT Xref: newsfeed1.easynews.com comp.databases.oracle.server:183257 X-Received-Date: Sat, 12 Apr 2003 14:13:31 MST (news.easynews.com) On Sat, 12 Apr 2003 10:19:19 -0700, John D wrote: > "Howard J. Rogers" wrote in message > news:... >> Check your sqlnet.ora on both machines. I suspect they are not identical. >> >> Regards >> HJR >> >> > They are identical: > > SQLNET.AUTHENTICATION_SERVICES= (NTS) > > NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) The thing slowing you down is: SQLNET.AUTHENTICATION_SERVICES= (NTS) which, essentially, tells Oracle*Net to use local MS version of Kerberos. That brings a 3d node into play, the authentication node, which should provide your local node with a key to encrypt all its packets. If you don't have kerberos configured, then Oacle will search for the Kerberos server in vain, by sending out UDP packets and waiting for a response. It will proceed only when a timeout occurs. Here is my sqlnet.ora: $ pg $TNS_ADMIN/sqlnet.ora # SQLNET.ORA Network Configuration File: C:\OEM\NETWORK\ADMIN\sqlnet.ora # Generated by Oracle configuration tools. # NAMES.DEFAULT_DOMAIN = WORLD # SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf NAMES.DEFAULT_DOMAIN = adelphia.net NAMES.DIRECTORY_PATH= (TNSNAMES) SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf It works lika charm, from all my PCs (3 of them). My database server is on RH 8.0, but that shouldn't be of any importance. -- Mladen Gogala Light travels faster than sound. That is why some people appear bright until you hear them speak.