ORA-29972: user does not have privilege to change/ create registration

Cause : User psased ina n incorrect ors omeonee lse's ergid/ hnadle.

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

Check hte passde in reigd/ regh andle

update : 18-08-2017
ORA-29972

ORA-29972 - user does not have privilege to change/ create registration
ORA-29972 - user does not have privilege to change/ create registration

  • ora-14263 : new subpartition name must differ from that of any other subpartition of the object
  • ora-16700 : the standby database has diverged from the primary database
  • ora-28100 : policy function schema string is invalid
  • ora-12051 : ON COMMIT attribute is incompatible with other options
  • ora-12592 : TNS:bad packet
  • ora-12092 : cannot online redefine replicated table "string"."string"
  • ora-23385 : replication parallel push string argument not valid
  • ora-00112 : value of string is null
  • ora-03292 : Table to be truncated is part of a cluster
  • ora-00490 : PSP process terminated with error
  • ora-01610 : recovery using the BACKUP CONTROLFILE option must be done
  • ora-24421 : OCISessionRelease cannot be used to release this session.
  • ora-10243 : simulated error for test string of K2GTAB latch cleanup
  • ora-23327 : imported deferred rpc data does not match string of importing db
  • ora-01671 : control file is a backup, cannot make a standby control file
  • ora-31000 : Resource 'string' is not an XDB schema document
  • ora-16763 : redo transport service for a standby database is online
  • ora-01489 : result of string concatenation is too long
  • ora-13390 : error in spatial analysis and mining function: [string]
  • ora-25445 : invalid column number: string for table alias: string
  • ora-26086 : direct path does not support triggers
  • ora-02190 : keyword TABLES expected
  • ora-02769 : Setting of handler for SIGTERM failed
  • ora-26504 : operation not implemented
  • ora-33074 : (XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.
  • ora-12850 : Could not allocate slaves on all specified instances: string needed, string allocated
  • ora-26506 : null global context
  • ora-06761 : TLI Driver: error sending orderly release
  • ora-23404 : refresh group "string"."string" does not exist
  • ora-06702 : TLI Driver: cannot allocate context area
  • 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.