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

_____________________________________________________________________________________________________________________

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

_____________________________________________________________________________________________________________________

0 comments:

Post a comment

Labels

Oracle (575) General (60) Unix (47) Blog (23) Script (12) OCI (3) SQL* Loader (3) Software (1)
 

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