Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Oracle connection from slow to speedy (Access2003)

    I suppose I can finally give after receiving so much from you here.

    I had complained about my computer being so slow and other's computers were much faster doing the same things on Server.
    Finally, this problem is resolved by our tech support people, and I am very grateful and want to share with whomever might be experiencing the same problems.

    We had checked sqlnet.ora file and here is what we have found.
    In
    NAMES.DEFAULT_DOMAIN = domainname
    section
    NAMES.DIRECTORY_PATH=(TNSNAMES) (from tnsname.ora file)
    I had
    NAMES.DIRECTORY_PATH=(OneName, SecondName, TNSNAMES)
    so when I was trying to access TSNAMES my connection was suppose to check OneName, SecondName and by the time it was reaching TNSNAMES where my info is stored -
    Oracle had timed out and crushed.
    I was spending sometimes 40min trying to open 1 table.

    Now because
    NAMES.DIRECTORY_PATH=(OneName, SecondName, TNSNAMES)
    was changed into
    NAMES.DIRECTORY_PATH=(TNSNAMES)
    I am a new person! And I wish this advise could help someone!

    Thanks,
    Sincerelly yours,
    Ms_Fan

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Oracle connection from slow to speedy (Access2003)

    Good for you! Thanks for sharing the solution.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •