ITPub博客

You Asked I am seeing that when I use the dbms_mview.refresh function to refresh a group of Materialized Views, that the view contents are deleted. I have also seen that if I set atomic_refresh to False, that Truncate should be used. In reading the description of atomic_refresh indicates whether the group of MV's is refresh together or as independent refreshes. It does not discuss 'Delete' vs 'Truncate'. My situation is that I have several MV's that are quite large and would prefer t

环境介绍：oracle11.2.0.3redhat 5.6 64biterror:Invalid Entry Size[@more@] 再将11.2.0.3的1of7 、2of7解压后安装过程中遇到：Invalid Entry Size错误，查找support后发现是md5变化导致的原因，Got "Invalid Entry Size" Error During Oracle 11.2.0.2 Install On Aix 6.1 [ID 1301113.1]SolutionOnce the Oracle Database file is downloaded from OTN ,Please check the following 1. filesize 2. md5sum or cksum value These two values need to be same as specified in the download page of the part

GPFS is IBM’s high-performance parallel, scalable file system for IBM UNIX clusters capable of supporting multi-terabytes of storage within a single file system.GPFS is a shared-disk file system where every cluster node can have parallel, concurrent read/write access to the same file.It is designed to provide high-performance I/O by "striping" data across multiple disks accessed from multiple servers.GPFS provides high availability through logging and replication, and can be configure

GPFS V3.4 Concepts, Planning, and Installation GuideGA76-0413-04[@more@] When utilizing GPFS™ with Oracle, configuration and tuning considerations include: When setting up your LUNs, it is important to create the NSD such that they map one to one with a LUN that is a single RAID device. For file systems holding large Oracle databases, set the GPFS file system block size through the mmcrfs command using the -B option, to a large value: 512 KB is generally suggested. 256

环境：ORACLE10.2.0.4 64BITREDHAT 5.6 64BITAGENT 11.2.0.1 64BIT打5759944补丁遇到：OPatch failed with error code 73[@more@] 因为公司内使用EM11g作为整体的数据监控平台，所以在agent端agent是11g，而DB是10g所以在opatch的时候调用的是agent的目录，最终导致安装补丁失败：[oracle@bi 5759944]$ ../opatch applyInvoking OPatch 10.2.0.4.2 Oracle Interim Patch Installer version 10.2.0.4.2Copyright (c) 2007, Oracle Corporation. All rights reserved. Oracle Home : /u01/oracle/product/10.2.0/db_1Central

解决：ls | xargs -n 50 rm -fr lsxargs就是将ls的输出，每10个为一组(以空格为分隔符)，作为rm -rf的参数也就是说将所有文件名50个为一组，由rm -rf删除[@more@]

环境：DELL R900 RedHat linux 5.6 64bitORACLE 10GR2在系统断电重启后发现存储上的iscsi卷没有自动挂载 [@more@] 解决步骤如下：首先是查看物理卷是否已经发现：[root@appdb-test oracle]# pvs PV VG Fmt Attr PSize PFree /dev/sdc test_volum lvm2 a- 1.09T 87.93G[root@appdb-test oracle]# 通过以上可以正确发现我之前创建的PV。继续查看我们的逻辑组是否被发现：[root@appdb-test oracle]# vgs -v Finding all volume groups Finding volume group "test_volum" VG Attr

环境介绍：power desiger 12.5今天开发组的问我说，关于使用power desiger修改某个表的name后，相应的code也会自动进行更改，找了许久也没有什么地方可以设置为不自动关联的，这个自动关联的方式确实很影响我们日常的使用，有时候我们想将name改为中文，code列继续保留原来的编码，我们不可能把每个列都一一打开来改的，其实通过设置以下参数就可以达到很好的效果的：[@more@]选择工具栏的：TOOL > General Options > Dialog 将里面的Nmae to Code mirroring前面的勾选去掉就可以了。

今天项目里报说通过POWERDESIGER反向工程生成的表里面缺少许多的表.[@more@]通过查找发现缺少的这些表都是物化视图对应的实体表，通过跟踪PD后台调用数据库的SQL语句发现是其对应的SQL为：select t.owner, t.table_name from sys.all_all_tables t where not exists (select 1 from sys.all_mviews s where s.owner = t.owner and t.table_name in (s.mview_name, s.update_log)) and t.iot_name is null and nvl(t.dropped, 'NO') = 'NO' and t.owner='TEST' order by t.owner, t.table_name通过以上问题的原因就很明显了，是PD

错误描述：oracle 10.2.0.4 64bitredhat5.6 64bit在创建函数完成后调用直接报错：Errors in file /opt/oracle/admin/kebao/udump/kebao_ora_26334.trc:ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []SESSION会话也直接中断。[@more@]通过定义typetype bodyfunction后通过SQL调用新声明的function函数，会话直接关闭，通过查看alert文件发现报以下错误：Errors in file /opt/oracle/admin/kebao/udump/kebao_ora_26334.trc:ORA-07445: exception

在win模式下和在linux下安装AGENT程序稍微有点出入，但总的方式都是使用静默的方式来安装，在linux下只需WGET， wget https://gcem:4900/agent_download/11.1.0.1.0/linux_x64/agentDownload.linux_x64 --no-check-certificate然后再安装：./agentDownload.linux_x64 -b $ORACLE_HOME -m gcem -r 4900 -y最后再执行$AGENT_HOME/root.sh文件即可，但是在WIN下就稍微有点出入，[@more@]在win下，首先要编辑response目录下得additional_agent.rsp文件内的几个参数：因为我不使用安全更新所以对应修改的参数为：SECURITY_UPDATES_VIA_MYORACLE

[oracle@gcem alert]$ adrciADRCI: Release 11.2.0.1.0 - Production on 星期二 10月 11 15:11:08 2011Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.ADR base = "/u01/app"adrci> show alert -tail 40 -f ***********************************************************************NI cryptographic checksum mismatch error: 12599.VERSION INFORMATION:TNS for Linux: Version 11.2.0.1.0 - ProductionOracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - ProductionT

[oracle@gcem alert]$ adrciADRCI: Release 11.2.0.1.0 - Production on 星期二 10月 11 15:11:08 2011Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.ADR base = "/u01/app"adrci> show alert -tail 40 -f ***********************************************************************NI cryptographic checksum mismatch error: 12599.VERSION INFORMATION:TNS for Linux: Version 11.2.0.1.0 - ProductionOracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - ProductionT

环境介绍：oracle GC11G 64BITORACLE LINUX 5.6 64BITMYSQL mysql Ver 14.14 Distrib 5.5.9, for Linux (x86_64) using readline 5.1ERROR:CS 10.2<MetricColl><String> 5mysql<String> 8qqsmysql<String> 8Response<String> 8Response<String> 192011-09-16 16:30:26<String> 166em_error=#28000Access denied for user 'root'@'qqdb.domain' (using password: NO) at /u01/app/10.2.1/db_1/agent11g/sysman/admin/scripts/emx/mysql/mysql_oem.pm line 45[@more@]今天需要将mysql添加到GC的监

环境：oracle OEM GC 11GOLX 5.6 64BIT在一台host上安装好AGENT后，发现不能在“目标”页签内不能发现新加的host，其他数据库、监听一切正常。[@more@]解决方式：再新安装的HOST机器上修改： $AGENT_HOME/sysman/emd/targets.xml文件，修改前：[oracle@qqdb ~]$ cat $AGENT_HOME/sysman/emd/targets.xml<Targets AGENT_TOKEN="6160aa0c6a04a931a68ee4b23ab71e439a9e9b7f"> <Target TYPE="oracle_emd" NAME="qqdb.domain:3872" DISPLAY_NAME="qqdb.domain:3872"/>

Applies to: Enterprise Manager Grid Control - Version: 11.1.0.1 to 11.1.0.1 - Release: 11.1 to 11.1Information in this document applies to any platform.GoalThe Goal of this Document is to provide Steps to Download and Apply Recommended Patch (WDJ7) for 11.1.0.1 Grid Control Installation using Smart Update Tool or using the Offline Method.[@more@]SolutionIt is recommended to apply Patch WDJ7 on WLS home before Installing/Upgrading the Grid control to 11.1.0.1. Release. Note: Make sure that you ha

由于初始的VNC分辨是800*600的，为了使用方便需要修改大点：首先停掉VNC的进程：killall -9 Xvnc新起：vncserver -geometry 1280x1024[@more@]

环境：GRID CENTER 10.2.0.5REDHAT 4 64BITSTAT:在进入安装时对system parameter进行检查，检查hostname不通过[@more@]今天在安装GC的时候，发现GC对于hostname有严格的限定，必须以某种格式而存在，正确的hosts文件应该包含以下两条：127.0.0.1 localhost.localdomain localhost192.168.8.93 gcem.domain gcemgcem是hostname

环境：oracle 10.2.0.1 64bitlinux 5.46bittest env.....error: 今天启动测试库直接报以下错误：[oracle@bogon ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jul 14 09:57:42 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL> startupORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], [][@more@]通过DOC:336447.1,确实是一BUG，主要是因为主机名变动导致的问题，通过修改主机名为原来的问题得以解决.[ora

POWERCENTER7.1.1 相信第一次接触powercenter的同学对normalizer这个组件并不陌生，她是用来做行列转换的组件，她的使用和其他组件的区别就是normalizer是先设置后拖拽，其他大部分组件都是先拖拽好了再慢慢的设置就可以了，迥异啊迥异，由于之前总按照 拖拽-设置的思路找原因了，后来看了helper后恍然大悟！[@more@] 。