How to fix the Oracle error TNS-04079: Cannot administer Oracle Connection Manager with no CMAN.ORA, and port = number.?

In this post, you’ll learn more about the Oracle ErrorTNS-04079: Cannot administer Oracle Connection Manager with no CMAN.ORA, and port = number. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

TNS-04079: Cannot administer Oracle Connection Manager with no CMAN.ORA, and port = number.

Reason for the Error TNS-04079: Cannot administer Oracle Connection Manager with no CMAN.ORA, and port = number.

Cause: CMAN.ORA is not present or address not configured in CMAN.ORA, and the net service name in the TNSNAMES.ORA contains a nondefault Oracle Connection Manager port.

How to fix the Error TNS-04079: Cannot administer Oracle Connection Manager with no CMAN.ORA, and port = number. ?

You can fix this error in Oracle by following the below steps

Action: Either change the TNSNAMES.ORA entry to use the default port, or configure the CMAN.ORA file with the Oracle Connection Manager’s address.