Problém: RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status RMAN-06210: List of Mismatched objects RMAN-06211: ==========================…
Problém: SQL> startup Instance ORACLE spustena. Total System Global Area 8551575552 bytes Fixed Size 2215064 bytes Variable Size 4966056808 bytes Database Buffers 3556769792 bytes Redo Buffers 26533888 bytes Databaze pripojena…
Problem SQL> drop package „DBA“.“pack_dev“; drop package „DBA“.“pack_dev“ * ERROR na řádku 1: ORA-04043: objekt SYS_PLSQL_FE118D94_31_1 neexistuje Analyse SQL> col owner format a15 col object_name format a15 col object_type format…
Problem RMAN> alter database mount; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of sql statement command at 08/14/2018 12:28:18 ORA-00220: control file not mounted…
Problem SQL> startup mount ORACLE instance started. Total System Global Area 1.0818E+11 bytes Fixed Size 6871864 bytes Variable Size 5.3687E+10 bytes Database Buffers 5.4224E+10 bytes Redo Buffers 261562368 bytes ORA-00214:…
Problem SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file ‚+DATA/ORCL/PARAMETERFILE/spfileORCL.ora‘ ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL/PARAMETERFILE/spfileORCL.ora ORA-15056: additional error message ORA-17503: ksfdopn:2 Failed to…
Problem [oracle@dbserver ~]$ tail -f /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/alert_ORCL1.log ORA-00312: online log 2 thread 1: ‚+REDO/ORCL/redo02a.log‘ ORA-00312: online log 2 thread 1: ‚+FRA/ORCL/redo02b.log‘ USER (ospid: 74269): terminating the instance due to error 16038…
Problém 2018-04-01T12:20:41.773391+02:00 Errors in file /u01/app/oracle/diag/rdbms/zmserv/zmserv2/trace/zmserv2_j001_18259.trc: ORA-12012: error on auto execute of job „SYS“.“ORA$AT_OS_OPT_SY_85360″ ORA-20001: Statistics Advisor: Invalid task name for the current user ORA-06512: at „SYS.DBMS_STATS“, line 47207 ORA-06512:…
