- 博客(494)
- 收藏
- 关注
RSS订阅转载 参数LOG_ARCHIVE_MIN_SUCCEED_DEST
LOG_ARCHIVE_MIN_SUCCEED_DESTPropertyDescriptionParameter typeIntegerDefault value1Modi...
2012-07-13 21:36:50
452
转载 v$bgprocess --解释oracle db 后台进程作用的视图
v$bgprocess --解释oracle db 后台进程作用的视图[@more@] ...
2012-07-13 21:34:21
352
转载 goldengate 认证矩阵matrix
http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html[@more@] ...
2012-07-12 21:59:19
377
转载 日志挖掘是看不到谁在尝试密码的
前几天有个客户问我，有个业务用户改密码后，很快就被锁定了。db是oracle10g的，问我有啥办法能看到是谁在尝试用这个用户登录，我想了想，对他说，可以用日志挖掘。后来做了一个实验，oracle10.2,min补充日志模式，尝试...
2012-04-02 13:27:34
203
转载 各种*nix操作系统下查看网卡带宽 .
solaris # ndd /dev/NICNAME link_speedLinux # ethtool NICNAME|grep SpeedAIX # entstat -d NICNAME |grep SpeedHPU...
2012-03-21 15:23:51
190
转载 Using Diagwait as a diagnostic to get more information for diagnosing Oracle Clusterware Node evicti
Using Diagwait as a diagnostic to get more information for diagnosing Oracle Clusterware Node evictions [ID 559365...
2012-03-21 15:19:37
117
转载 64bit client 与 32bit plsqldev是不兼容的
今天新装了oracle 打开pl/sql时报出了这个错误SQL*Net not properly installed OracleHomeKey:SOFTWAREORACLEPL/SQL Developer - (Not...
2012-02-15 17:58:13
128
转载 Data Guard Switchover and Failover Best Practices
Oracle9i: Data Guard Switchover and Failover Best Practices [ID 271448.1]Oracle10g: Data Guard Switchover and Fail...
2012-01-29 11:56:05
132
转载 How to Check ASM Login for Oracle Goldengate (OGG) ? [ID 1311784.1]
GoalHow to check ASM login for Oracle Goldengate (OGG) ?SolutionIf ASM is in use, OGG must be able to connect to t...
2012-01-18 15:00:37
152
转载 Checking for Oracle archive log corruption [ID 1268590.1]
日志挖掘可以验证归档日志是否损坏。GoalEXTRACT is hung reading an archive log. OGG trace and o/s truss outputs show EXTRACT repeated...
2012-01-18 14:56:36
144
转载 【原创】警告：实施goldengate之前源库务必要做的--此点在gg文档里没有提到
源库一定要是force logging模式。可以从select force_logging from v$database 中看到。注意：force logging 和supplemental是两回事，这两个不是同一个东西。[@...
2012-01-09 19:56:57
123
转载 【原创】goldengate 目的端rep复制进程 遇到ora-00001 异常终止abend的血案
环境介绍：goldengate 目的端rep复制进程 遇到ora-00001 异常终止abend的血案源头oracle，1个extract进程，该的进程参数文件配置的是user.*源头oracle，2个进datapump进程（这...
2012-01-09 13:18:49
315
转载 sqlplus / as sysdba 遇到ora-01012 no logged on
sqlplus / as sysdba 遇到ora-01012 no logged on 16G物理内存， processes 为300 ，aix上执行ps -ef |grep LOCAL=NO | wc -l 反馈 270个。...
2012-01-05 21:07:08
273
转载 How To Stop A Running Datapump Job Started In Background [ID 958532.1]
Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 and later [Release: 10.1 and later ]Inform...
2012-01-05 17:09:50
122
转载 再见，2011
再见，2011时光荏苒，在每天的忙碌之中，在不经意之间，我走过了2011。2011，对我来说终生难忘，在2011年我当上了爸爸，抱着小宝宝的感觉真是很好。为了全家，努力去工作。加油！！！当然，工作不是生活的全部。[@more@]...
2011-12-31 21:54:15
101
转载 [zhuan]linux限制IP访问ssh
http://blog.donews.com/cailiwen/archive/2007/11/27/1232048.aspx转帖：在/etc/hosts.allow输入 (其中192.168.10.88是你要允许登陆s...
2011-12-29 18:29:44
100
转载 [转]安装11GR2 RAC会碰到INS-20802错误 只要确认scanip可以ping通就可以忽略掉
以下转自马主任的经验总结。安装11GR2 RAC会碰到INS-20802错误 只要确认scanip可以ping通就可以忽略掉 。[@more@] ...
2011-12-26 09:23:54
262
转载 [总结]rac不可用的排错步骤
rac不可用的排错步骤:1.获得rac是由几个nodes 组成：询问客户方技术人员或者使用命令查询srvctl config database2.各个nodes之间的date 时间是否同步3.各个nodes之间的网卡的逻辑名是否...
2011-12-26 01:01:23
282
转载 oracle 10.2.0.1 rac 升级到10.2.0.4 rac时，dbua升级的组件列表
oracle 10.2.0.1 rac 升级到10.2.0.4 rac时，dbua升级的组件列表，此表摘自dbua运行时的界面。performing pre upgradeupgrade oracle serverupgrade...
2011-12-24 20:42:16
159
转载 Can you create a second voting disk in a different ASM diskgroup when using External Redundancy in 1
Oracle Server - Enterprise Edition - Version: 11.2.0.2 to 11.2.0.2 - Release: 11.2 to 11.2Information in this docu...
2011-12-19 22:36:13
104
转载 [原创]总结：实施goldengate director的步骤
实施goldengate director的步骤：前期准备：单独一台pc机器(假设此机器ip为192.168.0.11)，此机器装什么os，随意，只是weblogic和 oracle 10.2.0.1 db 和 directo...
2011-12-19 17:13:44
144
转载 Gather_stats_job 调用dbms_stats.gather_database_stats_job_proc过程来收集statistics 的信息
Gather_stats_job 调用dbms_stats.gather_database_stats_job_proc过程来收集statistics 的信息。 该过程收集对象statistics的条件如下： ...
2011-12-17 19:46:38
614
转载 Oracle GoldenGate Best Practice - Testing Maximum Performance of Disks in UNIX [ID 1356855.1]
Oracle GoldenGate Best Practice - Testing Maximum Performance of Disks in UNIX [ID 1356855.1][@more@] ...
2011-12-17 16:48:28
85
转载 goldengate 支持抽取源库上裸设备形成存放的redo log
Oracle GoldenGate Supports Reading Redo And Archive Log files Stored On Raw Devices With Source Database On AIX OS...
2011-12-17 16:45:11
121
转载 宝宝来到人间。
我的宝宝于2011-12-03（周六） 早晨6点40分在山东大学齐鲁医院顺利降生。体重8斤1两，顺产。感谢我的妻子，她为了孩子，勇敢的选择顺产。我很佩服她的勇气。。[@more@] ...
2011-12-09 15:14:29
82
转载 【转】find -atime -ctime -mtime区别
find -atime -ctime -mtime区别 find -atime -ctime -mtime区别 access time ， atime在读取文件或执行文件时会修改c...
2011-11-30 16:53:04
123
转载 sqlserver2005数据库镜像 的switch over 和fail over
此连接是对 sqlserver数据库镜像会话进行手动故障转移 的文档，此种情况下，类似于oracle的switch overhttp://msdn.microsoft.com/zh-cn/library/ms186348%28v...
2011-11-30 14:25:57
121
转载 oracle rules manager 组件对应的升级sql
The Oracle Rules Manager Component Is Invalid After Upgrade To 10.2.0.4 [ID 748699.1]Solution1. To upgrade "Rule...
2011-11-27 07:09:58
110
转载 impdp 时遇到ORA-02368 file string is not valid for this load operation
impdp 时遇到ORA-02368 file string is not valid for this load operation Datapump Import Fails To Start ...
2011-11-24 20:16:58
982
转载 oracle 10.2.0.4 expdp全库导出 和分用户impdp导入的记录
oracle 10.2.0.4 expdp全库导出 导出语句：D:oracleproduct10.2.0db_1BINexpdp system/aaaaaa dumpfile=all_1124.dmp DIRECTORY=dm...
2011-11-24 12:37:06
389
转载 expdp 报错
C:>D:oracleproduct10.2.0db_1BINsqlplus / as sysdba @c:startup.sqlSQL*Plus: Release 10.2.0.4.0 - Production on T...
2011-11-24 09:13:38
219
转载 Oracle Database High Availability Solutions for Unplanned Downtime
Oracle Database High Availability Solutions for Unplanned Downtimehttp://download.oracle.com/docs/cd/E11882_01/ser...
2011-11-21 21:04:45
96
转载 ASM Diskgroup Can Not Be Shown When Creating Database With DBCA
ASM Diskgroup Can Not Be Shown When Creating Database With DBCA[@more@] ...
2011-11-21 13:21:24
85
转载 各个操作系统的 操作系统日志
Windows: Save Application Log and System Log as txt files Using Event ViewerLinux: /var/log/messagesSun: /var/adm/...
2011-11-21 10:53:29
683
转载 oracle 11gR2 grid 用户所属的几个操作系统组 的几个注意点
To create a grid installation owner account where you have an existing system privileges group (in this example, d...
2011-11-19 22:09:36
174
转载 oracle 11gR2 grid 用户所属的几个操作系统组
ASM database administrator (osdba) groupASM instance administrator operator(osoper) groupASM instance ad...
2011-11-19 21:31:29
160
转载 【警钟】谨慎删除归档日志
谨慎删除归档日志，原因有二，第一，首先查看v$recover_files 没有任何记录。否则不能删除归档日志第二，若有dg环境，确认归档日志已经传递到dg的目的端，否则，禁止删除源端的归档日志。[@more@]...
2011-11-18 23:04:26
127
转载 Oracle DataPump Quick Start [ID 413965.1]
Oracle DataPump Quick Start [ID 413965.1][@more@] ...
2011-11-16 00:29:13
71
转载 诊断oracle clusterware问题，需要收集并上传的文件
CRS 10gR2/ 11gR1/ 11gR2 Diagnostic Collection Guide [ID 330358.1][@more@] ...
2011-11-16 00:14:13
80
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人