- 博客(95)
- 资源 (40)
- 收藏
- 关注
原创 MySQL 引擎 和 InnoDB并发控制 简介
<br /> <br /> <br /> MySQL存储引擎采用了可插拔的结构,即用户可以根据自己的需要来选择不同的存储引擎。<br /> <br />下表是MySQL不同的存储引擎的不同的特性:<br />Feature<br />MyISAM<br />BDB<br />Memory<br />InnoDB<br />Archive<br />NDB<br />Storage limits<br />256TB<br />No<br />Yes<br />64TB<br />No<br />
2011-04-29 15:07:00 5324 1
原创 MySQL 和 PostgreSQL 对比
<br /> <br /> 最近打算研究下几个开源的数据库,但是主要精力还是研究Oracle RDBMS。MySQL 和PostgreSQL 是开源中用的最多的2个。从网上搜了点资料。整理如下。这些资料也是以前的资料,现在肯定是有变动。所以这些内容,仅供参考。<br /> <br />一、两者的共同优势<br /> 这两个产品都属于开放源码的一员,性能和功能都在高速地提高和增强。MySQL AB的人们和PostgreSQL的开发者们都在尽可能地把各自的数据库改得越来越好,所以对于任何商业数据库
2011-04-29 11:23:00 7889 3
原创 Oracle ASM 系列 小结
<br /> <br /> <br />在metalink上看到一篇有关ASM 总结的文章,贴出来,共同学习。<br /> <br />一. Automatic Storage Management (ASM) Alerts:<br /> Alert: Querying v$asm_file Gives ORA-15196 After ASM Was Upgraded From 10gR2 To 11gR2 with an AU size > 1M [ID 1145365.1]<br />
2011-04-26 15:27:00 13657
原创 Patch 8402551 Is Not Available
<br /> <br /> <br />Patch 8402551 not available to download from Metalink.Solution<br />Patch 8402551 has been withdrawn because it had some issues, it was replaced by Patch 8969852.<br /><br />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
<br /> <br /> When applying a needed patch to the Grid Infrastructure Home for ASM or CRS the opatch utility may error out with the messages:<br /> <br />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.
<br /> <br />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
<br /> <br />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:<br /><br /><br />/u01/app/oracle/product/11.1.0/dbs>sqlplus<br /><br />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)
<br /> <br /> <br />Upgrading ASM instance from Oracle 10.1 to Oracle 10.2. (Single Instance) Solution<br /> o Upgrading of ASM instance from 10.1 to 10.2 can be accomplished through DBUA.<br /> 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)
<br /> <br />The present document explains how to upgrade an ASM instance from 10.2 to 11.1 release (on RAC). Solution<br />1) Shutdown all the database instances that are using ASM as storage option. <br /><br />2) Shutdown the ASM instances. <br /><br />
2011-04-25 16:50:00 5092
原创 How to perform Rolling Upgrade-Downgrade in 11g ASM
<br /> <br /> 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<br />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)
<br /> <br /> The present document explains how to upgrade an ASM instance from 10.2 to 11.1 release (single Instance configuration / Non-RAC). Solution<br />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
<br /> <br /> <br /> This note is to clarify the patch requirement when doing 11.2.0.1 to 11.2.0.2 rolling upgrade. <br /> <br />Pre-requsite for 11.2.0.1 to 11.2.0.2 ASM Rolling Upgrade<br /> There has been some confusion as what patches need
2011-04-25 16:14:00 5280
原创 Steps to Re-Create ASM Diskgroups
<br /> <br /> <br /> 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:<br /><br />SQL> startup mount<br /><br />OR
2011-04-25 15:01:00 5584
原创 Steps To Migrate-Move a Database From Non-ASM to ASM And Vice-Versa
<br /> <br /> <br />This article describes the steps to migrate a database from Non-ASM to ASM and vice-versa. <br /><br />To setup ASM, please follow<br />Note 452924.1 - How to Prepare Storage for ASM<br />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
<br /> <br /> This document provides a procedure to configure/reconfigure the ( High Availability Service ) HAS and CSS resource on Oracle Grid Infrastructure for nonRAC setup <br /> <br />Solution<br /> 1)When you install grid infrastructure f
2011-04-25 11:22:00 5416
原创 Pattern Matching Metacharacters For asm_diskstring
<br /> <br />This document will list the possible meta characters for asm_diskstring parameter <br /> <br />Solution<br />* and [] are the two valid meta characters for asm_diskstring parameter.<br /><br />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
<br /> <br /> <br /> After installing a non-RAC (Real Application Clusters) 10g database, you notice an ocssd.bin process running.<br /><br />ps -ef | grep ocssd.bin<br />oracle 11139 11056 0 14:02:14 pts/52 0:00 grep ocssd.bin<br />oracle 1824 1 0 M
2011-04-25 10:59:00 5416
原创 Moving ASM spfile to a shared device in RAC
<br /> <br /> <br />If using pfile, it must be a filesystem file on local filesystem.<br />If using spfile, then it can be in the following locations.<br />-- a filesystem file spfile on local filesystem<br />-- spfile on shared device<br />-- a ASM file i
2011-04-25 10:49:00 4805
原创 Maximum String Size for asm_diskstring Parameter
<br /> <br /> <br /> 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. <br /><br /> In an ASM instan
2011-04-25 10:41:00 4300
原创 How To Resize An ASM Disk On Release 10.2.0.X
<br /> <br /> <br />1) Please backup the database(s) contained inside the associated diskgroup.<br /><br />2) Then shutdown the databases contained inside the associated diskgroup.<br /><br />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)
<br /> <br /> rename diskgroup option is a new feature of 11gR2 .<br /><br /> 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
<br /> <br /> <br />之前做的一个实验:<br /> RAC 修改 ASM实例名的步骤<br /> http://blog.csdn.net/tianlesoftware/archive/2011/03/25/6275827.aspx<br /> <br /> <br /> 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
<br /> <br /> <br /> 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
<br /> <br /> The present document provides a clear example about how to rename an ASM diskgroup on release 11gR2. <br /> <br />Solution<br /> <br />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
<br /> <br /> 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
<br /> <br /> This operation will DESTROY any databases that are currently running on the +ASM instance <br /> <br />1) Shutdown all databases that are running on the box using the +ASM instance for storage management<br />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
<br /> <br />1) Shutdown all datbases that are running on the box using the +ASM instance for storage management <br />2) Use emca -x <sid> to remove the Database Console for each instance<br /><br />3) Remove the service for the instances<br /><br />
2011-04-24 17:18:00 4128
原创 How To Move The Database To Different Diskgroup (Change Diskgroup Redundancy)
<br /> <br /> Automatic Storage Management (ASM) is an integrated file system and volume manager expressly built for Oracle database files.<br /><br />This note is applicable :<br />1. If you wish to move to different ASM storage / Hardware.<br />2.
2011-04-24 16:12:00 7579
原创 How To Move Controlfile To ASM
<br /> <br /> This document provides information on how to move a controlfile from filesystem to ASM and Vise Versa <br /> <br />Solution<br /> <br />1. Identify the location of the current controlfile:<br />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
<br /> <br /> The goal is to move ASM spfile from one disk group to another.<br /><br /> 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
<br /> <br /> <br /> 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)
<br /> <br /> The next example can be used to remove ASMLIB I/O access and allow ASM to access the block devices directly: <br /> <br /><<< 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
<br /> <br /> 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
<br /> <br /> 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. <br /> 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
<br /> <br /> 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.<br /> <br />
2011-04-23 17:42:00 4396
原创 CSS Timeout Computation in Oracle Clusterware
<br /> <br />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 5226
原创 How to duplicate a controlfile when ASM is involved
<br /> <br /> 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
<br /> <br /> <br />This article describe how we can drop and recreate ASM diskgroup when its not possible to perform this through SQL command.<br /><br />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
<br /> <br />1. Run the following SQL to find the full path for the archivelog files.<br /><br />SELECT CONCAT('+'||gname, SYS_CONNECT_BY_PATH(aname,'/')) full_path,<br />dir, sys FROM (SELECT g.name gname, a.parent_index pindex, a.name aname,<br />a.refer
2011-04-23 13:43:00 5022
原创 How to Create Transportable Tablespaces Where the Source and Destination are ASM-Based
<br /> <br /> expdp/imp 的Transport_datafiles 在之前的Blog里有实例,参考下面blog的3.12小节: <br /> Oracle expdp/impdp 使用示例<br /> http://blog.csdn.net/tianlesoftware/archive/2011/03/18/6260138.aspx<br /> <br /> The purpose of this note is to describ
2011-04-23 13:17:00 4719
Oracle 11g 架构图 from Oracle University
2010-05-13
Oracle Database 10g OCP Certification All-in-One Exam Guide.pdf
2009-06-24
MFC简易股票交易系统
2008-06-17
Linux 7.7 平台 Oracle 19c Data Guard 环境 升级RU 19.3 到19.6 操作手册.pdf
2020-03-11
Linux 7.7 平台 Oracle 19.3 物理Data Guard 搭建手册.pdf
2020-03-11
Oracle 19c 单实例 RU 从19.3.0 升级到19.6.0 操作手册.pdf
2020-03-11
Oracle Linux 6.1 + Oracle 11.2.0.1 RAC + RAW安装文档.pdf
2012-11-22
oracle8i.internal.services.for.waits.latches.locks
2012-05-31
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人