For users that are using a Windows (XP/2003) German (Switzerland) version and want to install the Oracle 10gR2 database release, they will find that the installation of the database configuration utility will abort with the error messages:
ORA-00604: error ocured at recursive SQL level1
ORA-02248: invalid option for ALTER SESSION
So, what is the problem and how to solve it?
First off, the 10.1 release will install without any problems and this bug is only seen in the 10gR2 release. From my findings there is a problem with the NLS_CURRENCY which is derived from the NLS_TERRITORY setting. Somehow Oracle messes up with it.
The solution to this, is to install the software without the starter database checked. Let the installer finish up and then open up the registry and change the value NLS_LANG within HKEY_LOCAL_MACHINE / SOFTWARE / ORACLE / OraDB10g_home1 (your value might be different according to your values during installation) from:
GERMAN_SWITZERLAND.WE8MSWIN1252
to
GERMAN_GERMANY.WE8MSWIN1252
Once done, you can start up the database utility and create a database without any error messages.
It took me some time to figure this out and I hope it helps somebody out there.
