摘要：
最近打算研究下几个开源的数据库，但是主要精力还是研究Oracle RDBMS。 MySQL 和PostgreSQL 是开源中用的最多的2个。 从网上搜了点资料。 整理如下。 这些资料也是以前的资料， 现在肯定是有变动。 所以这些内容，仅供参考。 一、两者的共同优势 这两个产品都属于开放源码的一员，性能和功能都在高速地提高和增强。MySQL AB的人们和PostgreSQL的开发者们都在尽可能地把各自的数据库改得越来越好，所以对于任何商业数据库使用其中的任何一个都不能算是错误的选择。 二、两者不同的背景 MySQL的背后是一个成熟的商业公司，而PostgreSQL的背后是一个庞大的志愿开... 阅读全文
posted @ 2011-04-29 11:23
sqlite例子
阅读(367)
评论(0)
推荐(0)
摘要：
在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 [ID 1145365.1] http://blog.csdn.net/tianlesoftware/archive/2011/04/05/6302817.aspx二. Automatic Storage Managem 阅读全文
posted @ 2011-04-26 15:27
sqlite例子
阅读(201)
评论(0)
推荐(0)
摘要：
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 Patch 8461420, Patch 8969852 should be applied:1. Download Patch 89698522. Since Patch 8402551 is part of unpubli 阅读全文
posted @ 2011-04-26 09:48
sqlite例子
阅读(158)
评论(0)
推荐(0)
摘要：
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 create the patch_storage area: /oragrid/rdb_v112/.patch_storage/<patch#_date& 阅读全文
posted @ 2011-04-26 09:43
sqlite例子
阅读(187)
评论(0)
推荐(0)
摘要：
Beginning with Release 11g, Oracle Database includes an advanced fault diagnosability infrastructure for preventing, detecting, diagnosing, and resolving problems. This note helps to understandthenew11g infrastructure known as Automatic Diagnostic Repository.Scope and ApplicationAudience: Oracle 11g 阅读全文
posted @ 2011-04-25 22:58
sqlite例子
阅读(155)
评论(0)
推荐(0)
摘要：
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.0.6.0 - Production on Wed Apr 7 15:49:33 2010Copyright (c) 1982, 2007, Oracle. All rights reserved.Ente 阅读全文
posted @ 2011-04-25 17:19
sqlite例子
阅读(148)
评论(0)
推荐(0)
摘要：
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 use the ASM instance being upgraded must be shutdown.The following steps can be used to upgrade an ASM instance.1) 阅读全文
posted @ 2011-04-25 17:14
sqlite例子
阅读(192)
评论(0)
推荐(0)
摘要：
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) Shutdown the ASM instances. 3) Install / upgrade the new 11g CRS as described in the Installation Guide associated 阅读全文
posted @ 2011-04-25 16:50
sqlite例子
阅读(122)
评论(0)
推荐(0)
摘要：
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 conditions should be met for to perform ASM rolling upgrade(*) An ASM rolling upgrade applies only to clustered . 阅读全文
posted @ 2011-04-25 16:33
sqlite例子
阅读(144)
评论(0)
推荐(0)
摘要：
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 different directory) as described in the Installation Guide associated with your specific platform : http://www.orac. 阅读全文
posted @ 2011-04-25 16:22
sqlite例子
阅读(130)
评论(0)
推荐(0)
浙公网安备 33010602011771号