Error while creating new Role in 12c

0f11f590-2a95-4b06-9c0a-b1a5d3b911d2 Apr 28, 2014 3:31 PM

Hi all,

I'm getting an error while I'm trying to create a new developer role on my EM Express in Oracle 12c:

ORA-65096: invalid common user or role name

ORA-06512: at "SYS.PRVTEMX_ADMIN", line 9796

ORA-06512: at "SYS.WRI$_REPT_SECURITY", line 314

ORA-06512: at "SYS.DBMS_REPORT", line 744

ORA-06512: at line 1

Any idea of what I'm doing wrong

Thanks a lot in advance!.

1. Re: Error while creating new Role in 12c

thatJeffSmith-Oracle Apr 28, 2014 4:00 PM (in response to 0f11f590-2a95-4b06-9c0a-b1a5d3b911d2)

Sorry, this forum space isn't for EM Express or 12c-specific questions, it's for the Oracle SQL Developer IDE/GUI
Like Show 0 Likes(0)

Actions
2. Re: Error while creating new Role in 12c

0f11f590-2a95-4b06-9c0a-b1a5d3b911d2 Apr 28, 2014 4:39 PM (in response to thatJeffSmith-Oracle)

Thanks!, let me go to the correct forum
Like Show 0 Likes(0)

Actions
3. Re: Error while creating new Role in 12c

rp0428 Apr 28, 2014 9:12 PM (in response to 0f11f590-2a95-4b06-9c0a-b1a5d3b911d2)

Repost in the Multitenant forum and see my reply dated Apr 22, 2014 3:54 PM in this thread:
https://community.oracle.com/thread/3550674

Oracle 12c uses a NEW, and different, multitenant architecture. That requires that certain, basic operations (e.g. creating users, connecting) are done DIFFERENTLY.

If you want to avoid the RTFM responses that might be coming your way read jump the gun on them by reading chapters 17 and 18 in the Database Concepts doc. Those chapters, and my reply in that thread, will answer your question.
http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm
Like Show 1 Likes(1)

Actions