How to fix the Oracle error NNL-00005: no server has been set. Use the “SET SERVER” command first?

In this post, you’ll learn more about the Oracle ErrorNNL-00005: no server has been set. Use the “SET SERVER” command first with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

NNL-00005: no server has been set. Use the “SET SERVER” command first

Reason for the Error NNL-00005: no server has been set. Use the “SET SERVER” command first

Cause: The user attempted to issue a command which requires that a default managed Oracle Names server be set first.

How to fix the Error NNL-00005: no server has been set. Use the “SET SERVER” command first ?

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

Action: Use the SET SERVER command to set your default server, then reissue the command. Alternatively, if the command allows, re-issue it with a specific server name so the control program does not need to use the default.