jason_125的博客_Oracle故障处理原创博文

Cannot drop a database link after changing the global_name ORA-02024 (文档 ID 382994.1)

Cannot drop a database link after changing the global_name ORA-02024 (文档 ID 382994.1)APPLIES TO:Oracle Database - Enterprise Edition - Version 9.2.0.6 and laterInformation in this document applies to

database

Cannot

drop

原创 2017-10-27 16:00:32 1410 阅读

RMAN-06023: no backup or copy of datafile 16 found to restore

RMAN> restore database;Starting restore at 2017-03-02 12:03:05using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=4269 instance=cqdb&n

RMAN

06023

原创 2017-03-04 15:24:38 1155 阅读

ORA-00379: no free buffers available in buffer pool DEFAULT for block size 32K

在做异机迁移恢复数据库时，报如下错误。PSDRPC returns significant error 1013.PSDRPC returns significant error 1013.PSDRPC returns significant error 1013.RMAN-00571: =======================================================

RMAN

ORA

原创 2017-03-04 15:18:03 2470 阅读

rman还原数据库数据库报错问题处理

报错1、数据库开启block change tracking ,恢复完成后打开因文件不存在报错。RMAN> alter database open resetlogs;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MES

change

rman

block

原创 2016-10-31 11:36:37 2239 阅读

AIX平台署部数据库与打补丁常见错误

1、执行安装时，图形界面无法弹出并报错.$ ./runInstaller********************************************************************************Your platform requires the root user to perform certain pre-installationOS preparati

Oracle

数据库

AIX

原创 2016-10-18 10:11:00 1663 阅读

RHEL6.8_X86_RAC平台升级补丁报错处理

failed

with

OPatch

原创 2016-10-17 10:58:16 921 阅读

wiindows 2012R2+11gR2RAC(11204)多节点传送检查报PRVG-11134

安装数据库软件时，出现多节点传送检查失败，如下图该报错可以忽略，继续安装。官方解释如下： PRVG-11134: Interface "n.n.n.n" on node "racnode1" is not able tocommunicate with interface "n.n.n.n" on node "racnode2" (文档 ID 1372372.1)______

wiindows

PRVG

原创 2016-06-06 15:35:58 2512 阅读

windows 2012R2 11gRAC（11204）------INS-35423报错

1. INS-35423报错安装程序检测到 Oracle Clusterware 未在本地节点上运行，此时检查集群状态是正常的。查看安装日志。发现ORACLE_HOSTNAME变量使用了cluster1-vip作为主机名。日志如下：INFO: Initial values of SetupProperties :--------------------------------

报错

INS

原创 2016-06-06 15:11:10 4328 阅读

wiindows 2012R2+11gR2RAC(11204)安装grid报INS-20802错误

安装grid到84%报如下错误查看安装日志存在如下报错信息> ACFS-9340: 无法安装 ADVM 驱动程序。> acfsinstall: ACFS-09420: 当前未在此节点上安装驱动程序。> acfsinstall: ACFS-09411: CreateService 成功。> acfsinstall: CLSU-0

ins

20802

原创 2016-06-06 13:56:43 5100 阅读 1评论

OPatch Version: 11.2.0.3.13版本与OPatch Version: 11.2.0.3.10版本升级补丁区别

在RHEL6.6+11gR2RAC平台打补丁(11.2.0.4.8)与Patch 22646198 -Oracle Grid Infrastructure Patch Set Update 11.2.0.4.160419 (Apr2016) (IncludesDatabase PSU 11.2.0.4.160419)补丁都要求更新opatch工具版本为 OPa

Oracle

Opatch

原创 2016-05-30 17:07:30 3287 阅读

ORA-00845 MEMORY_TARGET not supported

环境：RHEL6.6+11gR2RAC由于虚拟环境搭建rac做测试，设置虚机内存为3G，打补丁导致pc机太慢，因此调整两台虚拟机内容为2534M内存，启动虚拟后发现数据库无法启动，尝试在单节点手工启动报如下错误：oracle@cluster2 ~]$ sqlplus /nologSQL*Plus: Release 11.2.0.4.0 Production on Sat May 28 01:03:

TARGET

MEMORY

ORA

原创 2016-05-30 16:17:09 689 阅读

11gR2 RAC时间同异常导致节点down掉问题处理

实验环境下11204的RAC环境，出现了一个节点DOWN掉的问题。检查日志信息后，在otcssd日志信息发现如下信息：2016-01-17 23:15:20.564: [ CTSS][1175029504]ctsscomm_recv_cb2: Receive incoming message event. Msgtype [

时间

down

导致节点

原创 2016-01-21 16:46:29 701 阅读

GI OPatch升级 The opatch Component check failed. This patch is not applicable for...

Oracle11gr2RAC(11204)打补丁11.2.0.4.8，系统为：SuSE11sp3 X86_64通过/u01/app/11.2.0/grid/OPatch/opatch auto /tmp/21523375 -ocmrf /tmp/ocm.rsp 同时对ORACLE_HOME,GI_HOME同时升级。出现如下报错：jason1:/u01/app/11.2.0/grid/OPatch

OPatch

GI

The

原创 2016-01-21 15:58:37 1132 阅读

ORA-01565: error in identifying file '+DATA/ORACLE/spfileORACLE.ora'

操作系统为suse11sp3_x86_64位，数据库为11204。不小心修改了RAC目录及子目录的权限，资源启动后发现两个节点数据库都未启动，如下：jason1:/u01/app/11.2.0/grid/bin # ./crsctl stat res -t------------------------------------------------------------------------

lost

ORA

TNS

原创 2016-01-21 15:33:48 1178 阅读

Suse11SP3系统平台Crsctl执行关闭时报错处理

Suse11SP3系统平台Crsctl执行关闭时报错处理Crsctl执行关闭时报错。jason1:/u01/app/11.2.0/grid/bin # ./crsctl stop crsCRS-2791: Starting shutdown of Oracle High AvailabilityServices-managed resources on 'jason1'CRS-2673: Atte

11gR2RAC Crsctl Suse

原创 2016-01-18 15:43:56 1235 阅读

Oracle Grid Infrastructure Install or Upgrade Fails With INS-20802

RAC on Windows: Oracle Grid Infrastructure Install or Upgrade Fails With Error INS-20802 if Microsoft WMI Service is Disabled (文档 ID 1641356.1)PPLIES TO:Oracle Database - Standard Edition - Version 11

Error INS-20802 wind

原创 2015-06-11 16:30:44 1008 阅读

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

此为11g的bug，需要在delete后加上force关键字，如下：RMAN-08137 When deleting archivelogs even when Streams CAPTURE does not require them [ID 1079953.1]In this Document Symptoms &

RMAN-08137

原创 2015-06-10 10:49:55 3736 阅读

RMAN-06820 ORA-17629 During Backup at Standby Site

RMAN-06820 ORA-17629

原创 2015-06-10 10:47:05 3831 阅读

root.sh Fails on the First Node for 11gR2 Grid Infrastructure Installation

在第二节点执行脚本报如下错误，根据官方提示进行修复仍无济于事。由于测试环境使用虚拟机搭建共享磁盘，最终发现导致如下报错原因为共享磁盘问题，更换共享磁盘后问题解决。node2:/u01/app/11.2.0/grid # ./root.sh Performing root user operation for Oracle 11g The following environmen

Oracle

虚拟机

local

operation

following

原创 2015-06-08 09:51:14 3262 阅读

suse11sp3 执行root.sh失败bug处理

当按照提示在节点1、节点2执行root.sh报错如下node1:/u01/app/11.2.0/grid # ./root.sh Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= grid

root.sh ACFS-9109:

原创 2015-06-08 09:45:28 1392 阅读

ORA-27102: out of memory故障处理

客户原有服务器为64G的内存，迁移后服务器为128G内存，数据库原SGA为8G，迁移至新服务器后修改数据库sga为16G，启动时报如下错误：数据库版本为10205，系统版本为RHEL6.5。SQL> startupORA-27102: out of memoryLinux-x86_64 Error: 28: No space left on d

ORA-27102

out of memory

原创 2014-08-18 13:07:24 3569 阅读

ora-600 [kcblasm_1]bug处理（二）

6、编译数据库。cd $ORACLE_HOME/rdbms/adminsqlplus /nologSQL> CONNECT / AS SYSDBASQL> STARTUPSQL> @catbundle.sql psu apply此过程日志过多，不再次显示。SQL> @utlrp.sql此过程日志过多，不再次显示。SQL> QUIT7、查看补丁是否安装到ORACLE_H

HISTORY

DBA

REGISTER

PSU

原创 2014-08-05 10:14:19 632 阅读

ora-600 [kcblasm_1]bug处理（一）

ORACLE10205数据库中存在ora-600 [kcblasm_1]bug，需要安装p12419392_10205_Linux-x86-64.zip补丁，如下进行升级处理。1、进行环境检测，确保以下命令在$PATH环境变量中并可用。[root@server orahome]# which make /usr/b

bug

处理

原创 2014-08-04 15:49:15 458 阅读

rman备份恢复到异机报ORA-01110 ORA-01180错误

备份

rman

恢复到异机

原创 2014-07-31 16:27:21 3055 阅读

crs_start -all Reports: "CRS-0223 Resource 'ora.<node name>.ons' has placement e

环境：RHEL5.6_X86_64 Oracle 10g10205 RAC[oracle@jason1 ~]$ crs_start -allAttempting to start `ora.jason1.ASM1.asm` on member `jason1`Attempting to start `ora.jason1.vip` on member `jason1`A

环境

crs_start -all Repor

RHEL5.6_X86_64 Oracl

原创 2013-11-25 10:16:35 1527 阅读

ORA-00600: [kcratr1_lastbwr]错误的处理办法

客户环境为Oracle 10201,64位数据库。数据库启动时报 ORA-00600: [kcratr1_lastbwr] 错误无法打开。查看mos给的处理方法如下：APPLIES TO:Oracle Server - Enterprise Edition - Version 10.2.0.1 to 11.1.0.6 [Release 10.2 to 11.1]Information in t

ORA-00600: [kcratr1_

原创 2013-10-15 13:47:41 2216 阅读

ORA-00600错误参数[6749]故障处理

客户报修客户端无法连接，远程查查看服务器发现数据库归档空间已满，警告日志报大量ORA-00600错误，数据库版本为10204.如下：Wed Aug 14 04:00:48 2013 Errors in file /home/oracle/orabase/admin/ORACLE/bdump/oracle_j000_8737.trc: ORA-00600: internal error code,

ORA-00600错误参数[6749]

原创 2013-10-14 09:45:44 1325 阅读

tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x1)

科室反应业务不能使用，工程师重启数据库及应用程序问题解决，收集日志查看日志发现如下信息，数据库版本为10.2.0.1./home/oracle/orabase/admin/ORACLE/bdump/oracle_lgwr_29650.trcOracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit ProductionWith

oracle

应用程序

thread

message

process

原创 2013-07-31 17:15:12 1262 阅读

ORA-00600 [kcratr1_lostwrt]错误处理

工程师将数据库未关闭进行整体拷贝在异机以为可以打开，将原服务器系统重做。打开时数据库报如下错误ORA-00600: 内部错误代码，参数: [kcratr1_lostwrt], [], [], [], [], [], [], [] 原因:When an instance is restarted following an instance crash, Oracle ca

ORA-00600 [kcratr1_l

原创 2013-07-04 08:53:17 540 阅读

ORA-02266错误处理

truncate一张表，报ORA-02266错误。SQL> truncate table WRM$_DATABASE_INSTANCE; truncate table WRM$_DATABASE_INSTANCE * ERROR at line 1: ORA-02266: unique/primary keys in table referenced b

ORA-02266 ORA-02298

原创 2013-07-03 16:10:52 1147 阅读

官方博客	全部文章	热门标签	班级博客
了解我们	网站地图	意见反馈

鸿蒙开发者社区	51CTO学堂
51CTO	软考资讯

51CTO博客

技术成就梦想！

Cannot drop a database link after changing the global_name ORA-02024 (文档 ID 382994.1)

RMAN-06023: no backup or copy of datafile 16 found to restore

ORA-00379: no free buffers available in buffer pool DEFAULT for block size 32K

rman还原数据库数据库报错问题处理

AIX平台署部数据库与打补丁常见错误

RHEL6.8_X86_RAC平台升级补丁报错处理

wiindows 2012R2+11gR2RAC(11204)多节点传送检查报PRVG-11134

windows 2012R2 11gRAC（11204）------INS-35423报错

wiindows 2012R2+11gR2RAC(11204)安装grid报INS-20802错误

OPatch Version: 11.2.0.3.13版本与OPatch Version: 11.2.0.3.10版本升级补丁区别

ORA-00845 MEMORY_TARGET not supported

11gR2 RAC时间同异常导致节点down掉问题处理

GI OPatch升级 The opatch Component check failed. This patch is not applicable for...

ORA-01565: error in identifying file '+DATA/ORACLE/spfileORACLE.ora'

Suse11SP3系统平台Crsctl执行关闭时报错处理

Oracle Grid Infrastructure Install or Upgrade Fails With INS-20802

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

RMAN-06820 ORA-17629 During Backup at Standby Site

root.sh Fails on the First Node for 11gR2 Grid Infrastructure Installation

suse11sp3 执行root.sh失败bug处理

ORA-27102: out of memory故障处理

ora-600 [kcblasm_1]bug处理（二）

ora-600 [kcblasm_1]bug处理（一）

rman备份恢复到异机报ORA-01110 ORA-01180错误

crs_start -all Reports: "CRS-0223 Resource 'ora.<node name>.ons' has placement e

ORA-00600: [kcratr1_lastbwr]错误的处理办法

ORA-00600错误参数[6749]故障处理

tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x1)

ORA-00600 [kcratr1_lostwrt]错误处理

ORA-02266错误处理