Shulou(Shulou.com)06/01 Report--

This article focuses on how to install the Oracle client and how to configure the TNSname network service name. This paper includes two methods: configuring netca and changing tnsnames files.

Environmental profile

Client version: Oracle client 11.2.0.1

Operating system version: Windows 10

Install database client software

First, we download the Oracle client from the official website, then decompress it, and select stup.exe to start the installation.

Don't worry about it here, just determine it directly (because the 11G client does not have the corresponding information of the win10 system when detecting the environment. )

Select the administrator. If there are many fewer functions by default, it is recommended to choose the administrator installation type.

Default is fine.

Select the installation directory, try not to change the path, do not have Chinese characters.

The above configuration summary

If the local firewall is turned on, there will usually be a prompt, just allow it directly.

Complete the database installation

Graphical configuration of local network service name

Be sure to run netca as an administrator in win10 and select the local network service name configuration

Select add

Set the service name (in this case, the database service name)

Default tcp protocol is fine.

The hostname refers to the hostname of the database. The port number can be kept by default.

Here, because of learning, I choose to test.

In general, the test fails because of the wrong user name. Click here to change the login and reset the password to pass the test (there will be another test later)

The test passed

Then just click on the next step to finish.

Whether to configure the next one with more of its own requirements, here we test to create only one.

Next step

Complete the configuration

Change the parameter file configuration local network service name

The network service name can also be changed directly by changing the parameter file, because the network service name information is stored in the tnsnames.ora file by default, so we can also add parameters directly to the tnsnames.ora file. However, because the file cannot be modified by default in win10, we first give permissions to the user.

The first zky was previously configured graphically, and then you can copy the above parameters directly, and you can also use them by changing them. (as shown in the following figure, we add a parameter with the local service name ZKYTXT by changing the parameter directly.)

ZKYTXT = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.214.214) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = zhanky)

ZKYTXT

Database local network service name (custom, used locally)

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.214.214) (PORT = 1521):

IP and protocol settings used for database network connections

(SERVICE_NAME = zhanky)

The service name of the database

Test connectivity

Test whether the previously configured TNS is connected, and you can see in the figure that all the tests have passed.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.