ITPub博客

<span style="line-height:1;font-size:16px;font-family:'Microsoft YaHei';">./addNode.sh -pre &nbsp;CLUSTER_NEW_NODES={sde1} CLUSTER_NEW_VIRTUAL_HOSTNAMES={sde1-vip}</span><br /><span style="line-height:1;font-size:16px;font-family:'Microsoft YaHei';">cluvfy stage -post nodeadd -n sde1,sde2</span><br...

<span style="font-size:16px;font-family:'Microsoft YaHei';">ogg@OSS-JH-DB1:/backup/ogg$ ./ggsci</span><br /><span style="font-size:16px;font-family:'Microsoft YaHei';">Oracle GoldenGate Command Interpreter for Oracle</span><br /><span style="font-size:16px;font-family:'Microsoft YaHei';">Version 1...

日常监控备份发现，有个库归档备份报错信息如下：channel ch01: finished piece 1 at 2015-08-04 09:42:46piece handle=al_4171_1_886843941 tag=TAG2...

****************************************************************************************************************************************

<span style="word-wrap:break-word;white-space:normal;word-spacing:0px;text-transform:none;color:#000000;font:16px/1 'sans serif', tahoma, verdana, helvetica;widows:1;letter-spacing:normal;text-indent:0px;-webkit-text-stroke-width:0px;">[root@sscp-db2 arch2]# scp 2_9204_844882031.dbf &nbsp;root@135.1...

Applies to:Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterInformation in this document applies to any platform.GoalBelow message keeps repeating in Alert-log.Time drift detected. Please check VKTM trace file for more details.Warning: VKTM detected a time drift...

用于:Oracle Database - Enterprise Edition - 版本 9.2.0.1 和更高版本本文档所含信息适用于所有平台Oracle Clusterware & Oracle Real Application Clusters症状概要：在Oracle的RAC环境中，数据库会收集global cache 的工作负载统计信息，并把这些信息通过STATSPACK, AWRs 和 GRID CONTROL等工具呈...

SQL> select a.processinstid from sas.wf_h_processinst a where a.createtime >= sysdate - 90;select a.processinstid from sas.wf_h_processinst a where a.createtime >= sysdate - 90                                *ERROR at...

应用厂家同事报错，随即诊断如下：[root@netmgrdb1 ~]# su - oracle[oracle@netmgrdb1 ~]$ iduid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1020(asmadmin),1021(asmdba),1022(asmoper),1031(dba)[oracle@netmgrdb1 ~]$ sqlplus '/ as sysdba'SQL*Plus: Release 11.2.0.3.0 Production on Fri Apr 17 16...

Restrictions and Usage NotesThe target database must be mounted or open. You do not have to take a datafile offline if you are performing block media recovery on it.You can only perform complete media recovery of individual blocks. Point-in-time recovery of individual data blocks is not supporte...

In this article I will demonstrate how to corrupt the ASM DISK header and to repair it using kfed utility.ASM metadata is stored in disk groups and each ASM disk has ASM metadata. ASM metadata block size is 4 KB (kfdhdb.blksize=4096).Typically first Allocation unit on every ASM disk will alway...

Enqueue Type        Descriptionenq: AD – allocate AU        Synchronizes accesses to a specific OSM (Oracle Software Manager) disk AUenq: AD – deallocate AU        Synchronizes accesses to a specific OSM disk AUenq: AF – task serializ...

凌晨00:10左右接到监控电话，说库连接异常，随即起床登陆主机一看，库实例已然crash掉啦,查告警日志：Mon Mar 23 20:45:24 2015Thread 1 advanced to log sequence 234601 (LGWR switch)  Current log# 3 seq# 234601 mem# 0: /dev/oravg/rgsinas_redo13Mon Mar 23 20:48:28 2015KCF: write/open error block=0x8...

      在常规的asm维护管理中，我们可以用具有sysasm和sysdba权限的sys用户登录asm实例，进行相关的维护管理工作，但是在ogg相关的项目工程中，ogg读取asm存放的日志文件，为了管理和安全规范和方便，需要给ogg建立专用的登陆asm实例访问asm日志的具备sysasm权限的账号：      比如，ogg里...

Applies to:Oracle Net Services - Version: 10.1.0.4.0 to 10.2.0.4.0Information in this document applies to any platform.SymptomsChecking the listener status, ASM instance is shown as BLOCKED.Remote connections and administration cannot be performed in this case for the ASM instance.Example :...

There is a misconception that SQL*Net is a protocol or runs on top of the network. These statements are false and, as such, means SQL*Net does not lend itself well to such questions as, Why does SQL*Net run faster on one infrastructure and not another? or Why is SQL*Net faster on the LAN than on t...

适用于:JDBC - 版本 10.1.0.2 到 11.2.0.3.0 [发行版 10.1 到 11.2]本文档所含信息适用于所有平台***Checked for relevance on 24-Apr-2013***文档 ID 1602113.1用途本文档旨在解释两个 RAC 概念，即透明应用程序故障转移 (TAF) 和快速连接故障转移 (FCF)。 适用范围需要了解 JDBC。详...

#!/bin/bash## hugepages_settings.sh## Linux bash script to compute values for the# recommended HugePages/HugeTLB configuration## Note: This script does calculation for all shared memory# segments available when the script is run, no matter it# is an Oracle RDBMS shared memory segment or n...

  uname -a  cat /etc/*release   rpm -qa |grep oracleasm  /etc/init.d/oracleasm status   lsmod |grep -i asm  cat /proc/filesystems |grep -i asm  ls -l /usr/sbin/oracleasm-discover   /etc/init.d/oracleasm listdisks   /etc/init.d/oracleasm listdisks ...

集群内的资源调度和互补:1 业务空闲的和业务繁忙的互补互动调度资源（忙的种类不同，网络/IOcpu）；2 白天忙的和晚上忙的业务时间错峰来资源互补互动调度(各自业务忙的时间不同)。oracle12cr2 待续hadoop yarn待续...