Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Exadata database patch upgrade erro

edited Jul 9, 2016 5:02AM in Database Install/Upgrade/Opatch (MOSC) 1 commentAnswered

Hi,

After intall Patch DBBP 12.1.0.2.160419 (Apr2016) in Exadata Database node :

When users try to connect in database they get "ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege" .

this is the errors we are facing when try to do execute this command :

$ORACLE_HOME/OPatch/datapatch -verbose

Patch 22806133 apply (pdb EDW2P): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/22806133/19983161/22806133_apply_BIEDW_EDW2P_2016Jun18_19_57_30.log (errors)
Error at line 15013: ORA-01031: insufficient privileges
Error at line 19725: ORA-47401: Realm violation for GRANT on SYS.DBMS_RLS
Error at line 84265: ORA-01031: insufficient privileges
Error at line 84330: ORA-01031: insufficient privileges
Error at line 84380: 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