PLSQL Developer connects to the external Oracle Server Database

PLSQL Developer connects to the Internet Oracle Server database 1. In the Oracle installation directory, find product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN \ tnsnames. ora file to open tnsnames. add the following content at the end of the ora file: QUEUETEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = ip address of the Internet oracle Server) (PORT = 1521) #1521 is the default PORT used by Marshal) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = docDB) # docDB is the name of the Internet oracle service instance, similar to mysql and SQL server databases. ) If the file is modified, the system prompts that the read-only file cannot be saved. You can copy the file and modify it. After modification, copy the file and paste it back to overwrite the original file. 2. Open the PLSQL Developer client, select the newly added database name, and enter the user name and password. PS: the connection is in. You can create an SQL window and enter select * from tab; to check whether all tables in the database can be found.