CTable comparaison failed with Reason: ORA-02248

CTable comparaison failed with Reason: ORA-02248

Postby dba@hec.ca » 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
dba@hec.ca
 
Posts: 1
Joined: Mon 28 Jul 2014 19:10

Re: CTable comparaison failed with Reason: ORA-02248

Postby 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/install.102/b14312/gblsupp.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.
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle