repvfy 20.02.05 failing with ORA-01031 — oracle-tech

    Forum Stats

  • 3,708,780 Users
  • 2,241,126 Discussions
  • 7,840,613 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

repvfy 20.02.05 failing with ORA-01031

JohnY-48JohnY-48 Posts: 2 Green Ribbon

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

Answers

  • JohnY-48JohnY-48 Posts: 2 Green Ribbon

    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;

Sign In or Register to comment.