Configure SYSOPER in 12c
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 ?