ITPub博客

/* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.5pt; mso-bidi-font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-the

In 11.2,不允许建立超过2tb的asm磁盘组，exadata在打相关补丁的情况下，可以建立超过2tb的磁盘组in this Document Goal Solution Applies to: Oracle Server - Enterprise Edition - Version: 11.2.0.0. to 11.2.0.2 - Release: 11.2 to 11.2Information in this document applies to any platform. ASM instance Goal Trying to add a 2 TB disk to an ASM diskgroup Solution In 11.2 a check was made to disallow creation of diskgroups with disks of size > 2tb. This should not apply to EXADATA mach

How to find RAC certifications in MOS Certification Tab [ID 1053954.1][@more@]

1.多路径软件是否支持asm一般ds8000使用的多路径软件是vpath，但是vpath不支持asm，所以需要换成mpio2.若是确定asm存储方式，请将hacmp软件卸载。3.emc的多路径软件是powerpath[@more@]

一次数据库不能归档问题的处理：http://empo007.itpub.net/post/12076/300893版权归属于原作者。感谢原作者。 数据库不能归档，很多的时候是因为磁盘空间不够或者在线日志文件损坏导致。然而4月份的时候，我却遇到一个非常奇怪的归档不成功的问题：1、用户数据库不能登陆，查看警告日志，发现下面的错误：ORA-19510: failed to set size of 102395 blocks for file "/oradata/gpsdb/archive/1_9410.dbf" (blocksize=1024)ORA-27037: unable to obtain file statusHP-UX Error: 2: No such file or directoryAdditional inform

Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.2.0 - Release: 9.2 to 11.2Information in this document applies to any platform. Symptoms While trying to connect to a database running on Windows using "/ as sysdba" from an OS session started as a domain user the following error occurs: sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on M Mar 8 17:22:36 2010Copyright (c) 1982, 2007, Oracle. All Rights Reserved.ERROR:ORA-1031: Insuf

Troubleshooting ORA-1031: Insufficient Privileges While Connecting As SYSDBA [ID 730067.1] 修改时间 05-SEP-2011 类型 TROUBLESHOOTING 状态 PUBLISHED In this Document Purpose Last Review Date Instructions for the Reader Troubleshooting Details Generic Concepts SYSDBA OS Authentication SYSDBA Password File Authentication Troubleshooting ORA-1031 when connecting as SYSDBA using OS Authenticat

Applies to: Oracle Server - Enterprise Edition - Version: 6.0.0.0 to 11.2.0.2.0 - Release: 6.0 to 11.2Microsoft Windows (32-bit) Symptoms The local connection is failing when making a bequeath connection:Enter user-name: sys as sysdbaEnter password:ERROR:ORA-12560: TNS:proto adapter error Changes This is a newly duplicated database. Cause The Windows service name does not match the value for ORACLE_SID. Solution The ORACLE_SID environment variable is used to determine which se

RAC and Sequences [ID 853652.1] 修改时间 13-JUL-2011 类型 BULLETIN 状态 PUBLISHED In this Document Purpose Scope and Application RAC and Sequences 1. Sequence setup 2. Gap in sequences 3. Performance impact when using CACHE or NOCACHE Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.2 - Release: 10.1 to 11.2Information in this document applies to any platform.

本文转自：http://jzhil2004.blog.163.com/blog/static/275585042010112911625896/感谢原作者.ORA-16047: DGID mismatch between destination setting and standby一般是由于主库上log_archive_dest_?参数设置的db_unique_name和实际备库上设置的db_unique_name不一致引起 处理过程：1）由于之前的standby备机是可以应用日志的，后面由于机房停电，在关闭主从的时候，先关闭主，然后再关闭从，可是当时关闭了主以后，由于从库已经非法停了，类似于停电，后面进行主从库重新开启应用的时候，过程如下：从库：startup mount;alter database

主库：v$managed_standbyv$archive_dest_status备库：v$archived_log[@more@]

SQL> ALTER tablespace temp add tempfile '/dev/vgbill05/rlvbill05_4g_48' size 4000M;ALTER tablespace temp add tempfile '/dev/vgbill05/rlvbill05_4g_48' size 4000MORA-01268: 用于变更永久性 TABLESPACE 的 TEMPFILE 子句无效SQL> 白鳝1群里的凉面说：你把size设置成小于4G的就可以了，我也碰到过这个，是bug单个文件不能超过4G，上次我们那个8i的系统就挂了，因为涨到了4G先记录一下。[@more@]

一般而言，crontab 定义的任务计划无法执行，无非几个原因：1.先看此linux系统中linux的 crontab进程是否在running 的状态。2.再看crontab中对应的脚本(假设此脚本名称为a.sql)是否有执行权限3.crontab中对应的脚本(假设此脚本名称为a.sql)中的内容是否包含如下的条目 a. ORACLE_BASE b. ORACLE_HOME C.ORACLE_SID D.PATH变量4. a.sql不要在windows下编辑好，然后ftp传到linux中。这样windows下有些不可见字符会导致linux无法运行此a.sql.此点是白鳝1群里一个哥们说的， [@more@][]

Role Transitions for Data Guard Configurations Using Mixed Oracle Binaries [ID 414043.1][@more@]

Oracle ASM and Multi-Pathing Technologies [ID 294869.1] 内容不错，其实就是一个pdf文档。[@more@]

ASM 11gR2 Incorrectly Recognize Disks (e.g. 1.25 TB ) As 4,095.25 TB Disk On AIX. [ID 1095202.1]这个bug也够狠的。。。1) ASM / ASMCA on AIX is detecting 1.25 TB (1,317,888 MB) as 4,095.25 TB (4,294,188,032 MB) disk:2) bootinfo OS AIX tool provides the correct size:Cause 1) On release 11.2.0.1:This problem is due to the Bug 9495887 ASM RECOGNIZE 1.25 TB DISKS AS 4,095.25 TB DISKS ON AIX.2) On release 11.2.0.2:This problem is due to the Bug 10072750 ASM RECOGNIZE 1 TB DISKS AS MORE THAN 2 TB DI

事先准备：cp 源端和目的端的目录。1.将ggv11.1安装于一个新目录。不用create subdirs2.停止源端和目的端的ddl复制--让目的端的replicat进程 执行完毕后。再处理。3.stop 源端 和 目的端进程。4.将在新目录中的ggv11.1覆盖到原来的gg目录5.处理ddl复制问题：(Oracle) Rebuilding the DDL environment to a clean state：核心：remove, and then reinstall 1.停止source所有的gg进程，改变目录到gg的安装目录 2.sqlplus / as sysdba 3.让那些发布ddl语句的进程断开，否则会报：ORA-04021 error 4.Run the ddl_disable script 5.Run th

What is the database initialization parameter that is associated to an ORA-32004 error ? [ID 335071.1]Goal How to know which parameter is obsolete and/or deprecated when the only message on screen whenattempting to start a database is "ORA-32004: obsolete and/or deprecated parameter(s) specified" ? Solution 1.Look at the DBA's alert log of the associated instance as newer versions of the RDBMS software will identify the parameters that are obsolete and/or deprecated within the a

select dest_id,error from v$archive_dest;有时候，主库上的alert日志不足以显示主库dataguard的传输问题，这就需要v$archive_dest视图来辅助定位 dataguard传输的问题。[@more@]

1.以grid用户执行：命令修改如下：（进入grid用户执行）crsctl modify resource ora.DATA.dg -attr AUTO_START=alwayscrsctl modify resource ora.FLA.dg -attr AUTO_START=always解决cluster重启后，oracle rac asm磁盘组无法自动加载的问题。此问题是是oracle 11.2.0.1 rac的bug2.修改系统参数：deferred_segment_creation alter system set deferred_segment_creation=FALSE此参数为FALSE时，表示空表也exp出来。该值设置后对修改前导入的空表不产生作用，仍不能导出，只能对后面新增的空表产生作用。[@more@]