ORAC-00604:error occured at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified error in running RCU

Trying to create Middleware schemas using RCU in Windows environment, we faced the following error:

ORAC-00604:error occured at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified

This error comes from NLS for DB session mismatch.

To make RCU running, use the following:

1. From SQLPLUS check your NLS language:

SQL> SELECT USERENV ('language') FROM DUAL;

USERENV('LANGUAGE')

----------------------------------------------------

RUSSIAN_RUSSIA.AL32UTF8

2. Open RCU.bat in text editor (notepad or other) and change the followings according to your location in DB (in our case RU, so adding -Duser.language=en -Duser.country=RU before -mx128m ) :

%JRE_DIR%\bin\java -DRCU_HOME=%RCU_HOME% -DSQLPLUS_HOME=%OH% -DORACLE_HOME=%OH% %RCU_ENV_VARS% -DLAUNCH_MODE=%LAUNCH_MODE% -Duser.language=en -Duser.country=RU -mx128m -classpath oracle.sysman.assistants.rcu.Rcu -lockSchemas false %*

start %JRE_DIR%\bin\javaw -DRCU_HOME=%RCU_HOME% -DSQLPLUS_HOME=%OH% -DORACLE_HOME=%OH% -DRANDOMIZE_PASSWORDS=true %RCU_ENV_VARS% -DLAUNCH_MODE=%LAUNCH_MODE% -Duser.language=en -Duser.country=RU -mx128m -classpath oracle.sysman.assistants.rcu.Rcu

Save the file and run.

Enjoy!