CTable comparaison failed with Reason: ORA-02248

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
[email protected]
Posts: 1
Joined: Mon 28 Jul 2014 19:10

CTable comparaison failed with Reason: ORA-02248

Post by [email protected] » Mon 28 Jul 2014 19:35

Hi,

I'm trying to make a comparaison with Data compare for Oracle (just 1 table)
At the end of the process I get ORA-02248 Invalid alter session.

We're on Orale 11.2.0.3

Thanks

Regards

Cyrille

alexa

Re: CTable comparaison failed with Reason: ORA-02248

Post by alexa » Wed 30 Jul 2014 09:29

You need to perform the following the following:

1. For NLS_LANG on the client, please specify the same value as it set on the server. In System Properties, please make the Windows environment variable NLS_LANG = FRENCH_CANADA.WE8ISO8859P15

Also, on the client, please change the value of the NLS_LANG parameter in the registry.

Please see the article http://docs.oracle.com/cd/B19306_01/ins ... blsupp.htm saying:

"The NLS_LANG parameter is stored in the registry under the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID\NLS_LANG subkey, where ID is the unique number identifying the Oracle home."

2. Restart dbForge and perform comparison once again.

Post Reply