这篇文章将为大家详细讲解有关如何静默安装oracle11g客户端,小编觉得挺实用的,因此分享给大家做个参考,希望大家阅读完这篇文章后可以有所收获。

简述:

我这里使用的版本是Oracle 11gr2 client 11.2.0.4

1.建立oraInst.loc文件

# vi /etc/oraInst.loc

inventory_loc=/u01/app/oraInventory/

inst_group=oinstall

# chmod 664 /etc/oraInst.loc

说明:这一段是在网上看到别人这么做,具体什么意思不清楚

2.修改rsp文件

# pwd

/soft/client/response

# ls

client_install.rsp netca.rsp

# cp client_install.rsp client.rsp

# vi client.rsp

主要修改client_install.rsp脚本里面几个参数,这里非常简单

#-------------------------------------------------------------------------------

# This variable holds the hostname ofthesystem as set by the user.

# It can be used to force theinstallationto use an alternative

# hostname rather than using thefirsthostname found on the system

# (e.g., for systems with multiplehostnamesand network interfaces).

ORACLE_HOSTNAME=Ben.element (执行hostname命令查看)

#-------------------------------------------------------------------------------

# Unix group to be set for theinventorydirectory.

UNIX_GROUP_NAME=oinstall (安装组)

#-------------------------------------------------------------------------------

# Inventory location.

INVENTORY_LOCATION=/u01/app/oraInventory(产品清单目录)

#-------------------------------------------------------------------------------

#-------------------------------------------------------------------------------

SELECTED_LANGUAGES=en,zh_CN (安装语言)

#-------------------------------------------------------------------------------

# Complete path of the OracleHome

ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1 ($ORACLE_HOME目录)

#-------------------------------------------------------------------------------

# Complete path of the Oracle Base.

ORACLE_BASE=/u01/app/oracle($ORACLE_BASE目录)

#-------------------------------------------------------------------------------

#-------------------------------------------------------------------------------

#Name :INSTALL_TYPE

#Datatype: String

#Description: Installation type ofthecomponent.

#

# The following choices areavailable. The value should contain

# only one of these choices.

# - InstantClient

# - Administrator

# - Runtime

# - Custom

#

#Example : INSTALL_TYPE ="Administrator"

#------------------------------------------------------------------------------

oracle.install.client.installType=Administrator (四种选择安装模式,我选择管理员模式)

#-------------------------------------------------------------------------------

#Name

#Datatype: boolean

#Description: whether or not this isanupgrade installation

#

# The following choices areavailable. The value shouldcontain

# only one of these choices.

# - true

# - false

#

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

#------------------------------------------------------------------------------

oracle.install.client.upgrading=false (布尔值更新,选择false,不知道干嘛用的,估计可以不写,但是我这里写,也安装成功)

#------------------------------------------------------------------------------

#------------------------------------------------------------------------------

# Specify the auto-updates option. Itcanbe one of the following:

# -MYORACLESUPPORT_DOWNLOAD

# -OFFLINE_UPDATES

# -SKIP_UPDATES

#------------------------------------------------------------------------------

oracle.installer.autoupdates.option=SKIP_UPDATES (跳过更新)

以上是要求选择和配置的几个参数

3.安装client

$ /soft/client/runInstaller -silent-ignorePrereq -force -responseFile /oracle/app/oracle/client_install.rsp

Starting Oracle Universal Installer...

Checking Temp space: must be greaterthan120 MB. Actual 217203 MB Passed

Checking swap space: must be greaterthan150 MB. Actual 8195 MB Passed

Preparing to launch OracleUniversalInstaller from /tmp/OraInstall2013-09-08_01-14-28PM. Pleasewait...[oracle@GE_GameSrv_A ~]$ [WARNING] [INS-32016] The selected Oraclehomecontains directories or files.

CAUSE: The selected Oraclehome contained directories or files.

ACTION: To start with an emptyOracle home, either remove its contentsor choose another location.

You can find the log of thisinstallsession at:

/u01/app/oraInventory/logs/installActions2013-09-08_01-14-28PM.log

The installation of Oracle Client 11gwassuccessful. (客户端成功安装)

Pleasecheck'/u01/app/oraInventory/logs/silentInstall2013-09-08_01-14-28PM.log' formoredetails.

Successfully Setup Software. (软件成功安装)

-silent表示以静默方式安装,不会有任何提示

-noconfig表示不运行配置助手netca

-responseFile表示使用哪个响应文件client_install.rsp

注意:我这里没有使用-noconfig参数

安装结束后,以root用户执行$ORACLE_HOME下的root.sh(如果客户端类型是instantClient则不用,但是我选择instantClient安装模式,就没安装成功过):

#/u01/app/oracle/product/10.2.0/client_1/root.sh

4.验证安装有效性

$SQLplus /nolog

SQL*Plus: Release 11.2.0.4.0 ProductiononSun Sep 8 07:54:40 2013

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

SQL>

5.配置tnsnames.ora

也可以直接从数据库copy过来

# vi tnsnames.ora

# tnsnames.ora Network ConfigurationFile:/u01/app/oracle/product/11.2.0.4/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

BEN =

(DESCRIPTION =

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

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

(CONNECT_DATA =

(SERVER =DEDICATED)

(SERVICE_NAME =ben)

)

)

6.登入验证

$ sqlplus scott/tiger@ben

SQL*Plus: Release 11.2.0.4.0 ProductiononSun Sep 8 08:27:18 2013

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

Connected to:

Oracle Database 11g EnterpriseEditionRelease 11.2.0.4.0 - 64bit Production

With the Partitioning, AutomaticStorageManagement, OLAP, Data Mining

and Real Application Testing options

SQL>

结束语

虽然执行脚本静默安装的时候,有一点点警告,说一些环境不符合,一些条件不满足,但是看到提示说成功安装client,软件成功安装就没问题了。

7.安装中遇到的问题

invalid stored block lengths

invalid stored block lengths此报错信息一般出现在oracledatabase安装或者upgrade patch时

造成此错误的原因有以下几种

a.)下载的安装包有问题

b.)解压过程中出现问题

c.)传输过程中存在问题

解决方案

a.)重新下载DB安装包

b.)重新解压

c.)重新上传到服务器中,默认开二进制传输

d.)restart server

这里我选择重新上传安装文件,因为在上传的过程中遇到一点问题。

8.以下是client.rsp完整信息

###############################################################################

## Copyright(c) Oracle Corporation1998,2013.All rights reserved. ##

## ##

## Specify values for the variableslistedbelow to customize ##

## your installation. ##

## ##

## Each variable is associated withacomment. The comment ##

## can help to populate the variableswiththe appropriate ##

## values. ##

## ##

###############################################################################

#-------------------------------------------------------------------------------

# Do not change the followingsystemgenerated value.

#-------------------------------------------------------------------------------

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

#-------------------------------------------------------------------------------

# This variable holds the hostname ofthesystem as set by the user.

# It can be used to force theinstallationto use an alternative

# hostname rather than using the firsthostnamefound on the system

# (e.g., for systems withmultiplehostnames and network interfaces).

ORACLE_HOSTNAME=Ben.element

#-------------------------------------------------------------------------------

# Unix group to be set for theinventorydirectory.

UNIX_GROUP_NAME=oinstall

#-------------------------------------------------------------------------------

# Inventory location.

INVENTORY_LOCATION=/u01/app/oraInventory/

#-------------------------------------------------------------------------------

# Specify the languages in whichthecomponents will be installed.

#

# en: English ja: Japanese

# fr: French ko : Korean

# ar: Arabic es : Latin American Spanish

# bn: Bengali lv: Latvian

# pt_BR: Brazilian Portugueselt: 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: SimplifiedChinese

# en_GB: English (GreatBritain)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 toselectany of the languages.

# Example : SELECTED_LANGUAGES=en,fr,ja

#

# Specify value as the following toselectall the languages.

# Example : SELECTED_LANGUAGES=all_langs

#-------------------------------------------------------------------------------

SELECTED_LANGUAGES=en,zh_CN

#-------------------------------------------------------------------------------

# Complete path of the OracleHome

ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1

#-------------------------------------------------------------------------------

# Complete path of the Oracle Base.

ORACLE_BASE=/u01/app/oracle

#-------------------------------------------------------------------------------

#Name :INSTALL_TYPE

#Datatype: String

#Description: Installation type ofthecomponent.

#

# The following choices areavailable. The value shouldcontain

# 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 isanupgrade installation

#

# The following choices areavailable. The value shouldcontain

# only one of these choices.

# - true

# - false

#

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

#------------------------------------------------------------------------------

oracle.install.client.upgrading=false

#------------------------------------------------------------------------------

# Name :oracle.install.client.customComponents

# Datatype: StringList

#

# This property is considered onlyifINSTALL_TYPE is set to "Custom"

#

# Description: List of ClientComponentsyou would like to install

#

#The following choices areavailable. You may specify any

#combination of thesechoices.Thecomponents you choose should

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

#Below is a list of componentsyou may specify to install.

#

# oracle.sqlj:11.2.0.4.0 --"OracleSQLJ"

# 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 -- "OracleProgrammer"

# oracle.xdk:11.2.0.4.0 -- "OracleXMLDevelopment 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 --"OracleODBC Driver"

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

# oracle.dbdev:11.2.0.4.0 --"OracleSQL 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 OracleSchedulerAgent.

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

# list of custom components during custominstall

#

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

#------------------------------------------------------------------------------

oracle.install.client.schedulerAgentHostName=

#------------------------------------------------------------------------------

# Port number to be used for by theOracleScheduler Agent.

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

# list of custom components duringcustominstall

#

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

#------------------------------------------------------------------------------

oracle.install.client.schedulerAgentPortNumber=

#------------------------------------------------------------------------------

# Specify the auto-updates option. Itcanbe one of the following:

# -MYORACLESUPPORT_DOWNLOAD

# -OFFLINE_UPDATES

# -SKIP_UPDATES

#------------------------------------------------------------------------------

oracle.installer.autoupdates.option=SKIP_UPDATES

#------------------------------------------------------------------------------

# In case MYORACLESUPPORT_DOWNLOADoptionis chosen, specify the location where

# the updates are to be downloaded.

# In case OFFLINE_UPDATES option ischosen,specify the location where the updates

# are present.

#------------------------------------------------------------------------------

oracle.installer.autoupdates.downloadUpdatesLoc=

#------------------------------------------------------------------------------

# Specify the My Oracle SupportAccountUsername 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 SupportAccountUsername 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.Lengthshould be greater than zero.

#

# Example :PROXY_HOST=proxy.domain.com

#------------------------------------------------------------------------------

PROXY_HOST=

#------------------------------------------------------------------------------

# Specify the proxy port number. ShouldbeNumeric and at least 2 chars.

#

# Example : PROXY_PORT=25

#------------------------------------------------------------------------------

PROXY_PORT=

#------------------------------------------------------------------------------

# Specify the proxy user name.LeavePROXY_USER and PROXY_PWD

# blank if your proxy server requiresnoauthentication.

#

# Example :PROXY_USER=username

#------------------------------------------------------------------------------

PROXY_USER=

#------------------------------------------------------------------------------

# Specify the proxy password.LeavePROXY_USER and PROXY_PWD

# blank if your proxy server requiresnoauthentication.

#

# Example : PROXY_PWD=password

#------------------------------------------------------------------------------

PROXY_PWD=

#------------------------------------------------------------------------------

# Specify the proxy realm.

#

# Example :PROXY_REALM=metalink

#------------------------------------------------------------------------------

PROXY_REALM=

关于“如何静默安装oracle11g客户端”这篇文章就分享到这里了,希望以上内容可以对大家有一定的帮助,使各位可以学到更多知识,如果觉得文章不错,请把它分享出去让更多的人看到。