How to fix the error ORA-00116: SERVICE_NAMES name is too long?

In this post, you’ll learn more about the Oracle ErrorORA-00116: SERVICE_NAMES name is too long with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-00116: SERVICE_NAMES name is too long

Reason for the Error ORA-00116: SERVICE_NAMES name is too long

A service name specified in the SERVICE_NAMES system parameter is too long.

How to fix the Error ORA-00116: SERVICE_NAMES name is too long ?

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

Use a shorter name in the SERVICE_NAMES value (<= 255 chars).