Connecting to Oracle takes more than 15 seconds
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Connecting to Oracle takes more than 15 seconds

  1. #1
    Join Date
    Nov 2000
    Posts
    57
    Could anybody suggest me what may be the problem here. It takes between 15 - 25 seconds to connect to oracle database?

    thaks for any help on this issue!

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    well if you use hostname you have to define your hosts file otheriwse the DNS takes longer

  3. #3
    Join Date
    Nov 2000
    Posts
    57
    We use TCP IP address on all our files

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    how´s host defined in tnsnames.ora

  5. #5
    Join Date
    Nov 2000
    Posts
    57
    Here is entry from clients tnsnames.ora file

    VDR5.world =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.27.4)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = VDR5)
    )
    )

  6. #6
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    How much time tnsping takes?

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

Posting Permissions

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



Click Here to Expand Forum to Full Width