ANBOB™

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 .

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

Oracle has the BBED utility (block browser and editor) is is all releases of Oracle, from Oracle7 to Oracle10g,In Oracle 11g, BBED becomes unavailable but if you search in the ins_rdbms.mk makefile,…

一个不错的oracle AWR 报告本地文件格式化chrome浏览器插件，看似用js完成，有一些特性非常不错， […]

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.

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统计linux系统中每个程序的内存使用情况，因为内存结构非常复杂，不一定100%精确，

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

[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 …

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

客户要求导出大量的数据(约800万记录)，开始为了格式上的好看生成的是ACCESS数据库文件，用Toad 11 […]

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.

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

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

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.

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

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

除了linux中长用的vmstat,iostat,top,sar等工具外有两组轻量的工具也值的推荐，
一个就是经典的IBM 的nmon+nmonanalyser
另一个是Collectl+Graphite

经常有同事提供一个好N个列的EXCEL让你关连数据库增加一列，不想让把excel那么多字段导入db，就可以利用伟大的excel 公式做到实现

1，配置OS环境
2，安装GRID （clusterware）到第三个节点
3，安装ORACLE RDBMS SOFTWARE到第三个节点
4, 增加oracle instance 到第三个节点