Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

ORA-01031: insufficient privileges

edited Aug 23, 2021 4:04PM in Database Install/Upgrade/Opatch (MOSC) 1 commentAnswered

I use dbca on redhat linux 7 to create a 12.2 database, got ORA-01031 insufficient privileges error poped up and asks either ignore or abort, https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=381109503997781&id=1904919.1&_afrWindowMode=0&_adf.ctrl-state=1br92emtjl_102 says create the password and retry, I checked and there is orapw* file created by dbca in the $ORACLE_HOME/dbs folder. so I retry and got same error, t


further checking postScripts.log

UPDATE sys.USER$ set SPARE6=NULL

      *

ERROR at line 1:

ORA-01031: insufficient privileges


UPDATE sys.USER$ set SPARE6=NULL

      *

ERROR at line 1:

ORA-01031: insufficient privileges

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center