ORA-16585: illegal operation on a primary site

Cause : Internal error

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

Contact Oracle Support Services.

update : 28-06-2017
ORA-16585

ORA-16585 - illegal operation on a primary site
ORA-16585 - illegal operation on a primary site

  • ora-12737 : Instant Client Light: unsupported server character set string
  • ora-23374 : object group "string"."string" already exists
  • ora-09922 : Can't spawn process - background log directory not created properly
  • ora-16791 : unable to check the existence of the standby redo logs
  • ora-02755 : osnfsmcre: cannot create chared memory file ?/dbs/ftt_.dbf
  • ora-12403 : invalid internal label
  • ora-02284 : duplicate INCREMENT BY specifications
  • ora-29550 : Java session state cleared
  • ora-06579 : Bind variable not big enough to hold the output value
  • ora-27047 : unable to read the header block of file
  • ora-32593 : database supplemental logging attributes in flux
  • ora-01954 : DEFAULT ROLE clause not valid for CREATE USER
  • ora-32310 : object materialized views must select from an object table
  • ora-31095 : cannot generate string : "string.string" already exists
  • ora-37155 : OLAP API bootstrap error: (case string)
  • ora-28272 : Domain policy restricts password based GLOBAL user authentication.
  • ora-38734 : Flashback log is inconsistent; belongs to another database.
  • ora-32150 : Cannot perform operation on a null timestamp
  • ora-12004 : REFRESH FAST cannot be used for materialized view "string"."string"
  • ora-29933 : object being disassociated has some user defined statistics stored
  • ora-00338 : log string of thread string is more recent than control file
  • ora-13062 : topology IDs do not match in the feature table and the topology
  • ora-23344 : constraint (string.string) does not exist
  • ora-19102 : XQuery string literal expected
  • ora-27453 : %s is an invalid job or program argument name.
  • ora-15034 : disk 'string' does not require the FORCE option
  • ora-23301 : mixed use of deferred rpc destination modes
  • ora-12470 : NULL or invalid user label: string
  • ora-30176 : invalid format code used in the format string
  • ora-01610 : recovery using the BACKUP CONTROLFILE option must be done
  • 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.