Oracle DBA, How To, Error, Cause and Action

ORA-01678: parameter string must be pairs of pattern and replacementstrings

ORA-01678: parameter string must be pairs of pattern and replacement strings




Cause: The initialization parameter does not have even number of strings for its value. The odd numbered strings are patterns to be found in file names. The even numbered strings are used to replace the corresponding patterns when found in file names.




Action: Specify even number of strings for the parameter, or omit the parameter.