![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle oerr
文章平均质量分 58
blockheading
Oracle rookie
展开
-
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
SYS@PROD1> alter database archivelog;alter database archivelog*ERROR at line 1:ORA-00265: instance recovery required, cannot set ARCHIVELOG modeElapsed: 00:00:00.22SYS@PROD1> alter database op原创 2016-10-22 14:04:47 · 400 阅读 · 0 评论 -
ORA-25319: Queue table repartitioning aborted
--ORA-25319: Queue table repartitioning aborted发生背景:监控日志时无限刷出ORA-25319: Queue table repartitioning abortederror 25319 happened during Queue table repartitioningErrors in file /u01/app/oracl原创 2016-12-30 20:26:34 · 2718 阅读 · 0 评论 -
ORA-19566: exceeded limit of 0 corrupt blocks for file /u01/app/oracle/oradata/PROD1/example01.dbf
--ORA-19566: exceeded limit of 0 corrupt blocks for file /u01/app/oracle/oradata/PROD1/example01.dbf问题原因:因为表空间中有坏块导致不能备份。RMAN> backup full database plus archivelog;Starting backup a原创 2016-12-30 21:24:31 · 1297 阅读 · 0 评论 -
NOTE: cannot fetch plan for SQL_ID: ******, CHILD_NUMBER: 0
--NOTE: cannot fetch plan for SQL_ID: ******, CHILD_NUMBER: 0SCOTT@PROD1> SELECT * FROM table(dbms_xplan.display_cursor(NULL, NULL, 'basic +rows'));PLAN_TABLE_OUTPUT---------------------原创 2017-02-22 19:40:59 · 1018 阅读 · 0 评论 -
ORA-03113: end-of-file on communication channel
--故障发生SYS@PROD1> startup forceORACLE instance started.Total System Global Area 732352512 bytesFixed Size 1347456 bytesVariable Size 356515968 bytesDatabase Buffers原创 2017-03-08 19:52:16 · 294 阅读 · 0 评论 -
EXP-00091 Exporting questionable statistics.
--EXP-00091 Exporting questionable statistics.[oracle@ocm1 ~]$ exp userid=scott/tiger tables=t file=/home/oracle/t1.dmp buffer=1048576 log=/home/oracle/t1.logExport: Release 11.2.0.3.0 - Production原创 2017-04-08 22:04:24 · 267 阅读 · 0 评论 -
ORA-12719: operation requires database is in RESTRICTED mode
ORA-12719: operation requires database is in RESTRICTED mode解决过程:SQL> drop database;drop database*ERROR at line 1:ORA-12719: operation requires database is in RESTRICTED modeSQL> ALTER SYSTE原创 2017-04-22 21:58:10 · 11733 阅读 · 0 评论 -
ORA-16820: fast-start failover observer is no longer observing this database
解决过程:ORA-16820: fast-start failover observer is no longer observing this databaseDGMGRL> stop observerDone.DGMGRL> show configurationConfiguration - testdg Protection Mode: MaxAvailability原创 2017-05-13 20:43:45 · 2082 阅读 · 0 评论 -
ORA-02437 使对已有数据不检查的主键约束生效
--ORA-02437 使对已有数据不检查的主键约束生效SYS@PROD1> desc t1 Name Null? Type ----------------------------------------------------- -------- ------------------------------------ ID NUMBER TEX原创 2017-05-13 20:56:46 · 1027 阅读 · 0 评论 -
ORA-09925: Unable to create audit trail file
--故障发现[oracle@ocm1 ~]$ rman target/Recovery Manager: Release 11.2.0.3.0 - Production on Sun Dec 11 21:32:02 2016Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.RMAN原创 2016-12-18 20:49:05 · 1547 阅读 · 0 评论 -
CRS-0184: Cannot communicate with the CRS daemon.
错误背景:查看grid状况发现报错。解决方法:原创 2017-01-01 21:54:01 · 438 阅读 · 0 评论 -
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
问题描述:在通过RMAN将数据库恢复到同类机异机的时候,restore spfile一直报RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or pieceRMAN> restore spfile from '/tmp/bak/db_14_1_928703445';Starting resto原创 2016-11-23 21:28:01 · 16006 阅读 · 0 评论 -
ORA-14452: attempt to create, alter or drop an index on temporary table already in use
发生重演:EODA@PROD1> drop table temp purge;drop table temp purge *ERROR at line 1:ORA-14452: attempt to create, alter or drop an index on temporary table already in useEODA@PROD1> select原创 2016-10-22 15:55:06 · 1453 阅读 · 0 评论 -
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
使用hr用户查看执行计划时报错SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled原因是该用户没有PLUSTRACE这个用户导致的。SYS@PROD1> grant plustrace to hr; --尝试授权提示不存在。grant plustrace to hr原创 2016-10-26 21:38:50 · 269 阅读 · 0 评论 -
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
EODA@PROD1> drop table t purge;drop table t purge *ERROR at line 1:ORA-00054: resource busy and acquire with NOWAIT specified or timeout expiredEODA@PROD1> select t2.username,t2.sid,t原创 2016-10-19 21:39:55 · 894 阅读 · 0 评论 -
ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
ORA-06554: package DBMS_STANDARD must be created before using PL/SQL参考:http://www.orafaq.com/forum/t/48150/2/解决方法:start /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/catalog.原创 2016-12-11 20:12:38 · 676 阅读 · 0 评论 -
ORA-12841: Cannot alter the session parallel DML state within a transaction
Cause: Transaction in progressAction: Commit or rollback transaction and then re-executeEODA@PROD1> alter session enable parallel dml;ERROR:ORA-12841: Cannot alter the session parallel DML原创 2016-12-02 15:47:47 · 2856 阅读 · 0 评论 -
ORA-00600 2662错误
使用隐含参数_ALLOW_RESETLOGS_CORRUPTION后resetlogs打开数据库后,我们说很多时候你会遇到ORA-00600 2662号错误,这个错误的含义是:A data block SCN is ahead of the current SCN. The ORA-600 [2662] occurs when an SCN is compared to the depen转载 2016-12-14 22:34:11 · 790 阅读 · 0 评论 -
Oracle12c(PDB中) ORA-01017: invalid username/password; logon denied
问题背景描述:SQL> alter session set container=pdbwyzc; --切换pdbSQL> define username=eodaSQL> define usernamepwd=fooSQL> create user &&username identified by &&usernamepwd;SQL> grant dba to &&username;原创 2016-12-03 14:33:08 · 4353 阅读 · 0 评论 -
ORA-00845: MEMORY_TARGET not supported on this system
问题描述:启动数据库时遇到845错误。SQL> startupORA-01081: cannot start already-running ORACLE - shut it down first解决方法:[oracle@ocm2 dbs]$ df -hFilesystem Size Used Avail Use% Mounted on/dev/map原创 2016-11-23 20:51:21 · 378 阅读 · 0 评论 -
ORA-16661: the standby database needs to be reinstated
--ORA-16661: the standby database needs to be reinstated解决过程:DGMGRL> reinstate database prod3DGMGRL> show configurationConfiguration - testdg Protection Mode: MaxAvailability Databases:原创 2017-04-23 16:43:25 · 1350 阅读 · 0 评论