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 : 30-05-2017

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

  • ora-13332 : invalid LRS point
  • ora-00824 : cannot set sga_target due to existing internal settings, see alert log for more information
  • ora-02189 : ON required
  • ora-38463 : invalid XML Tag list
  • ora-19264 : XQ0044 - invalid namespace in attribute constructors
  • ora-32161 : Cannot perform piecewise fetch
  • ora-01631 : max # extents (string) reached in table string.string
  • ora-39025 : jobs of type string are not restartable
  • ora-01352 : tablespace given for Logminer spill does not exist
  • ora-28337 : the specified index may not be defined on an encrypted column
  • ora-12039 : unable to use local rollback segment "string"
  • ora-02768 : Maximum number of files is invalid
  • ora-01528 : EOF while processing SQL statement
  • ora-26575 : remote database does not support replication parallel propagation
  • ora-38760 : This database instance failed to turn on flashback database
  • ora-31051 : Requested access privileges not supported
  • ora-09959 : IMON: deletion of a process failed.
  • ora-32605 : invalid REBUILD option
  • ora-06436 : ssaio: asynchronous I/O failed due to incorrect parameters.
  • ora-36165 : (XSAGGCNTPROP) Variable workspace object cannot have both an AGGCOUNT and the $COUNTVAR property.
  • ora-13452 : GeoRaster metadata BIN function error
  • ora-01875 : time zone minute must be between -59 and 59
  • ora-23426 : deferred RPC queue has entries for string
  • ora-12919 : Can not drop the default permanent tablespace
  • ora-00226 : operation disallowed while alternate control file open
  • ora-15132 : block string of file string in diskgroup string could not be written
  • ora-32055 : invalid file type
  • ora-13609 : The specified task string must be executing to be cancelled or interrupted.
  • ora-29284 : file read error
  • ora-27033 : failed to obtain file size limit
  • 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.