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 : 23-07-2017
ORA-12471

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

  • ora-12640 : Authentication adapter initialization failed
  • ora-38790 : BEFORE must be specified with RESETLOGS
  • ora-00273 : media recovery of direct load data that was not logged
  • ora-09363 : Windows 3.1 Two-Task driver invalid context area
  • ora-26698 : %s did not have a string rule set
  • ora-02446 : CREATE TABLE ... AS SELECT failed - check constraint violated
  • ora-14106 : LOGGING/NOLOGGING may not be specified for a clustered table
  • ora-15094 : attempted to write to file opened in read only mode
  • ora-13388 : invalid value for dst_spec parameter
  • ora-01907 : TABLESPACE keyword expected
  • ora-32807 : message system link string already exists
  • ora-36836 : (XSLMGEN06) Dimension string.string!string hierarchy string level string is missing a PHYSICALNAME property value
  • ora-02723 : osnpui: cannot send break signal
  • ora-36666 : (XSDPART04) workspace object is not a concat dimension.
  • ora-01858 : a non-numeric character was found where a numeric was expected
  • ora-29929 : missing SCAN Keyword
  • ora-30154 : The memory address given as buffer for OCIFileRead/Write is invalid
  • ora-26745 : cursors (string) are not sufficient
  • ora-01594 : attempt to wrap into rollback segment (string) extent (string) which is being freed
  • ora-02030 : can only select from fixed tables/views
  • ora-07445 : exception encountered: core dump [string] [string] [string] [string] [string] [string]
  • ora-39206 : A parallel degree of string is invalid.
  • ora-25321 : enqueue failed, user property specified but queue string.string is not an 8.1 style queue
  • ora-24783 : Cannot switch non-migratable transactions
  • ora-13224 : zero tolerance specified for layer in USER_SDO_GEOM_METADATA
  • ora-24432 : The statement that was returned is not tagged.
  • ora-23378 : connection qualifier "string" is not valid for object group "string"."string"
  • ora-13602 : The specified parameter string is not valid for task or object string.
  • ora-38777 : database must not be started in any other instance.
  • ora-06445 : ssvpstevrg: Incorrect parameters passed to function call
  • 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.