Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to install the oralce11g client, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

First verify that the operating system firewall and selinux are turned off:

-- View selinux status: sestatus

How to turn off SELinux:

Change the SELINUX= "" in the / etc/selinux/config file to disabled, and then restart.

If you do not want to restart the system, use the command setenforce 0

-- View iptables status: service iptables status

Turn off the firewall

1) after restart, it will take effect permanently:

Enable: chkconfig iptables on

Turn off: chkconfig iptables off

2) effective immediately and expire after restart:

Enable: service iptables start

Turn off: service iptables stop

1. Memory Requirements:At least 256 MB of physical RAM.

# grep MemTotal / proc/meminfo

To determine whether the system architecture can run the software, enter the following command:

# grep "model name" / proc/cpuinfo

To determine the size of the configured swap space, enter the following command:

# grep SwapTotal / proc/meminfo

To determine the available RAM and swap space, enter the following command:

# free

2. Disk Space Requirements

The minimum disk space requirement for a client install in the / tmp directory is 400 MB.

To determine the amount of disk space available in the / tmp directory, enter the following command:

# df-k / tmp

Between 146 MB and 1.38 GB of disk space for the Oracle software, depending on the installation type:

Installation Type Requirement for Software Files

Instant Client 146 MB

Administrator 1.38 GB

Runtime 1.10 GB

3. Operating System Requirements

To determine the distribution and version of Linux installed, enter the following command:

# cat / proc/version

4. Kernel Requirements

For Asianux Server 3, Oracle Linux 5, and Red Hat Enterprise Linux 5:

2.6.18 or later

To determine whether the required kernel is installed, enter the following command:

# uname-r

5.Package Requirements

The following or later version of packages for Asianux Server 3, Oracle Linux 5, and Red Hat Enterprise Linux 5 should be installed:

Binutils-2.17.50.0.6

Compat-libstdc++-33-3.2.3

Elfutils-libelf-0.125

Elfutils-libelf-devel-0.125

Elfutils-libelf-devel-static-0.125

Gcc-4.1.2

Gcc-c++-4.1.2

Glibc-2.5-24

Glibc-common-2.5

Glibc-devel-2.5

Ksh-20060214

Libaio-0.3.106

Libaio-devel-0.3.106

Libgcc-4.1.2

Libgomp-4.1.2

Libstdc++-4.1.2

Libstdc++-devel-4.1.2

Make-3.81

Sysstat-7.0.2

Operating system check:

Rpm-Q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat

[root@client] # rpm-Q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat

Binutils-2.20.51.0.2-5.43.el6.x86_64

Package compat-libstdc++-33 is not installed

Elfutils-libelf-0.161-3.el6.x86_64

Package elfutils-libelf-devel is not installed

Package gcc is not installed

Package gcc-c++ is not installed

Glibc-2.12-1.166.el6.x86_64

Glibc-common-2.12-1.166.el6.x86_64

Glibc-devel-2.12-1.166.el6.x86_64

Libaio-0.3.107-10.el6.x86_64

Package libaio-devel is not installed

Libgcc-4.4.7-16.el6.x86_64

Libstdc++-4.4.7-16.el6.x86_64

Package libstdc++-devel is not installed

Make-3.81-20.el6.x86_64

Sysstat-9.0.4-27.el6.x86_64

[root@client ~] #

Yum install-y compat-libstdc++*

Yum install-y elfutils-libelf-devel*

Yum install-y gcc*

Yum install-y libaio-devel*

Yum install-y libstdc++-devel*

Mount the CD and configure the yum source:

[root@client ~] # mount / dev/cdrom / mnt

Mount: block device / dev/sr0 is write-protected, mounting read-only

[root@client ~] #

[root@client ~] # vi / etc/yum.repos.d/yum.repo

[base]

Name=base

Baseurl= file:///mnt/Server

Enabled=1

Gpgcheck=0

Gpgkey= file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release

[root@client yum.repos.d] #

[root@client yum.repos.d] #

[root@client yum.repos.d] # yum clean all

Loaded plugins: product-id, refresh-packagekit, security, subscription-manager

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

Cleaning repos: base

Cleaning up Everything

[root@client yum.repos.d] # yum list

Omit.

[root@client yum.repos.d] # yum makecache

Loaded plugins: product-id, refresh-packagekit, security, subscription-manager

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

Base | 4.1 kB 00:00.

Base/group_gz | 211 kB 00:00.

Base/filelists_db | 3.4 MB 00:00.

Base/other_db | 1.3 MB 00:00.

Metadata Cache Created

[root@client yum.repos.d] #

-- install missing packages:

Yum install-y compat-libstdc++*

Yum install-y elfutils-libelf-devel*

Yum install-y gcc*

Yum install-y libaio-devel*

Yum install-y libstdc++-devel*

6.Creating Required Operating System Groups and Users

Add user groups oinstall, and oracle users:

[root@client Packages] # groupadd oinstall

[root@client Packages] # groupadd dba

[root@client Packages] # useradd-g oinstall-G dba oracle

[root@client Packages] # passwd oracle

Changing password for user oracle.

New password:

BAD PASSWORD: it is based ona dictionary word

BAD PASSWORD: is too simple

Retype new password:

Passwd: all authentication tokens updated successfully.

[root@client Packages] #

7.Creating Required Directories

[root@client] # mkdir-p / u01/app/oracle

[root@client] # chown-R oracle:oinstall / u01/app/oracle/

[root@client] # chmod-R 775 / u01/app/oracle/

8.Configuring the oracle User's Environment configure user environment variables

[oracle@client ~] $vi .bash _ profile

# .bash _ profile

# Get the aliases and functions

If [- f ~ / .bashrc]; then

. ~ / .bashrc

Fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

Export PATH

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_HOME=/u01/app/oracle/11.2/client

Export NLS_LANG= "american_america.ZHS16GBK"

Export NLS_DATE_FORMAT= "YYYY-MM-DD HH24:Mi:SS"

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib

~

".bash _ profile" 15L, 235C written

[oracle@client ~] $

[oracle@client ~] $source .bash _ profile

[oracle@client ~] $

8. Upload the oracle client installation package:

[oracle@client ~] $mkdir soft

[oracle@client ~] $cd soft/

[oracle@client soft] $ls

[oracle@client soft] $pwd

/ home/oracle/soft

[oracle@client soft] $

[oracle@client soft] $ls

P13390677_112040_Linux-x86-64_4of7.zip

[oracle@client soft] $unzip p13390677_112040_Linux-x86-64_4of7.zip

Omit.

9. Configure silent installation response file

[oracle@client soft] $ls

Client p13390677_112040_Linux-x86-64_4of7.zip

[oracle@client soft] $cd client/

[oracle@client client] $ls

Install readme.html response runInstaller stage welcome.html

[oracle@client client] $cd response/

[oracle@client response] $ls

Client_install.rsp netca.rsp

[oracle@client response] $

-- back up the response file first:

[oracle@client response] $cp client_install.rsp client_install.rsp.bak

[oracle@client response] $ls

Client_install.rsp client_install.rsp.bak netca.rsp

Modify the response file:

[oracle@client response] $vi client_install.rsp

#

# # Copyright (c) Oracle Corporation 1998 Magazine 2013. All rights reserved. # #

#

# # Specify values for the variables listed below to customize # #

# # your installation. # #

#

# # Each variable is associated with a comment. The comment # #

# # can help to populate the variables with the appropriate # #

# # values. # #

#

#

#-

# Do not change the following system generated value.

#-

Oracle.install.responseFileVersion=/oracle/install/rspfmt_clientinstall_response_schema_v11_2_0

#-

# This variable holds the hostname of the system as set by the user.

# It can be used to force the installation to use an alternative

# hostname rather than using the first hostname found on the system

# (e.g., for systems with multiple hostnames and network interfaces).

ORACLE_HOSTNAME=client

#-

# Unix group to be set for the inventory directory.

UNIX_GROUP_NAME=oinstall

#-

# Inventory location.

INVENTORY_LOCATION=/u01/app/oraInventory

#-

# Specify the languages in which the components will be installed.

#

# en: English ja: Japanese

# fr: French ko: Korean

# ar: Arabic es: Latin American Spanish

# bn: Bengali lv: Latvian

# pt_BR: Brazilian Portuguese lt: Lithuanian

# bg: Bulgarian ms: Malay

# fr_CA: Canadian French es_MX: Mexican Spanish

# ca: Catalan no: Norwegian

# hr: Croatian pl: Polish

# cs: Czech pt: Portuguese

# da: Danish ro: Romanian

# nl: Dutch ru: Russian

# ar_EG: Egyptian zh_CN: Simplified Chinese

# en_GB: English (Great Britain) sk: Slovak

# et: Estonian sl: Slovenian

# fi: Finnish es_ES: Spanish

# de: German sv: Swedish

# el: Greek th: Thai

# iw: Hebrew zh_TW: Traditional Chinese

# hu: Hungarian tr: Turkish

# is: Icelandic uk: Ukrainian

# in: Indonesian vi: Vietnamese

# it: Italian

#

# all_langs: All languages

#

# Specify value as the following to select any of the languages.

# Example: SELECTED_LANGUAGES=en,fr,ja

#

# Specify value as the following to select all the languages.

# Example: SELECTED_LANGUAGES=all_langs

#-

SELECTED_LANGUAGES=en,zh_CN

#-

# Complete path of the Oracle Home

ORACLE_HOME=/u01/app/oracle/11.2/client

#-

# Complete path of the Oracle Base.

ORACLE_BASE=/u01/app/oracle

#-

# Name: INSTALL_TYPE

# Datatype: String

# Description: Installation type of the component.

#

# The following choices are available. The value should contain

# only one of these choices.

#-InstantClient

#-Administrator

#-Runtime

#-Custom

#

# Example: INSTALL_TYPE = "Administrator"

#-

Oracle.install.client.installType=Administrator

#-

# Name: oracle.install.client.upgrading

# Datatype: boolean

# Description: whether or not this is an upgrade installation

#

# The following choices are available. The value should contain

# only one of these choices.

#-true

#-false

#

# Example: oracle.install.client.upgrading=true

#-

Oracle.install.client.upgrading=

#-

# Name: oracle.install.client.customComponents

# Datatype: StringList

#

# This property is considered only if INSTALL_TYPE is set to "Custom"

#

# Description: List of Client Components you would like to install

#

# The following choices are available. You may specify any

# combination of these choices. The components you choose should

# be specified in the form "internal-component-name:version"

# Below is a list of components you may specify to install.

#

# oracle.sqlj:11.2.0.4.0-"Oracle SQLJ"

# oracle.rdbms.util:11.2.0.4.0-"Oracle Database Utilities"

# oracle.javavm.client:11.2.0.4.0-"Oracle Java Client"

# oracle.sqlplus:11.2.0.4.0-"SQL*Plus"

# oracle.dbjava.jdbc:11.2.0.4.0-"Oracle JDBC/THIN Interfaces"

# oracle.ldap.client:11.2.0.4.0-"Oracle Internet Directory Client"

# oracle.rdbms.oci:11.2.0.4.0-"Oracle Call Interface (OCI)"

# oracle.precomp:11.2.0.4.0-"Oracle Programmer"

# oracle.xdk:11.2.0.4.0-"Oracle XML Development Kit"

# oracle.network.aso:11.2.0.4.0-"Oracle Advanced Security"

# oracle.assistants.oemlt:11.2.0.4.0-"Enterprise Manager Minimal Integration"

# oracle.oraolap.mgmt:11.2.0.4.0-"OLAP Analytic Workspace Manager and Worksheet"

# oracle.network.client:11.2.0.4.0-"Oracle Net"

# oracle.network.cman:11.2.0.4.0-"Oracle Connection Manager"

# oracle.network.listener:11.2.0.4.0-"Oracle Net Listener"

# oracle.ordim.client:11.2.0.4.0-"Oracle Multimedia Client Option"

# oracle.odbc:11.2.0.4.0-"Oracle ODBC Driver"

# oracle.has.client:11.2.0.4.0-"Oracle Clusterware High Availability API"

# oracle.dbdev:11.2.0.4.0-"Oracle SQL Developer"

# oracle.rdbms.scheduler:11.2.0.4.0-"Oracle Scheduler Agent"

#

#-

Oracle.install.client.customComponents= "oracle.sqlj:11.2.0.4.0", "oracle.rdbms.util:11.2.0.4.0", "oracle.javavm.client:11.2.0.4.0", "oracle.sqlplus:11.2.0.4.0", "oracle.dbjava.jdbc:11.2.0.4.0", "oracle.ldap.client:11.2.0.4.0", "oracle.rdbms.oci:11.2.0.4.0" "oracle.precomp:11.2.0.4.0", "oracle.xdk:11.2.0.4.0", "oracle.network.aso:11.2.0.4.0", "oracle.assistants.oemlt:11.2.0.4.0", "oracle.oraolap.mgmt:11.2.0.4.0", "oracle.network.client:11.2.0.4.0", "oracle.network.cman:11.2.0.4.0" "oracle.network.listener:11.2.0.4.0", "oracle.ordim.client:11.2.0.4.0", "oracle.odbc:11.2.0.4.0", "oracle.has.client:11.2.0.4.0", "oracle.dbdev:11.2.0.4.0", "oracle.rdbms.scheduler:11.2.0.4.0"

#-

# Host name to be used for by the Oracle Scheduler Agent.

# This needs to be entered in case oracle.rdbms.scheduler is selected in the

# list of custom components during custom install

#

# Example: oracle.install.client.schedulerAgentHostName = acme.domain.com

#-

Oracle.install.client.schedulerAgentHostName=

#-

# Port number to be used for by the Oracle Scheduler Agent.

# This needs to be entered in case oracle.rdbms.scheduler is selected in the

# list of custom components during custom install

#

# Example: oracle.install.client.schedulerAgentPortNumber = 1500

#-

Oracle.install.client.schedulerAgentPortNumber=

#-

# Specify the auto-updates option. It can be one of the following:

#-MYORACLESUPPORT_DOWNLOAD

#-OFFLINE_UPDATES

#-SKIP_UPDATES

#-

Oracle.installer.autoupdates.option=

#-

# In case MYORACLESUPPORT_DOWNLOAD option is chosen, specify the location where

# the updates are to be downloaded.

# In case OFFLINE_UPDATES option is chosen, specify the location where the updates

# are present.

#-

Oracle.installer.autoupdates.downloadUpdatesLoc=

#-

# Specify the My Oracle Support Account Username which has the patches download privileges

# to be used for software updates.

#

# Example: AUTOUPDATES_MYORACLESUPPORT_USERNAME=abc@oracle.com

#-

AUTOUPDATES_MYORACLESUPPORT_USERNAME=

#-

# Specify the My Oracle Support Account Username password which has the patches download privileges

# to be used for software updates.

#

# Example: AUTOUPDATES_MYORACLESUPPORT_PASSWORD=password

#-

AUTOUPDATES_MYORACLESUPPORT_PASSWORD=

#-

# Specify the Proxy server name. Length should be greater than zero.

#

# Example: PROXY_HOST=proxy.domain.com

#-

PROXY_HOST=

#-

# Specify the proxy port number. Should be Numeric and at least 2 chars.

#

# Example: PROXY_PORT=25

#-

PROXY_PORT=

#-

# Specify the proxy user name. Leave PROXY_USER and PROXY_PWD

# blank if your proxy server requires no authentication.

#

# Example: PROXY_USER=username

#-

PROXY_USER=

#-

# Specify the proxy password. Leave PROXY_USER and PROXY_PWD

# blank if your proxy server requires no authentication.

#

# Example: PROXY_PWD=password

#-

PROXY_PWD=

#-

# Specify the proxy realm.

#

# Example: PROXY_REALM=metalink

#-

PROXY_REALM=

[oracle@client client] $

[oracle@client response] $

There seems to be a lot of content above, but in fact, these values are mainly modified according to the actual environment, and other values can be left unfilled by default:

ORACLE_HOSTNAME=client

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/u01/app/oraInventory

SELECTED_LANGUAGES=en,zh_CN

ORACLE_HOME=/u01/app/oracle/11.2/client

ORACLE_BASE=/u01/app/oracle

Oracle.install.client.installType=Administrator

10. Start silently installing the client

Change to the installation directory and execute the following command to install the client silently

. / runInstaller-silent-responseFile / home/oracle/soft/client/response/client_install.rsp

[oracle@client response] $ls

Client_install.rsp client_install.rsp.bak netca.rsp

[oracle@client response] $pwd

/ home/oracle/soft/client/response

[oracle@client response] $cd..

[oracle@client client] $ls

Install readme.html response runInstaller stage welcome.html

[oracle@client client] $. / runInstaller-silent-responseFile / home/oracle/soft/client/response/client_install.rsp

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB. Actual 19745 MB Passed

Checking swap space: must be greater than 150 MB. Actual 4095 MB Passed

Preparing to launch Oracle Universal Installer from / tmp/OraInstall2017-10-25 11-11-32AM. Please wait... [oracle@client client] $You can find the log of this install session at:

/ u01/app/oraInventory/logs/installActions2017-10-25 11-11-32AM.log

The installation of Oracle Client 11g was successful.

Please check'/ u01/app/oraInventory/logs/silentInstall2017-10-25-11-11-32 AM.log 'for more details.

As a root user, execute the following script (s):

1. / u01/app/oraInventory/orainstRoot.sh

Successfully Setup Software.

[oracle@client client] $

Root execution:

[root@client ~] # / u01/app/oraInventory/orainstRoot.sh

Changing permissions of / u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of / u01/app/oraInventory to oinstall.

The execution of the script is complete.

[root@client ~] #

Client installation complete!

Test client:

-- configure tns:

[oracle@client admin] $cd $ORACLE_HOME/network/admin

[oracle@client admin] $ls

Samples shrept.lst

[oracle@client admin] $vi tnsnames.ora

Test =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.56.20) (PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = test)

)

)

~

"tnsnames.ora" [New] 8L, 171C written

[oracle@client admin] $

[oracle@client admin] $tnsping test

TNS Ping Utility for Linux: Version 11.2.0.4.0-Production on 25-OCT-2017 11:56:00

Copyright (c) 1997, 2013, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.56.20) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = test)

OK (50 msec)

[oracle@client admin] $sqlplus system/oracle@test

SQL*Plus: Release 11.2.0.4.0 Production on Wed Oct 25 11:56:25 2017

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL > show parameter name

NAME TYPE VALUE

-

Cell_offloadgroup_name string

Db_file_name_convert string

Db_name string test

Db_unique_name string test

Global_names boolean FALSE

Instance_name string test

Lock_name_space string

Log_file_name_convert string

Processor_group_name string

Service_names string service1,service2,service3

SQL >

Thank you for reading this article carefully. I hope the article "how to install the oralce11g client" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.