ITPub博客

1.相关sh文件没有x权限2.相关sh文件中，不包含如下的信息：[oracle@leiredhat u01]$ cat job.shexport ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/oracle/product/10.2.0/db_1PATH=/u01/app/oracle/oracle/product/10.2.0/db_1/bin:$PATHexport PATHexport ORACLE_SID=leifs/u01/app/oracle/oracle/product/10.2.0/db_1/bin/sqlplus system/aaaaaa @/u01/job.sql >> /u01/log_job.log注意：1.要求3个环境变量都要出现：ORACLE_BASE，ORACLE_HOME，ORACLE_SID2.要求使用绝对路径，不要使用相对路径或者环境变

存储过程中遇到ora-00942表或视图不存在SQL> create or replace procedure system.opt is 2 begin 3 insert into system.fga_log_view_bak( 4 SESSION_ID , 5 TSMP , 6 DB_USER , 7 OS_USER , 8 USERHOST , 9 CLIENT_ID , 10 ECONTEXT_ID , 11 EXT_NAME , 12 OBJECT_SCHEMA , 13 OBJECT_NAME , 14 POLICY_NAME , 15 SCN , 16 SQL_TEXT , 17 SQL_BIND

windows 下 asm存储，单实例，是我笔记本上的测试环境。几个月不用asm上的oracle了，现在启动不了。C:Documents and SettingsAdministrator>sc query OracleCSServiceSERVICE_NAME: OracleCSServiceTYPE : 10 WIN32_OWN_PROCESSSTATE : 2 START_PENDING(STOPPABLE, PAUSABLE, ACCEPTS_SHUTDOWN)WIN32_EXIT_CODE : 0 (0x0)SERVICE_EXIT_CODE : 0 (0x0)CHECKPOINT : 0x5b8WAIT_HINT : 0x3e8在帖子http://ms.itpub.net/redirect.php?fid=2&tid=1174616&goto=nextnewset 的提示下，解决了这个问题。D:oracleproduct10.2.0db_1BIN&g

修改时间 25-MAR-2011 类型 ANNOUNCEMENT 状态 PUBLISHED In this Document What is being announced? What do you need to do? Documentation: FAQ: Applies to: Management Pack for Oracle GoldenGate - Version: 2.0.0.0 and later [Release: 2.0 and later ]Information in this document applies to any platform. What is being announced? This includes references to documentation and the most commonly accessed Notes: What do

http://download.oracle.com/docs/cd/B19306_01/server.102/b14226/repunicode.htm#i11177Column Length Semantics for Replication Sites and Table Columns Column length semantics determine whether the length of a column is specified in bytes or in characters. You use BYTE to specify that the length is in bytes, and you use CHAR to specify that the length is in characters. CHAR length semantics is also known as codepoint length semantics. Because some character sets require more than one byte for ea

以下摘自goldengate v11.1.1 reference 第324页：Using COLMAPUse COLMAP to explicitly map source columns to target columns that have different namesor to specify default column mapping when source and target names are identical. COLMAPprovides instructions for selecting, translating, and moving column data. Do not use thisoption for tables being processed in pass-through mode by a data-pump Extract group.NOTE To create global rules for column mapping across all tables in subsequent TABLEstatements,

我自己查看SG246187，里面有一段这么说的：To show the clstrmgr version,type the command: snmpinfo -m dump -0 /usr/sbin/cluster/hacmp.defs clstrmgr。 但我输入后，无任何提示，直接进入下一行命令提示符。或者lslpp -l |grep cluster[@more@]

http://bbs.chinaunix.net/viewthread.php?tid=282444在aix里面查看实际的磁盘空间 lspv :查看系统硬盘 lspv hdisk# :查看硬盘hdisk#的空间分配情况 lsvg :查看系统VG lsvg vg_name : 查看VG的空间分配情况 lsvg -l vg_name: 查看VG中LV分配情况以及对应的文件系统 df -k :查看文件系统使用情况。[@more@]

http://www.loveunix.net/thread-37224-1-1.html在AIX 5.3版本以前，用户只能动态增加文件系统的大小，如果需要缩小文件系统的大小，只能重新创建一个文件系统，再将数据拷贝到其中。AIX 5.3版本中增加了一个新特性：即动态减小JFS2类型的文件系统的大小。方法如下：通过smit菜单：# smit chjfs2: 在字段“Number of units”中直接填入缩小或增大后的文件系统大小即可。通过命令行：chfs -a size=new_size filesystem_name注：“new_size”前面不加前缀表示将文件系统的空间改为“new_size”。如果“new_size”前面加前缀“+”，表示将该

老农说过：你lsfs的显示是对的。 lsvg -l里显示的type是标签而已，可以和实际不一样。 http://bbs.loveunix.net/thread-75259-1-1.html[@more@]

http://blog.csdn.net/bingzhuan/archive/2009/03/23/4016734.aspx若AIX 是 version 5.3 之前的版本，则不论文件系统是jfs 的，还是jfs2的，都不可以动态的缩小。若AIX 的版本是 AIX 5.3以后的版本，文件系统类型是jfs，则此文件系统不可动态的缩小。若AIX 的版本是 AIX 5.3以后的版本，文件系统类型是jfs2，则此文件系统是可动态缩小的。下面在AIX 5.3系统创建了两个文件系统：/usr/test（jfs2）和/wzktest（jfs），如下：testterm1:/#lsvg rootvg | grep "PP SIZE"VG STATE: active PP SIZE:

http://www.aixchina.net/club/viewthread.php?tid=4957　　. 若AIX 是 version 5.3 之前的版本，则不论文件系统是jfs 的， 还是 jfs2的 都不可以动态的缩小。 　　. 若AIX 的版本是 AIX 5.3以后的版本，文件系统类型是jfs, 则此文件系统不可动态的缩小。 　　. 若AIX 的版本是 AIX 5.3以后的版本，文件系统类型是jfs2, 则此文件系统是可动态缩小的。[@more@]

Valid HACMP names must be at least one character long and can contain characters ([A-Z, a-z]), numbers ([0-9]) and '_' (underscore). A name cannot begin with a number and a HACMP reserved word cannot be a valid name.[@more@]

hacmp5.3加入节点时出错信息如下ERROR: Unable to use communication interface 'rac2'.For each of the above invalid communication interfaces listed,please check that the owning node is running the clcomdES subsystem,and that the /usr/es/sbin/cluster/etc/rhosts file is properly configured.解决方法：/usr/es/sbin/cluster/etc/rhosts 文件中修改为本机的ip地址。[@more@]

原文来自：http://www.ningoo.net/html/2007/aix_5l_network_interface.htmlPiner写过一篇文章介绍AIX中网卡的管理和配置，这里想补充一些相关的信息。本文中所有试验都基于AIX 5.3。 AIX中查看系统中的网卡设备 #lsdev -Cc adapter | grep ent ent0 Available 00-08 10/100/1000 Base-TX PCI-X Adapter (14106902) ent1 Available 07-08 2-Port 10/100/1000 Base-TX PCI-X Adapter (14108902) ent2 Available 07-09 2-Port 10/100/1000 Base-TX PCI-X Adapter (14108902) ent3 Available 0B-08 10/100/1

Valid for ExtractUse the COMPRESSUPDATES and NOCOMPRESSUPDATES parameters for Extract to control the waycolumns are written to the trail record for update operations.COMPRESSUPDATES, the default, causes Extract to write only the primary key and thechanged columns of a row to the trail for update operations. This provides enoughinformation to update the correct target record, while restricting the amount of data thatmust be processed.NOCOMPRESSUPDATES sends all of the columns to the trail. This b

关于goldengate无主键表的update的同步源端：windows 2003 sql2005 sp3目的端:rhel5.3 x64bit, db2 v9.7 x64bit源端表结构：（无主键无唯一索引）CREATE TABLE [lc0019999].[KCCKD2]( [KCCKD2_PJLX] [char](1) NOT NULL, [KCCKD2_LSBH] [varchar](10) NOT NULL, [KCCKD2_FLBH] [varchar](10) NOT NULL, [KCCKD2_WLBH] [varchar](30) NOT NULL, [KCCKD2_TSKC] [char](1) NOT NULL DEFAULT (' '), [KCCKD2_XGDX] [varchar](30) NOT NULL DEFAULT (' '), [KCCKD2_DDLS] [varchar](20) NULL DEFAULT (' '), [KCCKD2_

************************************************************************* Running with the following parameters *************************************************************************replicat msstargetdb BASE4, userid gg, password ******discardfile /db2/ggv11db2/dirrpt/rep.dsc, append, MEGABYTES 2147SOURCEDEFS /db2/ggv11db2/dirdef/source_defs.defreperror ( 100, IGNORE )--注意：（后有一个空格，）前也有一个空格。Source Context : SourceModule : [er.main]

1.在目的数据库的相关表中，添加字段。注意字段的数据类型。2. rep.prm中进行如下的添加map 'lc0019999.KCCKD2', target gguser.KCCKD2, COLMAP (USEDEFAULTS, ETL_FL_NM = "gg_online", BUSI_DATE = @COLSTAT (NULL), PPN_TMSTAMP = @COLSTAT (NULL), OPERATION_TYPE = @GETENV ("GGHEADER", "OPTYPE") , MODIFY_DATETIME = @GETENV ("GGHEADER", "COMMITTIMESTAMP"));值得注意的是：OPERATION_TYPE = @GETENV ("GGHEADER", "OPTYPE") 这一个列，在数据库表中，请

add trandata报错的前提条件：1.oracle 92 数据库2.源端的表没有主键，没有唯一键。3.源端的表的列数超过32个列。如下的例子：GGSCI (rhel41) 2> add trandata GYHT.GY_CLHTK2011-04-26 21:20:20 WARNING OGG-00869 No unique key is defined for table GY_CLHTK. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.2011-04-26 21:20:20 WARNING OGG-00706 Failed to add supplemental log group on table GYHT.GY_CLHTK due to ORA-02257: maxim