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:
############################################################################### ## 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=
2) OPSI Script: (Schlank und einfach *gg*)
[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"
3) Exportierte ODBC Verbindungen. (ODBC.reg) Diese findet Ihr unter: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC
;)