Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error while creating new Role in 12c

2662756Apr 28 2014 — edited Apr 28 2014

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!.
This post has been answered by thatJeffSmith-Oracle on Apr 28 2014
Jump to Answer

Comments

thatJeffSmith-Oracle
Answer

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

Marked as Answer by 2662756 · Sep 27 2020
2662756

Thanks!, let me go to the correct forum

unknown-7404

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

1 person found this helpful
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 26 2014
Added on Apr 28 2014
#sql-developer
3 comments
2,237 views