Problém RMAN-06214: Archivelog      /mnt/backup/orcl/archlog1_351_893193559.arc RMAN-06214: Archivelog      /mnt/backup/orcl/archlog1_352_893193559.arc RMAN-06214: Archivelog      /mnt/backup/orcl/archlog1_353_893193559.arc ORA-00245: control file backup failed; target is likely on a local file system RMAN-08132: WARNING: cannot update recovery area reclaimable…

Kontrola nastavení počtu CPU v databázi SYS@orcp2> show parameter cpu NAME                                 TYPE        VALUE ———————————— ———– —————————— cpu_count                            integer     4 parallel_threads_per_cpu             integer     2 resource_manager_cpu_allocation      integer     4 Spuštění datové pumpy paralelně [oracle@orcp2…

Problém [oracle@dbserver 20831107]$ opatch apply Oracle Interim Patch Installer version 12.1.0.1.0 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc…

Co zabírá nejvíce místa v SYSAUX tablespace? SQL> set linesize 120 SQL> set pagesize 100 SQL> SQL> COLUMN “Item” FORMAT A25 SQL> COLUMN “Space Used (GB)” FORMAT 999.99 SQL> COLUMN…

dbserver:~ # ps hax -o user | sort | uniq -c 2 haldaemon 1 messagebus 1 nagios 1 ntp 34 oraprod 151 oratest 31 orastage 32 oradev 2 postfix 118…

Problém Export log datové pumpy (expdp) obsahuje následující chyby expdp system/heslo@orcl full=Y directory=TEST_DIR dumpfile=orcl.dmp logfile=orcl.log Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA >>> DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWMD: OLAP not…

IMP-00017: following statement failed with ORACLE error 1918: “ALTER USER “ADMIN_WOM” DEFAULT ROLE ALL” IMP-00003: ORACLE error 1918 encountered ORA-01918: user ‘ADMIN_WOM’ does not exist IMP-00003: ORACLE error 28031 encountered…

IMP-00019: row rejected due to ORACLE error 12899 IMP-00003: ORACLE error 12899 encountered ORA-12899: value too large for column “ORACLE_DBA”.”BASE01″.”MIS_NAROZ” (actual: 26, maximum: 25) Oracle XE edition SQL> SELECT value$…