ITPub博客

backport　　Backport是将一个软件的补丁应用到比此补丁所对应的版本更老的版本的行为。这是软件开发过程中维护步骤的一部分。最简单也可能是最常见的例子，就是针对某个软件的某个漏洞的补丁。某个软件的新版本发现了漏洞，通过修补源代码后可以修复；但此软件的旧版本因为源代码不同，而不能通过同样的修补来修复，这时就需要针对旧版本的软件来进行源代码修补了。　　针对软件的某个方面所做的改动，可能简单到修改几行代码，也可能复杂到需要修改大量的源代码文件。如果改动很复杂，那么backport行为就会很不值得，除非旧版本的软件比

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

Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1 and later [Release: 9.2 and later ]IBM AIX on POWER Systems (64-bit) Goal How does OUI check if the HACMP software is installed? Solution In 9i, when installing base release, e.g. 9.2.0.1, the OUI checks if cluster HACMP is available by looking at /etc/objrepos/HACMPnode. statx("/etc/objrepos/HACMPnode", 0x2FF212B8, 76, 0) = 0 If this file is present then it will look at the cluster by running

Only certain versions of HACMP are certified with any given Oracle RDBMS, and you want to determine the version of HACMP installed for certification purposes.Solution Description: ===================== You need to use the AIX command: lslpp -h "cluster*" This will display the HACMP installation and update information, along with the version number. Solution Explanation: ===================== The lslpp command lists installed filesets (packages), and

goldengate rep进程abend 遇到 discard file (./dirrpt/rini.dsc) exceeded max bytes (705032704)rep进程的参数文件是这样写的：discardfile ./dirrpt/rini.dsc, append, megabytes 5000解决方法：在dirrpt目录下执行：mv rini.dsc rini.dscbak问题分析：discard file是辅助你定位问题的文件，说白了，作用类似于oracle数据库的alert日志文件。可以重命名。[@more@]

1.一定要从metalink上开个sr，索要相应操作系统下的相应数据库的最新的goldengate软件。别用老的goldengate软件。老的goldengate软件存在很多bug（比如，goldengate v11.1.1.0.1软件对oracle进行ddl复制时，对 oracle 的rename这个ddl操作，会忽略掉，这是个很严重的bug，此bug有metalink文章Goldengate Replicat Ignores "Alter Table Rename" DDL [ID 1216846.1]）2.goldengate v11.1.1.0.29 for hpux 11.31 oracle 10.2.0.4 rac 的目的端（只有1个replicat进程） 应用速度记录：1分钟大概会应用43M的trail文件（每个trail文件

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.

一对双引号引发的goldengate血案：源是sql2005 ，目的是linux x64 下的db2 v9.7因为是测试环境，所以只同步了一个sql2005的表（注意，此时我并没有意识到sql2005是区分大小写的）源端和目的端配置完毕后，分别启动两端的mgr进程，状态是running。ok！extract 进程的状态是runningdatpump 进程的状态是runningreplicat进程的状态是runningok!在源端插入一条记录（此表已经被配置extract）,马上就看到了源端trail文件的修改时间变了。马上就看到了目的端trail文件的修改时间也变了。然后replicat进程的状态是running然后去目的库查看此条记录

CREATE TABLE U_DS.TB_SMS_SENDSTATUS ( SMSSENDSTATUSID NUMBER NOT NULL, MSGID NUMBER(19) NULL, CHANNELID NUMBER NULL, MISDNTYPE NUMBER NULL, PRIORITY NUMBER NULL, SOURCETYPE NUMBER NULL, CUSTOMERID NUMBER NULL, ORGANID VARCHAR2(20) NULL, USERID NUMBER NULL, SENDADDRESS VARCHAR2(20) NULL, MOBILE VARCHAR2(20)

本文转自：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

祈福的DBA (8819616) 21:50:21 一个数据库可以包含多个设备，一个设备也可以被多个数据库包含。祈福的DBA (8819616) 21:51:48 比如有数据库A和B，有设备甲乙丙丁，各100M 祈福的DBA (8819616) 21:52:00 A数据库可以包含甲乙100M以及丙的50M 祈福的DBA (8819616) 21:52:11 数据库B可以包含丙的50M和丁的100M 祈福的DBA (8819616) 21:53:01 A(甲-100M,乙-100M,丙-50M)B(丙-50M，丁-100M)[@more@]

在rac2节点上配置iscsi 连接共享存储(使用openfiler做共享存储)时遇到：注意：192.168.0.222是openfiler服务器ip[root@rac2 nodes]# iscsiadm -m discovery -t st -p 192.168.0.222iscsiadm: failing authentication, received incorrect username from target iscsiadm: Login authentication failed with target iscsiadm: discovery login to 192.168.0.222 failed, giving up最终发现是/etc/iscsi/iscsid.conf 配置文件的问题。[root@rac2 nodes]# cat /etc/iscsi/iscsid.conf ## Open-iSCSI default configuration.# Could be locate

查看selinux的状态：[root@rac1 ~]# getenforceDisabled[root@rac1 ~]# sestatusSELinux status: disabled[root@rac1 ~]# 修改selinux为disabled(禁用),重启后此修改生效[root@rac1 ~]# cat /etc/selinux/config # This file controls the state of SELinux on the system.# SELINUX= can take one of these three values:# enforcing - SELinux security policy is enforced.# permissive - SELinux prints warnings instead of enforcing.# disabled - SELinux is fully disabled.SELINUX=disabled#

1.检查linux防火墙是否处于开机自动启动状态： chkconfig --list |grep iptables2.检查linux防火墙当前是否处于运行状态：[root@rac1 ~]# service iptables statusFirewall is stopped.若是running的话， service iptables status的输出会有很多行。[@more@]

fat32 单个文件最大大小？ 4Gntfs 单个文件最大大小？ext2单个文件最大大小？ext3单个文件最大大小？ext4单个文件最大大小？[@more@]