Remotely connect Oracle with PL/SQL

1. Remote connection Oracle does not need to open Oracle Services, can be managed in the service, save a bit of resources

2. Modify the tnsnames.ora file in the Oracle directory my directory is: D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\ Tnsnames.ora

Last side add:

Ora =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST =115.238.***.***) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = * *)
)
)

Ora is the instance name of the remote databaseprotocol is the Protocol of the Connectionhost is the Ipdizhi of the remote databaseProt Port3. reopen Plsql in the database selection, click the drop-down menu, select the Ora input tablespace user name and password, you can connect. legends can be connected using Oracle Client tools. Note Connection as

Remotely connect Oracle with PL/SQL