Database Administration (MOSC)

MOSC Banner

Issue while creating common user in 12cR1

edited Mar 6, 2018 9:07AM in Database Administration (MOSC) 10 commentsAnswered

Hi All,

I was trying to create a common user for Golden gate bidirectional setup. However getting the below error while trying to do so:

SQL> SQL> create user c##sandeep identified by password;

create user c##sandeep identified by password

                                     *

ERROR at line 1:

ORA-01031: insufficient privileges

SQL> create user c##sandeep identified by password container=all;

create user c##sandeep identified by password container=all

                                     *

ERROR at line 1:

ORA-01031: insufficient privileges

SQL> sho user

USER is "SYS"

Even from SYS user I'm getting this error.

Can anyone please help me with this.

Thanks,

Sandeep

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