Oracle 11g Client & SysWow64/ODBCAD32

Antworten
SmEe
Beiträge: 7
Registriert: 18 Feb 2016, 08:56

Oracle 11g Client & SysWow64/ODBCAD32

Beitrag von SmEe »

Hallo Community,

anbei auch mal ein kleiner Beitrag von meiner Seite! Hoffe, das hilft jemanden weiter!

Installation von Oracle (NetClient & ODBC Schnittstelle) in der Version 11g.
Sowie ein Reg-File import für die ODBC Schnittstelle.


1) Oracle Setup für Silent-Installation vorbereiten. (AntwortFile)
Mehr unter: https://docs.oracle.com/cd/B28359_01/in ... m#CIHEAGGJ

Meine client_install.rsp:

Code: Alles auswählen

###############################################################################
## 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*)

Code: Alles auswählen

[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

...in diesem Sinne!

LG! ;)
Benutzeravatar
n.wenselowski
Ex-uib-Team
Beiträge: 3194
Registriert: 04 Apr 2013, 12:15

Re: Oracle 11g Client & SysWow64/ODBCAD32

Beitrag von n.wenselowski »

Hi,

sehr cool!

Willst du das vllt zur besseren Auffindbarkeit ins Wiki schreiben?
Dort gibt es schon eine Reihe von Vorlagen.


Gruß

Niko

Code: Alles auswählen

import OPSI
SmEe
Beiträge: 7
Registriert: 18 Feb 2016, 08:56

Re: Oracle 11g Client & SysWow64/ODBCAD32

Beitrag von SmEe »

Hmmm, wenn ich einen Button finden würde, der 'neu' heist, dann würde ich es machen! 8)
larsg
Beiträge: 283
Registriert: 16 Dez 2014, 18:06

Re: Oracle 11g Client & SysWow64/ODBCAD32

Beitrag von larsg »

du klickst im gewünschten abschnitt auf edit,
dann trägst du den titel für deinen beitrag ein, einfach einen anderen link als vorlage nehmen und abändern.
wenn du dann auf den link klickst, kannst du deinen beitrag darunter speichern.

zumindest hab ich es so gemacht :D

wenn ich mal mehr zeit habe, werd ich da auch einiges einstellen, was sich bei mir so angesammelt hat.

die oracle-geschichte wird für mich sicher noch interessant, werd ich mir mal merken. danke!
SmEe
Beiträge: 7
Registriert: 18 Feb 2016, 08:56

Re: Oracle 11g Client & SysWow64/ODBCAD32

Beitrag von SmEe »

...na, geht doch! ;)
Antworten