Posts

Showing posts from 2015

Oracle 12c Common and Local users Creation

                Oracle 12c Common and Local users Creation Error : ORA-65096 ORA-65049 In 12c when you login to a CDB database you default to the CDB$ROOT container. [oracle@rac1 db_1]$ echo $ORACLE_SID T12 [oracle@rac1 db_1]$ ps -ef | grep pmon oracle   21182     1  0 13:21 ?        00:00:00 ora_pmon_T12 [oracle@rac1 db_1]$ sqlplus / as sysdba SQL> show con_name CON_NAME ----------- CDB$ROOT An attempt to create users in the CDB$ROOT container may result in ORA-65096 or ORA-65049 . SQL> create user test identified by test; create user test identified by test             * ERROR at line 1: ORA-65096: invalid common user or role name oerr ora 65096 65096, 00000, "invalid common user or role name" // *Cause:  An attempt was made to create a common user or role with a name //          that wass not valid for common users or roles.  In addition to //          the usual rules for user and role names, common user and role //          names