Oracle's configuration client logs on to multiple remote databases

First, Introduction

Have been confused about the Oracle database client, how to configure, a few days ago because of the need to use Oracle, and the need to connect two different databases, through the Internet and ask colleagues finally put the client configuration, record, learning

Second, step

In fact, for the configuration of the software, if the configuration is still in effect after restarting the software, then it will definitely write this configuration to a file, but some software will encrypt these files or binary write, so we do not see, but fortunately Oracle's files can be seen and can be edited. Here's a look at two ways to configure the client to log in to multiple remote databases.

Method One, repair the configuration file

This method is straightforward, but there is a precondition: you need to know where the file is, then add the desired configuration directly, and you need to know how to add it correctly.

File location:homedir\product\11.1.0\client_1\network\admin\tnsnames.ora

Where Homedir refers to the installation of the client side of the directory, if you do not know where, in window can find a program in the client and then right-click to open the file location.

Configuration Item Format: If your client has already added a remote database, then the file already has a configuration, you just have to modify it in its format.

Here is my configuration file, which has a configuration, so there is already a configuration item, according to modify it.

This picture is the second way I added the second remote database after the contents of the configuration file

As you can see, the newly added configuration item is only one difference from the original, which is the IP address.

Method Two,

Unlike method one, this method is configured using the tools provided by Oracle--net configuration Assistant

It can be found in all programs:

Oracle's tool has been very user-friendly, but if you are touching it for the first time, you may still not know how to use it, because some of the terminology inside you don't understand what it means. I'll show you how to configure it in the next step.

Step one, open NET configuration assitant This tool, select the Local service name configuration

Step Two, select Add

Step three, fill in the service name, here is the service name of the remote database

Step four, select the communication protocol--TCP

Step five, fill in the hostname and port number-the IP address and port number of the remote database server

Step six, whether to test? Choose Test here to test if the connection is successful

Step seven, if the connection is not successful, you can modify the login, because the default is to use the system user login

Step eight, test the connection success

Step nine, enter a name for this service to fill in the identifier that identifies the service (we use Plsql login), because I have another orcl, so I wrote here is Orcl21

Step ten, whether to configure another net service name, select No here, if you want to continue to configure, then select Yes.

Step Xi. to this our configuration has been basically completed, here Click Next

Step 12, to this step, we have completely completed the configuration, click Finish to exit the net configuration Assistant

Once the configuration is complete, we can login to try and configure whether it is available.

We log in using Splsql, where we need to select the configuration item you just added at database, whose name is previously configured:orcl21

Here we have completed the configuration of the Oracle client landing multiple databases, and we look back at what the configured file looks like now:

A configuration item was added to the file, and the parameters in the configuration item were exactly the same as the one we filled out. So it also confirms the feasibility of the first method.

Iii. Summary

For some terminology in Oracle configuration, this blog is very comprehensive and can be consulted.

Through this configuration, it is found that the client is not required to monitor the configuration of the program. That is the database installation of the server is required, the previous configuration did not understand, even this is configured t_t.

Any software can not be separated from Io, in order to permanently save the data, only write to the file.

Just like these databases, no matter how they organize their data, the bottom line is to read and write files, and they organize the data simply to improve the speed of reading data, or to organize the data into more complex structures for direct use. But the last is to read and write files, but the written format is based on the design of the home database.

Seemingly summed up with the above content unrelated t_t, haha, suddenly think of the writing up.

Oracle's configuration client logs on to multiple remote databases