Configure network services in Oracle

Configure network services in Oracle

For Oracle, whether connecting to a local database or remotely connecting to a server database, you must configure a network service on the local machine to connect. You may not understand why.

Take SqlServer for example. When connecting to the database, SqlServer only needs to enter the local IP address, Server IP address, user name, and password to log on to the database. This is the connection method that directly specifies the IP address.

  <喎?http: www.bkjia.com kf ware vc " target="_blank" class="keylink"> Signature + signature + bXEo6zL + 8rHzai5/cXk1sPN + MLnt/Signature + 7 QwrXEt/Signature + signature/Signature + MLnt/7O8cP7oaM8L3A + Signature = "Step 1" src = "http://www.bkjia.com/uploads/allimg/150630/04145563a-1.png "title =" \ "/>

 

2. Select the default TCP/IP protocol

 

3. Enter the host name and port number. The host name is the IP address of the machine where the Oracle database is located, generally the Server IP address.

 

4. Enter the service name defined during database creation.

 

5. creation is complete.

In fact, the result of the above series of configurations is to install the directory (D: \ app \ NiuNiu \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN \ tnsnames. ora. the ora file contains the following characters:

DRP =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.24.187)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = drp)    )  )

The field description is as follows:
DRP: Custom network service name

ADDRESS_LIST: Indicates that the client needs to connect to one or more servers through multiple protocols. In this style file, the client uses the TCP/IP protocol to connect to the server.

PROTOCOL: Indicates the protocol to be connected. (Example: PROTOCOL = TCP)

SERVICE_NAME: ORACLE Database Service name. (Example: SERVICE_NAME = drp)

HOST: The IP address of the server used by the TCP/IP protocol. (For example, HOST = 192.168.24.187)

PORT: The port address used by TCP/IP. (For example, PORT = 1521)

Open PLSQL at this time, you will find:

 

The "DRP" option in the drop-down box is the name of the newly created network service.
PLSQL uses this network service name to find the corresponding string in the tnsnames. ora file in the corresponding path:

DRP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.24.187)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = drp) ) )

Then, remotely connect to the database on the corresponding server through the IP address and Database Service name. This is the basic principle. If it is incorrect, I still want to correct it!