netca command failed with ProfileException: Could not create Profile: TNS-04414: File error

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
Error Description:

Oracle netca command failed with following error.

ProfileException: Could not create Profile: TNS-04414: File error
Oracle Net Services configuration failed. The exit code is 1

Sample Error


[oracle@TESTBOX CDB]$ netca

Oracle Net Services Configuration:
ProfileException: Could not create Profile: TNS-04414: File error
Error: null
Check the trace file for details: /u01/app/oracle/cfgtoollogs/netca/trace_OraDB19Home1-2007245AM5532.log
Oracle Net Services configuration failed.  The exit code is 1

advertisements

Solution Description:

This might be some unnecessary characters in the sqlnet.ora file which is created during the manual editing. Move the sqlnet.ora file to a different name and invoke the netca command. 

[oracle@TESTBOX CDB]$ cd $ORACLE_HOME/network/admin



[oracle@TESTBOX admin]$ vi sqlnet.ora
[oracle@TESTBOX admin]$ mv -i sqlnet.ora sqlnet.ora_bk
[oracle@TESTBOX admin]$ netca

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer