本站用于记录日常工作内容,虚拟化云计算,数据库DBA,网络与安全。
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...
 
0
之前安装好 zabbix3.2与oracle,具体详见:http://www.92cto.com/blog/1953.html需要添加服务器的应用服务的日志监控与系统登陆信息监控,这里就作一个简单的例子。在zabbix上配置监控主机后,添加监控项目:监控日志key首先要了解key,log[ file  ,<regexp>,<encoding>,<maxlines>,<mode>,<output>]file:文件名,写绝对路径regexp:要匹配内容的正则表达式,或者直接写你要检索的内容也可以,例如我想检索带ERROR关键词的记录encoding:编码相关,留空即可maxlines:一次性最多提交多少行,这个参数覆盖配置文件zabbxi_agentd.conf中的’MaxLinesPerSecond’,我们也可以留空mode:默认是all,也可以是skip,skip会跳过老数据output:输出给zabbix server的数据。可以是\1、\2一直\9,\1表示第一个正则表达式匹配出得内容,\2表示第二个正则表达式匹配错的内容。项目:oracle_error_log类型 : zabbix agent(active)键值   :  log[/data/app/oracle/diag/rdbms/hextrack/hextrack/trace/alert_hextrack.log,"Warning|ORA\-",gbk,,,]这里是监控oracle告警文件中Warning或是ORA-开头的内容,采用GBK编码。信...
Centos6 源码编译安装zabbix3.2,对接oralce11g数据库Centos6 源码编译安装zabbix3.2,对接oralce11g数据库由于mysql用时间长了,性能会下降,所以需要对接oracle数据库。具体环境如下:30台服务器主机:RHEL6+JDK1.7+java程序。4台服务器主机: RHEL6+JDK1.7+weblogic10.32台主机安装数据库: RHEL6+oracle 11gr2.0.4+ISCSI存储。1台监控主机环境:RHEL6+Zabbix3.2之前安装好了oracle11gr2.0.4,不过使用的是GBK编码,但是zabbix是要求UTF-8的编码,这里我也不修改数据编码了。生产环境中,oracle还是要用UTF8编码,不然会有乱码的。添加好单独的表空间,再配置zabbix所需oracle账号信息:-- Create the user create user ZABBIX IDENTIFIED BY zabbix ACCOUNT UNLOCK;  default tablespace ZABBIX  temporary tablespace TEMP  profile DEFAULT  password expire;-- Grant/Revoke role privileges grant connect to ZABBIX;grant resource to ZABBIX;GRANT CREATE ANY DIRECTORY TO ZABBIX;GRANT DROP ANY DIRECTORY TO ZABBIX;-- Grant/Revoke system privileges grant drop any directory to ZABBIX;grant unlimited tablespace to ZABBIX;修改需要导入...
    总共311页,当前第1页 | 页数:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7