ITPub博客

实施goldengate director的步骤：前期准备：单独一台pc机器(假设此机器ip为192.168.0.11)，此机器装什么os，随意，只是weblogic和 oracle 10.2.0.1 db 和 director server software 的介质对应的os要和该os一致此机器上装weblogic 11g R1 （10.3.1） 和oracle 10.2.0.1 db 和 director server software实施步骤：1.安装weblogic weblogic 11g R1 （10.3.1），不建立domain.domain是 director server software 安装时自动部署的。2.安装oracle 10.2.0.1 db3.sqlplus 下建立用户sql> create user goldengate identified by a123456789;

Gather_stats_job 调用dbms_stats.gather_database_stats_job_proc过程来收集statistics 的信息。 该过程收集对象statistics的条件如下： （1）对象的统计信息之前没有收集过。 （2）当对象有超过10%的rows 被修改，此时对象的统计信息也称为stale statistics。 在Oracle 10g中，在查询表时，如果没有统计分析，那么会采用动态采样。[@more@]

Oracle GoldenGate Best Practice - Testing Maximum Performance of Disks in UNIX [ID 1356855.1][@more@]

Oracle GoldenGate Supports Reading Redo And Archive Log files Stored On Raw Devices With Source Database On AIX OS And Also Requires TRANLOGOPTIONS RAWDEVICEOFFSET Parameter [ID 1269855.1][@more@]

linux vnc登录不了的一个原因：linux系统防火墙被打开了。[@more@]

我的宝宝于2011-12-03（周六） 早晨6点40分在山东大学齐鲁医院顺利降生。体重8斤1两，顺产。感谢我的妻子，她为了孩子，勇敢的选择顺产。我很佩服她的勇气。。[@more@]

find -atime -ctime -mtime区别 find -atime -ctime -mtime区别 access time ， atime在读取文件或执行文件时会修改 create time ， ctime在文件写入，更改所有者，权限。链接时文件的ctime会随之改变 modified time ，mtime 在文件写入时会改变。 ls -lu 或者 ls -l --time=atime 显示文件的atime ls -lc 或者 ls -l --time=ctime 显示文件的ctime ls -l 显示文件的mtime[@more@]

此连接是对 sqlserver数据库镜像会话进行手动故障转移 的文档，此种情况下，类似于oracle的switch overhttp://msdn.microsoft.com/zh-cn/library/ms186348%28v=SQL.90%29.aspxsqlserver数据库镜像的有一个强制执行服务功能，此种情况下， 类似于oracle的fail overhttp://msdn.microsoft.com/zh-cn/library/ms189270.aspx[@more@]

The Oracle Rules Manager Component Is Invalid After Upgrade To 10.2.0.4 [ID 748699.1]Solution 1. To upgrade "Rules Manager" component, please run the following script: $ORACLE_HOME/rdbms/admin/rulpatch.sql 2. Verify if the "Rules Manager" component is upgraded/valid: SQL> Select comp_name, version, status from dba_registry;值得注意的是，运行类似这样的升级sql，在正常的open 状态下是不行的。必须在upgrade 下才能执行这些升级sql[@more@]

impdp 时遇到ORA-02368 file string is not valid for this load operation Datapump Import Fails To Start With Error ORA-02368 [ID 735625.1]Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.2This problem can occur on any platform. Symptoms Getting the following error when starting datapump import: ORA-31694: master table "RECOVERED"."SYS_IMPORT_FULL_01" failed to load/unload ORA-02354: error in exporting/importing data ORA-02368: file i

oracle 10.2.0.4 expdp全库导出 导出语句：D:oracleproduct10.2.0db_1BINexpdp system/aaaaaa dumpfile=all_1124.dmp DIRECTORY=dmpdir full=y导出时，形成的export.log文件：;;;Export: Release 10.2.0.4.0 - Production on Thursday, 24 November, 2011 9:14:17Copyright (c) 2003, 2007, Oracle. All rights reserved.;;;Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsFLASHBACK automatically enabled to p

C:>D:oracleproduct10.2.0db_1BINsqlplus / as sysdba @c:startup.sqlSQL*Plus: Release 10.2.0.4.0 - Production on Thu Nov 24 09:10:33 2011Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to an idle instance.ORACLE instance started.Total System Global Area 612368384 bytesFixed Size 1298160 bytesVariable Size 138412304 bytesDatabase Buffers 465567744 bytesRedo Buffers 7090176 bytesDatabase mounted.Database opened.Disconnected fro

Oracle Database High Availability Solutions for Unplanned Downtimehttp://download.oracle.com/docs/cd/E11882_01/server.112/e17157/unplanned.htm#HAOVW11825[@more@]

ASM Diskgroup Can Not Be Shown When Creating Database With DBCA[@more@]

Windows: Save Application Log and System Log as txt files Using Event ViewerLinux: /var/log/messagesSun: /var/adm/messagesHP-UX: /var/adm/syslog/syslog.logTru64: /var/adm/messagesIBM: /bin/errpt - a (redirect this to a file called messages.out or something similar)[@more@]

To create a grid installation owner account where you have an existing system privileges group (in this example, dba), whose members you want to have granted the SYSASM privilege to administer the Oracle ASM instance, enter a command similar to the following: # /usr/sbin/useradd -u 1100 -g oinstall -G dba grid In the preceding command: The -u option specifies the user ID. Using this command flag is optional, as you can allow the system to provide you with an automatically genera

ASM database administrator (osdba) group ASM instance administrator operator(osoper) group ASM instance administrator (osasm) group [@more@]

谨慎删除归档日志，原因有二， 第一，首先查看v$recover_files 没有任何记录。否则不能删除归档日志 第二，若有dg环境，确认归档日志已经传递到dg的目的端，否则，禁止删除源端的归档日志。[@more@]

Oracle DataPump Quick Start [ID 413965.1][@more@]

CRS 10gR2/ 11gR1/ 11gR2 Diagnostic Collection Guide [ID 330358.1][@more@]