1. The Forum has been upgraded to a modern and advanced system. Please read the announcement about this update.
  2. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle DB takes long time to connect

Discussion in 'General' started by anky84, Nov 1, 2010.

  1. anky84

    anky84 Guest

    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. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,131
    Likes Received:
    303
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    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.
     
  3. SBH

    SBH Forum Expert

    Messages:
    99
    Likes Received:
    6
    Trophy Points:
    160
    Location:
    Bangalore
    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. janste

    janste Active Member

    Messages:
    23
    Likes Received:
    6
    Trophy Points:
    90
    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.