Just for the people who are curios about the APEX import error ORA-02047 I had the last couple of weeks.
On the next workday I followed the hint from Dietmar and changed the settings in my dads.conf:
After that the error did not occur again.
In this time I did around 20 to 40 import and exports without any problems. I would say: That's it!
You always have to use AL32UTF8 in your PlsqlNLSLanguage variable.
Update:
28.11.2008 - Error occurred again... For now I just restarted the OAS service and the import worked as well as before.
Update:
12.02.2009 - Error now occurred several times again. Last week I couldn't restart the OAS service but when I tried it this week again it worked. Without any changes except restart my client. This error drives me crazy. At least right now it works...
Update:
15.05.2009 - Now I could fix the issue ones by looking into the sessions of the external database. There I canceled all sessions for the database user which I was connecting through APEX. Afterwards the import run again without a OAS restart.
I came to the idea through some fabulous hints from Scott and Joel.
Link: Import err: ORA-20001,ORA-02047,alter session set nls_numeric_characters...
On the next workday I followed the hint from Dietmar and changed the settings in my dads.conf:
<Location /pls/xe>
PlsqlNLSLanguage GERMAN_GERMANY.AL32UTF8
</Location>
After that the error did not occur again.
In this time I did around 20 to 40 import and exports without any problems. I would say: That's it!
You always have to use AL32UTF8 in your PlsqlNLSLanguage variable.
Update:
28.11.2008 - Error occurred again... For now I just restarted the OAS service and the import worked as well as before.
Update:
12.02.2009 - Error now occurred several times again. Last week I couldn't restart the OAS service but when I tried it this week again it worked. Without any changes except restart my client. This error drives me crazy. At least right now it works...
Update:
15.05.2009 - Now I could fix the issue ones by looking into the sessions of the external database. There I canceled all sessions for the database user which I was connecting through APEX. Afterwards the import run again without a OAS restart.
I came to the idea through some fabulous hints from Scott and Joel.
Link: Import err: ORA-20001,ORA-02047,alter session set nls_numeric_characters...
