Differences

This shows you the differences between two versions of the page.

Link to this comparison view

userspace:oracle_11g_odbc_client [2016/02/22 10:25]
SmEe created
userspace:oracle_11g_odbc_client [2016/02/22 10:30] (current)
SmEe
Line 1: Line 1:
 +**Installation von Oracle (NetClient & ODBC Schnittstelle) in der Version 11g.** 
 +**Sowie ein Reg-File import für die ODBC Schnittstelle.**
 https://​forum.opsi.org/​viewtopic.php?​f=7&​t=8167 https://​forum.opsi.org/​viewtopic.php?​f=7&​t=8167
 +
 +1) Oracle Setup für Silent-Installation vorbereiten. (AntwortFile)
 +Mehr unter: https://​docs.oracle.com/​cd/​B28359_01/​install.111/​b32002/​app_nonint.htm#​CIHEAGGJ
 +
 +Meine client_install.rsp:​
 +<​code>​
 +###############################################################################​
 +## Copyright(c) Oracle Corporation 1998,2011. 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=
 +#​-------------------------------------------------------------------------------
 +# Unix group to be set for the inventory directory.  ​
 +UNIX_GROUP_NAME=
 +#​-------------------------------------------------------------------------------
 +# Inventory location.
 +INVENTORY_LOCATION=
 +#​-------------------------------------------------------------------------------
 +# 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=de,​en
 +#​-------------------------------------------------------------------------------
 +# Complete path of the Oracle Home  ​
 +ORACLE_HOME=C:​\Oracle\Client
 +#​-------------------------------------------------------------------------------
 +# Complete path of the Oracle Base. 
 +ORACLE_BASE=C:​\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 : InstantClient
 +#             ​Administrator : Administrator
 +#             ​Runtime ​      : Runtime
 +#             ​Custom ​       : Custom
 +#
 +#​Example ​   : INSTALL_TYPE = "​Administrator"​
 +#​------------------------------------------------------------------------------
 +oracle.install.client.installType=Custom
 +#​-------------------------------------------------------------------------------
 +#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=false
 +#​------------------------------------------------------------------------------
 +# 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.3.0 -- "​Oracle SQLJ"
 +# oracle.rdbms.util:​11.2.0.3.0 -- "​Oracle Database Utilities"​
 +# oracle.javavm.client:​11.2.0.3.0 -- "​Oracle Java Client"​
 +# oracle.sqlplus:​11.2.0.3.0 -- "​SQL*Plus"​
 +# oracle.dbjava.jdbc:​11.2.0.3.0 -- "​Oracle JDBC/THIN Interfaces"​
 +# oracle.ldap.client:​11.2.0.3.0 -- "​Oracle Internet Directory Client"​
 +# oracle.rdbms.oci:​11.2.0.3.0 -- "​Oracle Call Interface (OCI)"
 +# oracle.precomp:​11.2.0.3.0 -- "​Oracle Programmer"​
 +# oracle.xdk:​11.2.0.3.0 -- "​Oracle XML Development Kit"
 +# oracle.network.aso:​11.2.0.3.0 -- "​Oracle Advanced Security"​
 +# oracle.assistants.oemlt:​11.2.0.3.0 -- "​Enterprise Manager Minimal Integration"​
 +# oracle.oraolap.mgmt:​11.2.0.3.0 -- "OLAP Analytic Workspace Manager and Worksheet"​
 +# oracle.network.client:​11.2.0.3.0 -- "​Oracle Net"
 +# oracle.network.cman:​11.2.0.3.0 -- "​Oracle Connection Manager"​
 +# oracle.network.listener:​11.2.0.3.0 -- "​Oracle Net Listener"​
 +# oracle.ordim.client:​11.2.0.3.0 -- "​Oracle Multimedia Client Option"​
 +# oracle.odbc:​11.2.0.3.0 -- "​Oracle ODBC Driver"​
 +# oracle.has.client:​11.2.0.3.0 -- "​Oracle Clusterware High Availability API"
 +# oracle.dbdev:​11.2.0.3.0 -- "​Oracle SQL Developer"​
 +# oracle.rdbms.scheduler:​11.2.0.3.0 -- "​Oracle Scheduler Agent"
 +#
 +#​-------------------------------------------------------------------------------
 +oracle.install.client.customComponents="​oracle.network.client:​11.2.0.3.0","​oracle.odbc:​11.2.0.3.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:
 +# a.MYORACLESUPPORT_DOWNLOAD
 +# b.OFFLINE_UPDATES
 +# c.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 atleast 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=
 +</​code>​
 +
 +2) OPSI Script: (Schlank und einfach *gg*)
 +<​code>​
 +[Actions]
 +DefVar $InstallDir$
 +Set $InstallDir$ ​     = "​%Systemdrive%\Oracle"​
 +
 +ShowBitmap "​%ScriptPath%\logo.png"​ "​ODBC"​
 +
 +if FileExists("​%ScriptPath%\delsub32.opsiscript"​)
 +            Sub "​%ScriptPath%\delsub32.opsiscript"​
 +            ​
 +endif
 +
 +Message "​Installiere ODBC"
 +
 +Winbatch_silent_install /​WaitForProcessEnding "​javaw.exe"​
 +Files_install
 +DosInAnIcon_import
 +
 +[Winbatch_silent_install]
 +"​%SCRIPTPATH%\setup.exe"​ -silent -noconsole -nowelcome -nowait -responseFile "​%SCRIPTPATH%\client_install.rsp"​
 +
 +[Files_install]
 +copy -s "​%ScriptPath%\tnsnames.ora"​ "​C:​\oracle\Client\network\admin\"​
 +
 +[DosInAnIcon_import]
 +reg.exe import "​%ScriptPath%\ODBC.reg"​
 +;​regedit.exe /s "​%ScriptPath%\ODBC.reg"​
 +</​code>​
 +
 +3) Exportierte ODBC Verbindungen. (ODBC.reg)
 +Diese findet Ihr unter: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC
  
 ;) ;)

QR Code
QR Code userspace:oracle_11g_odbc_client (generated for current page)