ORA-31086: insufficient privileges to register schema "string"

Cause : An attempt was made to register a schema without sufficient privileges.

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

Make sure that the user has sufficient privileges to register the schema.

update : 30-04-2017
ORA-31086

ORA-31086 - insufficient privileges to register schema "string"
ORA-31086 - insufficient privileges to register schema "string"

  • ora-25274 : AQ Buffered Queue event
  • ora-30182 : invalid precision specifier
  • ora-29538 : Java not installed
  • ora-06321 : IPA: Cannot reach the remote side
  • ora-25273 : AQ QMN process alternate cleanup event
  • ora-14309 : Total count of list values exceeds maximum allowed
  • ora-32319 : Cannot use direct loader log to FAST REFRESH materialized view "string"."string"
  • ora-01600 : at most one "string" in clause "string" of string
  • ora-38715 : Invalid log number specified in the DUMP FLASHBACK command.
  • ora-24374 : define not done before fetch or execute and fetch
  • ora-06419 : NETCMN: server can not start oracle
  • ora-19683 : real and backup blocksize of file string are unequal
  • ora-14457 : disallowed Nested Table column in a Temporary table
  • ora-14266 : data type or length of an index subpartitioning column may not be changed
  • ora-12632 : Role fetch failed
  • ora-03263 : cannot drop the first file of tablespace string
  • ora-36740 : A CHILDLOCK was detected in your valueset
  • ora-37041 : (XSACQUIRE_DEP_TIMEOUT) Composite, concat, dimension map, or internal partition workspace object is locked by another user and the WAIT timed out.
  • ora-06914 : CMX: unexepected event during start of oracle
  • ora-06307 : IPA: Cannot reset connection
  • ora-27504 : IPC error creating OSD context
  • ora-24371 : data would not fit in current prefetch buffer
  • ora-14071 : invalid option for an index used to enforce a constraint
  • ora-38904 : DML error logging is not supported for LOB column "string"
  • ora-06976 : X.25 Driver: endpoint creation failure
  • ora-22275 : invalid LOB locator specified
  • ora-14643 : Hakan factor mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-02153 : invalid VALUES password string
  • ora-14263 : new subpartition name must differ from that of any other subpartition of the object
  • ora-30976 : invalid Parent Order Key Index option for XML Index
  • 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.