Ksar

Exemplo para usar o ksar e gerar um relatório PDF:

  1. export LC_ALL=C && export S_TIME_FORMAT=ISO
    for a in `ls sa0*`; do sar -A -f $a >> /tmp/sar.txt; done
  2. java -jar ksar.jar
  3. load data from file
  4. generate PDF

exachk – bundle patch failed

Exachk reporta o erro “Verify bundle patch version installed patches bundle patch version registered in database” para uma base instalada via dbca.

Solução encontrada no blog oficial da Oracle: blog.oracle.com: https://blogs.oracle.com/UPGRADE/entry/dbca_12c_and_datapatch_pl

O Oracle MOS note 2084676.1 também documenta a solução:

1) DBCA doesnot execute datapatch in Oracle 12.1.0.X. The solution is to apply the SQL changes manually after creating a new Database .

After creating a new database make sure to run:

cd $ORACLE_HOME/OPatch
./datapatch -verbose

and also check DBA_REGISTRY_SQLPATCH view:

select PATCH_ID, PATCH_UID, VERSION, STATUS, DESCRIPTION
from DBA_REGISTRY_SQLPATCH
order by BUNDLE_SERIES;