TNS-04404: no error caused by: oracle.net.config.ConfigException: TNS-04414: File error caused by: TNS-04612

This error is seen in Oracle 10gR2, on tnsnames.ora alias definition error during database creation. The error is likely to report SQL*Net alias in tnsnames.ora file.

Look for “DESCRIPTION” line in the alias, add a space if “DESCRIPTION” in line with alias and a space between “DESCRIPTION” and “=” sign.

Example:

DEV =
(DESCRIPTION =
/

(ADDRESS = (PROTOCOL = TCP)(HOST =dev-vip)(PORT = 1521))

Restart database creation.

Leave a Reply

100 Arbor Oak Drive, #200
Ashland, Virginia 23005-2261
Phone: 1-(804)-368-8631
Toll Free: 1-(877)-230-7449
Website: http://www.ooacllc.com
Email: info@ooacllc.com