ITPub博客

dbca时提示 file etc oratab is not accessible原因是安装oracle的时候，忘记去执行 一个root.sh文件了，当然了，需要用root用户执行：解决办法：[root@localhost 10.2.0]#cd /oracle/product/10.2.0/db_1[root@localhost 10.2.0]# ./root.shThe following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /opt/oracle/product/10gEnter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /oracle/product/10.2.0/db_1/bin./root.sh: line 155: [: too many arguments./

Support Status - Oracle Database on Linux Itanium [ID 1130325.1] 修改时间 04-APR-2011 类型 ANNOUNCEMENT 状态 PUBLISHED In this Document What is being announced? Support Status for Oracle Database on Linux Itanium Who to contact for more information? Applies to: Oracle Server - Personal Edition - Version: 9.2.0.2 to 10.2.0.5 - Release: 9.2 to 10.2Oracle Server - Enterprise Edition - Version: 9.2.0.2 to 1

Database 11g Release 2 Certification Highlights [ID 1065024.1] 修改时间 14-APR-2011 类型 BULLETIN 状态 PUBLISHED In this Document Purpose Scope and Application Database 11g Release 2 Certification Highlights Frequently Asked Questions 1) When will 11.2 be certified on my platform? 2) Which Database server versions can I connect to and which Database client versions can interoperate with the 11

Client / Server / Interoperability Support Between Different Oracle Versions [ID 207303.1] 修改时间 20-OCT-2010 类型 BULLETIN 状态 PUBLISHED Oracle Client / Server Interoperability Support Introduction This note gives a summary of the support for interoperability between Oracle client and server versions. This includes support for connections over database links between Oracle versions. Note that this relates to

---------------------------DBConfiger.exe - 应用程序错误---------------------------应用程序正常初始化(0xc0000135)失败。请单击“确定”，终止应用程序。 ---------------------------确定 ---------------------------搜了一下，发现是是由于没有安装.NET framework 所造成的。安装.NET framework即可。由于程序采用VS.net编写，需要.NET framework 的支持。 .NET framework微软官方地址：http://download.microsoft.com/download/3/F/0/3F0A922C-F239-4B9B-9CB0-DF53621C57D9/dotnetfx3.exe[@more@]

环境介绍： 源头：rhel5 32bit，oracle10.2.0.4 32bit ，goldengate v11.1.1 for oracle 10g 32bit 目的地：rhel5 32bit，oracle10.2.0.4 32bit ，goldengate v11.1.1 for oracle 10g 32bit 源头的goldengate 配置没有问题，info all 命令都是running 目的地的goldengate 配置看似没有问题，虽然info all 命令都是running 从源头做了几个dml操作后，查看源头extract进程和datapump进程的统计信息： stats extract ext 和 stats extract datapump，都反馈如下的结果 *** Daily statistics since 2011-04-15 21:12:07 ***

The Collector process operates on the target system to receive incoming data and write it to the trail.Dynamic CollectorTypically, Oracle GoldenGate users do not interact with the Collector process. It is started dynamically by the Manager process. This is known as a dynamic collector.Static CollectorYou can run a static Collector manually by running the SERVER program at the command line with the following syntax and input parameters as shown:Syntax server <parameter> [<parameter>]

Use the ASSUMETARGETDEFS parameter when the source and target tables specified with a MAP statement have identical column structureIt directs Oracle GoldenGate not to look up source structures from a source-definitions file.For source and target column structures to be identical, they must:● have identical column names (including case, if applicable)● have identical data types● have identical column sizes● have the same column length semantics for character columns (bytes versuscharacters)●

www.mydb2.cn[@more@]

以下摘自http://www.loveunix.net/archiver/tid-58989.html老农说过：a.b.c.d a.b的升级必须光盘引导migrate，否则有问题。其余的可以update_allchinadns 说过： AIX 的级别由 Version.Release.Modification.Fix（VRMF）级别（例如 4.3.3.0）来确定。如果您想要安装的升级版将更改 VRMF 的 Version 或 Release 字段，就被称作迁移安装。例如，如果您的 AIX 级别为 4.3.3.0，而您想要将系统升级至 5.1.0.0，您将必须从安装介质（CD-ROM 或“网络安装管理”）引导系统并执行基本操作系统迁移安装。 如果升级版将更改 VRMF 的 Modif

命令行的参数为./db2setup -f sysreq[@more@]

DB2目录文件结构原帖请见：http://sgadba.blog.163.com/blog/static/137046660201002625614299/感谢原作者。 [db2inst2@lamp T0000000]$ pwd/home/db2inst2/db2inst2/NODE0000/SAMPLE/T0000000db2inst2(第二个红色): 实例名NODE0000: 数据库分区名，新版本的DB2中，数据库分区取代了以前版本中的节点的概念SAMPLE: 实例下的样本数据库T0000000: 表空间的容器与SAMPLE同级中有 SQL00001 SQL00002 sqldbdir TESTsqldbdir: 存储本地数据库目录相关的文件, 它记录各数据库名称、数据库别名以及数据库类型和数据库的位置信息SQL00001: 系统自带

db2实例，是一个数据库管理器环境，跟sqlserver实例类似。db2数据库，类似于sqlserver的数据库表空间：一个db2数据库可以有一个或者多个表空间容器：容器是表空间的组成部分。多库结构的数据库：sqlserver ； db2 ； sybase单库结构的数据库：oracle[@more@]

1.将gam_server 改名。[root@leiredhat ~]# ps -ef |grep gam_serverroot 11244 1 0 09:39 ? 00:00:00 /usr/libexec/gam_serverroot 22764 11169 0 12:03 pts/2 00:00:00 grep gam_server[root@leiredhat ~]# mv /usr/libexec/gam_server /usr/libexec/gam_server.bak[root@leiredhat ~]# cd /usr/libexec/[root@leiredhat libexec]# ll | grep gam_server-rwxr-xr-x 1 root root 107912 2006-11-20 gam_server.bak[root@leiredhat libexec]# ps -ef |grep gam_serverroot 11244 1 0 09:39 ?

db2副本，db2 copy，这个名称一开始理解不透，后来研究了一下，其实就是 db2 software 的安装目录，那么多个db2 software的安装 目录。[@more@]

[db2inst1@leiredhat sqllib]$ ll |grep db2nodes.cfg-r--r--r-- 1 db2inst1 db2iadm1 14 12-12 03:13 db2nodes.cfg[db2inst1@leiredhat sqllib]$ db2stop2010-12-12 03:27:45 0 0 SQL1064N DB2STOP processing was successful.SQL1064N DB2STOP processing was successful.[db2inst1@leiredhat sqllib]$ ll |grep db2nodes.cfg-rw-r--r-- 1 db2inst1 db2iadm1 14 12-12 03:13 db2nodes.cfg[db2inst1@leiredhat sqllib]$ cat /home/db2inst1/sqllib/db2nodes.cfg0 leiredhat 0[@more@]

原文：http://hi.baidu.com/dba_james/blog/item/733ef8fce90b4442d7887d65.html使用 db2icrt 创建实例 DB2® 实例是用来存储数据和运行应用程序的一种环境。使用 db2icrt 命令来创建实例。 在 Linux® 或UNIX® 操作系统上，必须具有 root 用户权限。 在 Windows® 操作系统上，必须以本地管理员登录。 要使用 db2icrt 创建实例： 1. 使用适当权限登录。 2. 运行 db2icrt 命令。例如，在 Linux 或 UNIX 操作系统上： DB2DIR/instance/db2icrt -a AuthType -u FencedID InstName

cmd_sqlplus 中的break命令 ，注意break 是sqlplus命令，不是sql语句。SQL> select deptno,empno,ename,sal from scott.emp order by deptno;        10   &nbsp...

Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 Connected as SYSSQL> ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';Session alteredSQL> EXECUTE DBMS_LOGMNR.START_L...

Microsoft Windows [版本 5.2.3790](C) 版权所有 1985-2003 Microsoft Corp.C:\Documents and Settings\Administrator>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Thu Dec 2 17:01:13 2010Co...