导航

随笔分类 -  Oracle故障解决

1 2 下一页

CLSRSC-400: A system reboot is required to continue installing

摘要：诊断：CLSRSC-400: A system reboot is required to continue installing.Linux7.5安装Grid Infrastructure 12.2.0.1时，在root.sh时会报错2019/1021 09:19:28 CLSRSC-330: A 阅读全文

posted @ 2019-10-21 18:48 datalife 阅读(1330) 评论(0) 推荐(0)

ocr_vote disk损坏恢复

摘要：1. 检查votedisk和 ocr备份[root@rh6rac1 bin]./ocrconfig -showbackuprh6rac1 2019/03/19 16:57:40 /oracle/grid/cdata/rh6rac-cluster/backup00.ocrrh6rac1 2019/03 阅读全文

posted @ 2019-03-19 10:26 datalife 阅读(706) 评论(0) 推荐(0)

ORA-27302: 错误发生在: sskgpwrm1

摘要：opidrv aborting process M002 ospid (3561) as a result of ORA-600ORA-27300: 操作系统相关操作: semctl 失败, 状态为: 22ORA-27301: 操作系统故障消息: Invalid argumentORA-27302: 阅读全文

posted @ 2019-01-31 15:40 datalife 阅读(1126) 评论(0) 推荐(0)

How To Upgrade ASMLib Kernel Driver as Part of Kernel Upgrade? (文档 ID 1391807.1)

摘要：How To Upgrade ASMLib Kernel Driver as Part of Kernel Upgrade? (文档 ID 1391807.1) 阅读全文

posted @ 2017-12-15 15:13 datalife 阅读(155) 评论(0) 推荐(0)

Troubleshooting 10g and 11.1 Clusterware Reboots (文档 ID 265769.1)

摘要：Troubleshooting 10g and 11.1 Clusterware Reboots (文档 ID 265769.1) This document is intended for DBA's and support analysts experiencing 10g or 11.1 Cl 阅读全文

posted @ 2017-12-13 17:12 datalife 阅读(229) 评论(0) 推荐(0)

RMAN-06900 RMAN-06901 ORA-19921

摘要：转自http://blog.itpub.net/12778571/viewspace-700360/ 1、连接到rman中$ rman target/Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 21 10:27:39 20 阅读全文

posted @ 2017-11-27 11:38 datalife 阅读(1768) 评论(0) 推荐(0)

一则ORACLE进程都在但是无法进入实例的问题

摘要：[oracle@localhost ~]$ ps -ef|grep smonoracle 14809 1 0 Sep25 ? 00:13:02 ora_smon_mailp3[oracle@localhost ~]$ export ORACLE_SID=mailp3[oracle@localhost 阅读全文

posted @ 2017-10-19 11:17 datalife 阅读(507) 评论(0) 推荐(0)

数据泵导出报ORA-01555 ORA-22924

摘要：最近对某数据库执行数据泵导出操作时碰到如下错误：Processing object type DATABASE_EXPORT/SCHEMA/JOBProcessing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INS 阅读全文

posted @ 2017-09-22 13:21 datalife 阅读(1646) 评论(0) 推荐(0)

从巡检备份失败排查解决数据库故障

摘要：最近某业务备份报错：Starting Control File and SPFILE Autobackup at 09-MAY-16piece handle=c-335040995-20160509-00 comment=API Version 2.0,MMS Version 5.0.0.0Fini 阅读全文

posted @ 2016-05-09 15:44 datalife 阅读(859) 评论(0) 推荐(0)

数据库节点1存储丢失

摘要：1.查看oracleasm日志sjzxdb1:/var/log # more oracleasmCreating /dev/oracleasm mount point: /dev/oracleasmLoading module "oracleasm": oracleasmMounting ASMli... 阅读全文

posted @ 2016-01-21 11:01 datalife 阅读(495) 评论(0) 推荐(0)

ORA-00245: control file backup failed; target is likely on a local file system

摘要：ORACLE11G RAC alert报错如下：Errors in file /u01/app/oracle/diag/rdbms/dljyzs/dljyzs1/trace/dljyzs1_ora_81734.trc:ORA-00245: control file backup failed; ta... 阅读全文

posted @ 2015-08-22 09:40 datalife 阅读(848) 评论(0) 推荐(0)

NBU恢复报：ORA-19554 ORA-27211

摘要：RMAN> run {2> allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=rac1)';3> restore controlfile from '/cntrl_7418_1_888200750'; 4> rele... 阅读全文

posted @ 2015-08-22 09:38 datalife 阅读(3487) 评论(0) 推荐(1)

rh6安装oracle11g+ASM

摘要：安装步骤我这里略过，主要说下安装过程中遇到到问题或重要步骤：1、UDEV绑定：for i in b c d e ;doecho "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id --whitelisted --replace-whit... 阅读全文

posted @ 2015-06-14 19:47 datalife 阅读(406) 评论(0) 推荐(0)

安装LINUX X86-64的10201出现链接ins_ctx.mk错误-转自yingtingkun

摘要：详细错误信息为：Error in invoking target‘install’of makefile‘/opt/oracle/product/10.2/ctx/lib/ins_ctx.mk’. See‘/opt/oracle/oraInvertory/logs/installActions201... 阅读全文

posted @ 2014-05-30 17:40 datalife 阅读(225) 评论(0) 推荐(0)

Linux安装Oracle报Checking operating system version must be redhat-3, SuSE-9, redhat-4

摘要：解决办法：vi /xx/database/install/oraparam.ini找到【Certified Versions】Linux=redhat-3，SuSe-9，redhat-4，后面加上redhat-5保存并退出即可。如图： 阅读全文

posted @ 2014-05-30 08:31 datalife 阅读(1591) 评论(0) 推荐(0)

如何解决Ora-00600 4194错误-转自eygle

摘要：启动数据库出现Ora-00600 4194错误，观察alert文件，主要错误日志如下:Sat Jan 21 13:55:21 2006Errors in file /opt/oracle/admin/conner/bdump/conner_smon_17113.trc:ORA-00600: internal error code, arguments: [4194], [43], [46], [], [], [], [], []Sat Jan 21 13:55:21 2006Errors in file /opt/oracle/admin/conner/udump/conner_ora_171 阅读全文

posted @ 2011-03-15 19:57 datalife 阅读(475) 评论(0) 推荐(0)

UNDO表空间的ORA-1122错误解决（三)转

摘要：http://space.itpub.net/?uid-4227-action-viewspace-itemid-198238 阅读全文

posted @ 2011-03-15 19:55 datalife 阅读(177) 评论(0) 推荐(0)

UNDO表空间的ORA-1122错误解决（二）转

摘要：前一段时间解决了一个ORA-1122错误，正好本机的数据库环境由于Windows的自动重起，导致数据库无法打开，出现错误信息也是ORA-1122。这次出现错误的表空间是UNDO表空间。上一篇介绍了利用备份进行恢复的方法，这篇尝试重建UNDO表空间的方法。UNDO表空间的ORA-1122错误解决（一）：http://yangtingkun.itpub.net/post/468/455691由于数据库存在备份，因此可以轻松的对数据库进行恢复，不过难得碰到一个错误的情况，尝试一下是否可以在缺少备份的基础上进行数据库的恢复：再看一下问题，尝试打开数据库，则会报错：SQL> CONN /@TEST 阅读全文

posted @ 2011-03-15 19:54 datalife 阅读(327) 评论(0) 推荐(0)

ORA-01152: file 1 was not restored from a sufficiently old backup

摘要：RMAN> shutdown immediate database dismounted Oracle instance shut down RMAN> startup mount connected to target database (not started) Oracle instance started database mounted Total System Global Area 285212672 bytes Fixed Size 1218968 bytes Variable Size 83887720 bytes Database Buffers 1929379 阅读全文

posted @ 2011-03-15 19:53 datalife 阅读(2242) 评论(0) 推荐(0)

控制文件丢失-恢复引起的一系列错误的解决

摘要：[oracle@server ~]$ rman target/Recovery Manager: Release 10.2.0.1.0 - Production on Fri Jan 7 00:05:03 2011Copyright (c) 1982, 2005, Oracle. All rights reserved.connected to target database: orcl (not mounted)RMAN> set DBID=1266181584executing command: SET DBIDRMAN> restore controlfile from &# 阅读全文

posted @ 2011-03-15 19:52 datalife 阅读(744) 评论(0) 推荐(0)

1 2 下一页