database creation TNS04404 no error

database creation TNS04404 no error

1. delete tnsname.ora

Example
# del /home/oracle/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsname.ora

2.Edit  hosts files with simply  localhost.localdomain localhost

Example

$ nano /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

10.2.5.126  localhost localhost.localdomain localhost




3. Edit /etc/hostname



$ nano /etc/hostname

 localhost.localdomain







Ctrl-O Enter (saves)
Ctrl-X (exits)

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.