上一页 1 ··· 12 13 14 15 16 17 18 19 20 ··· 32 下一页
2011年4月26日
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 [ID 1145365.1] http://blog.csdn.net/tianlesoftware/archive/2011/04/05/6302817.aspx二. Automatic Storage Managem 阅读全文
posted @ 2011-04-26 15:27 davedba 阅读(175) 评论(0) 推荐(0)
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 Patch 8461420, Patch 8969852 should be applied:1. Download Patch 89698522. Since Patch 8402551 is part of unpubli 阅读全文
posted @ 2011-04-26 09:48 davedba 阅读(139) 评论(0) 推荐(0)
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 create the patch_storage area: /oragrid/rdb_v112/.patch_storage/System intact, . 阅读全文
posted @ 2011-04-26 09:43 davedba 阅读(133) 评论(0) 推荐(0)
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 create the patch_storage area: /oragrid/rdb_v112/.patch_storage/System intact, . 阅读全文
posted @ 2011-04-26 09:43 davedba 阅读(91) 评论(0) 推荐(0)
2011年4月25日
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 understandthenew11g infrastructure known as Automatic Diagnostic Repository.Scope and ApplicationAudience: Oracle 11g 阅读全文
posted @ 2011-04-25 22:58 davedba 阅读(123) 评论(0) 推荐(0)
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 understandthenew11g infrastructure known as Automatic Diagnostic Repository.Scope and ApplicationAudience: Oracle 11g 阅读全文
posted @ 2011-04-25 22:58 davedba 阅读(108) 评论(0) 推荐(0)
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.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 davedba 阅读(107) 评论(0) 推荐(0)
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.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 davedba 阅读(146) 评论(0) 推荐(0)
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 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 davedba 阅读(122) 评论(0) 推荐(0)
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 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 davedba 阅读(127) 评论(0) 推荐(0)
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) Shutdown the ASM instances. 3) Install / upgrade the new 11g CRS as described in the Installation Guide associated 阅读全文
posted @ 2011-04-25 16:50 davedba 阅读(103) 评论(0) 推荐(0)
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) Shutdown the ASM instances. 3) Install / upgrade the new 11g CRS as described in the Installation Guide associated 阅读全文
posted @ 2011-04-25 16:50 davedba 阅读(135) 评论(0) 推荐(0)
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 conditions should be met for to perform ASM rolling upgrade(*) An ASM rolling upgrade applies only to clustered . 阅读全文
posted @ 2011-04-25 16:33 davedba 阅读(119) 评论(0) 推荐(0)
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 conditions should be met for to perform ASM rolling upgrade(*) An ASM rolling upgrade applies only to clustered . 阅读全文
posted @ 2011-04-25 16:33 davedba 阅读(167) 评论(0) 推荐(0)
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 different directory) as described in the Installation Guide associated with your specific platform : http://www.orac. 阅读全文
posted @ 2011-04-25 16:22 davedba 阅读(120) 评论(0) 推荐(0)
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 different directory) as described in the Installation Guide associated with your specific platform : http://www.orac. 阅读全文
posted @ 2011-04-25 16:22 davedba 阅读(122) 评论(0) 推荐(0)
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 to be applied for 11.2.0.1 ASM rolling upgrade to 11.2.0.2 to be successful. Documentation rega. 阅读全文
posted @ 2011-04-25 16:14 davedba 阅读(167) 评论(0) 推荐(0)
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 to be applied for 11.2.0.1 ASM rolling upgrade to 11.2.0.2 to be successful. Documentation rega. 阅读全文
posted @ 2011-04-25 16:14 davedba 阅读(105) 评论(0) 推荐(0)
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 mountORA-15032: not all alterations performedORA-15063: diskgroup "" lacks quorum of 2 PST 阅读全文
posted @ 2011-04-25 15:01 davedba 阅读(177) 评论(0) 推荐(0)
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 mountORA-15032: not all alterations performedORA-15063: diskgroup "" lacks quorum of 2 PST 阅读全文
posted @ 2011-04-25 15:01 davedba 阅读(84) 评论(0) 推荐(0)
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 Best PracticesNote 249992.1 - New Feature on ASM (Automatic Storage Manager).Scope and ApplicationA schedu 阅读全文
posted @ 2011-04-25 14:49 davedba 阅读(141) 评论(0) 推荐(0)
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 Best PracticesNote 249992.1 - New Feature on ASM (Automatic Storage Manager).Scope and ApplicationA schedu 阅读全文
posted @ 2011-04-25 14:49 davedba 阅读(101) 评论(0) 推荐(0)
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 grid infrastructure for single instance, at the end we run root.sh, that directs you to run the following scrip. 阅读全文
posted @ 2011-04-25 11:22 davedba 阅读(83) 评论(0) 推荐(0)
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 grid infrastructure for single instance, at the end we run root.sh, that directs you to run the following scrip. 阅读全文
posted @ 2011-04-25 11:22 davedba 阅读(128) 评论(0) 推荐(0)
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*' scope=both;System altered.SQL> select path from v$asm_disk;PATH-------- 阅读全文
posted @ 2011-04-25 11:05 davedba 阅读(172) 评论(0) 推荐(0)
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*' scope=both;System altered.SQL> select path from v$asm_disk;PATH-------- 阅读全文
posted @ 2011-04-25 11:05 davedba 阅读(122) 评论(0) 推荐(0)
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 1824 1 0 Mar 12 ? 0:01 /oracle/64bit/10.1.0/bin/ocssd.bin Solution In a non-RAC environment, the ocssd.b. 阅读全文
posted @ 2011-04-25 10:59 davedba 阅读(116) 评论(0) 推荐(0)
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 1824 1 0 Mar 12 ? 0:01 /oracle/64bit/10.1.0/bin/ocssd.bin Solution In a non-RAC environment, the ocssd.b. 阅读全文
posted @ 2011-04-25 10:59 davedba 阅读(134) 评论(0) 推荐(0)
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 in a ASM diskgroup (only for spfile for DB instances before 11.2)Trying to put ASM spfile 阅读全文
posted @ 2011-04-25 10:49 davedba 阅读(141) 评论(0) 推荐(0)
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 in a ASM diskgroup (only for spfile for DB instances before 11.2)Trying to put ASM spfile 阅读全文
posted @ 2011-04-25 10:49 davedba 阅读(141) 评论(0) 推荐(0)
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 instance we can have multiple asm_diskstring parameters. But the values from them are co 阅读全文
posted @ 2011-04-25 10:41 davedba 阅读(89) 评论(0) 推荐(0)
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 instance we can have multiple asm_diskstring parameters. But the values from them are co 阅读全文
posted @ 2011-04-25 10:41 davedba 阅读(116) 评论(0) 推荐(0)
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 database connections are accessing this specific diskgroup:SQL> alter diskgroup dismount;4) 阅读全文
posted @ 2011-04-25 09:55 davedba 阅读(124) 评论(0) 推荐(0)
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 database connections are accessing this specific diskgroup:SQL> alter diskgroup dismount;4) 阅读全文
posted @ 2011-04-25 09:55 davedba 阅读(149) 评论(0) 推荐(0)
2011年3月31日
Oracle 11.2.0.2 Patch 说明
摘要： 今天小看了一下 Oracle 11.2.0.2 Patch， patch number: 10098816。 Patch最大的6G多。 杯具中. Oracle 软件是越来越大了。 还在下这些Patch文件，等下完了，把本机的11gR1的升级下玩玩。 Oracle 针对这个Patch 的更新，专门出了一个说明文档，具体参考： Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2 [ID 1189783.1] http://blog.csdn.net/tianlesoftware/archive/2011/03 阅读全文
posted @ 2011-03-31 23:00 davedba 阅读(137) 评论(0) 推荐(0)
Oracle 11.2.0.2 Patch 说明
摘要： 今天小看了一下 Oracle 11.2.0.2 Patch， patch number: 10098816。 Patch最大的6G多。 杯具中. Oracle 软件是越来越大了。 还在下这些Patch文件，等下完了，把本机的11gR1的升级下玩玩。 Oracle 针对这个Patch 的更新，专门出了一个说明文档，具体参考： Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2 [ID 1189783.1] http://blog.csdn.net/tianlesoftware/archive/2011/03 阅读全文
posted @ 2011-03-31 23:00 davedba 阅读(135) 评论(0) 推荐(0)
Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2 [ID 1189783.1]
摘要： Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2 [ID 1189783.1]Modified 13-SEP-2010Type ANNOUNCEMENTStatus PUBLISHEDIn this DocumentWhat is being announced?Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2What do you need to do?Who to contact for more infor 阅读全文
posted @ 2011-03-31 22:49 davedba 阅读(175) 评论(0) 推荐(0)
Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2 [ID 1189783.1]
摘要： Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2 [ID 1189783.1]Modified 13-SEP-2010Type ANNOUNCEMENTStatus PUBLISHEDIn this DocumentWhat is being announced?Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2What do you need to do?Who to contact for more infor 阅读全文
posted @ 2011-03-31 22:49 davedba 阅读(236) 评论(0) 推荐(0)
On RAC, expdp Removes the Service Name [ID 1269319.1]
摘要： On RAC, expdp Removes the Service Name [ID 1269319.1]Modified 25-NOV-2010Type PROBLEMStatus MODERATEDIn this DocumentSymptomsCauseSolutionReferencesThis document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent tec 阅读全文
posted @ 2011-03-31 16:14 davedba 阅读(224) 评论(0) 推荐(0)
On RAC, expdp Removes the Service Name [ID 1269319.1]
摘要： On RAC, expdp Removes the Service Name [ID 1269319.1]Modified 25-NOV-2010Type PROBLEMStatus MODERATEDIn this DocumentSymptomsCauseSolutionReferencesThis document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent tec 阅读全文
posted @ 2011-03-31 16:14 davedba 阅读(202) 评论(0) 推荐(0)
上一页 1 ··· 12 13 14 15 16 17 18 19 20 ··· 32 下一页