-
编辑 删除
Check the existence of public synonyms Remove the public synonyms
在安装12c Cloud Control时遭遇Check the existence of public synonyms， Remove the public synonyms错误，由于之前安装过一次，可能没删除干净但是不知道public synonym名称是什么，上mos上查查，终于找到了一篇文章，解决方法如下：1.删除资料库用户：drop user SYSMAN cascade;drop user SYSMAN_MDS cascade;drop...
-
编辑 删除
ORA-07445: 出现异常错误: 核心转储 [plcurClose()+40] [SIGSEGV]
1.环境介绍DB版本：Oracle 11g 11.2.0.3 64位OS版本: IBM AIX 6.1 64位2.现象Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x424C455F51545A0C] [PC:0x102618AA8, plcurClose()+40] [flags: 0x0, count: 1]Errors in file /u01/oracle/diag/rdbms/jzh/jzh2/trace/jzh2_j012_6095470.trc &nbs...
-
编辑 删除
Non critical error ORA-48913 caught while writing to trace file
检查某客户数据库alert警告日志发现如下错误：Non critical error ORA-48913 caught while writing to trace file "/u01/oracle/jzh/db/tech_st/11.1.0/admin/jzh_dpebsr12/diag/rdbms/jzh/jzh/trace/jzh_ora_9568606_owc.trc"Error message: ORA-48913: 鍐欏叆璺熻釜鏂囦欢澶辫触, 杈惧埌浜嗘枃浠跺ぇ灏忛檺鍒?[10485760...
-
编辑 删除
记一次RAC Brain Split脑裂分析过程
1.环境介绍：DB版本：11.2.0.4 64位OS版本：AIX 6.1 位2.错误现象node1 节点1ASM实例日志：Mon Jan 12 09:08:48 2015Reconfiguration started (old inc 8, new inc 10)List of instances:1 (myinst: 1) Global Resource Directory frozen* dead instance detected - domain 1 invalid = TRUE * dead i...
-
编辑 删除
Oracle 10g RAC 修改心跳为绑定网卡(设置冗余)
环境： Oracle 10.2.0.4 RAC, 2节点Linux AS 5.3 配置文件： /ect/hosts 配置主机名和IP地址的对应/etc/sysconfig/network 配置主机名和网关/etc/sysconfig/network-scripts/i...
-
编辑 删除
Private strand flush not complete
一次例行巡检，在客户数据库中发现大量Private strand flush not complete错误，alert日志信息如下：客户DB版本为11.2.0.3 64位Thread 1 cannot allocate new log, sequence 11004Private strand flush not complete Current log# 2 seq# 11003 mem# 0: /oradata1/MESP/redo02a.log Current log# 2 seq# 1...
-
编辑 删除
ORA-07445: exception encountered: core dump [qertbStart()+327] [SIGSEGV]
检查alert警告日志时，发现报错ORA-07445: exception encountered: core dump [qertbStart()+327] [SIGSEGV]客户环境是：oracle 10.2.0.4，redhat 6.1trace文件内容如下：ksedmp: internal or fatal errorORA-07445: exception encountered: core dump [qertbStart()+327] [SIGSEGV] [unknown code] [0x000000000] [] [...
-
编辑 删除
Data Guard维护管理三之处理archivelog gap
1.When Is an Archive Gap Discovered?An archive gap can occur whenever the primary database archives a log locally, but the log is not received at the standby site. Every minute, the primary database polls its standby databases to see if there are gaps in the sequence of archived redo log files.每...
-
编辑 删除
Data Guard维护管理二
1.备库归档日志设置不正确如果standby_archive_dest初始化参数在备库设置路径不正确，那数据库就不能存储归档日志可以从视图v$archive_dest中destination,error字段查找原因，语句如下：SELECT DESTINATION, ERROR FROM V$ARCHIVE_DEST;SQL> SELECT DESTINATION, ERROR FROM V$ARCHIVE_DEST;2.使用alter database命令r...
-
编辑 删除
ORA-01102: cannot mount database in EXCLUSIVE mode
刚刚安装完数据库，启动报错ORA-01102: cannot mount database in EXCLUSIVE modeSQL> startupORACLE instance started.Total System Global Area 534462464 bytesFixed Size 2230072 bytesVariable Size &n...
-
编辑 删除
ORA-07445: exception encountered: core dump [PC:0x90000000D017E10]
上周给客户做巡检时在alert日志发现这个错误ORA-07445: exception encountered: core dump [PC:0x90000000D017E10] [SIGSEGV]ORA-07445: exception encountered: core dump [PC:0x90000000D017E10] [SIGSEGV] [ADDR:0xFFFFFFFFDFFFB00] [PC:0x90000000D017E10] [Address not mapped to object] 2014/11/18 04:39:20 ...
-
编辑 删除
Data Guard维护管理一
1.检查警告日志数据库警告日志是按照时间顺序记录数据库的信息和错误，除了提供oracle数据库信息之外，还包括对Data Guard一些操作的信息，如下：1.1执行相关sql语句：alter database recover managed standby,startup,shutdown,archive log还有recover；1.2一些后台进程会报相关错误，如：ARCO,MRP0,RFS,LGWR；1.3操作...
-
编辑 删除
最常见的5个导致 RAC 实例崩溃的问题
问题 1：ORA-29770 LMHB 终止实例症状：LMON (ospid: 31216) waits for event 'control file sequential read' for 88 secs.Errors in file /oracle/base/diag/rdbms/prod/prod3/trace/prod3_lmhb_31304.trc (incident=2329):ORA-29770: global enqueue process LMON (OSID 31216) is hung for more than 70 secondsL...
-
编辑 删除
谓词条件是is null走索引吗？
1.创建测试表JZH@TEST>create table t (x int,y int);Table created.JZH@TEST>create index t_indx on t(x,y);Index created.JZH@TEST>insert into t values(1,1);1 row created.JZH@TEST>insert into t values(1,null);1 row created.JZH@TEST>insert into t values(null,1);1 row created.JZH@TEST>insert int...
-
编辑 删除
Oracle 11.2.0.4 RAC psu补丁升级至11.2.0.4.2
1、 当前数据库环境：两节点RAC OS Redhat 6.4 64bitGrid software 11.2.0.4Oracle software 11.2.0.4准备补丁安装包如下：p6880880_112000_Linux-x86-64.zipp18139609_112040_Linux-x86-64.zip2、 检查当前数据库的版本[oracle@nopplbds03 OPatch]$ ./opatchversion...
-
编辑 删除
[INS-06006] Passwordless SSH connectivity not set up
升级Grid Infrastructure时遭遇[INS-06006] Passwordless SSH connectivitynot set up between the following node(s)错误，如下图：一、环境说明：DB版本：Oracle 11.2.0.4 OS版本：Redhat 6.4二、处理方法1、使用ssh验证等效性[grid@NOPPLBDS03 ~]$ date;ssh NOPPLBDS03dateWed Dec 10 17:06:23 CS...
-
编辑 删除
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream
客户数据库备份日志报错：RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process，DB版本为11.2.0.1，根据备策略，每天备份归档，并且自动删除档，保留两个星期的归档，手功执如下命令：delete noprompt archivelog until time 'sysdate-14'；依...
-
编辑 删除
简单配置 Log Miner
1.启用数据库附加日志SYS@TEST>alter database add supplemental log data;Database altered.2.以sysdba登陆，执行logminer脚本SYS@TEST>@$ORACLE_HOME/rdbms/admin/dbmslm.sqlPackage created.Grant succeeded.Synonym created.3.检查logminer是否可用SYS@TEST>desc dbms_logmnrPROCEDURE ADD_LOGFILE ...
-
编辑 删除
ORA-00270: error creating archive log ORA-16055: FAL request rejected
客户在检查数据库alert日志时发现错误，信息如下：ORA-00270: error creating archive log FAL[server, ARC1]: FAL archive failed, see trace file.Errors in file c:\app\administrator\diag\rdbms\bpmes\bpmes\trace\bpmes_arc1_5680.trc:ORA-16055: FAL request rejectedARCH: FAL archive failed. Archiver ...
-
编辑 删除
ORA-00600: internal error code, arguments: [kollasg:client-side tmp lob]
朋友的数据库alert警告日志文件里报ORA-00600: internal error code, arguments: [kollasg:client-sid tmp lob]数据库版本是10.2.0.5，在mos上找到了一篇文章ORA-00600 [kollasg:client-side tmp lob] Fetching Row With LOB Column in OCI Application (文档 ID 1418135.1)APPLIES TO:Oracle Database - Enterprise E...
