TNS-04414: File error when using dbca silent

When hurriedly using a set of silent database creation scripts on 11gR2 I stumbled several times across an error where dbca was failing after about 15s, and had not even started copying files. The log files in $ORACLE_BASE/cfgtoollogs/dbca/<my_db> all contained:

Various posts on the web were suggesting a problem in the tnsnames.ora file which was almost true:
In my haste, I had neglected to set the hostname properly. When you install an Oracle Enterprise Linux 7.x, the installer will put your fully qualified domain name in file
Thus the hostname command will return your server FQDN:

Well your Oracle listener set up will not like that because you will endup with a listener.ora entry looking like this:

Once I corrected the hostname to remove the domain name,

I reconfigured the listener and dbca ran fine. The good thing about OEL7.x is that you just need to edit the /etc/hostname file without having to reboot, unlike its older cousin OEL6.x where you had to reboot after editing /etc/sysconfig/network

David White

About David White

David White has written 18 post in this blog.

Oracle Technologies Consultant at Easyteam

Laisser un commentaire

Votre adresse de messagerie ne sera pas publiée. Les champs obligatoires sont indiqués avec *

%d blogueurs aiment cette page :