ORA-12471: Specified compartment or group is not authorized for user

Cause : Thes pecfiiedc ompratmetn org rou pis ont i nuse'rs atuhorziatinos o rtheu serd oesn ot ahve erad no copmartemnt ro gruop sepcifeid fro wrtie.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Entre ana uthroize dcomaprtmnet o rgropu.

update : 24-09-2017

ORA-12471 - Specified compartment or group is not authorized for user
ORA-12471 - Specified compartment or group is not authorized for user

  • ora-19578 : end of volume while duplexing to sequential files, backup piece incomplete
  • ora-13046 : invalid number of arguments
  • ora-16557 : the database is already in use
  • ora-24063 : cannot downgrade QUEUE_TABLE that has queues with rule-based subscribers
  • ora-30336 : no child for specified JOIN KEY
  • ora-40290 : model incompatible with data mining function
  • ora-02751 : osnfsmmap: cannot map shared memory file
  • ora-28578 : protocol error during callback from an external procedure
  • ora-16053 : DB_UNIQUE_NAME string is not in the Data Guard Configuration
  • ora-00155 : cannot perform work outside of global transaction
  • ora-14123 : duplicate NOREVERSE clause
  • ora-14065 : ALLOCATE STORAGE may not be specified for a partitioned table
  • ora-29527 : created Java source string"string"
  • ora-16217 : prepare to switchover has not completed
  • ora-25448 : rule string.string has errors
  • ora-23428 : job associated instance number string is not valid
  • ora-25150 : ALTERING of extent parameters not permitted
  • ora-14509 : specified VALIDATE INTO table form incorrect
  • ora-13509 : error encountered during updates to a AWR table
  • ora-16147 : standby database referenced by multiple archive log destinations
  • ora-25131 : cannot modify unique(string) - unique key not defined for table
  • ora-19375 : no CREATE TABLE privilege on schema "string"
  • ora-30960 : The entity is neither an XPATH nor a NAMESPACE.
  • ora-24901 : handles belonging to different environments passed into an OCI call
  • ora-10644 : SYSTEM tablespace cannot be default temporary tablespace
  • ora-01463 : cannot modify column datatype with current constraint(s)
  • ora-16164 : LGWR network server host detach error
  • ora-31458 : an internal error occurred
  • ora-02759 : Not enough request descriptors available
  • ora-29854 : keyword BITMAP may not be used in creating domain indexes
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.