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) ) )
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:
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