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
TNS_ADMIN parameter in the Windows registry as follows:
1) open regedit
2) go to
3) you will find subkeys named
Select the one you wish to use with the database converter.
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
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) ) )
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
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:
If the problem persists after these steps, learn the following two articles
giving detailed instructions how to diagnose and fix this error:
Go to Top