Database Administration (MOSC)

MOSC Banner

Insufficient privileges to shutdown CDB with common user in 12c

edited Feb 15, 2016 12:11PM in Database Administration (MOSC) 3 commentsAnswered ✓

I have a common user in the database with SYSDBA privilege and I am not able to shutdown the database with it.

I get insufficient privileges.

sys@cdbtest>grant sysdba to C##TEST container=all;

Grant succeeded.

sys@cdbtest>select * from v$pwfile_users where username='C##TEST';

USERNAME       SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM     CON_ID

------------------------------ ----- ----- ----- ----- ----- ----- ----------

C##TEST       TRUE  TRUE  FALSE FALSE FALSE FALSE    0

c##test@cdbtest>show user

USER is "C##TEST"

c##test@cdbtest>shut immediate;

ORA-01031: insufficient privileges

Is there anything I am missing here?

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