- 3,708,780 Users
- 2,241,126 Discussions
- 7,840,613 Comments
Forum Stats
Discussions
Categories
- 22 Industry Applications
- 3.2K Intelligent Advisor
- 4 Insurance
- 746 On-Premises Infrastructure
- 251 Analytics Software
- 21 Application Development Software
- 1.7K Cloud Platform
- 700.4K Database Software
- 17.4K Enterprise Manager
- 4 Hardware
- 107 Infrastructure Software
- 70 Integration
- 45 Security Software
repvfy 20.02.05 failing with ORA-01031

Does anyone else receive the following error when running the 20.02.05 version of repvfy? This did not occur in the previous version.
- --------------------------------------------------------------------- --
-- REPVFY: 20.02.05 Repository: 13.3.0.0.0 14-Apr-2020 10:46:11 --
---------------------------------------------------------------------------
verifyUSERS
1004. EM Users with DBA priviledges
ORA-01031: insufficient privileges
ORA-06512: at line 1
0
Answers
This appears to be a known issue now according to MOS Doc ID 2699316.1.
The solution is:
1. Login to repository database as user with sysdba privilege
2. Execute the query and retry the repvfy command
SQL> grant select on sys.user$ to sysman;