ITPub博客

Oracle、MySQL专业服务（兼职）： 专家级服务： 灾难恢复、紧急性能优化、重大事故处理、重大事件保障，重大项目迁移（EBS\SAP\TB级别数据\0停机迁移\AIX to x86）、改造、升级。

Tidb 登录，查找TOP SQL、慢SQL、会话管理，批量杀会话等

Oracle 如何快速的 duplicate 一个数据库

如果你的Exadata明明密码对了，却登录不上，不要着急因为Exadata输入一次密码错误会锁定10分钟。

Patch: Log: /cfgtoollogs/opatchauto/core/opatch/opatch2019-05-31_02-22-44AM_1.log Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: ApplySession failed in system modification phase... 'ApplySession::apply failed: java.io.IOException: oracle.sysman.oui.patch.PatchException: java.io.FileNotFoundException: /ContentsXML

经过测试得出如下结论，，dblink在session 第一次调用后保持长连接，退出session之后链接断开。不同的session，使用不同的 dblink 长连接 。

使用RPM包 静默方式安装 oem agent1.生成rpm包登陆oms 服务器：#####前置条件# mkdir -p /usr/lib/oracle# chmod 777 /usr/lib/oracle保证可以执行rpmbuild命令否则安装包：[root@omsserver ~]# yum install -y rpm-build#####开始：$ cd /u01/app/Middleware/oms/bin/登陆会话：$ ./emcli...

Exception Name:MakefileExceptionException String:Error in invoking target 'install' of makefile'/u01/app/oracle/middleware_12.1.0.5/oms/sqlplus/lib/ins_sqlplus.mk'. Se...

opatchauto apply –analyze

[oracle@dm10db04 trace]$ srvctl start instance -d haiermdm -i haiermdm4<br />PRCR-1013 : Failed to start resource ora.haiermdm.db<br />PRCR-1064 : Failed to start resource ora.haiermdm.db on node dm10db04<br />CRS-5017: The resource action "ora.haiermdm.db start" encountered the following error:...

<p style="margin-top:0px;margin-bottom:16px;font-size:16px;font-family:微软雅黑, Tahoma;line-height:25.59375px;white-space:normal;background-color:#FFFFFF;">1.最近客户系统在执行ETL时，出现异常宕机</p><p style="margin-top:0px;margin-bottom:16px;font-size:16px;font-family:微软雅黑, Tahoma;line-hei...

<strong>Oracle重置序列(不删除重建方式)</strong> <br />Oracle中一般将自增sequence重置为初始1时，都是删除再重建，这种方式有很多弊端，依赖它的函数和存储过程将失效，需要重新编译。 <br />不过还有种巧妙的方式，不用删除，利用步长参数，先查出sequence的nextval，记住，把递增改为负的这个值（反过来走），然后...

1.监视：视图DBA_AUTOTASK_JOB_HISTORY来跟踪自动作业情况。可以通过查询视图DBA_AUTOTASK_HISTORY追踪job运行情况：

客户系统alert log中出现大量的分布式延时信息：Wed Jun 03 20:05:44 2015DISTRIB TRAN HAIERMDM.f905907b.355.1.7544  is local tran 355.1.7544 (hex=163.01.1d78)  insert pending committed tran, scn=13510368365236 (hex=c49.a0b50ab4)Wed Jun 03 20:05:44 2015DISTRIB TRAN HAIERMDM.f905907b.355.1...

临时表空间SET LINESIZE 160COL TABLESPACE_NAMEFOR A30SELECTTABLESPACE_NAME                 ASTABLESPACE_NAME        ,SUM(BYTES)/1024/1024/1024   &nbsp...

SELECT a.sid,b.sql_id,b.sql_text,a.MACHINEFROM v$session a,v$sqlarea bWHERE a.sql_hash_value = b.hash_valueAND a.sid IN (SELECT /*+ rule*/ sidFROM v$accessWHERE OBJECT = 'ODS7001_V_CD_EDW_WK');

ogg 同步 物化视图创建限制：Materialized views are supported by Extract in classic and integrated modes with the following limitations.1.Materialized views created WITH ROWID are not supported.2.The materialized view log can be created WITH ROWID.3.The source table must have a primary key.4.Tr...

Thu May 21 23:26:00 2015Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x7F167EC05000] [PC:0x49E0CF0, __intel_new_memcpy()+5424] [flags: 0x0, count: 1]Errors in file /u01/app/oracle/diag/rdbms/oms/OMS3/trace/OMS3_j001_10768.trc  (incident=1635086):ORA-07445: exception...

Errors in file /u01/app/oracle/diag/rdbms/oms/OMS3/trace/OMS3_j001_13961.trc:ORA-12012: error on auto execute of job "SYS"."ORA$AT_SA_SPC_SY_47429"ORA-01426: numeric overflowORA-06512: at "SYS.DBMS_ADVISOR", line 201ORA-06512: at "SYS.DBMS_SPACE", line 2480ORA-06512: at "SYS.DBMS_SPACE", line 2553

如下数据是在一体机环境下收集的：[grid@dm02db01 ~]$asmcmdASMCMD> lsdgState               Type    Rebal Sector  Block    AU        Total_MB ...