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 : 26-06-2017
ORA-12465

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-14054 : invalid ALTER TABLE TRUNCATE PARTITION option
  • ora-13030 : Invalid dimension for the SDO_GEOMETRY object
  • ora-38476 : abstract type used for an Attribute set may not be modified.
  • ora-16796 : one or more properties could not be imported from the database
  • ora-26050 : Direct path load of domain index is not supported for this column type.
  • ora-29262 : bad URL
  • ora-06734 : TLI Driver: cannot connect
  • ora-10701 : Dump direct loader index keys
  • ora-28557 : unknown string for database link to non-Oracle system
  • ora-02752 : osnfsmmap: illegal shared memory address
  • ora-14001 : LOCAL clause contradicts previosly specified GLOBAL clause
  • ora-33002 : (XSAGDNGL00) In AGGMAP workspace object, the FLOOR argument of number must be less than the CEILING argument of number.
  • ora-30350 : specified dimension attribute does not exist
  • ora-31092 : invalid SQL name "string"
  • ora-07637 : smsdbp: buffer protect option not specified when sga created
  • ora-16116 : no work available
  • ora-01072 : cannot stop ORACLE; ORACLE not running
  • ora-00386 : use_indirect_data_buffers not supported
  • ora-07200 : slsid: oracle_sid not set.
  • ora-29384 : number of children for plan string exceeds string
  • ora-31210 : DBMS_LDAP: PL/SQL - LDAP get_dn error.
  • ora-02270 : no matching unique or primary key for this column-list
  • ora-19727 : cannot plug data [string] at level string into database running Oracle string
  • ora-36165 : (XSAGGCNTPROP) Variable workspace object cannot have both an AGGCOUNT and the $COUNTVAR property.
  • ora-24904 : invalid callback attribute passed into OCI call
  • ora-09777 : osnpbr: cannot send break message
  • ora-12229 : TNS:Interchange has no more free connections
  • ora-28584 : heterogeneous apply internal error
  • ora-38956 : Target platform string not cross platform compliant
  • ora-16769 : the physical standby database is open read-only
  • 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.