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 : 28-06-2017

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

  • ora-06704 : TLI Driver: receive break message failed
  • ora-37154 : OLAP API initialization error: (case string)
  • ora-39038 : Object path "string" is not supported for string jobs.
  • ora-29928 : duplicate default selectivity specified
  • ora-06532 : Subscript outside of limit
  • ora-31121 : The string operator can not be FALSE
  • ora-30389 : the source statement is not compatible with the destination statement
  • ora-25125 : BUFFER_POOL storage option not allowed
  • ora-38758 : cannot flashback data file string; restored since last recovery
  • ora-40290 : model incompatible with data mining function
  • ora-00257 : archiver error. Connect internal only, until freed.
  • ora-06403 : Unable to allocate memory.
  • ora-02067 : transaction or savepoint rollback required
  • ora-15082 : ASM failed to communicate with database instance
  • ora-13419 : cannot perform mosaick operation on the specified table column
  • ora-01525 : error in renaming data files
  • ora-22319 : type attribute information altered in ALTER TYPE
  • ora-34143 : (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER.
  • ora-02222 : invalid PCTINCREASE storage option value
  • ora-30184 : argument type not compatible with a format code
  • ora-24027 : AQ HTTP propagation encountered error, status-code string, string
  • ora-24023 : Internal error in DBMS_AQ_EXP_INTERNAL.string [string] [string]
  • ora-04941 : required operating system patch needs to be applied
  • ora-13006 : the specified cell number is invalid
  • ora-26054 : Direct Path Context prepared for a different mode than operation requested.
  • ora-01042 : detaching a session with open cursors not allowed
  • ora-07431 : fork failed
  • ora-16205 : DDL skipped due to skip setting
  • ora-01480 : trailing null missing from STR bind value
  • ora-13608 : The task or object name string is invalid.
  • 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.