2011年04月_Dave

12月 11月 10月 09月 08月 07月 06月 05月 04月 03月 02月 01月

原创 MySQL 引擎和 InnoDB并发控制简介

MySQL存储引擎采用了可插拔的结构，即用户可以根据自己的需要来选择不同的存储引擎。 下表是MySQL不同的存储引擎的不同的特性： Feature MyISAM BDB Memory InnoDB Archive NDB Storage limits 256TB No Yes 64TB No

2011-04-29 15:07:00 5324 1

原创 MySQL 和 PostgreSQL 对比

最近打算研究下几个开源的数据库，但是主要精力还是研究Oracle RDBMS。MySQL 和PostgreSQL 是开源中用的最多的2个。从网上搜了点资料。整理如下。这些资料也是以前的资料，现在肯定是有变动。所以这些内容，仅供参考。 一、两者的共同优势 　　这两个产品都属于开放源码的一员，性能和功能都在高速地提高和增强。MySQL AB的人们和PostgreSQL的开发者们都在尽可能地把各自的数据库改得越来越好，所以对于任何商业数据库

2011-04-29 11:23:00 7889 3

原创 Oracle ASM 系列小结

在metalink上看到一篇有关ASM 总结的文章，贴出来，共同学习。 一. Automatic Storage Management (ASM) Alerts: Alert: Querying v$asm_file Gives ORA-15196 After ASM Was Upgraded From 10gR2 To 11gR2 with an AU size > 1M [ID 1145365.1]

2011-04-26 15:27:00 13657

原创 Patch 8402551 Is Not Available

Patch 8402551 not available to download from Metalink.Solution Patch 8402551 has been withdrawn because it had some issues, it was replaced by Patch 8969852. Even Patch 8402551 included in Patch 8461420, Patch 8969852 sh

2011-04-26 09:48:00 4424

原创 How to install a patch on clusterware 11.2.0.1 into grid infrastructure home

When applying a needed patch to the Grid Infrastructure Home for ASM or CRS the opatch utility may error out with the messages: ApplySession failed: ApplySession failed to prepare the system. ApplySession was not able to cre

2011-04-26 09:43:00 7718

原创 11g Understanding Automatic Diagnostic Repository.

Beginning with Release 11g, Oracle Database includes an advanced fault diagnosability infrastructure for preventing, detecting, diagnosing, and resolving problems. This note helps to understand the new 11g infrastructure known as Automatic D

2011-04-25 22:58:00 4614

原创 Unable To Open Database After ASM Upgrade From Release 11.1 To Release 11.2

After upgrade the ASM instance from release 11.1 to release 11.2 existing database is unable to start/open due to the next error: /u01/app/oracle/product/11.1.0/dbs>sqlplus SQL*Plus: Release 11.1.0.6.0 - Production

2011-04-25 17:19:00 5154

原创 Upgrading ASM instance from Oracle 10.1 to Oracle 10.2. (Single Instance)

Upgrading ASM instance from Oracle 10.1 to Oracle 10.2. (Single Instance) Solution o Upgrading of ASM instance from 10.1 to 10.2 can be accomplished through DBUA. o All the database that use the ASM instance being upgra

2011-04-25 17:14:00 4537

原创 How To Upgrade ASM from 10.2 to 11.1 (RAC)

The present document explains how to upgrade an ASM instance from 10.2 to 11.1 release (on RAC). Solution 1) Shutdown all the database instances that are using ASM as storage option. 2) Shutdown the ASM instances.

2011-04-25 16:50:00 5092

原创 How to perform Rolling Upgrade-Downgrade in 11g ASM

The purpose of this document is to provide information about the ASM rolling upgrade feature and Step by Step to install a patchset or patch in ASM Home without downtime.Solution The following conditions should be met for to perfor

2011-04-25 16:33:00 6293

原创 How To Upgrade ASM from 10.2 to 11.1 (single Instance configuration -Non-RAC)

The present document explains how to upgrade an ASM instance from 10.2 to 11.1 release (single Instance configuration / Non-RAC). Solution 1) Install the new 11g ASM Oracle Home (on a different directory) as described in the Instal

2011-04-25 16:22:00 4716

原创 Pre-requsite for 11.2.0.1 to 11.2.0.2 ASM Rolling Upgrade

This note is to clarify the patch requirement when doing 11.2.0.1 to 11.2.0.2 rolling upgrade. Pre-requsite for 11.2.0.1 to 11.2.0.2 ASM Rolling Upgrade There has been some confusion as what patches need

2011-04-25 16:14:00 5280

原创 Steps to Re-Create ASM Diskgroups

In the event you cannot mount your ASM disk groups, you will be unable to start any databases using those disk groups. Here is a possible error reported when mounting ASM disk groups: SQL> startup mount OR

2011-04-25 15:01:00 5584

原创 Steps To Migrate-Move a Database From Non-ASM to ASM And Vice-Versa

This article describes the steps to migrate a database from Non-ASM to ASM and vice-versa. To setup ASM, please follow Note 452924.1 - How to Prepare Storage for ASM Note 265633.1 - ASM Technical Best Practices<br

2011-04-25 14:49:00 5747

原创 Reconfigure HAS and CSS for nonRAC ASM on 11.2

This document provides a procedure to configure/reconfigure the ( High Availability Service ) HAS and CSS resource on Oracle Grid Infrastructure for nonRAC setup Solution 1）When you install grid infrastructure f

2011-04-25 11:22:00 5416

原创 Pattern Matching Metacharacters For asm_diskstring

This document will list the possible meta characters for asm_diskstring parameter Solution * and [] are the two valid meta characters for asm_diskstring parameter. SQL> alter system set asm_diskstring='/dev/raw/raw

2011-04-25 11:05:00 5321

原创 OCSSD.BIN Process is Running in a Non-RAC Environment

After installing a non-RAC (Real Application Clusters) 10g database, you notice an ocssd.bin process running. ps -ef | grep ocssd.bin oracle 11139 11056 0 14:02:14 pts/52 0:00 grep ocssd.bin oracle 1824 1 0 M

2011-04-25 10:59:00 5416

原创 Moving ASM spfile to a shared device in RAC

If using pfile, it must be a filesystem file on local filesystem. If using spfile, then it can be in the following locations. -- a filesystem file spfile on local filesystem -- spfile on shared device -- a ASM file i

2011-04-25 10:49:00 4805

原创 Maximum String Size for asm_diskstring Parameter

In a single asm_diskstring parameter we can have 255 characters and this excludes the asterisk (*) , comma (,) and single-quote ('). This is limited by v$asm_disk.path column's datatype length. In an ASM instan

2011-04-25 10:41:00 4300

原创 How To Resize An ASM Disk On Release 10.2.0.X

1) Please backup the database(s) contained inside the associated diskgroup. 2) Then shutdown the databases contained inside the associated diskgroup. 3) Dismount the associated diskgroup to verify no client databas

2011-04-25 09:55:00 4982

原创 How to rename diskgroup in 10g ASM (Pre-11gR2 release)

rename diskgroup option is a new feature of 11gR2 . The command renamedg was introduced in 11gR2; however, there are many cases where a diskgroup in a 10g or 11.1 environment needs to be renamed. You can use this tool

2011-04-24 21:56:00 5251

原创 How to rename ASM instances in RAC or clustered environment

之前做的一个实验： RAC 修改 ASM实例名的步骤 http://blog.csdn.net/tianlesoftware/archive/2011/03/25/6275827.aspx The following procedures do require some down time. One node at a time, we will shutdown al

2011-04-24 21:27:00 7408 1

原创 How to rename ASM disks

If all you are doing is changing the name of the disk, then the only thing that should be necessary from Oracle's perspective is to change the ASM_DISKSTRING parameter on the ASM instance. Alternatively, you may be able to just r

2011-04-24 18:32:00 4760

原创 How To Rename A Diskgroup On ASM 11gR2

The present document provides a clear example about how to rename an ASM diskgroup on release 11gR2. Solution 1) First of all, the desired diskgroup needs to be dismounted (from each node if this is a RAC confi

2011-04-24 18:16:00 5004

原创 How To Remove An Empty ASM System Directory

Sometimes it can happen that the ASM contains empty system directories which cannot be removed. According to Note 3751057.8(ALTER DISKGROUP DROP DIRECTORY FORCE removes system aliases) the system generated directories should be removed

2011-04-24 17:28:00 11880

原创 How to remove an ASM instance and its corresponding database(s) on UNIX

This operation will DESTROY any databases that are currently running on the +ASM instance 1) Shutdown all databases that are running on the box using the +ASM instance for storage management 2) Use emca -x <sid> to rem

2011-04-24 17:20:00 4349

原创 How to remove an ASM instance and its corresponding database(s) on WINDOWS

1) Shutdown all datbases that are running on the box using the +ASM instance for storage management 2) Use emca -x <sid> to remove the Database Console for each instance 3) Remove the service for the instances

2011-04-24 17:18:00 4128

原创 How To Move The Database To Different Diskgroup (Change Diskgroup Redundancy)

Automatic Storage Management (ASM) is an integrated file system and volume manager expressly built for Oracle database files. This note is applicable : 1. If you wish to move to different ASM storage / Hardware. 2.

2011-04-24 16:12:00 7579

原创 How To Move Controlfile To ASM

This document provides information on how to move a controlfile from filesystem to ASM and Vise Versa Solution 1. Identify the location of the current controlfile: SQL> select name from v$controlfile;<br

2011-04-23 22:33:00 4580 1

原创 How to move ASM spfile to a different disk group

The goal is to move ASM spfile from one disk group to another. During initial ASM setup the spfile might have been created in a default disk group (e.g. DATA). The requirement is now to move the ASM spfile to another

2011-04-23 21:58:00 8979

原创 How to move ASM database files from one diskgroup to another

The preferred way of doing the file movement amoung ASM DISKGROUPS is using RMAN. RMAN is critical to Automatic Storage Management and is responsible for tracking the ASM filenames and for deleting obsolete ASM files. Since ASM f

2011-04-23 21:47:00 4547

原创 How To Migrate ASMLIB devices to Block Devices (non-ASMLIB)

The next example can be used to remove ASMLIB I/O access and allow ASM to access the block devices directly: <<< Before Continue With The Next Action Plan, Please Make Sure You Have A Full Database Backup Of All The Databa

2011-04-23 21:30:00 4011

原创 How to map asm files with online database files

One of the features of ASM is databases consolidation. A single diskgroup will be the repository for multiple databases. The result, having a large number of datafiles. If the files were created using OMF (Oracle Managed Files) form

2011-04-23 21:12:00 4365

原创 How to Increase CSS Misscount in single instance ASM installations

CSS is an essential component of ASM installations as it is required to syncrohize ASM resources and ASM crashes in the absence of CSS component. When there is any OS resource saturation (ie, CPU, memory shortage, etc), CSS

2011-04-23 17:45:00 4147

原创 10g RAC: Steps To Increase CSS Misscoun，t Reboottime and Disktimeout

The purpose of this note is to document the steps needed to modify the CSS misscount, reboottime and disktimeout settings. Please review Note 294430.1 to understand the implications before editing these settings.

2011-04-23 17:42:00 4396

原创 CSS Timeout Computation in Oracle Clusterware

The purpose of this Note is to document default CSS misscount timeout calculations in 10g Release 1, 10g Release 2 , 11g and higher versions. Scope and ApplicationDefine misscount parameter Define the default calculations for the misscount p

2011-04-23 17:38:00 5225

原创 How to duplicate a controlfile when ASM is involved

This document presents different options to duplicate a controlfile in environments using ASM. The procedure applies either to duplicate a controlfile into ASM using a controlfile stored in file system or to duplicate a controlfile int

2011-04-23 17:11:00 6698

原创 How To Drop and Recreate ASM Diskgroup

This article describe how we can drop and recreate ASM diskgroup when its not possible to perform this through SQL command. When a member disk in external redundancy diskgroup is no longer present (or destroyed beyond repair)

2011-04-23 16:52:00 6353

原创 How To Delete Archive Log Files Out Of +Asm

1. Run the following SQL to find the full path for the archivelog files. SELECT CONCAT('+'||gname, SYS_CONNECT_BY_PATH(aname,'/')) full_path, dir, sys FROM (SELECT g.name gname, a.parent_index pindex, a.name aname, a.refer

2011-04-23 13:43:00 5022

原创 How to Create Transportable Tablespaces Where the Source and Destination are ASM-Based

expdp/imp 的Transport_datafiles 在之前的Blog里有实例，参考下面blog的3.12小节： Oracle expdp/impdp 使用示例 http://blog.csdn.net/tianlesoftware/archive/2011/03/18/6260138.aspx The purpose of this note is to describ

2011-04-23 13:17:00 4719