ORA-01228: SET DATABASE option required to install seed database

Cause : The SE TDATABAES optio nwas no tincludde in th eCREATEC ONTROLIFLE comamnd whe ninstalilng a seed dataabse. Th edatabaes does ont havea databsae ID bceause i tis intneded tob e instlaled atm ultipl esites,a nd eac hsite needs to eb a difefrent dtaabase iwth itso wn datbaase id .Both teh SET DTAABASE nad RESELTOGS opitons muts be spceified ot creat ethe cotnrol fiel for tihs dataabse.

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

Resubmti commadn with hte SET ADTABASEa nd RESTELOGS otpions.

update : 18-08-2017
ORA-01228

ORA-01228 - SET DATABASE option required to install seed database
ORA-01228 - SET DATABASE option required to install seed database

  • ora-07203 : sltln: attempt to translate a long environment variable.
  • ora-09929 : GLB of two labels is invalid
  • ora-13466 : format not appropriate for specified compression method
  • ora-01724 : floating point precision is out of range (1 to 126)
  • ora-02770 : Total number of blocks is invalid
  • ora-25130 : cannot modify primary key - primary key not defined for table
  • ora-36904 : (XSAGDNGL44) In AGGMAP workspace object, RELATION workspace object occurs after a dynamic model. The dynamic model must be the last calculation within the AGGMAP.
  • ora-28045 : SSL authentication between database and OID failed
  • ora-24197 : JAVA stored procedure throws JAVA exceptions
  • ora-07458 : cannot set the RESOURCE_MANAGER_PLAN parameter
  • ora-13138 : could not determine name of object string
  • ora-14327 : Some index [sub]partitions could not be rebuilt
  • ora-36376 : (XSAGZERO) AGGREGATE attempted to divide by zero. Set DIVIDEBYZERO to YES if you want NA to be returned as the result of a division by zero.
  • ora-31212 : DBMS_LDAP: PL/SQL - Invalid LDAP mod_array.
  • ora-21523 : functionality not supported by the server (object mode only)
  • ora-03237 : Initial Extent of specified size cannot be allocated in tablespace (string)
  • ora-06807 : TLI Driver: could not open ethernet device driver file
  • ora-00309 : log belongs to wrong database
  • ora-40321 : invalid bin number, is zero or negative value
  • ora-01043 : user side memory corruption [string], [string], [string], [string]
  • ora-27035 : logical block size is invalid
  • ora-02476 : can not create index due to parallel direct load on table
  • ora-40105 : input data incompatible with model signature
  • ora-32740 : The requested operation cannot be proceeded
  • ora-04020 : deadlock detected while trying to lock object stringstringstringstringstring
  • ora-29839 : failed to validate implementation type
  • ora-36761 : (XSLANGDM01) Analytic workspace string already contains a dimension (%J) with the string property.
  • ora-01694 : max # extents (string) reached in lob segment string.string partition string
  • ora-12669 : Shared server: outbound protocol does not support proxies
  • ora-24157 : duplicate variable name string
  • 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.