Views: 18.4k  |  Created: 07/27/2009

Average Rating: 0
Oracle Client has 1 inventory records, 23 Questions, 0 Blogs and 3 links. Please help add to this by sharing more!

Deployment Tips (14)

Most Common Setup Type
Legacy Setup with command line support
Average Package Difficulty Rating
Rated 3 / 5 (Average) based on 7 ratings
Most Commonly Reported Deployment Method
Vendor Provided Command Line (answer file driven)
or cancel
25
Command Line
To create the response file for Oracle Client 11.2g I had to call Setup.exe without any command line parameters. On the 6th dialog window there was a button to save the response file. The silent installation worked with the command line:

"\\server\share\Setup.exe" -waitforcompletion -responseFile "\\server\share\file.rsp" -force -silent -noconsole

To uninstall it I had to download the uninstall tool from Oracle (credentials required):

http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_deinstall.zip
or
http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_deinstall.zip
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
  • Note: the option -responseFile is case-sensitive!
Please log in to comment
6
Note

Silent mode won't work from the c:\temp folder on Win7. Had me chasing my tail for hours.

Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
6
Command Line
I managed to uninstall the Oracle client using the following:
C:\>cd \app\oracle\product\11.2.0\client_1\deinstall
C:\app\oracle\product\11.2.0\client_1\deinstall\> deinstall.bat -silent
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
5
Command Line
I attempted to create a response file from the command line and had no luck.

Setup.exe -record -responseFile c:\client.rsp

I ran the setup.exe and right before installing, there is an option to save a response file. I was able then to run the setup with the reponse file.

Setup.exe -responseFile c:\client.rsp
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
5
Note
Oracle 11g R1 is not supported with Windows 7, R2 supports it. R1 will still install by hand on Windows 7 after failed prerequisites and checking the corresponding check box. If you try to automate it will not finish because of the same failed prerequisites. I found a work around for this:

Add a Windows 7 entry into the refhost.xml

Location of this file on my system:
c:\unpacked_client_installation\win32_11gR1_client\client\stage\prereq\client\refhost.xml

newly edited refhost.xml file:


<CERTIFIED_SYSTEMS>
<OPERATING_SYSTEM>
<!--Microsoft Windows 2000-->
<VERSION VALUE="5.0"/>
<SERVICE_PACK VALUE="1"/>
</OPERATING_SYSTEM>
<OPERATING_SYSTEM>
<!--Microsoft Windows XP-->
<VERSION VALUE="5.1"/>
<SERVICE_PACK VALUE="1"/>
</OPERATING_SYSTEM>
<OPERATING_SYSTEM>
<!--Microsoft Windows 2003-->
<VERSION VALUE="5.2"/>
</OPERATING_SYSTEM>
<!--Microsoft Windows Vista-->
<OPERATING_SYSTEM>
<VERSION VALUE="6.0"/>
</OPERATING_SYSTEM>
<!--Microsoft Windows 7-->
<OPERATING_SYSTEM>
<VERSION VALUE="6.1"/>
</OPERATING_SYSTEM>
</CERTIFIED_SYSTEMS>

New lines are added at the end of this excerpt after <!--Microsoft Windows 7-->. Notice version value=6.1.

With new refhost.xml file all checks passed.
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
3
Note
The section of the OUI where it runs the 'Configuration Assistants' would hang indefinitely. I worked out that this was due to some Java foul-up or other. I tried so many flavours of JREs as pre-requisites (thank heavens for VMWare!) but it would always hang.

Terminating the 'java.exe' process caused the installer to display an error but luckily allowed me to re-try the operation. I clicked 'Retry' and within a blink, the installer was happy again.
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
3
Command Line
I recorded the response file using:

setup.exe -record -destinationFile c:\OraInst\rec.rsp
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
3
Note

The install does not allow relative paths for response file. So giving %~dp0 in the command file would not install the application. Its better to copy the .rsp file locally and run from there.

Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
2
Script
I had to use a vbs script to get this to install using SCCM 2007. It also comes in handy (with little modification) when using .iss files for silent deployment because you don't have to copy the .iss file to the local drive. So all I did was run the gui setup.exe then saved the response file. Hope this helps someone save some time. Disclaimer: I suck at this. ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// strComputer = "." strFolder = ".\" Set oShell= CreateObject("WScript.Shell") Set oFSO = CreateObject("Scripting.FileSystemObject") Set oFolder = oFSO.GetFolder(strFolder) 'Insert full command line in between the quotes below cmdLine = """" & oFolder.Path & "\setup.exe"" -nowait -noconsole -force -waitforcompletion -silent -responseFile " & """" & oFolder.Path & "\client.rsp""" i = oShell.Run (cmdLine, 0, True) Set oShell = nothing WScript.Sleep 60000 Set oWMIService = GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") 'Insert process name in between the apostrophes below sQuery = "Select * from Win32_Process Where Name = 'oui.exe'" Set cProc = oWMIService.ExecQuery(sQuery) iniProc = cProc.Count Do While iniProc = 1 WScript.Sleep 5000 Set oWMIService = GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") 'Insert process name in between the apostrophes below sQuery = "Select * from Win32_Process Where Name = 'oui.exe'" Set cProc = oWMIService.ExecQuery(sQuery) iniProc = cProc.Count Loop Set cProc = nothing Set oWMIService = nothing WScript.Quit(i) ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
2
Script
REM Create the install directory mkdir C:\oracle64 REM Copy the response file copy /Y client.rsp C:\oracle64\client.rsp REM Call the response file start /wait setup.exe -silent -noconsole -nowelcome -nowait -responseFile "C:\oracle64\client.rsp" REM Create the network\admin directory in case it isn't there yet mkdir C:\oracle64\product\11.2.0\client_1\network\admin REM Copy a custom tnsnames.ora included in the zipped package to the directory copy /Y tnsnames.ora C:\oracle64\product\11.2.0\client_1\network\admin\tnsnames.ora REM Create a directory for the Oracle ODBC drivers mkdir C:\oracle64\product\11.2.0\client_1\instantclient\ REM Copy the contents of the ODBC directory to the directory xcopy /E /Y odbc\* C:\oracle64\product\11.2.0\client_1\instantclient REM Registry key entries to create a DSN. Replace tnsdbname with the TNS name of your DB. reg add "HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\Environment" /v TNS_Admin /d C:\oracle64\product\11.2.0\client_1\network\admin reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources" reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources" /v tnsdbname /d "Oracle in instantclient_11_2" reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v Driver /d c:\oracle\instantclient\instantclient_11_2\SQORA32.dll reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v DisableRULEHint /d T reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v Attributes /d W reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v FetchBufferSize /d 64000 reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v NumericSettin /d NLS reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v "ForceWCHAR /d F reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v FailoverDelay /d 10 reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v FailoverRetryCount /d 10 reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v MetadataIdDefault /d F reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v BindAsFLOAT /d F reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v BindAsDATE /d F reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v CloseCursor /d F reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v EXECSchemaOpt /d "" reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v EXECSyntax /d F reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v Application Attributes /d T reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v ResultSets /d T reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v QueryTimeout /d T reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v CacheBufferSize /d 20 reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v StatementCache /d F reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v Failover /d T reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v Lobs /d T reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v DisableMTS /d T reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v DisableDPM /d F reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v BatchAutocommitMode /d IfAllSuccessful reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v Description /d tnsdbname reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v ServerName /d tnsdbname reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v Password /d "" reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v UserID /d "" reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\tnsdbname" /v DSN /d tnsdbname REM Run the ODBC install. I have noted this sometimes doesn't work, you can run it as admin later. C:\oracle64\product\11.2.0\client_1\instantclient\odbc_install.exe
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
1
Note
I install to C:\oracle or C:\oracle64 pending the client bitness. In Windows 7, remember to choose the correct ODBC control panel. There is a different ODBC panel for 32-bit hidden in syswow64. •After installation, you will need to run C:\oracle64\product\11.2.0\client_1\instantclient\odbc_install.exe by right clicking it and running it as administrator. It will display a brief DOS prompt and you can click to say the program installed correctly. •Run C:/Windows/system32/odbcad.exe •Change to the System DSN tab. •Choose the appropriate connection (created by the KACE installation if you used my registry notes) and click configure. •You can enter the username for the connection if it is not already filled in. Use the following for the DSN propeties if you want to use the Oracle ODBC with Access or Excel: •On the Application tab, make sure only the following boxes are checked: •Enable Result Sets •Enable Query Timeout •Read-Only Connection •Enable Thread Saftey •On the Oracle tab, make sure only the following boxes are checked: •Enable LOBs •Enable Statement Caching •Enable Failover •Still on the Oracle tab, make the following changes to settings: •The Fetch Buffer Size should be equal to or greater than 128000. •The Cache Buffer Size should be equal to or greater than 2000. •The Enable Failover Retry and Delay settings should both equal 10. •On the Workarounds tab, make sure only the following boxes are checked: •Bind TIMESTAMP as DATE •Bind NUMBER as FLOAT •Disable RULE hint •It is extremely important to uncheck Disable Microsoft Transaction Server on the Workarounds tab. This is selected by default and significantly slows down linked table queries through Access.'
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
0
Script

A simple script for deploy with SCCM 2007:

________________________________________________________________

Dim oShell, sFolder, sCmd, iReturn
Set oShell = WScript.CreateObject("WScript.Shell")

sFolder = Left(WScript.ScriptFullName, Len(WScript.ScriptFullName) - Len(WScript.ScriptName))
set oEnv = oShell.Environment("PROCESS")

oEnv("SEE_MASK_NOZONECHECKS") = 1
sCmd = sFolder & "win32\setup.exe -force -silent -waitforcompletion -noconsole -nowelcome -responseFile " & sFolder & "win32\response\response.rsp"

iReturn = oShell.Run(sCmd, 0, true)
oEnv.Remove("SEE_MASK_NOZONECHECKS")
Set oShell = Nothing

Setup Information:
Setup Type: Legacy Setup with command line support
Deployment Method Used: Vendor Provided Command Line (answer file driven)
Deployment Difficulty: Very Easy
Platform(s): Windows
Please log in to comment
-2
Command Line

From the command line run setup.exe -help to view all available commands. Create a response file for an automated install.

Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
-8
Command Line

I handled the 11G package with the ODT plugin package by doing a full repackage into an MSI. It was not easy, and was a long and drawn out process, however the benefits were fantastic. All our oracle apps are now packaged and we don't have to deal with the Oracle installer failing and stupidly updating files and registry entries.

Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment

Inventory Records (1)

View inventory records anonymously contributed by opt-in users of the K1000 Systems Management Appliance.

Versions

Oracle Client

Version

11

Questions & Answers (23)

Questions & Answers related to Oracle Oracle Client

1
ANSWERED
1
ANSWERS
4
ANSWERS
5
ANSWERS
5
ANSWERS
4
ANSWERS
11
ANSWERS
4
ANSWERS
1
ANSWERS
2
ANSWERS
28
ANSWERS

Blogs (0)

Blog posts related to Oracle Oracle Client

Reviews (0)

Reviews related to Oracle Oracle Client