How to fix the Oracle error PRCD-01242: Unable to convert RAC database {0} to RAC One Node database because the database had no service added?

In this post, you’ll learn more about the Oracle ErrorPRCD-01242: Unable to convert RAC database {0} to RAC One Node database because the database had no service added with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PRCD-01242: Unable to convert RAC database {0} to RAC One Node database because the database had no service added

Reason for the Error PRCD-01242: Unable to convert RAC database {0} to RAC One Node database because the database had no service added

Cause: Attempt to convert RAC database to RAC One Node database was rejected because the database did not have any service configured. A RAC One Node database must always have one service.

How to fix the Error PRCD-01242: Unable to convert RAC database {0} to RAC One Node database because the database had no service added ?

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

Action: Use ‘srvct add service’ command to add a service and then run ‘srvctl convert database -c RACONENODE’.