DNS requests

DBA Geral (instalação, configuração do banco, scripts do Sql*Plus, shell scripts, batch scripts, etc...)
Post Reply
marciob
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 48
Joined: Thu, 17 Sep 2009 3:47 pm
Location: rio de janeiro

Environment information:
* Oracle version: Oracle 9i
* Operating system: UNIX - Solaris 9


* Problem - Sirs I am having Many requisitions on my bank server for my company's DNS

well my environment is as follows:

I have an Oracle database for a system GED and I have a mapped pool area where I have a routine that sends the files via FTP into these areas.

Is this normal?

I wish someone could help me
pauloaleo
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 181
Joined: Wed, 09 Feb 2005 12:30 pm
Location: SÃO BERNARDO DO CAMPO - SP

I did not get it right. You are trying many DNS requisitions on the Solaris server.
This part must be resolved by checking the SOLV.CONF file that is in / etc.

And the FTP, what happens to him?
marciob
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 48
Joined: Thu, 17 Sep 2009 3:47 pm
Location: rio de janeiro

Well what happens is as follows:

When I run the NetStat command in Solaris appear thousands of requisitions for DNS, which I would like to know if a server with my characteristics (SEERVIDOR of GED with An area mapped pool where the files are), would this be normal?

My FTP What is happening is as follows:

On this bank server there is an FTP server for a routine that I have scheduled to access this server of FTP and place the file inside the pool area. But you have a week that is occurring failed on many FTP connections for this server within my routine. Well this happens in a small time space type two to three minutes. Sometimes inside a file transaction it hangs and the connection drops next it does all the FTP process again

well I actually think it may be due to the volume of DNS requisitions, But I'm not sure.
pauloaleo
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 181
Joined: Wed, 09 Feb 2005 12:30 pm
Location: SÃO BERNARDO DO CAMPO - SP

How is your resolv.conf? And the hosts? Nothing changed in DNS?

You register UNIX machines in DNS?
marciob
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 48
Joined: Thu, 17 Sep 2009 3:47 pm
Location: rio de janeiro

Well at first the three dns's who are at resolv.conf are responding

and also possess within it a search with some domain we have
pauloaleo
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 181
Joined: Wed, 09 Feb 2005 12:30 pm
Location: SÃO BERNARDO DO CAMPO - SP

What is the content of your file

/ etc / nsswitch.conf
marciob
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 48
Joined: Thu, 17 Sep 2009 3:47 pm
Location: rio de janeiro

OPA could only attend now
but let's go

Select all

# 
# /etc/nsswitch.files: 
# 
# An example file that could be copied over to /etc/nsswitch.conf; it 
# does not use any naming service. 
# 
# "hosts:" and "services:" in this file are used only if the 
# /etc/netconfig file has a "-" for nametoaddr_libs of "inet" transports. 
 
passwd:     files 
group:      files 
hosts:      files       dns 
ipnodes:    files 
networks:   files 
protocols:  files 
rpc:        files 
ethers:     files 
netmasks:   files 
bootparams: files 
publickey:  files 
# At present there isn't a 'files' backend for netgroup;  the system will 
#   figure it out pretty quickly, and won't use netgroups at all. 
netgroup:   files 
automount:  files 
aliases:    files 
services:   files 
sendmailvars:   files 
printers:       user files 
 
auth_attr:  files 
prof_attr:  files 
project:    files

When I perform a Commando netstat the return It is with several requests like this:

Select all

s5700bd27.56473      10.25.190.137.domain 5840      0 49640      0 ESTABLISHED 
s5700bd27.56473      10.25.190.137.domain 5840      0 49640      0 ESTABLISHED 
s5700bd27.56473      10.25.190.137.domain 5840      0 49640      0 ESTABLISHED 
s5700bd27.56473      10.25.190.137.domain 5840      0 49640      0 ESTABLISHED 
s5700bd27.56473      10.25.190.137.domain 5840      0 49640      0 ESTABLISHED 
s5700bd27.56473      10.25.190.137.domain 5840      0 49640      0 ESTABLISHED

I think it can better understand what is happening

I am waiting


and thank you
pauloaleo
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 181
Joined: Wed, 09 Feb 2005 12:30 pm
Location: SÃO BERNARDO DO CAMPO - SP

Send the result:

Select all

 tail -200 /var/adm/messages > lista.txt 
type as root the command below and send me the result.

Select all

/etc/init.d/named status 
and send me the command output:

Select all

named-checkconf /etc/named.conf
marciob
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 48
Joined: Thu, 17 Sep 2009 3:47 pm
Location: rio de janeiro

Paulo,

inside the list.txt there was nothing
when I performed the /etc/init.d/named status command me return that it was not possible to find the directory

Select all

bash: /etc/init.d/named: No such file or directory 
 
named-checkconf /etc/named.conf tb retornou 
 
named.conf: No such file or directory
pauloaleo
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 181
Joined: Wed, 09 Feb 2005 12:30 pm
Location: SÃO BERNARDO DO CAMPO - SP

Do you have access like root on the machine?
marciob
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 48
Joined: Thu, 17 Sep 2009 3:47 pm
Location: rio de janeiro

yes everything was done as root


there is no file nor the role named tb the named.conf file
pauloaleo
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 181
Joined: Wed, 09 Feb 2005 12:30 pm
Location: SÃO BERNARDO DO CAMPO - SP

No / var / adm has no messages ??

You can see the DMESG command what you return ......
marciob
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 48
Joined: Thu, 17 Sep 2009 3:47 pm
Location: rio de janeiro

Within the MESSAGES files do not have any information

DMESG returned the following

Select all

Jun 16 18:10:30 s5700bd27 ftpd[29376]: [ID 664088 daemon.error] getpeername (in.ftpd): Transport endpoint is not connected 
Jul 23 11:43:21 s5700bd27 su: [ID 810491 auth.crit] 'su root' failed for oracle on /dev/pts/1 
Jul 27 16:39:20 s5700bd27 ftpd[23591]: [ID 265846 daemon.notice] repeated login failures from 10.16.45.36 [10.16.45.36] 
Sep 24 19:15:42 s5700bd27 ftpd[7122]: [ID 664088 daemon.error] getpeername (in.ftpd): Transport endpoint is not connected
pauloaleo
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 181
Joined: Wed, 09 Feb 2005 12:30 pm
Location: SÃO BERNARDO DO CAMPO - SP

By DMESG errors, Keepalive must be thinking that his FTP connections are open for a long time and is eliminating them, because they think they have made a problem.
Check there if this is set in the Solaris TCP / IP.


User avatar
adrianoturbo
Moderador
Moderador
Posts: 393
Joined: Thu, 20 Mar 2008 4:09 pm
Location: Brasília

Just a question is using FTP to back up?
marciob
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 48
Joined: Thu, 17 Sep 2009 3:47 pm
Location: rio de janeiro

Adriano,
FTP is used only by an application that is connected to my GED


is the only one that has the connection to my bank
marciob
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 48
Joined: Thu, 17 Sep 2009 3:47 pm
Location: rio de janeiro

Paul,

knows which file I can verify if this is set?
pauloaleo
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 181
Joined: Wed, 09 Feb 2005 12:30 pm
Location: SÃO BERNARDO DO CAMPO - SP

Config / magnus.conf:

Select all

KeepAliveTimeout 
   Description: Determines the maximum time that the server holds open  
       an HTTP Keep-Alive connection or a persistent connection between the  
       client and the server. 
   Default: 30 
 
MaxKeepAliveConnections  
   Description: Specifies the maximum number of Keep-Alive and persistent  
       connections that the server can have open simultaneously. 
   Range: 0 to 1048576, no default given 
 
KeepAliveThreads 
   Description: Directive determines the number of threads in the  
      keep-alive subsystem. 
   Default: 1
pauloaleo
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 181
Joined: Wed, 09 Feb 2005 12:30 pm
Location: SÃO BERNARDO DO CAMPO - SP

For TCP (Example only)

Select all

ndd-set / dev / tcp tcp_keepalive_interval $ ((300 * 1000))
pauloaleo
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 181
Joined: Wed, 09 Feb 2005 12:30 pm
Location: SÃO BERNARDO DO CAMPO - SP

To set in Solaris 10

Select all

/usr/sbin/ndd -set /dev/tcp tcp_keep_alive_interval 
The default is 7200000 = 2 hours.
marciob
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 48
Joined: Thu, 17 Sep 2009 3:47 pm
Location: rio de janeiro

Paulo did not understand.


Do you want me set on my server time? OK?


I did not find the config / magnus.conf file: on my server



99] Can you tell me where this file is?
marciob
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 48
Joined: Thu, 17 Sep 2009 3:47 pm
Location: rio de janeiro

Paulo did not understand.


Do you want me set on my server time? OK?


I did not find the config / magnus.conf file: on my server



99] Can you tell me where this file is?
pauloaleo
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 181
Joined: Wed, 09 Feb 2005 12:30 pm
Location: SÃO BERNARDO DO CAMPO - SP

Arrow in the TCP

I found a Solaris 7 here

If you type:

Select all

/dev # ndd /dev/tcp \tcp_keepalive_interval
must appear 7200000 that is equal to 2 hours.

Increases this
marciob
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 48
Joined: Thu, 17 Sep 2009 3:47 pm
Location: rio de janeiro

Paulo my is the default 7200000

You asked me to increase I have to put a 10000000?

It's good

follows the other information on my server:

Select all

tcp_time_wait_interval = 60000 
tcp_fin_wait_2_flush_interval= 675000 
tcp_conn_req_max_q=128
pauloaleo
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 181
Joined: Wed, 09 Feb 2005 12:30 pm
Location: SÃO BERNARDO DO CAMPO - SP

If 7200000 is equal to 2 hours and your FTP is lasting more than this, it increases for 6 hours that is 21600000
Post Reply
  • Information
  • Who is online

    Users browsing this forum: Bing [Bot] and 1 guest