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 1156 阅读

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 2468 阅读

ORA-00119, ORA-00132 Incorrect Value for REMOTE_LISTENER

In an Oracle 11g RAC environment, you might get this error when trying to start the database. This may happen for any one of the instances. When everything else is ONLINE and STABLE in your $GRID_HOME

ORA-00119

ORA-00132 Incorrect

转载 2016-11-18 14:45:42 960 阅读

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 2238 阅读

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 4327 阅读

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 3286 阅读

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 687 阅读

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 1129 阅读

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 1233 阅读

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 630 阅读

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 459 阅读

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 1525 阅读

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 2212 阅读

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 1263 阅读

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 阅读

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

鸿蒙开发者社区	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

ORA-00119, ORA-00132 Incorrect Value for REMOTE_LISTENER

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]错误处理