How to fix the error ORA-00066: SID ‘string’ contains an illegal character or is too long?

In this post, you’ll learn more about the Oracle ErrorORA-00066: SID ‘string’ contains an illegal character or is too long with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-00066: SID ‘string’ contains an illegal character or is too long

Reason for the Error ORA-00066: SID ‘string’ contains an illegal character or is too long

The specified SID contained an illegal character or the SID specified was too long, which cannot occur in an SPFILE setting. Illegal characters include ,#”‘=() and whitespace.

How to fix the Error ORA-00066: SID ‘string’ contains an illegal character or is too long ?

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

Use a SID that does not contain a special character or whitespace. Check platform specific documentation for the maximum length of SID.