How to configure Oracle client runtime in CentOS

Time:2021-6-2

Author: 33 chongtian

Blog:http://www.zhouhuibo.club

Through the process of learning and sharing, summarize and output the problems and technologies in their work, hoping that both rookies and veteran can gain new knowledge through their own articles and put them into practice.

1、 Preparation – Download runtime environment package

This paper mainly describes the installation and configuration of the Oracle client runtime environment, so as to avoid the trouble in the process of using.

Problems must be recorded in time and documents must be updated in time. Every time you install it, you have to find the problem again,Sure, sureThe general steps should be recorded to facilitate their later operation and maintenance.

First, download the Oracle runtime environment and enter the Oracle download websitePortal, as shown in the figure

Select the corresponding version, the actual operation process is not recommended to use the latest version, there is no one to help you solve the problem

How to configure Oracle client runtime in CentOS

Recommended version: instantclient-basic-linux.x64-11.2.0.4.0.zip

File direct download

Oracle official website also need to register to download, and the download speed is slow. In order to facilitate you to download, I will give you the download address directly to save the above steps

The download address is as follows

https://download.csdn.net/dow…

2、 Deployment operations

new directory

mkdir /usr/local/oracle

Put the downloaded file in the directory and execute theunzipDecompression command

unzip /usr/local/oracle/instantclient-basic-linux.x64-11.2.0.4.0.zip 

Root user, add the link library path / Oracle / product / 11.2.0/db in the file / etc / ld.so.conf_ 1 / lib, save and exit. And execute

ldconfig

Don’t forget the last step!!!Otherwise, there will be a classic error prompt, and the solution is very simple, that is, carefully check whether I have followed my steps.

error while loading shared libraries: libclntsh.so.11.1

In the end, the deployment has actually been completed, isn’t it very simple! That’s because I’ve stepped on all the pits, I think( ˇˍˇ) I think it’s all tears.

3、 Test whether the deployment is successful

After the deployment is completed, we should always test to see if the deployment is successful. We can choose which way to test. There are many ways that suit us. I mainly recommend two.

First, write your own test cases

recommend

If you are a programmer, write a small demo

Connect to Oracle and send aselect date from dualCommand, receive the return value to judge whether it is successful

This should be a very simple thing

The second way is to use the official help library

Similarly, in order to facilitate the download, I also download it for your convenience

Download address:https://download.csdn.net/dow…

However, this method is not recommended because it’s too boring. I need to configure environment variables and install some strange libraries. At this time, I wrote a demo by myself, which has already been completed.

Of course, if there is a good configuration in this way, please @ me and share an address with me.

END

Welcome to the official account toolkit, dedicated to sharing outstanding open source projects, learning resources and tools.

Reply to the keyword “pay attention to the gift package”, send you a complete skill map of programmers.

How to configure Oracle client runtime in CentOSTitle: centos7 configure Oracle client runtime
Author: Zhou Huibo
Excerpt: centos7 configure Oracle client runtime
categories: golang
tags:

  • centos7
  • oracle

abbrlink: 36786
date: 2021-03-11 19:59:20

Author: 33 chongtian

Blog:http://www.zhouhuibo.club

Through the process of learning and sharing, summarize and output the problems and technologies in their work, hoping that both rookies and veteran can gain new knowledge through their own articles and put them into practice.

1、 Preparation – Download runtime environment package

This paper mainly describes the installation and configuration of the Oracle client runtime environment, so as to avoid the trouble in the process of using.

Problems must be recorded in time and documents must be updated in time. Every time you install it, you have to find the problem again,Sure, sureThe general steps should be recorded to facilitate their later operation and maintenance.

First, download the Oracle runtime environment and enter the Oracle download websitePortal, as shown in the figure

Select the corresponding version, the actual operation process is not recommended to use the latest version, there is no one to help you solve the problem

How to configure Oracle client runtime in CentOS

Recommended version: instantclient-basic-linux.x64-11.2.0.4.0.zip

File direct download

Oracle official website also need to register to download, and the download speed is slow. In order to facilitate you to download, I will give you the download address directly to save the above steps

The download address is as follows

https://download.csdn.net/download/HapplyFox/15809690

2、 Deployment operations

new directory

mkdir /usr/local/oracle

Put the downloaded file in the directory and execute theunzipDecompression command

unzip /usr/local/oracle/instantclient-basic-linux.x64-11.2.0.4.0.zip

Root user, add the link library path / Oracle / product / 11.2.0/db in the file / etc / ld.so.conf_ 1 / lib, save and exit. And execute

ldconfig

Don’t forget the last step!!!Otherwise, there will be a classic error prompt, and the solution is very simple, that is, carefully check whether I have followed my steps.

error while loading shared libraries: libclntsh.so.11.1

In the end, the deployment has actually been completed, isn’t it very simple! That’s because I’ve stepped on all the pits, I think( ˇˍˇ) I think it’s all tears.

3、 Test whether the deployment is successful

After the deployment is completed, we should always test to see if the deployment is successful. We can choose which way to test. There are many ways that suit us. I mainly recommend two.

First, write your own test cases

recommend

If you are a programmer, write a small demo

Connect to Oracle and send aselect date from dualCommand, receive the return value to judge whether it is successful

This should be a very simple thing

The second way is to use the official help library

Similarly, in order to facilitate the download, I also download it for your convenience

Download address:https://download.csdn.net/download/HapplyFox/15810208

However, this method is not recommended because it’s too boring. I need to configure environment variables and install some strange libraries. At this time, I wrote a demo by myself, which has already been completed.

Of course, if there is a good configuration in this way, please @ me and share an address with me.

END

Welcome to the official account toolkit, dedicated to sharing outstanding open source projects, learning resources and tools.

Reply to the keyword “pay attention to the gift package”, send you a complete skill map of programmers.
How to configure Oracle client runtime in CentOS