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
P: Error "ORA-12500: the listener could not start a server
process..."
R: The process of starting up a dedicated server process failed. The
executable could not be found or the environment may be set up incorrectly.
Verify that the ORACLE Server executable is present and has execute
permissions enabled. Ensure that the ORACLE environment is specified correctly
in LISTENER.ORA. If Oracle server is running under MS Windows NT/2000/XP,
check that service 'OracleService<data source name>' (where
<data source name> is an actual name of destination Oracle data source)
is running on the database server machine.
Go to Top
P: Error "ORA-12505: the program could not resolve service
name..."
R: The service name specified in the connection was not found in the
listener's tables. Check to make sure that the service name is correct.
The services that are currently registered with the listener can be obtained
by typing: LSNRCTL SERVICES <listener-name>
Go to Top
P: Error "ORA-12541: no listener..."
R: The connection request could not be completed because the listener is not
running on the database server. Start the listener on the destination machine
using 'lsnrctl start' command.
Go to Top
P: Error "ORA-12545: connect failed because target host or object
does not exist..."
R: Oracle suggest ensuring that the ADDRESS parameters (in the TNSNAMES.ORA
file) have been entered correctly; the most likely incorrect parameter is the
node name. Ensure that the executable for the server exists (perhaps "oracle"
is missing.) If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change
the host name to a numeric IP address and try again. It could be a network
connectivity problem. Try pinging the host. This error has been observed on a
laptop when the database was local, TCP/IP protocol used but the network card
had been removed.
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:
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
P: The application failed to start because OCI.dll was not found.
R: OCI.DLL is supplied by the Oracle Corporation and is a part of the Oracle
Version 7.3.4 (or later) client software installation. Check that you have
Oracle client and networking components installed on the machine where you
run our software from. Also please make sure that the path to Oracle components
folder is in $PATH system variable.
Go to Top
P: After entering all Oracle connection settings properly I've
got the following error: "Oracle data source does not exist.
Check to verify correct name was given.".
R: It means that the program failed to connect to the destination server
using the selected method. To bypass this error you can try the following
trick. Leave both "Server" and "Port" fields empty and
enter in "Database" field the entire connection string as follows:
(DESCRIPTION=
(CONNECT_DATA=(SERVICE_NAME=))
(ADDRESS=(PROTOCOL=TCP)(HOST=IP address of Oracle server)(PORT=1521))
)
Of course, you need to replace "IP address of Oracle server"
in the sample above with the actual value of IP address.
Go to Top
If you came across some other kind of problem while using Oracle related converters, please contact our support department.