(Modified) oracle11g listens to the configuration of multiple hosts and uses pl/SQL to connect to and operate multiple databases.

(Modified) oracle11g listens to the configuration of multiple hosts and uses pl/SQL to connect to and operate multiple databases.

Many friends in the development project do not use a single database, but have a single host as the database server for development. In this way, our developers need to connect to it.

First, go to oracle's Net Mananger;

 

The next step is to make simple settings ..
(1) Click the service name, and then click "+" here;

 

Go to the following page, and define the service name. Here, we use "service ". Indicates connecting to the database server rather than the local machine:

 

Click Next and select the TCP/IP protocol

Next, enter the IP address of the target host to be monitored,

Next, take the next step. Pay attention to the following steps,
Enter the database instance of the target host, that is, the global database name. You can use SQL _PLus to search for unknown data. SQL statement: select global_name from global_name;

You need to correspond to the Instance name of the target host to listen. Click Next. You can also test whether the connection can be connected;

 
Click test:

(2) After that, you can see the added service under "service name ".

 

 

Next, we use the pl/SQL tool to connect to the target host database. here we can see a service just configured, such:

 

In this way, you can use tools to operate the target database... If you want to listen to multiple target databases, repeat the above steps!

 

PS: as mentioned in the original article, the listener is added after the service is added, but I find that the service can be connected after the service is added. If PL/SQL cannot be used to log on after the service is added, for more information, see the original article and add a listener.

Source: http://my.oschina.net/hackenhu/blog/96837