Oracle Client Connection server [go]

Many friends in the development project not everyone with a database, but a separate host as a development database server, so that our developers need to connect it. The first is to enter Oracle's Net mananger;

 

The next step is to make a simple setup. (1) Click on the service name and click the "+" sign here ;

 

　　　　Enter the following interface, the service name can be defined, I here is the "service." Represents a connection to a database server, not a native:

 

< Span class= "Apple-converted-space" >< Span class= "Apple-converted-space" >< Span class= "Apple-converted-space" >          point Next, select TCP/IP protocol

< Span class= "Apple-converted-space" >< Span class= "Apple-converted-space" >< Span class= "Apple-converted-space" >

< Span class= "Apple-converted-space" >< Span class= "Apple-converted-space" >< Span class= "Apple-converted-space" >   go to the next step, enter the IP address of the target host to be monitored,

< Span class= "Apple-converted-space" >< Span class= "Apple-converted-space" >< Span class= "Apple-converted-space" >

< Span class= "Apple-converted-space" >< Span class= "Apple-converted-space" >< Span class= "Apple-converted-space" >   then take the next step, take note of this step below,            here is the database instance where you want to enter the target host, which is the global database name. Do not know can be used sql_plus to find, SQL statement: select Global_name from Global_name;

You need to correspond to the instance name of the target host to listen. Click Next to complete, you can also test whether you can connect ;

  Click Test:

(2) When you are finished, you can see the service you just added under "Service naming"

 

next we use PL The/sql tool connects to the target host database, where we can see a service just configured, such as:  

 

This allows the tool to manipulate the target database ... If you want to listen to multiple target databases, repeat the above steps!

Of course, you can also copy the configured connection file directly from its machine TNS can

Oracle Client Connection server [go]