1, through PL/SQL to connect to other databases can be implemented by the service name by adding IP and left slash:
2, sometimes our IP and left slash can not lose the other database, because it is configured in a file. Where is this file?
In the Network/admin/tnsnames.ora file under this path, we can see
Can see the configuration file has been equipped with the remote address and port, as well as the service name, when we log in, the database select PLATFORM1, in fact, choose this set of configuration.
3, through the Sqlplus connection remote database is the following wording
Scott/[email Protected]:1521/platform
Here, Scott is the username, Tiger is the password, 172.16.10.76 and 1521 are the IP and port number of the target database, and platform is the service name.
PL/SQL How to view current connection information and how to specify an IP address