ITPub博客

环境信息：主环境为RAC 11.2.0.4               DG环境为：单机由于主环境参数：standby_file_management=auto，从库忘记设置该参数为auto，使用了默认值manual，导致在主库添加表空间后从库的数据文件出现异常：主库：create tablespace history;从库开始报错如下：Media R...

在安装完RAC11.2.0.4,并打上PSU后，在通过DBCA创建数据库实例是出现诡异现象：弹出来的框为单实例创建，二并非RAC实例。反复试了几次都是同样的问题，检查安装无问题。在metalink上查看了下，问题原因很多，同事通过sqlplus连接空实例测试出现如下报错：[oracle@zderp2vprd01 cfgtoollogs]$ sqlplus / as sysdbaSQL*...

Using configuration parameter file: /oracle/app/11.2.0/grid_1/crs/install/crsconfig_paramsStopping CRS...Stopped CRS successfullypatch /osbackup/soft/21523375/21352635  apply successful for home  /oracle/app/11.2.0/grid_1 patch /osbackup/soft/21523375/21352649  apply fail...

申明：本文转载自：http://czmmiao.iteye.com/blog/1763055IPC Send timeout故障现象RAC 数据库上比较常见的一种问题就是“IPC Send timeout”。数据库Alert log中出现了“IPC Send timeout”之后，经常会伴随着ora-29740 或者 "Waiting for clusterware split-brain resolution"等，数据库实例会因此异常终止...

APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterLinux x86-64SYMPTOMSDynamically added new disks to storage using udev rules(as per the docs note 414897.1, 1528148.1, 371814.1 etc).During start_udev, udev has deleted the public network interface a...

在AIX6.1下安装ORACLE11.2.0.4 RAC的时候，在节点2执行root.sh报错如下：[root@oratest02:/oracle/]#sh /oracle/app/11.2.0/grid_1/root.shPerforming root user operation for Oracle 11g The following environment variables are set as:    ORACLE_OWNER= grid    ORACLE_HOME=  ...

最近系统检查发现有个系统一直在报错：ORA-03137: TTC 协议内部错误: [12333] [48] [9] [91] [] [] [] []检查trc文件发现有如下问题：ump file /oracle/app/db/diag/rdbms/oracle1/oracle1/incident/incdir_7497/oracle1_ora_17113_i7497.trcOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Product...

In this DocumentSymptomsCauseSolutionReferencesAPPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterInformation in this document ap...

原文：http://blog.csdn.net/haibusuanyun/article/details/46926973近期在多个大型系统中遇到此问题，一般来说如果客户端未反映异常的话可以忽略的。如果是客户端登陆时遇到ORA-12170: TNS:Connect timeout occurred，可以参考 http://blog.csdn.net/haibusuanyun/article/details/14517211#t12###############参考MOS...

昨晚对一套RAC系统顺利进行了PSU补丁包的安装后，在启动数据库时报错如下：    Mon Oct 19 17:52:31 2015ALTER SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=10.0.61.96)(PORT=1526))' SCOPE=MEMORY SID='hbdbuat1';This instance was first to mountNOTE: Loaded library: SystemO...

准备过节了，对系统做了一次全面的检查，也发现了不少的问题，对某一台RAC检查时发现如下错误：<br />2015-08-23 04:34:18.962:<br />[client(18715)]CRS-0009:log file "/oracle/app/11.2.0/grid/log/d4jt6csvpra04/client/olsnodes.log" reopened<br />2015-08-23 04:34:18.962:<br />[client(18715)]CRS-0019:file r...

<h2 class="km" style="font-family:Arial, Helvetica, sans-serif;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:#C4D1E6;font-size:16px;color:#FFFFFF;text-transform:uppercase;padding-top:6px;padding-bottom:6px;padding-left:8px;line-height:normal;white-space:normal;background-colo...

<h2 class="km" style="font-family:Arial, Helvetica, sans-serif;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:#C4D1E6;font-size:16px;color:#FFFFFF;text-transform:uppercase;padding-top:6px;padding-bottom:6px;padding-left:8px;line-height:normal;white-space:normal;background-colo...

在很多系统中经常都会看到如下报错：系统版本：oracle 11.2.0.4 RAC操作系统：linux、aix都有类似情况：Archived Log entry 1253 added for thread 2 sequence 653 ID 0x6ceef059 dest 1:Tue Jun 02 13:49:31 2015***********************************************************************Fatal NI connect er...

     我们oracle 11.2.0.2 for aix平台安装grid集群软件时，到了选择组级别时，报以下错误:  [INS-30060] Check For Group Existence Failed      检查/etc/...

今天在给某项目做备份数据还原是出现如下错误，P6（V8版本）系统对11.2.0.4 RAC的支持上存在一定的bug。故项目只能用11.2.0.3，在安装系统时时间比较仓促也并未打上最新的PSU，故而有了如下报错：数据库整库导入，使用table_exists_action=replace来出来重复的表数据，因一直统计信息存在一定问题，事先采用exclude=statist...

今天一同事告知，新clone的数据库无法正常启动，登陆启动之后报错如下：[oracle@PlanDB01Dev ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Fri May 15 15:17:38 2015Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected.SQL> startupORA-00119: invalid specifica...

在创建数据库实例的时候未采用loltp模板，在后期做数据泵备份数据时报错如下：oracle@zderpppad01:/home/oracle$expdp \'/ as sysdba\' dumpfile=guijian.dmp logfile guijian.log schemas=guijianExport: Release 11.2.0.4.0 - Production on Thu May 14 18:11:50 2015Copyright (c) 1982, 2011, Oracle and/or it...

Memory Notification: Library Cache Object loaded into SGAHeap size 97011K exceeds notification threshold (51200K)Details in trace file /oracle/app/db/diag/rdbms/mdmdb/MDMDB1/trace/MDMDB1_ora_31499.trcKGL object name :create table T$GB_10FE975E4A207B0BE053 nologging tablespace CMX_TEMP noparallel ...

告警日志错误：Tue Mar 10 21:48:29 2015SKGXP:[110ab7ca8.1]{-}: WARNING: Failed to set buffer limit on IPC interconnect socketSKGXP:[110ab7ca8.1]{-}: Oracle requires that the socket receive buffer size be tunable up to 2048 KB.Please make sure the kernel paramete...