Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 10.1.0.4/win32: login to db takes 20-30 secs

RE: 10.1.0.4/win32: login to db takes 20-30 secs

From: Andre van Winssen <awinssen_at_xs4all.nl>
Date: Sat, 16 Apr 2005 16:09:22 +0200
Message-ID: <PKEFJOAFGKKFFOGJDFPACEENCHAA.awinssen@xs4all.nl>


Niall, you are right, that's certainly related to my little problem After an installation sqlnet.ora has sqlnet.authentication_services =(NTS) When I changed this logging goes much faster. In my case I logged on locally after having set ORACLE_SID=XYZ

I'll update my iTar :-)

Can't remember this long login time being the case in versions < 10.1

Kind regards,
Andre
  -----Oorspronkelijk bericht-----
  Van: Niall Litchfield [mailto:niall.litchfield_at_gmail.com]   Verzonden: zaterdag 16 april 2005 14:52   Aan: awinssen_at_xs4all.nl
  CC: oracle-l_at_freelists.org
  Onderwerp: Re: 10.1.0.4/win32: login to db takes 20-30 secs

  Have a look and see if sqlnet.authentication_services is set to nts at both ends.

  Niall

  On 4/16/05, Andre van Winssen <awinssen_at_xs4all.nl> wrote:     Hello,

    After a fresh install of 10.1.0.4 (on Win2K here) I created a simple     database using dbca.

    What I find strange is that, although everything else is looking fine, a     login to the database takes approx 20 to 30 secs.

    And it's not just sqlplus also exp/imp/dbconsole show the same login time.

    I logged a tar for this and expect some input from Oracle but wanted to know

    if it is common and not something special to my env.

    I haven't had a change to use other servers yet.

    Regards,

    Andre van Winssen

    --
    http://www.freelists.org/webpage/oracle-l

  --
  Niall Litchfield
  Oracle DBA
  http://www.niall.litchfield.dial.pipex.com

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Apr 16 2005 - 10:16:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US