![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle 故障解决案例
文章平均质量分 60
leishifei
这个作者很懒,什么都没留下…
展开
-
Oracle数据库诊断案例-redo log日志组处于高激活状态
From:http://www.eygle.com/archives/2005/06/oracleeaoieiear.html贴过来这里我们主要学习一种解决问题的思路 平台:SunOS 5.8 Generic_108528-23 sun4u sparc SUNW,Ul原创 2011-08-30 06:41:52 · 429 阅读 · 0 评论 -
error while loading shared libraries: libclntsh.so.9.0 错误小记
<br />error while loading shared libraries: libclntsh.so.9.0 错误小记<br /><br /><br />一直玩Oracle 10g,今天在单位虚拟机上装了个9i玩玩,当时没有问题,但是用硬盘拷回家后,在自己的本本上运行,却出现了问题,错误提示信息如下:<br /><br />[oracle@ora9iserv bin]$ sqlplus /nolog<br />sqlplus: error while loading shared librari原创 2011-04-18 21:12:00 · 1831 阅读 · 0 评论 -
Linux中sqlplus退格显示^H的解决方案
<br />Linux中sqlplus退格显示^H的解决方案<br /><br /><br />设定环境变量:<br /><br />1)在bash下,把 stty erase ^H 添加到.bash_profile中<br />2)在csh下,把 stty erase ^H 添加到.cshrc中<br /><br />下面是我的实现方法(在bash下)<br /><br />[root@ORA9ISERV ~]# su - oracle 进入oracle主目录,里面有 .bash_profile<br /原创 2011-04-18 15:26:00 · 272 阅读 · 0 评论 -
compat-oracle-rhel4-1.0-5.i386.rpm compat-libcwait-2.1-1.i386.rpm下载地址
<br /><br />compat-oracle-rhel4-1.0-5.i386.rpm compat-libcwait-2.1-1.i386.rpm下载地址 <br /><br /><br />compat-oracle-rhel4-1.0-5.i386.rpm<br />compat-libcwait-2.1-1.i386.rpm<br /><br />Linux下安装ORACLE9i时需要这两个相应的rpm包<br /><br />下载地址<br />http://oss.oracle.com/原创 2011-04-18 15:01:00 · 1156 阅读 · 0 评论 -
ORA-01102 cannot mount database in EXCLUSIVE mode解决方法
<br />ORA-01102 cannot mount database in EXCLUSIVE mode解决方法<br /><br /><br />某系统突然掉电,系统启动后发现Oracle无法启动。<br />启动时报如下错误:<br />ORA-01102 cannot mount database in EXCLUSIVE mode<br /> <br />出现1102错误可能有以下几种可能:<br /><br />一、在HA系统中,已经有其他节点启动了实例,将双机共享的资源(如磁盘阵列上的裸设原创 2011-04-18 14:57:00 · 507 阅读 · 0 评论 -
ORA-01078: 和 LRM-00109:错误 解决方法
<br />ORA-01078: 和 LRM-00109:错误 解决方法<br /><br />在oracle9i和oracle10g中,数据库默认将使用spfile启动数据库,如果spfile不存在,startup又将如何呢?<br />将会发生下列错误:<br /><br />SQL> connect sys/orcl as sysdba<br />已连接。<br /><br />SQL> startup<br />ORA-01078: failure in processing system para原创 2011-04-18 14:53:00 · 752 阅读 · 0 评论 -
Linux下oracle常见安装错误
<br />Linux下oracle常见安装错误<br /><br /><br />#./runInstaller之后出现如下的错误信息:<br />REDHAT AS5 x86上安装Oracle1020<br />Exception in thread "main" java.lang.UnsatisfiedLinkError:<br />/tmp/OraInstall2007-12-03_09-02-02AM/jre/1.4.2/lib/i386/libawt.so:libXp.so.6: cannot原创 2011-04-18 14:44:00 · 444 阅读 · 0 评论 -
ORA-19907: recovery time or SCN does not belong to recovered incarnation
ORA-19907:recovery time or SCN does not belong to recovered incarnationCause:A point-in-time recovery to an SCN or timestamp prior to the last resetlogs was requested.<br />Action:Either change the specified recovery time/scn, or change the recovery destin原创 2011-04-14 15:18:00 · 1121 阅读 · 0 评论 -
Windows上安装Oracle11gR2时,出错 File not found D:/app/oracle/product/11.2.0/dbhome_1/bin/orandce11.dll.dbl orancds11r.dll.dbl
<br />在Windows上安装Oracle11gR2时,出错 File not found D:/app/oracle/product/11.2.0/dbhome_1/bin/orandce11.dll.dbl orancds11r.dll.dbl<br /> <br /><br /><br />如图所示:<br /><br /> <br /> <br /><br />解决办法(任选其一)<br />1. 忽略这两个错误<br />2. 重命名注册表项 “HKEY_LOCAL_MACHINE/Softw原创 2011-04-15 17:10:00 · 2247 阅读 · 1 评论 -
ORA-19909: datafile 1 belongs to an orphan incarnation 一例
ORA-19909: datafile 1 belongs to an orphan incarnationSQL> startup mount;ORACLE instance started.Total System Global Area 6847938560 bytesFixed Size 2219808 bytesVariable Size 3539992800 bytesDatabase Buffers 3288334336原创 2011-04-13 16:23:00 · 2439 阅读 · 0 评论 -
Windows XP 64 bit机器上使用PL/SQL链接Oracle的问题(Could not initialize ".../oci.dll")
<br />Windows XP 64 bit机器上使用PL/SQL链接Oracle的问题(Could not initialize ".../oci.dll")<br /><br /><br />今天为了玩玩PL/SQL Developer,就在自己的64位台式机上安装PL/SQL Developer,安装过程很顺利,但是利用快捷方式启动后输入相应用户名跟密码后却得到了如下图所示的错误。<br /><br /><br /><br />提示:需要32位的客户端,所以就到官网上下载了一个32位的Oracle原创 2011-04-15 12:41:00 · 2898 阅读 · 0 评论 -
Oracle AWR报告的所取的两个SNAP之间不能重启DB,否则ORA-20019
<br /> <br />select output from table(dbms_workload_repository.awr_report_html(:dbid, :inst_num,:bid, :eid,:rpt_options )) <br />* ERROR at line 1:<br /> ORA-20019: Database/Instance 1276219506/1 was re-started during specified snapshot interval 22-70 <br原创 2011-04-17 11:44:00 · 942 阅读 · 0 评论 -
ORA-09817: Write to audit file failed.解决方法
ORA-09817: Write to audit file failed.解决方法 遇到的问题:连接oracle报错:ORA-09817: Write to audit file failed.# su - oracle$ sqlplus /nolog SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jun 28 22原创 2011-06-29 12:12:00 · 1475 阅读 · 0 评论 -
"Pmon Failed To Acquire Latch" Messages in Alert Log -Database Hung [ID 468740.1]
"Pmon Failed To Acquire Latch" Messages in Alert Log -Database Hung [ID 468740.1] Modified 15-SEP-2010 Type PROBLEM Status MODERATED In this Document Symptom原创 2011-06-22 14:55:00 · 756 阅读 · 0 评论 -
shutdown immediate 遇到 PMON failed to acquire latch, see PMON dump
今天做实验的时候shutdown immediate超过了我的忍耐极限,查看log,显示如下:Wed Jun 22 01:36:35 2011PMON failed to acquire latch, see PMON dumpPMON failed to acquire latch, see PMON dumpPMON failed to acquire latch, see P原创 2011-06-22 14:57:00 · 1097 阅读 · 0 评论 -
EXP-00091: Exporting questionable statistics
<br />在使用EXP工具进行导出备份或迁移数据的时候有时会报很多的“EXP-00091: Exporting questionable statistics”错误,具体的现象和处理方法如下:<br /><br />1.问题现象<br />[oracle@RH207 exp]$ exp test/test file=test.dmf log=test.log<br />……忽略……<br />EXP-00091: Exporting questionable statistics.<br />EXP-00原创 2011-04-26 19:49:00 · 383 阅读 · 0 评论 -
ORA-25153: Temporary Tablespace is Empty
测试现象:ORA-25153: Temporary Tablespace is Empty 检查原因:检查一下DBA_TABLESPACES, TEMP的status还是online,不过是假象SQL> select tablespace_name,status from dba_tablespaces; TABLESPACE_NAME原创 2011-06-17 16:37:00 · 330 阅读 · 0 评论 -
ORA-01555 "Snapshot too old" - Detailed Explanation
<br />ORA-01555 "Snapshot too old" - Detailed Explanation<br />===================================================<br /><br />Overview<br />~~~~~~~~<br /><br />This article will discuss the circumstances under which a query can return the Oracle <br />erro原创 2011-04-25 21:16:00 · 329 阅读 · 0 评论 -
Oracle 10g 安装过程中需要执行的两个脚本
<br /># /u01/app/oracle/oraInventory/orainstRoot.sh<br />Changing permissions of /u01/app/oracle/oraInventory to 775.<br />Changing groupname of /u01/app/oracle/oraInventory to oinstall.<br />The execution of the script is complete<br /># /u01/app/oracle/p原创 2011-04-21 11:58:00 · 289 阅读 · 0 评论 -
Resolving the ORA-12705 error
原文请见:http://www.dba-oracle.com/t_ora_12705_error.htmResolving the ORA-12705 error<br />Oracle Tips by Burleson Consulting<br /><br />Question: My Oracle database allows me to connect with TOAD, Oracle Enterprise Manager and SQL Developer, but when I try t转载 2011-04-22 12:12:00 · 631 阅读 · 0 评论 -
ORA-32018: parameter cannot be modified in memory on another instance
ORA-32018:parameter cannot be modified in memory on another instanceCause:Parameter adjustment can take a very long timeAction:Modify the parameter individually on each i原创 2011-06-09 09:31:00 · 1568 阅读 · 0 评论 -
Oracle 备份数据库控制文件用以丢失后的恢复浅析
<br />SQL> alter database backup controlfile to trace as '/u02/backup/c.trc';<br />$ vi c.trc<br />"c.trc" 164 lines, 6757 characters <br />-- The following are current System-scope REDO Log Archival related<br />-- parameters and can be included in the da原创 2011-04-13 22:32:00 · 491 阅读 · 0 评论 -
ORA-19906: recovery target incarnation changed during recovery
ORA-19906:recovery target incarnation changed during recoveryCause:While a media recovery was active, a new incarnation was detected by the server due to inspection or cataloging of archived logs or backup files.Action:If you want recovery to use the new i原创 2011-04-13 21:31:00 · 629 阅读 · 0 评论 -
00054:resource busy and acquire with nowait specified
<br />当某个数据库用户在数据库中插入、更新、删除一个表的数据,或者增加一个表的主键时或者表的索引时,<br />常常会出现ora-00054:resource busy and acquire with nowait specified这样的错误。<br />主要是因为有事务正在执行(或者事务已经被锁),所有导致执行不成功。<br /> <br />1、用dba权限的用户查看数据库都有哪些锁<br />select t2.username,t2.sid,t2.serial#,t2.logon_time原创 2011-04-05 22:12:00 · 214 阅读 · 0 评论 -
DBVERIFY - Database file Verification Utility (7.3.2 - 11.2) [ID 35512.1]
DBVERIFY - Database file Verification Utility (7.3.2 - 11.2) [ID 35512.1] Modified 20-NOV-2010 Type REFERENCE Status PUBLISHED Introduction~~~~~~~~~~~~ This article describes the basic details of the DBVERIFY (or DBV) utility which can be原创 2011-05-19 21:56:00 · 548 阅读 · 0 评论 -
Time Zone IDs for 7 Time Zones Changed in Time Zone Files Version 3 and Higher, Possible ORA-1882 After Upgrade [ID 414590.1]
Time Zone IDs for 7 Time Zones Changed in Time Zone Files Version 3 and Higher, Possible ORA-1882 After Upgrade [ID 414590.1] Modified 12-NOV-2008 Type BULLETIN Status PUBLISHED <br />In this Document<br /> Purpose<br /> Scope and Application<br原创 2011-05-15 12:19:00 · 1099 阅读 · 0 评论 -
Oracle RAC + Bug:4679769引起10201CRS安装执行root.sh失败
<br />安装10201版本CRS软件,执行root.sh经常会遇到如下错误提示:<br /> [root@db1 oracle]# /oracle/oraInventory/orainstRoot.sh Changing permissions of /oracle/oraInventory to 770. Changing groupname of /oracle/oraInventory to oinstall. The execution of the script is comple原创 2011-05-12 11:54:00 · 895 阅读 · 2 评论 -
PROT-1: root.sh Failed to Initialize ocrconfig [ID 983792.1]
PROT-1: root.sh Failed to Initialize ocrconfig [ID 983792.1] Modified 03-MAR-2010 Type PROBLEM Status MODERATED <br />In this Document<br /> Symptoms<br /> Cause<br /> Solution<br /> References<br /><br /> <br />This document is being delivered原创 2011-05-12 10:38:00 · 785 阅读 · 0 评论 -
RAC root.sh Oracle CRS stack is already configured and will be running under init(1M) 的解决方法
RAC 在安装时意外中断, 重新安装clusterware 软件, 安装过程中没有问题,在最后执行root.sh 脚本的时候出现异常, 脚本一闪而过,没有执行成功。[root@nodea bin]# /u01/app/oracle/product/10.2.0/crs/root.shWARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by rootWARNING: directory '/u01/app/oracle/produc原创 2011-05-12 09:57:00 · 470 阅读 · 0 评论 -
Redhat 5.4 RAC multipath 配置raw,运行root.sh 时报错Failed to upgrade Oracle Cluster Registry configuration 解决方法
之前打算装Oracle 11gR2的RAC的。 后来因为资源不够,就改装oracle 10g了。 raw 是用openfiler 配置 加 Multipath多路径配置的。 raw的配置参考我的Blog: Linux 5.4 LVM RAW 设备 配置的深入研究 http://blog.csdn.net/tianlesoftware/archive/2010/11/26/6036263.aspx这种情况下配置有些注意事项。 否转载 2011-05-12 09:44:00 · 901 阅读 · 0 评论 -
Oracle RAC 安装 运行 root.sh时报Failed to upgrade Oracle Cluster Registry configuration问题的解决
<br />CentOS 5.4 x86 Linux安装oracle rac 10.2.0.1的过程中,运行root.sh的时候报如下错误:<br />rac1@root[/oracle/crs/10.1/bin]> cd ..<br />rac1@root[/oracle/crs/10.1]> ./root.sh<br />WARNING: directory '/oracle/crs' is not owned by root<br />WARNING: directory '/oracle' is n转载 2011-05-12 09:18:00 · 784 阅读 · 0 评论 -
Executing root.sh errors with "Failed To Upgrade Oracle Cluster Registry Configuration" [ID 466673.1]
Executing root.sh errors with "Failed To Upgrade Oracle Cluster Registry Configuration" [ID 466673.1] Modified 07-JUN-2010 Type PROBLEM Status PUBLISHED <br />In this Document<br /> Symptoms<br /> Changes<br /> Cause<br /> Solution<br /> Refer原创 2011-05-12 09:16:00 · 301 阅读 · 0 评论 -
解决 ERROR - ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
<br /> 1. Open the ""<OracleHome>/network/admin/listener.ora" file in the host,and you will see:<br /> SID_LIST_LISTENER =<br /> (SID_LIST =<br /> (SID_DESC =<br /> (SID_NAME = PLSExtProc)<br /> (ORACLE_HOME = D:/oracle/product/10.2.0/原创 2011-04-07 14:58:00 · 549 阅读 · 0 评论 -
Flash Recovery Area空间不足导致shutdown immediate长时间挂起
<br /><br />以下是操作记录:<br />$ sqlplus /nolog<br /><br />SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 8 14:06:45 2011<br /><br />Copyright (c) 1982, 2005, Oracle. All rights reserved.<br /><br />SQL> conn /as sysdba<br />Connected.<br />SQL> shutdown原创 2011-04-08 13:55:00 · 613 阅读 · 0 评论 -
ORA-19909 datafile 1 belongs to an orphan incarnation
<br />ORA-19909 datafile 1 belongs to an orphan incarnation<br />Contributed by Martin<br />Friday, 22 May 2009<br />Last Updated Friday, 22 May 2009<br /><br />Managed recovery aborts on a standby database. Messages in the alert log of a standby database原创 2011-04-13 16:19:00 · 1453 阅读 · 0 评论 -
ORA-27054 ERRORS WHEN RUNNING RMAN WITH NFS
Subject: ORA-27054 ERRORS WHEN RUNNING RMAN WITH NFSDoc ID: Note:387700.1Type: PROBLEMLast Revision Date: 12-DEC-2007Status: MODERATED<br />Subject: ORA-27054 ERRORS WHEN RUNNING RMAN WITH NFS <br />Doc ID: Note:387700.1 Type: PROBLEM <br />Last Revisio原创 2011-04-10 22:46:00 · 441 阅读 · 0 评论 -
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
<br />问题:<br />今天在AIX 5L 的一个双节点RAC环境测试一个数据库的备份脚本,一开始遇到了一些错误,但没能记录下来,最后就记录下来了这一个ORA-27054错误。<br />以下是操作过程:<br />RMAN-00571: ===========================================================<br /><br />RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ======原创 2011-04-10 22:08:00 · 1601 阅读 · 0 评论 -
ORA-21561: OID generation failed
<br />Oracle 10.2.0.4 dbca 建立数据库时弹出对话框<br />提示:ORA-21561: OID generation failed<br /> <br />解决方法:<br /><br /> <br />Connection Via 10.2.0.3 SQL*Net Fails With Error ORA-21561: OID Generation Failed [ID 559981.1]Cause<br />Incorrect /etc/hosts mapping for t原创 2011-04-07 10:16:00 · 2742 阅读 · 0 评论 -
Asm Diskgroup success mounted And dismounted messages in database alert.log
<br />Thu Apr 7 03:41:01 2011<br />SUCCESS: diskgroup RECOVERY_AREA was mounted<br />SUCCESS: diskgroup RECOVERY_AREA was dismounted<br /><br />Applies to:<br />Oracle Server - Enterprise Edition - Version: 10.2 to 10.2<br />This problem can occur on any原创 2011-04-08 08:56:00 · 404 阅读 · 0 评论 -
Oracle Switchover RAC数据库提示ORA-600(kcctrdf_2)错误解决方案
<br />Oracle 10g RAC环境数据库执行ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL DATABASE操作,<br />试图将当前的物理STANDBY数据库切换为PRIMARY数据库时,出现下面的错误:<br />SQL> CONN SYS/TEST@TESTRAC_STANDBY AS SYSDBA<br />已连接。<br />SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;<br />SWITC原创 2011-04-07 21:47:00 · 460 阅读 · 0 评论