Connection Timeouts and DNS
2/24/2015 10:25:00 PM
Gönderen Mete Karar
On an Oracle 11.1.0.7.0 database running on AIX system, clients were complaining about connection timeouts. Tnsping was showing latency more than 1000 ms.
$ truss -aefo tnsping.trc tnsping <tns_db>
30539848: 31654123: _getpid() = 30539848
30539848: 31654123: kopen("/etc/resolv.conf", O_RDONLY) = 5
30539848: 31654123: kioctl(5, 22528, 0x0000000000000000, 0x0000000000000000) Err#25 ENOTTY
30539848: 31654123: kioctl(5, 22528, 0x0000000000000000, 0x0000000000000000) Err#25 ENOTTY
30539848: 31654123: kread(5, " n a m e s e r v e r 1".., 4096) = 114
30539848: 31654123: kread(5, " n a m e s e r v e r 1".., 4096) = 0
30539848: 31654123: statx("/etc/resolv.conf", 0x0FFFFFFFFFFF9108, 176, 0) = 0
30539848: 31654123: close(5) = 0
30539848: 31654123: socket(1, 1, 0) = 5
30539848: 31654123: kfcntl(5, F_SETFD, 0x0000000000000001) = 0
30539848: 31654123: connext(5, 0x0FFFFFFFFFFF8BD8, 1025) Err#2 ENOENT
30539848: 31654123: close(5) = 0
30539848: 31654123: kopen("/etc/netsvc.conf", O_RDONLY) = 5
30539848: 31654123: kioctl(5, 22528, 0x0000000000000000, 0x0000000000000000) Err#25 ENOTTY
30539848: 31654123: kioctl(5, 22528, 0x0000000000000000, 0x0000000000000000) Err#25 ENOTTY
30539848: 31654123: kread(5, " # @ ( # ) 4 3 ".., 4096) = 4096
30539848: 31654123: kread(5, " o n a n d r e s o l".., 4096) = 638
30539848: 31654123: close(5) = 0
30539848: 31654123: _thread_self() = 31654123
30539848: 31654123: _thread_self() = 31654123
30539848: 31654123: kopen("/etc/hesiod.conf", O_RDONLY) Err#2 ENOENT
30539848: 31654123: __libc_sbrk(0x0000000000010020) = 0x00000001106A4D40
30539848: 31654123: kopen("/etc/irs.conf", O_RDONLY) Err#2 ENOENT
30539848: 31654123: _thread_self() = 31654123
30539848: 31654123: getdomainname(0x09001000A02273B0, 1024) = 0
30539848: 31654123: _thread_self() = 31654123
30539848: 31654123: _thread_self() = 31654123
30539848: 31654123: _thread_self() = 31654123
30539848: 31654123: getdomainname(0x09001000A02273B0, 1024) = 0
30539848: 31654123: _thread_self() = 31654123
30539848: 31654123: _thread_self() = 31654123
30539848: 31654123: _thread_self() = 31654123
30539848: 31654123: _thread_self() = 31654123
30539848: 31654123: _thread_self() = 31654123
30539848: 31654123: _thread_self() = 31654123
30539848: 31654123: _thread_self() = 31654123
30539848: 31654123: getdomainname(0x09001000A02273B0, 1024) = 0
30539848: 31654123: _thread_self() = 31654123
30539848: 31654123: _thread_self() = 31654123
30539848: 31654123: _thread_self() = 31654123
30539848: 31654123: getdomainname(0x09001000A02273B0, 1024) = 0
30539848: 31654123: _thread_self() = 31654123
30539848: 31654123: _thread_self() = 31654123
30539848: 31654123: kopen("/etc/hosts", O_RDONLY) = 5
30539848: 31654123: kioctl(5, 22528, 0x0000000000000000, 0x0000000000000000) Err#25 ENOTTY
30539848: 31654123: kfcntl(5, F_SETFD, 0x0000000000000001) = 0
30539848: 31654123: kioctl(5, 22528, 0x0000000000000000, 0x0000000000000000) Err#25 ENOTTY
30539848: 31654123: kread(5, " # @ ( # ) 4 7\t 1 . 2".., 4096) = 2018
30539848: 31654123: kread(5, " # @ ( # ) 4 7\t 1 . 2".., 4096) = 0
30539848: 31654123: close(5) = 0
30539848: 31654123: kopen("/etc/hosts", O_RDONLY) = 5
30539848: 31654123: kioctl(5, 22528, 0x0000000000000000, 0x0000000000000000) Err#25 ENOTTY
30539848: 31654123: kfcntl(5, F_SETFD, 0x0000000000000001) = 0
30539848: 31654123: kioctl(5, 22528, 0x0000000000000000, 0x0000000000000000) Err#25 ENOTTY
30539848: 31654123: kread(5, " # @ ( # ) 4 7\t 1 . 2".., 4096) = 2018
30539848: 31654123: kread(5, " # @ ( # ) 4 7\t 1 . 2".., 4096) = 0
30539848: 31654123: socket(2, 2, 0) = 6
30539848: 31654123: getsockopt(6, 65535, 4104, 0x0FFFFFFFFFFF7BE4, 0x0FFFFFFFFFFF7BE0) = 0
30539848: 31654123: connext(6, 0x09001000A0167878, 16) = 0
30539848: 31654123: _esend(6, 0x0FFFFFFFFFFF8AF0, 35, 0, 0x0000000000000000) = 35
30539848: 31654123: _poll(0x0FFFFFFFFFFF7CB0, 1, 1000) = 1
30539848: 31654123: _enrecvfrom(6, 0x0FFFFFFFFFFF9E20, 1024, 0, 0x0FFFFFFFFFFF8470, 0x0FFFFFFFFFFF7C98, 0x0000000000000000) = 104
30539848: 31654123: _esend(6, 0x0FFFFFFFFFFF8AF0, 47, 0, 0x0000000000000000) = 47
30539848: 31654123: _poll(0x0FFFFFFFFFFF7CB0, 1, 1000) = 1
30539848: 31654123: _enrecvfrom(6, 0x0FFFFFFFFFFF9E20, 1024, 0, 0x0FFFFFFFFFFF8470, 0x0FFFFFFFFFFF7C98, 0x0000000000000000) = 122
30539848: 31654123: close(6) = 0
30539848: 31654123: close(5) = 0
As you might notice, what tnsping and also any other Oracle Net service is doing is to check DNS server first then use local hosts file for name resolution. This is the cause of the latency because a public DNS server was set for this server and naturally there was no record for it on the DNS. Even you set hosts file as primary source in the netsvc.conf, Oracle does not care and uses DNS at first.
After clearing DNS configuration on the server, connection times get into order. It's also a known bug that is fixed in 11.2.0.2. So, you need to upgrade for an appropriate solution.
Subscribe to:
Post Comments (Atom)
19/7/21 02:22
Cheat Judi Online bisa memberikan keuntungan dengan cepat dan tentunya bisa membuat anda mendaptakan uang dengan mudah,jika anda berminat
maka anda bisa mengunjungi blog dibawah ini.
Aplikasi Hack Judi Online
Aplikasi Cheat Perang Baccarat
kunjungi juga blog dibawah ini
Agen Judi Perang Baccarat
Perlu Menang
Prediksi Togel
Agen Bandar Sakong Terpercaya
Daftar Agen Judi Terpercaya
Agen Judi Online Terpercaya
Agen Judi Casino Terpercaya
Agen Poker Terpercaya
Agen Judi Bola Terpercaya
Agen Slot Game Terpercaya
Agen Sportsbook Terpercaya
Agen Judi Sakong Terpercaya
Agen Judi Online Joinitu
website judi online joinitu
Agen Slot Game Terpercaya ituVIP