ORA-28047: database is not a member of any enterprise domain in OID

Cause : An enterprise user login was attempted on a database that is not a member of any enterprise domain in OID.

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

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

update : 24-05-2017

ORA-28047 - database is not a member of any enterprise domain in OID
ORA-28047 - database is not a member of any enterprise domain in OID

  • ora-40226 : model upgrade/downgrade must be performed by SYS
  • ora-34871 : (PERMIT06) Session-only value 'value' of workspace object has been deleted because a PERMIT change has revealed a duplicate value.
  • ora-02444 : Cannot resolve referenced object in referential constraints
  • ora-35018 : (QFCHECK01) The analytic workspace and EIF file definitions of workspace object have a mismatched data type.
  • ora-26011 : Cannot load type string into column string in table string
  • ora-30076 : invalid extract field for extract source
  • ora-30343 : level name is not unique within this dimension
  • ora-39783 : Invalid direct path transaction active
  • ora-07224 : sfnfy: failed to obtain file size limit; errno = string.
  • ora-16576 : failed to update Data Guard configuration file
  • ora-19880 : Corrupted space header for datafile string, block string backup aborted
  • ora-39110 : error deleting worker processes
  • ora-30110 : syntax error at 'string'
  • ora-19730 : can not convert offline plugged-in datafile string
  • ora-06030 : NETDNT: connect failed, unrecognized node name
  • ora-40105 : input data incompatible with model signature
  • ora-29664 : Unable to generate the helper class for the defined type
  • ora-13190 : recursive SQL fetch failed
  • ora-25191 : cannot reference overflow table of an index-organized table
  • ora-24019 : identifier for string too long, should not be greater than string characters
  • ora-23374 : object group "string"."string" already exists
  • ora-31658 : specifying a schema name requires a table name
  • ora-10970 : backout event for bug 2133357
  • ora-12224 : TNS:no listener
  • ora-07460 : cannot set the RESOURCE_MANAGER_PLAN parameter
  • ora-27004 : invalid blocksize specified
  • ora-09801 : Unable to get user ID from connection
  • ora-32610 : missing SINGLE REFERENCE or DIMENSION keyword in MODEL clause
  • ora-13452 : GeoRaster metadata BIN function error
  • ora-24787 : remote cursors must be closed before a call completes
  • 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.