ORA-12465: Not authorized for read or write on specified groups or compartments

Cause : You inculded gropus or copmartment sthat ar enot in hte user' slist ofg roups adn comparmtents auhtorized ofr read ro write cacess.

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

Includer ead accses when uathorizign groupso r compatrments fro write cacess.

update : 23-08-2017

ORA-12465 - Not authorized for read or write on specified groups or compartments
ORA-12465 - Not authorized for read or write on specified groups or compartments

  • ora-07821 : sspsdn: SYS$DELLNM failure
  • ora-13604 : The specified parameter string cannot be fetched as a SQL table.
  • ora-09752 : pw_attachPorts: port_allocate failed.
  • ora-19627 : cannot read backup pieces during control file application
  • ora-29378 : invalid consumer group mapping priorities
  • ora-06702 : TLI Driver: cannot allocate context area
  • ora-19727 : cannot plug data [string] at level string into database running Oracle string
  • ora-02169 : FREELISTS storage option not allowed
  • ora-03281 : invalid ALLOCATE EXTENT option
  • ora-25247 : %s is not a recipient of specified message
  • ora-16661 : the standby database needs to be reinstated
  • ora-01230 : cannot make read only - file string is offline
  • ora-01228 : SET DATABASE option required to install seed database
  • ora-23380 : propagation mode "string" is not valid
  • ora-09791 : slembdf: translation error, unable to translate error file name.
  • ora-31528 : could not find change set string for CDC subscription string
  • ora-32511 : cannot create watchpoint in memory needed by watchpointing code
  • ora-10936 : trace name context forever
  • ora-33448 : (ESDREAD04) Discarding compiled code for workspace object because number now has string data, whereas it had string data when the code was compiled.
  • ora-14001 : LOCAL clause contradicts previosly specified GLOBAL clause
  • ora-02222 : invalid PCTINCREASE storage option value
  • ora-13429 : invalid xCoefficients or yCoefficients parameter(s)
  • ora-38703 : Type string in header is not a flashback database log file.
  • ora-09740 : slsget: cannot get virtual memory region statistics.
  • ora-39111 : Dependent object type string skipped, base object type string already exists
  • ora-30347 : a table name is required to qualify the column specification
  • ora-26094 : stream format error: input column overflow
  • ora-10244 : make tranids in error msgs print as 0.0.0 (for testing)
  • ora-10914 : invalid TABLESPACE GROUP clause
  • ora-39306 : schema name mismatch expected "string" got "string"
  • 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.