Oracle DB takes long time to connect

in ; Hi All, My Oracle DB since yesterday is taking a long time to get connected. I deleted the trace files ...
+ Post Reply + Post New Topic
Results 1 to 4 of 4
  1. #1
    anky84 is offline Junior Member
    Points: 50, Level: 1
    Join Date
    01 Nov 2010
    Posts
    1
    Points
    50

    Oracle DB takes long time to connect

    Hi All,
    My Oracle DB since yesterday is taking a long time to get connected. I deleted the trace files present in the path given by:
    sql> show parameter background%
    but still it takes almost 5 minutes to get connected to the DB.
    Please suggest a solution.

    Thank You,
    anky84.


  2. #2
    zargon's Avatar
    zargon is offline Forum Guru
    Points: 26,200, Level: 96
    Join Date
    22 Oct 2008
    Location
    Aurora, CO
    Posts
    2,011
    Points
    26,200

    Re: Oracle DB takes long time to connect

    Quote Originally Posted by anky84 View Post
    Hi All,
    My Oracle DB since yesterday is taking a long time to get connected. I deleted the trace files present in the path given by:
    sql> show parameter background%
    but still it takes almost 5 minutes to get connected to the DB.
    Please suggest a solution.

    Thank You,
    anky84.
    What connection string are you using? Is this a local or remote connection? You provide no details yet expect expert answers, something that cannot happen without sufficient information.

    Post exactly what you are doing to connect to this database so we can possibly see where the problem may be.
    David Fitzjarrell

  3. #3
    SBH
    SBH is offline Forum Expert
    Points: 3,670, Level: 38
    Join Date
    27 Sep 2010
    Location
    Bangalore
    Posts
    99
    Points
    3,670

    Re: Oracle DB takes long time to connect

    If you are trying to connect from remote machine to database server (on other machine), a lot depends upon your network bandwidth.
    Factos which affect your connection time are Domain name service,Network topology, network contention and bandwidth,

    Optionally you can check size of tnsnames.ora file and status of SQL* net tracing for netwrok performance. Check the SDU (Session data unit) and MTU (maximum transfer unit) parameters.

  4. #4
    janste is offline Junior Member
    Points: 350, Level: 6
    Join Date
    23 Jan 2011
    Posts
    23
    Points
    350

    Re: Oracle DB takes long time to connect

    We have to assume that your problem is client connections but a good rule is always to start locally. If you can connect directly without problems move out to your application and try a tnsping to check your connectivity. If it is a database problem you should face the same when connecting internally but if not you need to start network tracing.

Other Solutions
  1. Triggers does not support long data type
    By salmankhalid in forum SQL PL/SQL
    Replies: 3
    Last Post: 11-28-2010, 01:26 PM
  2. Oracle date / time conversion
    By dsub42 in forum SQL PL/SQL
    Replies: 1
    Last Post: 04-07-2010, 07:56 AM
  3. Connect with remote oracle database from PHP
    By asela_05085 in forum Oracle Database
    Replies: 6
    Last Post: 09-04-2009, 08:57 AM
  4. Replies: 3
    Last Post: 08-17-2009, 08:02 AM