ORA-28048: database is a member of multiple enterprise domains in OID

Cause : An enterprise user login was attempted on a database that is a member of multiple enterprise domains in OID.

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

An administrator should put the database into only one enterprise domain in OID, and then the user should reconnect.

update : 26-09-2017

ORA-28048 - database is a member of multiple enterprise domains in OID
ORA-28048 - database is a member of multiple enterprise domains in OID

  • ora-02009 : the size specified for a file must not be zero
  • ora-34342 : (MXDSS01) IMPORTANT: Analytic workspace string is read-only. Therefore, you will not be able to use the UPDATE command to save changes to it.
  • ora-07216 : slghst: gethostname error, unable to get name of current host.
  • ora-27458 : A program of type PLSQL_BLOCK cannot have any arguments.
  • ora-00119 : invalid specification for system parameter string
  • ora-07275 : unable to send signal to process
  • ora-27508 : IPC error sending a message
  • ora-00391 : All threads must switch to new log format at the same time
  • ora-32317 : cannot run a job from a job
  • ora-38951 : Target platform string not cross platform compliant
  • ora-29323 : ALTER DATABASE SET COMPATIBILITY command not supported by string
  • ora-39033 : Data cannot be filtered under the direct path access method.
  • ora-29903 : error in executing ODCIIndexFetch() routine
  • ora-19722 : datafile string is an incorrect version
  • ora-25461 : rule set not specified
  • ora-00165 : migratable distributed autonomous transaction with remote operation is not allowed
  • ora-36682 : (XSDPART20) Partition name string appears twice.
  • ora-39219 : directory object name is too long
  • ora-22634 : Error adding new instance to AnyDataSet
  • ora-30334 : illegal dimension level name
  • ora-36808 : (XSTBLFUNC04) The OLAP_TABLE function LEVELREL clause cannot declare number ADT fields from number AW fields.
  • ora-31488 : cannot support change set string in this configuration
  • ora-06535 : statement string in string is NULL or 0 length
  • ora-31686 : error creating worker processes
  • ora-29260 : network error: string
  • ora-02047 : cannot join the distributed transaction in progress
  • ora-39129 : Object type string not imported. Name conflicts with the master table
  • ora-14150 : missing SUBPARTITION keyword
  • ora-28539 : gateway does not support result sets
  • ora-24807 : LOB form mismatch
  • 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.