ITPub博客

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 ...

记录一下ORACLE 10gR2的软件下载地址，备用。下载OTN上的这些软件，你需要一个OTN免费帐号，不过如果通过迅雷进行下载，就不用登陆OTN了：Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)http://download.oracle.com/otn/nt/oracle10g/1020...

Cluster nodes maintain their heartbeat via private network and voting disk. When there is a private network disruption, cluster nodes can not communicate to each other via private network for the time period of misscount setting, split brain will happen. In such case, voting disk will be used to...

[oracle@bcc1 ~]$ srvctl add service -hAdds a service configuration to the Oracle Clusterware.Usage: srvctl add service -d <db_unique_name> -s <service_name> {-r "<preferred_list>" [-a "<available_list>"] [-P {BASIC | NONE | PRECONNECT}] | -g <pool_name> [-c {UNIFORM | SINGLETON}] } [-k  ...

11g R2 RAC: SERVER POOLSJanuary 11, 201311g R2 RAC, Uncategorized                                         In this post, I will explain about Server P...

waring 1： WARNINGASM CheckLinux Disk I/O Scheduler should be configured to [Deadline]All ASM InstancesView做了如下修改：[root@bcc1 ~]# echo 'deadline' > /sys/block/sda/queue/scheduler[root@bcc1 ~]# cat...

[grid@bcc2 ~]$ sqlSQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 7 15:26:21 2015Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to an idle instance.SQL> exitDisconnected[grid@bcc2 ~]$ vi .bash_profile # .bash_profile# Get the aliases and functionsi...