本站用于记录日常工作内容,虚拟化云计算,数据库DBA,网络与安全。
最近一台新上线的Oracle 数据库在警告日志文件中(alert.log)持续出现如下错误:Tue Jul 18 23:09:22 2006WARNING: inbound connection timed out (ORA-3136)Tue Jul 18 23:09:23 2006WARNING: inbound connection timed out (ORA-3136)Tue Jul 18 23:09:25 2006WARNING: inbound connection timed out (ORA-3136)Tue Jul 18 23:09:30 2006WARNING: inbound connection timed out (ORA-3136)Tue Jul 18 23:12:15 2006WARNING: inbound connection timed out (ORA-3136)同时在sqlnet.log中记录了如下错误:VERSION INFORMATION:TNS for Linux: Version 10.2.0.2.0 - ProductionOracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.2.0 - ProductionTCP/IP NT Protocol Adapter for Linux: Version 10.2.0.2.0 - ProductionTime: 19-JUL-2006 11:25:26Tracing not turned on.Tns error struct:ns main err code: 12535TNS-12535: TNS:operation timed outns secondary err code: 12606nt main err code: 0nt secondary err code: 0nt OS err code: 0Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=58147))这是和网络连接相关的一个错误,Metalink上...
ISCSI重启或断网假死,挂载后LV无设备或系统找不到分区解决方法。Centos6主机采用ISCSI+LVM+XFS分区来保存数据。 ISCSI存储或客户端出现断网或ISCSI程序假死,出现这种情况后,为保证数据不出意外损失。先关闭使用存储的运行程序,然后将XFS的分区取消挂载。#:  umount /data然后将ISCSI取消登陆。#:  iscsiadm -m node --targetname iqn.2016-11.dev.iscsi-target:data4 --portal 192.168.1.202 --logout然后查看分区信息,ISCSI相关信息是否还存在。#:  fdisk -l#:  lvs最后再重新挂载ISCSI。[root@cfs1 ~]# :    iscsiadm -m discovery -t sendtargets -p 192.168.11.202[root@cfs1 ~]# :    iscsiadm -m node --targetname iqn.2016-11.dev.iscsi-target:data1 --portal 192.168.11.202 --login完成后,检查ISCSI设备与LVM设备是否正常。[root@cfs1 ~]# :  fdisk -l[root@cfs1 ~]# : vgscan[root@cfs1 ~]# :  lvscan如果正常,fdisk -l 查看时会显示XFS分区信息,如下图。正常情况分区会显示,如图中: Disk /dev/mapper/vg_data-lv_data。如果没有分区,可能是lv 没有正常激活,显示为inactive 。[root@c...
Microsoft SQL Server 数据库的 JDBC URL 格式对于 Microsoft SQL Server 数据库,可以使用以下示例 JDBC URL 作为模型:■    按主机名连接到默认的(未命名的)SQL Server 实例:jdbc:sqlserver://host;databaseName=database■    按主机名和实例名连接到已命名的实例:jdbc:sqlserver://host;instanceName=instance;databaseName=database■    按主机名和端口连接到 SQL Server:jdbc:sqlserver://host:port;databaseName=database■    按端口连接:jdbc:sqlserver://localhost:1422;databaseName\=VIM_VCDB(要单独传递的用户名、密码和数据库类型)■    使用集成安全性连接到本地服务器:jdbc:sqlserver://localhost\\SQLEXP_VIM;databaseName=VIM_VCDB;integratedSecurity=true■    不使用集成安全性连接到本地服务器:jdbc:sqlserver://localhost\\SQLEXP_VIM;databaseName\=VIM_VCDB (要单独传递的用户名、密码和数据库类型)默认情况下,Microsoft SQL Server 的 VMware vCenter Server JDBC 配置可能无法使用直接 IPv6 地址。必须使用下列形式之一:■ &nb...
 服务器每隔一段时间后就出现无法登陆的问题。重启数据库后,问题解决,但这并不是长久之计。查看日志文件:D:\app\administrator\diag\rdbms\hzdb\hzdb\alert的alert.log,出现大量的重复错误信息,如下所示:Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.206.83)(PORT=2067))   TNS-00505: 操作超时 nt secondary err code: 60  nt OS err code: 0  ns secondary err code: 12560  nt main err code: 505  TNS-12535: TNS: 操作超时  Tracing not turned on.  Tns error struct:ns main err code: 12535  VERSION INFORMATION: TNS for 32-bit Windows: Version 11.1.0.7.0 - Production Oracle Bequeath NTProtocol Adapter for 32-bit Windows: Version 11.1.0.7.0 - Production Windows NT TCP/IP NT ProtocolAdapter for 32-bit Windows: Version 11.1.0.7.0 - Production  Fatal NI connect error 12170.为什么会出现这样的情况呢?网上搜索后得知,在Oracle11G中,有这样两个参数SQLNET.INBOUND_CONNECT_TIMEOUT 和INBOUND_CONNECT_TIMEOUT_list...
 
0
10.2. Changing Network Kernel SettingsOracle now uses User Datagram Protocol (UDP) as the default protocol on Linux for interprocess communication, such as cache fusion buffer transfers between the instances. However, starting with Oracle 10g network settings should be adjusted for standalone databases as well.Oracle recommends the default and maximum send buffer size (SO_SNDBUF socket option) and receive buffer size (SO_RCVBUF socket option) to be set to 256 KB. The receive buffers are used by TCP and UDP to hold received data until it is read by the application. The receive buffer cannot overflow because the peer is not allowed to send data beyond the buffer size window. This means that datagrams will be discarded if they do not fit in the socket receive buffer. This could cause the sender to overwhelm the receiver.The default and maximum window size can be changed in the proc file system without reboot:The default setting in bytes of the socket receive buffer:# sysctl -w net.c...
How To: Network / TCP / UDP TuningThis is a very basic step by step description of how to improve the performancenetworking (TCP & UDP) on Linux 2.4+ for high-bandwidth applications. These settings are especiallyimportant for GigE links. Jump to Quick Step or All The Steps.AssumptionsThis howto assumes that the machine being tuned is involved in supporting high-bandwidthapplications. Making these modifications on a machine that supports multiple users and/ormultiple connections is not recommended - it may cause the machine to deny connectionsbecause of a lack of memory allocation.The StepsMake sure that you have root privleges.Type: sysctl -p | grep memThis will display your current buffer settings. Save These! You may want toroll-back these changesType: sysctl -w net.core.rmem_max=8388608 This sets the max OS receive buffer size for all types of connections.Type: sysctl -w net.core.wmem_max=8388608 This sets the max OS send buffer size for all types of connections.Type...
    总共312页,当前第1页 | 页数:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7