To connect to a remote oracle database, you must first clear the network, and then you need to know the IP address, database port number, user name, password, database service name and other information of the remote database.

1. To install the oracle client locally, please find the tnsname.ora file in the following path. ~ \ Oracle \ product \ 10 . 2 . 0 \ db _ 1 \ network \ ADMIN

2. Open the tnsname.ora file. Add the following:

Local instance name =

(description? =

(address? =? (agreement? =? TCP) (host? =? Database IP address) (port? =? Port number))

(CONNECT_DATA？ =

(server? =? Dedicated)

(SERVICE_NAME？ =? Service name)

)

3. Then take PL/SQL as an example. Select the correct database and connection method, and fill in the correct user name and password.