Remotely connect to Oracle using NET Manager tools

One, configure the Oracle port on the server

Enter the NETCA command on the command line to open the related configuration default port number is 1521

Second, after configuring the port, use the Telnet tool to debug the port.

Enter the Telnet server IP port number at the command line

Third, find the net Manager self-bringing tool

Customizing a service Name

Configure the IP and port number you need to connect to the server here

Note: The service name here must match the name of the database in the server

If the test is not connected, first make sure that the database service is started, and then check that the user and password are correct

Last: Save network configuration

After the configuration is complete, the client can view the Tnsnames.ora file in your installation directory \product\12.1.0\dbhome_1\network\admin folder

Resolution: If you need to connect to another server, copy the parameters in the red box to modify the server name, server IP, server port

Summary: Using the Oracle Developer Connection tool (similar tools PL/SQL Developer) will be able to connect directly using the following methods

Remotely connect to Oracle using NET Manager tools