10年ORACLE MYSQL DBA经验,金融通信行业,9IOCP 10G OCM QQ:22389860

  • 博客访问: 2617462
  • 博文数量: 624
  • 用 户 组: 普通用户
  • 注册时间: 2008-10-13 13:03
  • 认证徽章:




发布时间:2016-03-08 13:07:21

有的时候我们做OGG的时候add trandata会出现异常。这里就剖析一下add trandata到底做了什么GGSCI (yjfora81 as ggs_admin@testdb) 2> add trandata ppzhu1.test32016-03-08 11:47:36  WARNING OGG-00706  Failed to add supplemental log group on table PPZHU1.TEST3 due to ORA-00054: resource busy and ac.........【阅读全文】

阅读(12739) | 评论(0) | 转发(1)

发布时间:2015-09-02 15:48:01

ORACLE:<br />CREATE TABLE testpur (i NUMBER, j NUMBER , f varchar2(20))<br />&nbsp; &nbsp; &nbsp;PARTITION BY RANGE(i)<br />&nbsp; &nbsp; &nbsp; &nbsp; (PARTITION p1 VALUES LESS THAN (10),<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PARTITION p2 VALUES LESS THAN (20),<br />&nbsp; &nbsp; &nbsp; &nbsp.........【阅读全文】

阅读(3444) | 评论(0) | 转发(0)

发布时间:2015-04-21 11:40:19

首先说明NOT IN 和NOT EXISTS 并不完全等价 ORACLE MYSQL 都是如此......【阅读全文】

阅读(5341) | 评论(0) | 转发(0)

发布时间:2015-04-08 15:10:56

DECLARE  row_result varchar2(4000);  selectsql  varchar2(4000);  qrycursor  SYS_REFCURSOR;  txt_handle UTL_FILE.file_type;BEGIN  selectsql  := 'select USER_ID||chr(9)||EXTERNAL_ID||chr(9)||ACCOUNT_ID||chr(9)||CERTIFY_STATUS||chr(9)||USER_STATUS||chr(9)||.........【阅读全文】

阅读(3203) | 评论(0) | 转发(0)

发布时间:2015-01-27 17:32:11

                  Fatal NI connect error 12170 TNS-12535 TNS-00505今天一位朋友遇到这个错误,每2个小时长时间运行的存储过程就断开,一开始怀疑PROFILE或者RESOURCE PLAN限制。但是大家都明白,一般很少用这些,特别是资源计划,拿到报错后如下:Fatal NI connect e.........【阅读全文】

阅读(4527) | 评论(0) | 转发(0)

发布时间:2015-01-26 11:36:15

If the session is not making a SQL call to Oracle (is INACTIVE) when it is terminated, the ORA-28 message is not returned immediately. The message is notreturned until the user subsequently attempts to use the terminated session.When an inactive session has been terminated, STATUS in the view V.........【阅读全文】

阅读(2816) | 评论(0) | 转发(0)

发布时间:2014-12-16 18:58:59

                                                  ORACLE11GR2 RAC DATABASE+STANDLONE STANDBY配置摘要一、目标为集群数据库配置DATAGUARD,同时实现SWITCH OVER,同时DATAGUARD端并.........【阅读全文】

阅读(8394) | 评论(0) | 转发(0)

发布时间:2014-10-10 18:30:15

Interpreting HANGANALYZE trace files to diagnose hanging and performance problems for 9i and 10g. (文档 ID 215858.1)WHY USING HANGANALYZEA “true” hang in the Oracle database can be defined as an internal deadlock or a cyclical dependency between two or more processes. When dealing with .........【阅读全文】

阅读(3242) | 评论(0) | 转发(0)

发布时间:2014-03-31 21:35:24


阅读(4489) | 评论(0) | 转发(1)

发布时间:2014-03-04 11:05:45

For Oracle with UTF8 and UTF16 character setsAdd TRANLOGOPTIONS option CONVERTUCS2CLOBS to extract parameter file.Please make sure you use the above parameter ONLY  when your Oracle Database has UTF charactersets.  Otherwise, it might corrupt your CLOB data, for.........【阅读全文】

阅读(5672) | 评论(0) | 转发(0)

gaopengtttt2018-04-23 10:48


回复  |  举报

gaopengtttt2018-04-23 10:48

Don't ignore character set information sent by the client. To ignore client information and use the default server character set, use --skip-character-set-client-handshake; this makes MySQL behave like MySQL 4.0

回复  |  举报

登录 注册