2011年04月_iteye_20968

MySQL 引擎和 InnoDB并发控制简介

MySQL存储引擎采用了可插拔的结构，即用户可以根据自己的需要来选择不同的存储引擎。下表是MySQL不同的存储引擎的不同的特性：FeatureMyISAMBDBMemoryInnoDBArchiveNDBStorage limits256TBNo...

2011-04-29 15:07:00 46

NoSQL 数据库简介

一. NoSQL概念开源的数据库用的最多的是PostgreSQL和MySQL。关于这2者的对比，参考我的Blog： MySQL 和 PostgreSQL 对比 http://blog.csdn.net/tianlesoftware/archive/2011/04/29/6371498.aspx NoSQL 它指的是一个整体的概念，在2009年被提了出来。大...

2011-04-29 14:12:00 56

MySQL 和 PostgreSQL 对比

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

2011-04-29 11:23:00 54

Mysql中，SQL语句长度限制

今天发现了一个错误：Could not execute JDBC batch update最后发现原因是SQL语句长度大于1M,而我机器上的mysql是默认设置，也就是说mysql通讯的数据包大小设置是１M,这就造成sql语句执行失败。于是把mysql的配置文件（my.ini）中的max_allowed_packet = 6M变大，问题就解决了。...

2011-04-28 15:48:00 223

如何卸载IE9恢复IE8浏览器？

IE9正式版发布了，一些朋友安装后发现有些功能并不满意，于是想卸载IE9并恢复以前的IE8浏览器。下面介绍如何卸载IE9恢复IE8浏览器的方法。IE9浏览器安装后自动覆盖以前的IE8浏览器，如果想恢复以前的IE8，只需要：控制面板 -> 程序 -> 程序和功能 -> 查看已安装更新在里面找到Microsoft Windows下的Windows I...

2011-04-27 10:59:00 126

dsp builder中多个project自动生成VHDL冲突的解决方法

在用dsp builder实现算法时，分解成多个小模块仿真比较方便。每个模块可以独立生成对应的VHDL代码。然而不同模块的VHDL有重复的文件被包含在qip文件中，编译时会因为重复而报错。我的解决方法是，在每个模块生成VHDL代码时，都放在一个文件夹中，重复的文件会自动覆盖掉，便不会出现重复导致的报错了。...

2011-04-26 19:44:00 97

Oracle ASM 系列小结

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

2011-04-26 15:27:00 96

Patch 8402551 Is Not Available

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

2011-04-26 09:48:00 58

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. Ap...

2011-04-26 09:43:00 55

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 understandthene...

2011-04-25 22:58:00 56

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>sqlplusSQL*Plus: Release 11.1...

2011-04-25 17:19:00 70

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) Solutiono Upgrading of ASM instance from 10.1 to 10.2 can be accomplished through DBUA.o All the database that...

2011-04-25 17:14:00 49

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). Solution1) Shutdown all the database instances that are using ASM as storage option. 2) Shu...

2011-04-25 16:50:00 47

How to perform Rolling Upgrade-Downgrade in 11g ASM

The purpose of this document is to provide information about theASM rolling upgrade feature and Step by Stepto install a patchset orpatch in ASM Homewithoutdowntime.SolutionThe following ...

2011-04-25 16:33:00 54

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). Solution1) Install the new 11g ASM Oracle Home (on a diff...

2011-04-25 16:22:00 43

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 wha...

2011-04-25 16:14:00 58

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> star...

2011-04-25 15:01:00 62

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 followNote 452924.1 - How to Prepare Storage for ASMNote 265633.1 - ASM Technical ...

2011-04-25 14:49:00 70

Reconfigure HAS and CSS for nonRAC ASM on 11.2

Thisdocument provides a procedure to configure/reconfigure the ( High AvailabilityService ) HAS and CSS resource on Oracle Grid Infrastructure for nonRAC setup Solution 1） Whenyou install gri...

2011-04-25 11:22:00 49

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_d...

2011-04-25 11:05:00 56

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.binoracle 11139 11056 0 14:02:14 pts/52 0:00 grep ocssd.binoracle ...

2011-04-25 10:59:00 49

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 devic...

2011-04-25 10:49:00 49

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. ...

2011-04-25 10:41:00 49

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 n...

2011-04-25 09:55:00 58

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. Y...

2011-04-24 21:56:00 54

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 a...

2011-04-24 21:27:00 36

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. Altern...

2011-04-24 18:32:00 57

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. Solution1) First of all, the desired diskgroup needs to be dismounted (from each node if...

2011-04-24 18:16:00 88

How To Remove An Empty ASM System Directory

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

2011-04-24 17:28:00 60

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 management2...

2011-04-24 17:20:00 35

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 instance3) Remove the service...

2011-04-24 17:18:00 39

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...

2011-04-24 16:12:00 53

How To Move Controlfile To ASM

This document provides information on how to move a controlfile from filesystem to ASM and Vise Versa Solution1. Identify the location of the current controlfile:SQL> select name from ...

2011-04-23 22:33:00 53

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 AS...

2011-04-23 21:58:00 66

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 deleti...

2011-04-23 21:47:00 50

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

The next example can be used to remove ASMLIB I/O accessand allow ASM to access the block devices directly: <<< Before Continue With The Next Action Plan, Please Make Sure You Have A F...

2011-04-23 21:30:00 61

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 us...

2011-04-23 21:12:00 46

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. Whenthere is any OS resource saturation (ie, CPU...

2011-04-23 17:45:00 45

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 ...

2011-04-23 17:42:00 50

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 andhigher versions. Scope and ApplicationDefinemisscount parameter...

2011-04-23 17:38:00 51

空空如也

空空如也