ITPub博客

Applies to: Oracle Net Services - Version: 7 to 8.0 Information in this document applies to any platform. Purpose This article describes configuration of sqlnet.ora, tnsnames.ora and listener.ora. This article has been written focusing versions 7 to 8.0. Scope and Application This article is intended for database administrators who would like to configure Net8 Configuring TNSNAMES.ORA, SQLNET.ORA,and LISTENER.ORA in Net8 The LISTENER.ORA File: ===================Database listeners

http://www.cnblogs.com/NickyYe/archive/2011/06/21/2086135.html原文请建如上的的链接。[@more@][]

db2_redhat 4u6_64bit删除db2软件的步骤1。 删除/opt/ibm/db2这个目录2。 清空/tmp目录3。 清空 /var/db2这个目录4。 vi 打开/etc/services ，把涉及到db2的内容删除。一般涉及到db2的内容在最后。5。 删除用户dasusr1 ，db2inst1， db2fenc1 6。 删除组 db2iadml db2fgrp1此时卸载完成。安装db2软件的步骤（双机）1。进入解压后的server目录，执行./db2setup, 选择企业版或者其他版本--请与lic授权文件对应。2。在安装的第三步，select the installation type，选择cumtom3. 在安装的第四步，选最后一项：install ... and save my setti

linux中alias 的定义，在~/.bashrc中添加即可，比如加入 alias ll='ls -lht' 若是所有用户都能使用ll，请在/etc/.bashrc中添加。[@more@]

邓世昌是我儿时的崇拜对象，也是我一生的英雄。直至现在，邓世昌在我脑海中的影像基本上是陈宝国在“北洋水师”中扮演的邓世昌。百度百科中记录：1894年9月17日在大东沟海战中，邓世昌指挥“致远”舰奋勇作战，后在日舰围攻下，“致远”多处受伤 全舰燃起大火，船身倾斜。邓世昌鼓励全舰官兵道：“吾辈从军卫国，早置生死于度外，今日之事，有死而已！”“倭舰专恃吉野，苟沉此舰，足以夺其气而成 事”，毅然驾舰全速撞向日本主力舰“吉野”号右舷，决意与敌同归于尽。倭舰官兵见状大惊失色，集中炮火向“致远”射击，不幸一发炮弹击中“

以下均是在ggsci提示符下执行,以下以extract抽取进程为例子1. send extract ext_name, status 2. info extract ext_name3. info extract ext_name, showch4. info extract ext_name, detail5. lag extract ext_name6. stats extract ext_name7. stats extract ext_name, table lc0019999.zwkmzd[@more@]

HP-UX系统日志文件 2008/11/28 19:38 文件名－－－－－－－－－文件内容－－－－－－－－－－－－－－监测方法 /etc/rc.log －－－－－－启动日志－－－－－－－－－－－－－－用读取文本文件的方法， /var/adm/syslog/syslog.log 一般系统日志（包括客户端的访问记录）－－－－－－ /var/adm/sw/*.log －－－－软件安装日志－－－－－－－－－－分析发生的相关问题。 /var/adm/wtmp（wtmps）－用户登录信息－－－－－－－－－－用last 命令查看（清空：>wtmp） /var/adm/btmp（btmps）－－用户登录失败信息－－

you are trying to manipulate a job in the job queue (DBA_JOBS/USER_JOBS) and you receive: ORA-08102: index key not found, object... Cause: Internal error: possible inconsistency in index Action: Send trace file to your customer support representative, along with information on reproducing the error Example: SQL> execute dbms_job.remove(1); ORA-08102: index key not found, object #124 ->>> SYS.I_JOB_NEXT where object #124 is the object# in DBA_OB

replicat screpsetenv ( NLS_LANG = " SIMPLIFIED CHINESE_CHINA.ZHS16GBK " )assumetargetdefsDBOPTIONS DEFERREFCONSTgettruncatesapplynoopupdatesuserid goldengate, password oracleddl include objname "scott.*" &INCLUDE OBJTYPE 'USER'ddlerror 600, ignorediscardfile ./dirrpt/scrini.dsc, append, megabytes 500map scott.*, target scott2.*;[@more@]

Checked for relevance on 14-May-2009" PURPOSE ------- To further document a known DataPump restriction. SCOPE & APPLICATION ------------------- This applies to Database Administrators who have traditionally used UNIX named pipes with the original Export and Import to 'compress', 'gzip' or 'split' Export dump files. DATAPUMP EXPORT/IMPORT DOES NOT WORK WITH UNIX NAMED PIPES ---------------------------------------------------------- EXPLANATION -----------

修改时间 20-JUL-2010 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution References Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.4 - Release: 10.1 to 10.2Information in this document applies to any platform. Goal With the old EXPORT utility you can execute the export using exp command with gzip program as below: mknod /u01/backup/exp/export_pipe p nohup /usr/bin/gzip < /u01/backup/exp/export_pipe

修改时间 17-APR-2009 类型 BULLETIN 状态 PUBLISHED PURPOSE The basic function of the export utility is to extract the objects of a database and locate them in a flat file that is usually on tape or on disk. The process for exporting to tape is explained in this bulletin. SCOPE & APPLICATION Informative SEARCH WORDS 2 gig limit This bulletin examines several considerations and steps for exporting data to tape on unix platforms eith

2011-09-14 09:25:06 WARNING OGG-00869 No unique key is defined for table BONUS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.Using following columns in default map by name: ENAME, JOB, SAL, COMMUsing the following key columns for target table SCOTT2.BONUS: ENAME, JOB, SAL, COMM.[@more@]

以下语句（scott.bonus表无主键无唯一索引）若是在gg源端发出，会导致gg目的端abend(除非目的端复制进程参数文件有APPLYNOOPUPDATES 或者ALLOWNOOPUPDATES 参数) update scott.bonus set ename='lei2' where ename='lei2'; gg目的端abend时，dirrpt下的rpt文件报错如下：2011-09-14 09:35:23 ERROR OGG-01168 Encountered an update for target table SCOTT2.BONUS, which has no unique key defined. KEYCOLS can be used to define a key. Use ALLOWNOOPUPDATES to process the update without applying it to the target data

C:Documents and SettingsAdministrator>sqlplus / as sysdbaSQL*Plus: Release 11.1.0.6.0 - Production on 星期二 9月 13 22:55:50 2011Copyright (c) 1982, 2007, Oracle. All rights reserved.连接到:Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select supplemental_log_data_min from v$database;SUPPLEME--------NO注意：是no的话，会导致logminer工具无法捕捉dml操作。。。[@more@]

/* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.5pt; mso-bidi-font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-the

What Are The Considerations In Using "Batchsql"? [ID 1060546.1] 修改时间 04-APR-2011 类型 HOWTO 状态 PUBLISHED In this Document Solution Applies to: Oracle GoldenGate - Version: 4.0.0 and later [Release: 4.0.0 and later ]Information in this document applies to any platform. Solution Issue: BatchSQL Implemantation and Limitations: Solution Overview: BATCHSQL is a Replicat parameter implementi

Applies to: Oracle GoldenGate - Version: 4.0.0 and later [Release: 4.0.0 and later ]Information in this document applies to any platform. Solution Oracle 10g introduced new flashback ability at several levels: database, dropped table, and committed transaction.Goldengate supports the flashback of committed transactions, but does not support flashback at the database or dropped table levels.Supportedflashback table ... to SCN ... flashback table ... to TIMESTAMP ...flashback tabl

Excessive REPLICAT LAG Times [ID 962592.1] 修改时间 01-MAR-2011 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Cause Solution Applies to: Oracle GoldenGate - Version: 10.4.0.20 and later [Release: 10.4.0 and later ]Information in this document applies to any platform. Symptoms REPLICAT lag times often exceed 30 minutes; is there a way to improve REPLICAT performance/throughput? Cause CauseIn

In 11.2,不允许建立超过2tb的asm磁盘组，exadata在打相关补丁的情况下，可以建立超过2tb的磁盘组in this Document Goal Solution Applies to: Oracle Server - Enterprise Edition - Version: 11.2.0.0. to 11.2.0.2 - Release: 11.2 to 11.2Information in this document applies to any platform. ASM instance Goal Trying to add a 2 TB disk to an ASM diskgroup Solution In 11.2 a check was made to disallow creation of diskgroups with disks of size > 2tb. This should not apply to EXADATA mach