自动化运维工具之:dcli 批量管理主机

dcli 为Oracle Exadata Machine中提供的管理cell的工具,全名 Distributed Command Line Interface,在Exadata, Exalogic, Exalytics等系列一体机都自带这个工具, 该工具是一套python脚本,可以用文本工具直接查看编辑, 在当前的IT管理中批量管理几百台机器已不是什么稀奇的事, 所以在日常一些批量共性的常规检查和运维就需要一种维护工具自动实现或者叫自动化运维工具, 当前较流行的有puppet和ansible 产品

,

Leap Second (闰秒) 在ORACLE环境的影响

因为我国是东八时区(UTC+8),所以我国将在北京时间2017年1月1日的7时59分59秒也会做闰秒调整和全球同步,到时会出现7:59:60的特殊现象。对时间敏感的系统不可忽略,除了航天系统,我们的数据库系统应该也要做好检查, 润秒有可能会使OS Reboot,应用HANG, Clusterware restart影响.

,

Shell: To delete listener log file contains text and xml format (自动清理监听日志)

清理数据库监听日志的脚本 清理多个监听日志 清理文本和XML格式,自动判断 根据文本格式大小默认1GB 根据X […]

Shell: extract more from listener.log(分析监听日志)

最近遇到了两起数据库连接数不足的问题, 通常都会预留一些会话增加的情况, 但在一些特殊情况下如连接风暴(logon storm), 如果在监听中没有做rate限流,对数据库来说
巨大的冲击可能会导致数据库Hang 或 ora-20 或ora-18 错误。

Unable execute “@”(at) sql file in sqlplus on hp-ux issue

I have a ORACLE db server on hp-ux,  i want to execute […]

,

How to use the MegaCLI Utility with your RAID Controller on your DELL PowerEdge Server in Linux. (在linux监控RAID信息)

The MegaRAID Storage Manager includes both GUI (MSM) and The megacli tool is used for managing the controller via the command-line interface, text based tools (MegaCLI) to monitor and manage the disk array.

Shell script to backup MySQL database(备份MySQL 脚本)

this is shell script to backup mysql database, using mysqldump to dump all databases into separate files, and encrypt backup file using zip password option, Generate a collective file using tar, ftp to ftp server, to send email to DBA .

,

MySql 5.5 tar安装及sysbench 配置

Next, let’s create the mysql user and group: groupadd m […]

How to used the gdb (GNU Debugger) Collecting Hanganalyze and Systemstate Dumps on Linux systems(操作系统收集hanganalyze和systemstate)

Prior to 10g you can use a unix debugger like gdb, adb or dbx to attach to a shadow process and dump the system state using the function ksudss which is the subroutine in the Oracle source code which does the same.

How to get call stack of oracle processes ?

Each time your program performs a function call, information about the call is generated. That information includes the location of the call in your program, the arguments of the call, and the local variables ..

,

SHELL:Find Memory Usage In Linux (统计每个程序内存使用情况)

shell统计linux系统中每个程序的内存使用情况,因为内存结构非常复杂,不一定100%精确,

Install ZABBIX On Linux 5 监控安装配置(pdf)

•What is zabbix ?
•What can it monitor?
•Structure of ZABBIX and Componentes

script:purge ADR file

[oracle@db231 ~]$ ./adr_purge
INFO: Purge started at Thu May 16 07:35:32 CST 2013
INFO: adrci purge started at Thu May 16 07:35:32 CST 2013
INFO: adrci purging diagnostic destination diag/tnslsnr/db231/listener
INFO: purging ALERT older than 90 days …
INFO: purging INCIDENT older than 30 days …

Backup ASM metadata with shell

Creates a backup directory if required, works out the A […]

, ,

How TO Kill and Logout users in pts/* Linux

In Linux, PTS stands for Pseudo Terminal Slave. PTS refers to a user currently logged in to your terminal using an SSH or telnet connection.

Bonding Network Interfaces on LINUX5

The Linux bonding driver provides a method for aggregating multiple network interfaces into a single logical bonded interface.

Check goldengate replicate Availability (检查OGG REPLICATE)

通过检查replicate进程确认OGG REPLICATE进程是否存活shell

How To send email From a shell on linux

usually,we do not want to setup an email serve,but just want to send an email from a Linux Shell script easily when got any alert or exptions.then let’s know what happend with the event on the Host,then to solve this problem.

,

About Network stats tools on linux

Bing determines bandwidth on a point-to-point link by sending ICMP ECHO_REQUEST packets and measuring their roundtrip times for different packet sizes on each end of the link

rlwrap 独立的历史操作记录

我是习惯在sqlplus中做一些操作,在linux中安装rlwrap 支持方向键,但如果多个用户在同一台机器上登录,每个人常用的命令不同,方向键查找起来很麻烦,so.那就把我们经常用的操作分类或以用户分类,设立独立的历史操作记录log