- 博客(9)
- 资源 (3)
- 收藏
- 关注
原创 oracle goldengate 添加新表
1. 源端,添加标记日志cd /u01/ggs./ggscidblogin USERID ogg, PASSWORD welcome1add trandata CISADM.CI_REGadd trandata CISADM.CI_ACCT_CHARadd trandata CISADM.CI_SP_CHARadd trandata CISADM
2016-04-28 15:33:30 2365
原创 OGG-01296 Oracle GoldenGate Delivery for Oracle OGG-01668 Oracle GoldenGate Delivery for Oracle
2016-04-28 10:40:22 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, rebi01.prm: Error mapping from CISADM.CI_REG to DW_IDL.DW_CIS_CI_REG.2016-04-28 10:40:22 ERROR OGG-01668 Oracle Go
2016-04-28 15:32:24 3774
原创 如何在Exadata计算节点扩展磁盘空间(驱动)(文档 ID 1582139.1)
适用版本:Exadata X2-2 Exadata X3-2 目的:在Exadata计算节点扩展磁盘空间(驱动)在Exadata升级后或者增加新的空间到/u01 或者创建新的文件系统 /u01详细:检查物理卷的大小[root@gasdbadm01 ~]# pvs PV VG Fmt Attr PSize PF
2016-04-25 15:49:17 1289
原创 自定义SQL提示符
在文件$ORACLE_HOME/sqlplus/admin/glogin.sql的最后一行添加如下内容set SQLPROMPT '&_USER.@&_connect_identifier.>'修改完后再登录为:[oracle@node3 admin]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Mo
2016-04-25 14:18:52 917
原创 自定义OS, SQL命令提示符
以下命令一定要常用常用hostnameidwho am iecho $ORACLE_SIDpwd避免连错服务器,在root家目录下的.bashrc中添加如下内容PS1='[\h:\u:\w${ORACLE_SID}]$'\h代表主机名 \u代表当前OS用户\w是显示当前目录更多参数如下
2016-04-25 11:51:42 525
原创 ERROR OGG-00446 No valid log files for current redo sequence 20415, thread 1, error retrieving re
2016-04-19 17:48:52 ERROR OGG-00446 No valid log files for current redo sequence 20415, thread 1, error retrieving redo file name for sequence 20415, archived = 0, use_alternate = 0Not able to e
2016-04-21 14:24:08 2308
原创 ERROR OGG-10151 Oracle GoldenGate Capture for Oracle, capture.prm: (capture
2016-04-01 12:23:34 ERROR OGG-10151 Oracle GoldenGate Capture for Oracle, capture.prm: (capture.prm) line 8: Parsing error, parameter [exttrail] has unrecognized keyword or extra value "100".
2016-04-01 12:30:44 7246
原创 ./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such
[oracle@node2 goldengate]$ ./ggsci ./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory[oracle@node2 goldengate]$ 刚安装好报这个问题,配置下换将
2016-04-01 10:32:08 1696
原创 ORA-00439: feature not enabled: Real Application Clusters
还原spfile后启动到nomountSQL> startup nomountORA-00439: feature not enabled: Real Application ClustersSQL> 这是由于主库集群参数SQL> show parameter cluster_database NAME TYPE
2016-04-01 09:17:41 5490
Oracle 9i_10g编程艺术:深入数据库体系结构
2016-01-05
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人