Tag Archives: dba

Oracle 貴到不像話! 開始 IBM DB2 解決方案 / mysql to db2 轉移




Application Development with DB2



利用 MySQL 技能学习 DB2 Express: DB2 与 MySQL 的管理任务和基本任务
您的数据库环境要求具有跨数据库的技能吗?如果您熟悉 MySQL,那么可以使用您已经拥有的很多技能来学习 DB2 Express。本文是关于利用 MySQL 技能学习 DB2 的系列文章的第一部分,将对管理任务、数据类型、SQL、锁定等进行比较。

利用 MySQL 技能学习 DB2 Express: DB2 与 MySQL 的备份和恢复
具有 MySQL 背景的 DBA 可以利用本指南学习 DB2 中的备份和恢复实用程序是如何工作的,并与 MySQL 中的备份和恢复功能进行对比。

从 MySQL 或 PostgreSQL 迁移到 DB2 Express-C
容易使用、强大而且免费!这就是人们对 MySQL 和 PostgreSQL 的评价。但是,您知道 DB2 Express-C 是一种免费的具有专业水准且容易使用的数据库吗?学习如何轻松地从 MySQL/PostgreSQL 迁移到 DB2

利用 MySQL 技能学习 DB2 Express,第 4 部分: DB2 与 MySQL 数据转移
如果您是一位要同时管理 MySQL 和 IBM DB2 Express-C 的 DBA,就需要理解这两种数据库服务器的功能差异。本文是系列文章中的第 4 篇,这个系列帮助具有 MySQL 背景的 DBA 学习如何管理 DB2 Express。在本文中,学习在这两种产品中数据转移技术有何差异。讨论的技术包括 Import、Export、Load 以及专门用于数据转移的其他实用程序。

利用 MySQL 技能学习 DB2 Express,第 3 部分: DB2 与 MySQL 图形用户界面
DB2 for Linux, UNIX, and Windows 提供了丰富的 GUI 特性,使管理员能够执行他们的日常任务,包括空间管理、备份和恢复以及与开发相关的任务。本文帮助正在从 MySQL 迁移到 DB2 Express 的读者对比这两种数据库的功能。

install oracle 11g steps

記錄一下, 方便查詢

ORACLE URL : Installing Oracle Database 11g Release 1 on Enterprise Linux 5 (32- and 64-bit)

ORACLE wiki : http://wiki.oracle.com/

step-by-step screenshots : http://www.thegeekstuff.com/2008/10/oracle-11g-step-by-step-installation-guide-with-screenshots/

Install Oracle 11g on CentOS with VMware ( Mac )

Oracle 11g R1 Enterprise安裝研究(CentOS 5.2) : http://forum.icst.org.tw/phpbb/viewtopic.php?f=21&t=16411&start=0&sid=866700eee479d130d126967c3160e7f4

Oracle 11g R2 Enterprise (CentOS 5.3 x86_64) 安裝筆記 : http://hans0713.blogspot.com/2009/10/oracle-11g-r2-enterprise-centos-53.html

Oracle 9i Streams 安裝步驟 – http://www.oracle-base.com/articles/9i/Streams9i.php

Oracle 11g Release 2 RAC On Linux Using VMware Server 2 –


Linux OS 下這些調整 sysctl

fs.file-max = 65535
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65535
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144


Database administrator

A database administrator (DBA) is a person who is responsible for the environmental aspects of a database. The role of a database administrator has changed according to the technology of database management systems (DBMSs) as well as the needs of the owners of the databases. For example, although logical and physical database design are traditionally the duties of a database analyst or database designer, a DBA may be tasked to perform those duties.


The duties of a database administrator vary and depend on the job description, corporate and Information Technology (IT) policies and the technical features and capabilities of the DBMS being administered. They nearly always include disaster recovery (backups and testing of backups), performance analysis and tuning, data dictionary maintenance, and some database design.

Some of the roles of the DBA may include

  • Installation of new software — It is primarily the job of the DBA to install new versions of DBMS software, application software, and other software related to DBMS administration. It is important that the DBA or other IS staff members test this new software before it is moved into a production environment.
  • Configuration of hardware and software with the system administrator — In many cases the system software can only be accessed by the system administrator. In this case, the DBA must work closely with the system administrator to perform software installations, and to configure hardware and software so that it functions optimally with the DBMS.
  • Security administration — One of the main duties of the DBA is to monitor and administer DBMS security. This involves adding and removing users, administering quotas, auditing, and checking for security problems.
  • Data analysis — The DBA will frequently be called on to analyze the data stored in the database and to make recommendations relating to performance and efficiency of that data storage. This might relate to the more effective use of indexes, enabling "Parallel Query" execution, or other DBMS specific features.
  • Database design (preliminary) — The DBA is often involved at the preliminary database-design stages. Through the involvement of the DBA, many problems that might occur can be eliminated. The DBA knows the DBMS and system, can point out potential problems, and can help the development team with special performance considerations.
  • Data modeling and optimization — By modeling the data, it is possible to optimize the system layouts to take the most advantage of the I/O subsystem.
  • Responsible for the administration of existing enterprise databases and the analysis, design, and creation of new databases.
    • Data modeling, database optimization, understanding and implementation of schemas, and the ability to interpret and write complex Structured Query Language (SQL) queries
    • Proactively monitor systems for optimum performance and capacity constraints
    • Establish standards and best practices for SQL
    • Interact with and coach developers in SQL scripting



Manage Oracle Streams Advanced Queuing – DBMS_AQADM


官網資料 : http://download-west.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_aqadm.htm#i1015375

The DBMS_AQADM package provides procedures to manage Oracle Streams Advanced Queuing (AQ) configuration and administration information.

See Also:

This chapter contains the following topics: