When initializing a domain in Oracle, ORA-01722 error messages is likely to occur on a client machine belonging to any of the following language groups:
-
French
-
Slav — Russian, Polish, and so forth
-
Western European and Scandinavian — German, Dutch, Norwegian, and so forth
-
Spanish — Spanish of Spain
-
Portuguese
-
Italian
-
Baltic — Latvian, Lithuanian, and so forth
If you ignore ORA-01722 error messages and complete the domain initialization, the domain does not initialize correctly. To prevent the problem from occurring or to resolve the problem if it has already occurred, do the following:
-
In the Registry Editor, under My Computer, expand the KEY_LOCAL_MACHINE folder hierarchy.
-
Expand the SOFTWARE folder hierarchy.
-
Expand the ORACLE folder hierarchy.
-
Right-click the KEY_OraDb12Home1 folder.
-
On the pop-up menu, point to New and click String Value.
-
Under Name, type the parameter NLS_NUMERIC_CHARACTERS.
-
Right-click the NLS_NUMERIC_CHARACTERS parameter string and then, on the pop-up menu, click Modify.
-
In the Edit String dialog box, under Value data, enter the following values: ., (dot and comma)
-
Click OK.
If you performed this workaround after you have received an ORA-01722 error message, when you try to run the interrupted initialization process again,
the software might prompt you to resume or restart the process. For details about resuming or restarting the process, see Handle an Initialization Failure.