Symptoms
Whilst using GUI DBCA tool the error code “Exception:TNS-04414: file error” is reported.
Cause
Some DBCA operations require reading and parsing the net admin files, TNSNAMES.ORA, LISTENER.ORA and SQLNET.ORA. If there is any syntax issues with those files, including control characters, etc, Then the operation can fail.
SOLUTION:
Use the GUI Net manager tool to check which file has the problem.Select
1. Open Net Manager tool (NetMGR)
2. Click on Local, then click on Profile. This is the Sqlnet.ora file settings. If the drop down button on right-hand panel, Naming, General, etc. works, showing values for the parameters, that as set, the file can be read. Otherwise, rename Sqlnet.ora and rebuild using Net Manager.
3. Click on Service Naming. You should be able to see all the service names in your tnsnames.ora file. If clicking on any of the entries returns an error, then delete and recreate the entry. If no entries are returned, rename the Tnsnames.ora and rebuild using Net Manager.
4. Click on Listener and select the listener name. If nothing is returned, then the Listener.ora file needs to be rebuilt. Rename / move the listener.ora file and use Net Manager to build new listener.
Ensure any action to recreate, or change entry is saved by Net Manager, via File, Save Network Configuration
REMEMBER:
Use Net Manager to create and edit the sqlnet.ora file.
Do not edit the sqlnet.ora file manually.
When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.
This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.