How to fix the Oracle error TNS-04075: Cannot use ADMINISTER directly from the command line.?

In this post, you’ll learn more about the Oracle ErrorTNS-04075: Cannot use ADMINISTER directly from the command line. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

TNS-04075: Cannot use ADMINISTER directly from the command line.

Reason for the Error TNS-04075: Cannot use ADMINISTER directly from the command line.

Cause: ADMINISTER can only be issued from the CMCTL> prompt.

How to fix the Error TNS-04075: Cannot use ADMINISTER directly from the command line. ?

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

Action: Use the -c option with any command instead of ADMINISTER.