|   |   | 
From:       To:      

How to resolve Oracle errors

On this page you will find how to resolve Oracle errors that can appear when using Intelligent Converters software. If you experience Oracle error that is not listed here, contact to Intelligent Converters team using Feedback Form

I have multiple Oracle homes installed on my system. Can this cause a problem while using Intelligent Converters software?
Yes, it will be a problem, since the program doesn't know to which Oracle home it should connect. You can resolve this using TNS_ADMIN environmental variable to point to the directory where you wish to take tnsnames.ora from. Or you can set TNS_ADMIN parameter in the Windows registry as follows:
1) open regedit
2) go to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
3) you will find subkeys named HOME0, HOME1, etc. Select the one you wish to use with the database converter.
4) add TNS_ADMIN variable for this home and enter the path to tnsnames.ora file in this variable
Go to Top

ORA-06413: Connection not open
If you run the database converter on 64-bit Windows, the most probable reason of the error is that executable module has been placed into folder "C:\Program Files (x86)\..." while Oracle does not allow bracket symbols in client application. In order to fix the error, copy all contents of product's installation folder into another location that does not contain brackets in the path.
Go to Top

ORA-12154: TNS: could not resolve the connect identifier specified
This is a very common error caused by either local copy of the tnsnames.ora file or listener configuration or database name aliases. So, we recommend to check that:

Below is an example of correct TNSNAMES.ORA:

MYORCL=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname_or_IP)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = MYORCL)
    )
  )

Go to Top

ORA-12640: Authentication adapter initialization failed
The most probable reason of the error is incorrect record in SQLNET.ORA file. By default SQLNET.ORA is located in $ORACLE_HOME/network/admin folder). Open it with any editor and find entry 'SQLNET.AUTHENTICATION_SERVICES'. It has to be as follows: 

SQLNET.AUTHENTICATION_SERVICES=(NONE)
Go to Top

ORA-12705: Invalid or unknown NLS parameter value specified
This error occurs when Oracle failed to extract regional settings (language, territory, or character set) or server settings do not match client. Compare Oracle server language configuration with local settings and edit local settings if necessary. First, extract NLS parameters from Oracle server: 

SQL> SELECT * FROM nls_database_parameters;


PARAMETER VALUE
------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8MSWIN1252
...

Then find local NLS settings stored in Windows registry and compare it:

  1. run regedit
  2. open "HKLM\Software\Oracle\KEY_<SERVICE NAME>" key, where <SERVICE NAME> is the name of Oracle service you're trying to connect
  3. find NLS_LANG value under this key
  4. if it is defined to "NA" or differs from NLS_LANGUAGE.NLS_TERRITORY.NLS_CHARACTERSET value received from Oracle server above, change it. In our example it should be AMERICAN.AMERICA.WE8MSWIN1252

If the problem persists after these steps, learn the following two articles giving detailed instructions how to diagnose and fix this error:
http://www.dba-oracle.com/t_ora_12705_resolution.htm
http://www.dba-oracle.com/t_ora_12705_error.htm
Go to Top

Copyright (c) 2001-2023 Intelligent Converters