How to fix the Oracle error ORA-01228: SET DATABASE option required to install seed database?

In this post, you’ll learn more about the Oracle ErrorORA-01228: SET DATABASE option required to install seed database with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error ORA-01228: SET DATABASE option required to install seed database

The SET DATABASE option was not included in the CREATE CONTROLFILE command when installing a seed database. The database does not have a database ID because it is intended to be installed at multiple sites, and each site needs to be a different database with its own database id. Both the SET DATABASE and RESETLOGS options must be specified to create the control file for this database.

How to fix the Error ORA-01228: SET DATABASE option required to install seed database ?

You can fix this error in Oracle by following the below steps

Resubmit command with the SET DATABASE and RESETLOGS options.