Database Administration (MOSC)

MOSC Banner

Configure SYSOPER in 12c

edited Jan 18, 2017 9:52AM in Database Administration (MOSC) 3 commentsAnswered ✓

In previous versions of the database if I wanted to have a user who could start and stop the db, perform backups etc, but not have access to sysdba features, I could use SYSOPER.

Having a lot of problems trying to do the same sort of things in 12.1, and so am assuming things have changed.

SQL> create user c##jason identified by jason1 container=all;

User created.

SQL> grant create session, sysoper to c##jason;

Grant succeeded.

SQL> connect "c##jason/jason1 as sysoper"

SQL> Connected.

SQL> shutdown immediate

ORA-01031: insufficient privileges

What am I doing wrong, or is there a new way to do things in the 12c world ?

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