DBA Hub

📋Steps in this guide1/1

Troubleshoot oracle database DBACLASS

Troubleshoot oracle database , solution on ORA- and RMAN- errors during activites in oracle database.

oracle troubleshootingintermediate
by OracleDba
12 views
1

Overview

- ORA-02095: specified initialization parameter cannot be modified - RMAN-06429: TARGET database is not compatible version - RMAN-20002: target database already registered in recovery catalog - ORA-00245: Control File Backup Failed; Target Is Likely On A Local File System - Prereq check failed – The database must be in upgrade mode - failed jdk version is incompatible.please use a jdk version with opatchauto - ORA-00027: cannot kill current session - ORA-15032: not all alterations performed - RMAN-20035: invalid high RECID in rman catalog - ORA-19588: Archived Log RECID Is No Longer Valid - ORA-29516: Aurora assertion failure: Assertion failure - ORA-08104: this index object is being online built or rebuilt - ORA-01452: Cannot CREATE UNIQUE INDEX; Duplicate Keys Found - ORA-27054: NFS file system where the file is created while expdp - ORA-00600 kcratr_nab_less_than_odr while starting the database - ORA-27102: out of memory while starting DB instance - RMAN-07539: insufficient privileges to create or upgrade the catalog schema - ORA-00059: maximum number of DB_FILES exceeded - ERROR: No checkpoint table specified for ADD REPLICAT - INS -07003 unexpected error occured while accessing the bean store - ORA-31623: a job is not attached to this session via the specified handle - OGG-01028 Formatting error on: table name - ERROR OGG-01841 CACHESIZE TOO SMALL: - ORA-600:[kpdbModAdminPasswdInRoot: Not CDB] - ORA-38706: Cannot turn on FLASHBACK DATABASE logging. - ORA-38774: cannot disable media recovery – flashback database is enabled - ORA-38760: This Database Instance Failed To Turn On Flashback Database - ORA-01126: database must be mounted in this instance and not open in any instance - PL/SQL package DBMS_RCVMAN version 12.01.00.01 in RCVCAT database is not current - ORA-20013: DBMS_QOPATCH ran mostly in non install area - ORA-29548: Java system class reported - PRVF-5424 : Clock time offset check failed - RMAN-20001: target database not found in recovery catalog - ORA-02304: invalid object identifier literal while doing impdp - ORA-31637 ORA-06512 ORA-39062 error while doing impdp - ORA-02030: can only select from fixed tables/views - ORA-04063: view “SYS.KU$_RADM_FPTM_VIEW” has errors - ORA-06512: at “SYSMAN.EM_SELF_UPDATE” while installation 12c cloud control - Agent Clone Failed Exit Code:1 - ORA-04063: package body “SYS.DBMS_CUBE_EXP” while expdp - ORA-00020: maximum number of processes exceeded - ORA-02394: Exceeded Session Limit On IO Usage - ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit - ORA-39087: directory name is invalid - ORA-01000: maximum open cursors exceeded - ORA-30013: undo tablespace ‘UNDOTBS1’ is currently in use - ORA-25153: Temporary Tablespace is Empty while doing export - ORA-25152: TEMPFILE cannot be dropped at this time - ORA-04045 errors and ORA-01031 while running utlrp.sql - ORA-39071: Value for EXCLUDE is badly formed during expdp - ORA-00119: invalid specification for system parameter LOCAL_LISTENER - MRP0: Background Media Recovery terminated with error 1274 - ORA-38301: Can Not Perform DDL/DML Over Objects In Recycle Bin - ORA-01157: Cannot Identify ORA-01110: Data File With Dba_temp_file - ORA-15073: Diskgroup Mounted By Another Instance - ORA-01123: Cannot Start Online Backup; Media Recovery Not Enabled - ORA-01940: Cannot Drop A User That Is Currently Connected - ORA-56935: Existing Datapump Jobs Are Using A Different Version - ORA-01450: Maximum Key Length (6398) Exceeded - ORA-24247: Network Access Denied By Access Control List (ACL) - ORA-00054: resource busy and acquire with NOWAIT specified - ORA-01102: cannot mount database in EXCLUSIVE mode - ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT - ORA-02266: unique/primary keys in table referenced while truncating table - ORA-39142: Incompatible Version Number 4.1 In Dump File - ORA-08189: cannot flashback the table because row movement is not enabled - ORA-15027: active use of diskgroup  precludes its dismount - ORA-15235: diskgroup mount mode conflicts with existing mount - ORA-14400: inserted partition key does not map to any partition - ORA-14074: partition bound must collate higher than that of the last partition - ORA-14402: updating partition key column would cause a partition change - ORA-20005: object statistics are locked (stattype = ALL) - ORA-29280: invalid directory path ORA-06512:”SYS.UTL_FILE” - ORA-01665: control file is not a standby control file - ORA-01274: Cannot Add Data File That Was Originally Created As - ORA-01145: Offline Immediate Disallowed Unless Media Recovery Enabled - Prerequisite check “CheckActiveFilesAndExecutables” failed - ORA-38880: Cannot advance compatibility from 12.1.0.2.0 to 12.2.0.1.0 due to guaranteed restore points - ORA-39358: Export Dump File Version Not Compatible - ORA-31617: unable to open dump file for write - ORA-39174: Encryption password must be supplied - ORA-38856: cannot mark instance UNNAMED_INSTANCE as enabled - ORA-01203: Wrong Incarnation Of This File – Wrong Creation SCN - ORA-65500: Could Not Modify DB_UNIQUE_NAME While Duplicating Db - ORA-65049: creation of local user or role is not allowed in CDB$ROOT - ORA-65096: invalid common user or role name - ORA-32001: write to SPFILE requested but no SPFILE is in use - ORA-1495 :specified chained row table not found - ORA-13541: System Moving Window Baseline Size Greater Than Retention - ORA-02396: exceeded maximum idle time, please connect again - ORA-12838: Cannot Read/Modify An Object After Modifying It In Parallel - ORA-12841: Cannot alter the session parallel DML state within a transaction - ORA-12719: Operation Requires Database Is In RESTRICTED Mode - ORA-12839: Cannot Modify An Object In Parallel After Modifying It - ORA-19381: Cannot Create Staging Table In SYS Schema - ORA-12988: Cannot Drop Column From Table Owned By SYS - ORA-12984: Cannot Drop Partitioning Column - ORA-12991: column is referenced in a multi-column constraint - ORA-12985: Tablespace ‘USERS’ Is Read Only, Cannot Drop Column - ORA-19809: limit exceeded for recovery files - ORA-00997: illegal use of LONG datatype - ORA-01624: Log 1 Needed For Crash Recovery Of Instance - ORA-01623: Log 3 Is Current Log For Instance Cannot Drop - RMAN-08137: WARNING: Archived Log Not Deleted, Needed For Standby - ORA-39095: Dump File Space Has Been Exhausted: Unable To Allocate - ORA-01466: unable to read data – table definition has changed during flashback - ORA-14404: partitioned table contains partitions in a different tablespace - ORA-30032: the suspended (resumable) statement has timed out - ORA-30033: Undo tablespace cannot be specified as default user tablespace - ORA-12910: Cannot Specify Temporary Tablespace As Default Tablespace - ORA-30041: Cannot grant quota on the tablespace - ORA-28040: No Matching Authentication Protocol - ORA-00350: log 4 of instance needs to be archived - ORA-02020: Too Many Database Links In Use - ORA-20002: Version of statistics table SCOTT.STATS is too old - ORA-28014: cannot drop administrative users - ORA-00392: log 7 of thread 1 is being cleared, operation not allowed - ORA-30034: Undo Tablespace Cannot Be Specified As Temporary Tablespace - ORA-32771: Cannot Add File To Bigfile Tablespace - ORA-32774: More Than One File Was Specified For Bigfile Tablespace - ORA-32773: Operation Not Supported For Smallfile Tablespace - ORA-01536: Space Quota Exceeded For Tablespace - ORA-15260: Permission Denied On ASM Disk Group

Comments (0)

Please to add comments

No comments yet. Be the first to comment!