ITPub博客

主库：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@][]

AIX: 'GGS ERROR 190 ... : Received Signal: OMVS Shutdown (33).' [ID 969596.1]Applies to: Oracle GoldenGate - Version: 4.0.0 - Release: 4.0.0Information in this document applies to any platform. Solution Issue: GoldenGate process on AIX stops with the following message: GGS ERROR 190 GoldenGate Collector: Received signal: OMVS Shutdown (33). Solution Overview: This message means that AIX had a system-wide paging problem, which it reported to the GoldenGate component, in this case the

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

implementing replication of cyclic sequences in GoldenGate [ID 1321558.1]Purpose OGG has added support for replication of cyclic sequences in the 11.1.1.1.x builds. Backport: Any code prior to v11.1.1.x must contain patch 9428942 to reliably replicate cyclic sequences. Documentation for versions 10.0, 10.4 and 11.1 states that extract supports sequences. In fact, sequences were not intended to be supported @ were never tested – hide, customer does not need to know this

事先准备：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

fsck 和chkdsk[@more@]

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@]

RH4 构建ORACLE ASM --http://guojuanjun.blog.51cto.com/277646/288332原创作品，允许转载，转载时请务必以超链接形式标明文章 原始出处 、作者信息和本声明。否则将追究法律责任。http://guojuanjun.blog.51cto.com/277646/288332 ORACLE ASM没有提供LINUX2.6.9-5.EL驱动.详情见http://www.oracle.com/technology/software/tech/linux/asmlib/rhel4.html,安装ASM之前,需升级LINUX内核. 安装以下RPM包,升级到LINUX2.6.9-11.EL,ORACLE提供了相应有ASM驱动.kernel-2.6.9-11.EL.i686.rpmkernel-devel-2.6.9-11.EL.i686.rpmkernel-hugemem-2.

Solaris内存管理以及判定内存是否够用的方法http://blog.sina.com.cn/s/blog_592060b50100dmwa.htmlSolaris内存管理以及判定内存是否够用的方法Solaris内存管理的一些基本原理 首先需要对Solairs的内存管理有一个基本的了解。Solaris内存管理简单来说就是“虚拟内存管理”模型。（注：现代OS差不多都是虚拟内存管理，包括Windows，Linux）虚拟内存的定义是： 虚拟内存的定义是基于对地址空间的重定义的，即把地址空间定义为连续的虚拟内存地址，以借此欺骗程序，使它们以为自己正在使用一大块的连续地址。（参见：虚拟内存- 维基百科

以下转自：http://4develop.in/page/MSSQL_DifficultProblems/20101207_16_3edfcac5-a2da-4a70-8e89-49d506bc1ece/sqlserver2005%E6%95%B0%E6%8D%AE%E5%BA%93%E9%95%9C%E5%83%8F%E6%8A%A5%E9%94%991469%E6%97%A0%E6%B3%95%E5%90%AF%E7%94%A8%E6%95%B0%E6%8D%AE%E5%BA%93%E9%95%9C%E5%83%8F%E6%95%B0%E6%8D%AE%E5%BA%93%E5%9C%A8%E5%85%B6%E4%B8%AD%E4%B8%80%E4%B8%AA%E4%BC%99%E4%BC%B4%E4%B8%8A%E6%98%AF%E8%87%AA%E5%8A%A8%E5%85%B3%E9%97%AD%E7%9A%84%E6%95%B0%E6%8D%AE%E5%BA%93.html sql server 2005数据库镜像报错1469，无法启用数据

v$controlfile_record_section[@more@]

https://www.ibm.com/developerworks/cn/views/aix/libraryview.jsp?type_by=%E6%8A%80%E6%9C%AF%E6%96%87%E7%AB%A0&view_by=search&sort_by=Date&sort_order=desc&view_by=Search&search_by=HACMP+%E8%AE%A4%E8%AF%81%E5%AD%A6%E4%B9%A0%E7%B3%BB%E5%88%97&Go.x=17&Go.y=19[@more@]

http://www.redbooks.ibm.com/abstracts/sg246375.html[@more@]

MBIND: CANNOT ALLOCATE MEMORY ON STARTUP [ID 578536.1] 修改时间 02-APR-2009 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Changes Cause Solution References Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.4 Linux x86-64 Oracle Server Enterprise Edition - Version: 10.2.0.4 Symptoms Seeing memory errors upon starting the database after applying 10.2.0.4 patchset.Typic