Labels

Thursday, March 6, 2014

Supressing C## for common user in Oracle 12c

Normally common user are started with C## in 12c. But this can be eliminated by using hidden parameter below method. SQL> alter system set  "_common_user_prefix"='v##' scope=spfile; System altered. SQL> create user v## identified by test;create user v## identified by test            *ERROR at line 1:ORA-65096: invalid common user or role nameSolutions:-SQL> create pfile from spfile;
 File created. SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down. #####Opened the pfile and modify the value ora12c._common_user_prefix='V##' SQL> startup pfile='C:\app\XXXXXX\product\12.1.0\dbhome_1\database\INITora12c.ORA';ORACLE instance started. Total System Global Area 1068937216 bytesFixed Size                  2410864 bytesVariable Size             666896016 bytesDatabase Buffers          394264576 bytesRedo Buffers                5365760 bytesDatabase mounted.Database opened.SQL> show con_name CON_NAME------------------------------CDB$ROOTSQL> create user v## identified by test; User created.

No comments:

Post a Comment