- 博客(7)
- 收藏
- 关注
原创 goldengate ddl enable,ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid
环境: 数据库版本11.2.0.3.11Oracle GoldenGate Command Interpreter for OracleVersion 11.2.1.0.5_01 16224002 OGGCORE_11.2.1.0.6_PLATFORMS_130205.0600_FBOLinux, x64, 64bit (optimized), Oracle 11g on Feb 5 2...
2014-10-14 18:52:20
4301
转载 Adding / Dropping Disks From a ASM Disk Group
磁盘组规划出现问题,需要踢出磁盘,具体添加删除步骤如下: Adding / Dropping Disks From a ASM Disk Groupby Jeff Hunter, Sr. Database AdministratorContents Introduction Identify Candidate Disks Add Disks to a Disk Gro...
2014-09-20 23:08:32
815
原创 归档误删除,RMAN备份失败
错误信息如下:Starting backup at 16-AUG-14current log archivedreleased channel: c1released channel: c2RMAN-00571: ===========================================================RMAN-00569: ==============...
2014-08-18 22:03:02
1003
转载 SPOOL sql语句实现LOOP循环转储多文件
客户想在sql文件的spool中实现循环,每次循环为每天生成一个结果文件,在Oracle community 中找到如下方式记录: SET serverout onSET some_more_appropriate_headingsSPOOL my_master_spool_fileBEGIN FOR i IN 1 .. 10 LOOP DBMS_OUT...
2014-08-02 11:49:14
1539
原创 ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], []
环境描述 AIX5.3 HACMP Oracle 10.2.0.5 故障描述 Sun Jun 01 06:46:43 BEIST 2014 Errors in file /u01/app/admin/findbb/udump/findbb_ora_696582.trc: ORA-00600: internal ...
2014-07-25 23:19:50
1912
原创 IBM POWER LINUX不支持Oracle 11G
Oracle will not be releasing Oracle Database 11g on IBM Linux on Power systems. Customers can continue to run the terminal patch set of Oracle Database 10g Release 2 (10.2.0.5) on IBM Linux on Po
2014-07-23 09:01:36
2510
原创 IOT/Abort trap 故障
故障现象:RAC节点2新建连接无法连接数据库,已有连接报无法扩展空间。crs_stat –t -v报错,IOT/Abort trap节点1执行crs_stat –t -v发现节点2的ONS和GSD服务为OFFLINE$errpt C69F5C9B 0719173614 P S SYSPROC SOFTWARE PROGRAM ABNORMALLY TER...
2014-07-22 11:22:32
5291
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人