Download the zip file from the link given in MOS Doc: 1426973.1
Download the EMDIAG REPVFY Kit Release 2020.02.05 from here
[oracle@oel6oem ~]$ cd Downloads/
[oracle@oel6oem Downloads]$ ls -ltr
total 1540
-rw-r--r--. 1 oracle oracle 1574627 Apr 12 14:20 repvfy12.zip
Make directory “emdiag” inside repository database ORACLE_HOME
[oracle@oel6oem Downloads]$ . oraenv
ORACLE_SID = [emrep] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@oel6oem Downloads]$ cd $ORACLE_HOME
[oracle@oel6oem db_1]$ mkdir emdiag
Unzip the downloaded file in this directory
[oracle@oel6oem Downloads]$ pwd
/home/oracle/Downloads
[oracle@oel6oem Downloads]$ ls -ltr
total 1540
-rw-r--r--. 1 oracle oracle 1574627 Apr 12 14:20 repvfy12.zip
[oracle@oel6oem Downloads]$ unzip repvfy12.zip -d $ORACLE_HOME/emdiag
Archive: repvfy12.zip
creating: /u01/app/oracle/product/12.1.0.2/db_1/emdiag/12cR1/
inflating: /u01/app/oracle/product/12.1.0.2/db_1/emdiag/12cR1/_analyzetable.sql
inflating:
...............................
................................
/u01/app/oracle/product/12.1.0.2/db_1/emdiag/lib/DeadlockParser/lib/log4j-1.2.17.jar
creating: /u01/app/oracle/product/12.1.0.2/db_1/emdiag/log/
Modify the permission of “repvfy”
[oracle@oel6oem Downloads]$ cd /u01/app/oracle/product/12.1.0.2/db_1/emdiag/
[oracle@oel6oem emdiag]$ ls
12cR1 13cR1 bin cfg lib log
[oracle@oel6oem emdiag]$ cd bin
[oracle@oel6oem bin]$ chmod +x repvfy
Install repvfy
[oracle@oel6oem bin]$ ./repvfy install
Please enter the SYSMAN password:
SQL*Plus: Release 12.1.0.2.0 Production on Sun Apr 12 14:28:16 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> Connected.
Session altered.
Session altered.
VIEW EM$DIAG_RESULTS_EXT: already gone
VIEW EM$DIAG_LATEST_RESULTS_EXT: already gone
VIEW EM$DIAG_LATEST_SCORE_EXT: already gone
VIEW EM$DIAG_INFO_EXT: already gone
VIEW EM$DIAG_INFO_FULL_EXT: already gone
VIEW EM$DIAG_OBJ_EXT: already gone
VIEW EM$DIAG_OBJ_LOG_EXT: already gone
VIEW EM$DIAG_REP_EXT: already gone
VIEW EM$DIAG_REP_LOG_EXT: already gone
VIEW EM$DIAG_REP_RUN_EXT: already gone
VIEW EM$DIAG_LOGS_EXT: already gone
VIEW EM$DIAG_OBJ_ERROR_EXT: already gone
VIEW EM$DIAG_REP_ERROR_EXT: already gone
VIEW EM$DIAG_ERRORS_EXT: already gone
PACKAGE GC_DIAG_EXT: already gone
PACKAGE GC_DIAG2_EXT: already gone
PACKAGE GC_DIAG3_EXT: already gone
TABLE EM_DIAG_CONFIG_EXT: already gone
TABLE EM_DIAG_OPTIONS_EXT: already gone
TABLE EM_DIAG_OBJ_LOG_EXT: already gone
TABLE EM_DIAG_REP_LOG_EXT: already gone
TABLE EM_DIAG_REP_RESULTS_EXT: already gone
TABLE EM_DIAG_DMP_EXT: already gone
TABLE EM_DIAG_OBJ_EXT: already gone
TABLE EM_DIAG_REP_EXT: already gone
TABLE EM_DIAG_MODULES_EXT: already gone
TABLE EM_DIAG_SCHEMA_OBJECTS_EXT: already gone
PL/SQL procedure successfully completed.
not spooling currently
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL*Plus: Release 12.1.0.2.0 Production on Sun Apr 12 14:28:17 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> Connected.
Session altered.
Session altered.
PL/SQL procedure successfully completed.
Table created.
Trigger created.
Trigger created.
No errors.
Table created.
Table created.
Table created.
Table altered.
Table created.
Table altered.
Table created.
Table altered.
Table created.
Index created.
Table created.
Index created.
Table created.
Table created.
Index created.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Package created.
No errors.
Package created.
No errors.
Package created.
No errors.
Package body created.
No errors.
Package body created.
No errors.
Package body created.
No errors.
PL/SQL procedure successfully completed.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Table truncated.
1 - ADP
PL/SQL procedure successfully completed.
Commit complete.
1 - AGENTS
PL/SQL procedure successfully completed.
Commit complete.
1 - ASLM
PL/SQL procedure successfully completed.
Commit complete.
1 - AVAILABILITY
PL/SQL procedure successfully completed.
Commit complete.
1 - BACKLOG
PL/SQL procedure successfully completed.
Commit complete.
1 - BLACKOUTS
PL/SQL procedure successfully completed.
Commit complete.
1 - CA
PL/SQL procedure successfully completed.
Commit complete.
1 - CAT
PL/SQL procedure successfully completed.
Commit complete.
1 - CORE
PL/SQL procedure successfully completed.
Commit complete.
1 - CREDENTIALS
PL/SQL procedure successfully completed.
Commit complete.
1 - ECM
PL/SQL procedure successfully completed.
Commit complete.
1 - EMDIAG
PL/SQL procedure successfully completed.
Commit complete.
1 - EVENTS
PL/SQL procedure successfully completed.
Commit complete.
1 - EXADATA
PL/SQL procedure successfully completed.
Commit complete.
1 - JOBS
PL/SQL procedure successfully completed.
Commit complete.
1 - JVMD
PL/SQL procedure successfully completed.
Commit complete.
1 - LOADERS
PL/SQL procedure successfully completed.
Commit complete.
1 - METRICS
PL/SQL procedure successfully completed.
Commit complete.
1 - NOTIFICATIONS
PL/SQL procedure successfully completed.
Commit complete.
1 - OMS
PL/SQL procedure successfully completed.
Commit complete.
1 - PATCHING
PL/SQL procedure successfully completed.
Commit complete.
1 - PLUGINS
PL/SQL procedure successfully completed.
Commit complete.
1 - PROVISIONING
PL/SQL procedure successfully completed.
Commit complete.
1 - RCA
PL/SQL procedure successfully completed.
Commit complete.
1 - REPORTS
PL/SQL procedure successfully completed.
Commit complete.
1 - REPOSITORY
PL/SQL procedure successfully completed.
Commit complete.
1 - ROLES
PL/SQL procedure successfully completed.
Commit complete.
1 - TARGETS
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Commit complete.
1 - TEMPLATES
PL/SQL procedure successfully completed.
Commit complete.
1 - TRACE
PL/SQL procedure successfully completed.
Commit complete.
1 - UPGRADE
PL/SQL procedure successfully completed.
Commit complete.
1 - USERS
PL/SQL procedure successfully completed.
Commit complete.
Table truncated.
2 - AGENT
PL/SQL procedure successfully completed.
Commit complete.
2 - AQ
PL/SQL procedure successfully completed.
2 - BLACKOUT
PL/SQL procedure successfully completed.
Commit complete.
2 - CA
PL/SQL procedure successfully completed.
Commit complete.
2 - EXADATA
PL/SQL procedure successfully completed.
Commit complete.
2 - HOME
PL/SQL procedure successfully completed.
Commit complete.
2 - JOB
PL/SQL procedure successfully completed.
Commit complete.
2 - METRIC
PL/SQL procedure successfully completed.
Commit complete.
2 - PLUGIN
PL/SQL procedure successfully completed.
Commit complete.
2 - REPORT
PL/SQL procedure successfully completed.
Commit complete.
2 - ROLE
PL/SQL procedure successfully completed.
Commit complete.
2 - TABLE
PL/SQL procedure successfully completed.
2 - TARGET
PL/SQL procedure successfully completed.
Commit complete.
2 - USER
PL/SQL procedure successfully completed.
Commit complete.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
not spooling currently
COMPONENT INFO
-------------------- --------------------
EMDIAG Version 20.02.05
EMDIAG Edition 2
Repository Version 12.1.0.5.0
Database Version 12.1.0.2.0
Test Version 20.04.12
Repository Type CENTRAL
Verify Tests 583
Object Tests 235
Deployment SMALL
9 rows selected.
not spooling currently
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@oel6oem bin]$
Check version
[oracle@oel6oem bin]$ ./repvfy version
Please enter the SYSMAN password:
Component Version
------------------------- -------------------------
repvfy 20.02.05
Database 12.1.0.2.0
Repository 12.1.0.5.0
EMDIAG Branch 12cR1
EMDIAG PL/SQL 20.02.05
EMDIAG Tests 20.04.12
Installed for 12cR1
Linux EL6.6 3.8.13
x86_64-linux-thread-mult
PERL 5.14.1
SQL*Plus 12.1.0.2.0
Zip 3.0
Unzip 6.00
------------------------- -------------------------
DBATracker 