How to fix the Oracle error PRCD-01119: Failed to create database {0} because the database unique name matches that of database {1} in the first 8 characters?

In this post, you’ll learn more about the Oracle ErrorPRCD-01119: Failed to create database {0} because the database unique name matches that of database {1} in the first 8 characters with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PRCD-01119: Failed to create database {0} because the database unique name matches that of database {1} in the first 8 characters

Reason for the Error PRCD-01119: Failed to create database {0} because the database unique name matches that of database {1} in the first 8 characters

Cause: The database unique name is not unique in the first 8 characters. It is a requirement because the name is used to generate ORACLE_SID.

How to fix the Error PRCD-01119: Failed to create database {0} because the database unique name matches that of database {1} in the first 8 characters ?

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

Action: Ensure that the name supplied to either DBCA or srvctl during database creation is sufficiently unique, and retry the command.