2 Replies Latest reply: Jun 26, 2013 7:32 AM by kc-runner RSS

    Oracle 12c: ORA-65049: creation of local user or role is not allowed in CDB$ROOT

    kc-runner

      Last night I installed Oracle 12C on OEL 6.4. See Installing Oracle Spatial and Graph 12c on OEL 6.4 .

       

      Today I attempted to create a test user following a syntax that worked for 11g but I received a permission error.

       

      $ sqlplus sys as sysdba

      SQL*Plus: Release 12.1.0.1.0 Production on Wed Jun 26 07:08:11 2013

      Copyright (c) 1982, 2013, Oracle.  All rights reserved.

       

      Enter password:

      Connected to:

      Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

      With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

       

      SQL> GRANT DBA, CONNECT, RESOURCE TO STEVE IDENTIFIED BY dbl-secret-pwd;

      GRANT DBA, CONNECT, RESOURCE TO STEVE IDENTIFIED BY dbl-secret-pwd

      *

      ERROR at line 1:

      ORA-65049: creation of local user or role is not allowed in CDB$ROOT

       

      Any ideas why I get this error in 12c?