OPSI DokuWiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
**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

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

;)