/build/static/layout/Breadcrumb_cap_w.png

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login
Views: 20k  |  Created: 05/17/2006

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

Deployment Tips (17)

Most Common Setup Type
Legacy Setup with command line support
Average Package Difficulty Rating
Rated 3 / 5 (Average) based on 8 ratings
Most Commonly Reported Deployment Method
Repackaged (to a setup.msi)
140
Command Line
You can create a respons file with these parameters:

setup -record -destinationFile {response_file_name}
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
134
Command Line
setup.exe -nowait -force -silent -responseFile xyz.rsp

-nowait closes the console window when the silent installation completes, which would otherwise wait for input.

-force allows install to a not empty directory.

you might want to add -waitforcompletion if you want setup.exe to run untill installation completes, instead of forking into javaw.exe
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
131
Command Line
I found that the -waitforcompletion parameter only worked when launching the Oracle Universal Installer (OUI.EXE) directly. SETUP.EXE does not seem to use it.

OUI.EXE is found in the Install folder.
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
128
Note
On German Windows XP there is a problem creating response files. They lack the sections containing language selection and selected products to install.

To get around this, you will have to modify install\oraparam.ini. Change NLS_ENABLED=TRUE to NLS_ENABLED=FALSE. After this change response file creating works.
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
128
Command Line
-waitforcompletion -nowait -noconsole -force -silent -responseFile <file>

I didn't have any luck with the -waitforcompletion switch when I was using the setup.exe, you may have better luck with the oui.exe. I'm also not sure if you need to -nowait switch as it is for the pause at the end of the installation if your using the console.

The big addition I wanted to add is the -noconsole switch, since the silent switch just removes the gui. With the gui gone, all the output is directed to the console window which is left floating about. The -noconsole switch as its name suggests will prevent the console from being instantiated and the install is then silent.
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
123
Note

When deploying a patch like 10.2.0.3.0, you should refrain from recording your own response file for the patchset. Instead use the short and simple sample response file provided in disk1\response. This one rsp will work for deploying the patch on top of all runtime, custom and admin deployments of 10.2.0.1.

Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
120
Command Line
That little tip about using the alternative setup.exe/oui.exe from the install directory just fixed a problem I'd been having for about a week (i.e. how to get the package script to wait before running some post-installation stuff). Previously I'd been doing all sorts of checks to see when the logfile was created and then killing java.exe

God I hate the OUI.
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
8
Note
Voor windows 7 unattended install

Toevoegen van versie 6.1 in de files
stage\prereq\client_prereqs\client\refhost.xml
stage\prereq\client\refhost.xml
<!--Microsoft Windows 7-->
<OPERATING_SYSTEM>
<VERSION VALUE="6.1"/>
</OPERATING_SYSTEM>
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
  • You need to add the version in ..\install\oraparam.ini under the section [Certified versions] - ejhager 11 years ago
8
Command Line
This is what my final solution ended up looking like for a completely silent install using the custom response file:

setup.exe -NOWAIT -NOCONSOLE -FORCE -WAITFORCOMPLETION -SILENT -RESPONSEFILE "c:\Oracle10\Oracle_1\client\response\clientcustom.rsp"
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
6
Command Line
This commandline worked for an uninstall:

setup.exe -deinstall -silent -noconsole -force -removeallfiles ORACLE_HOME="PathToHome" REMOVE_HOMES={"PathToHome"}

Note: You have to make the script wait until javaw.exe is done. There are a few files left in %ProgramFiles%\Oracle and the startmenu shortcuts are not removed
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
3
Note
This Batch File worked well for me. Got it from this website.

-----------------
@ECHO OFF
ECHO Oracle 10g R2 Client 10.2.0.3 Client (FULL)..
SET OPTIONS=
SET OPTIONS=ORACLE_HOME=%SYSTEMDRIVE%\Oracle\OraHome10
SET OPTIONS=%OPTIONS% ORACLE_HOME_NAME=OraHome10
SET OPTIONS=%OPTIONS% TOPLEVEL_COMPONENT={"oracle.client","10.2.0.3.0"}
SET OPTIONS=%OPTIONS% SHOW_SPLASH_SCREEN=false
SET OPTIONS=%OPTIONS% SHOW_WELCOME_PAGE=false
SET OPTIONS=%OPTIONS% SHOW_CUSTOM_TREE_PAGE=false
SET OPTIONS=%OPTIONS% SHOW_SUMMARY_PAGE=false
SET OPTIONS=%OPTIONS% SHOW_INSTALL_PROGRESS_PAGE=true
SET OPTIONS=%OPTIONS% SHOW_CONFIG_TOOL_PAGE=false
SET OPTIONS=%OPTIONS% SHOW_XML_PREREQ_PAGE=false
SET OPTIONS=%OPTIONS% SHOW_ROOTSH_CONFIRMATION=false
SET OPTIONS=%OPTIONS% SHOW_END_SESSION_PAGE=false
SET OPTIONS=%OPTIONS% SHOW_EXIT_CONFIRMATION=false
SET OPTIONS=%OPTIONS% NEXT_SESSION=false
SET OPTIONS=%OPTIONS% NEXT_SESSION_ON_FAIL=false
SET OPTIONS=%OPTIONS% COMPONENT_LANGUAGES={"en"}
SET OPTIONS=%OPTIONS% INSTALL_TYPE="Administrator"
SET OPTIONS=%OPTIONS% oracle.client:DEPENDENCY_LIST={"oracle.winprod:10.2.0.3.0","oracle.network.client:10.2.0.3.0"}
SET OPTIONS=%OPTIONS% oracle.winprod:DEPENDENCY_LIST={"oracle.ntrdbms.admin:10.2.0.3.0","oracle.ntrdbms.perfmon:10.2.0.3.0","oracle.oo4o:10.2.0.3.0","oracle.odbc:10.2.0.3.0","oracle.ntoledb:10.2.0.3.0","oracle.ntoledb.odp_net:10.2.0.3.0"}
SET OPTIONS=%OPTIONS% oracle.has.common:OPTIONAL_CONFIG_TOOLS="{}"
SET OPTIONS=%OPTIONS% oracle.network.client:OPTIONAL_CONFIG_TOOLS="{}"
START /WAIT INSTALL\oui.exe -silent %OPTIONS% -nowelcome -noconfig -waitforcompletion -force -nowait

REM Copy configuration files for NetConfig/Net Manager
COPY THPCONFIG\*.* %SYSTEMDRIVE%\oracle\OraHome10\network\ADMIN

EXIT
---------------------------
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
3
Note
In developing a fully silent install for Oracle 10 I ended up using the vendor provided clientcustom.rsp file. In my testing I found that this response file did not install the ODBC portion of the install. After recording a response file I noticed that some entries are missing from for ODBC. Here are the entries that are missing:

# oracle.winprod:10.2.0.1.0 - Oracle ODBC
# oracle.ntoramts:10.2.0.1.0 - Oracle ODBC
# oracle.oo4o:10.2.0.1.0 - Oracle ODBC
# oracle.odbc:10.2.0.1.0 - Oracle ODBC
# oracle.ntoledb:10.2.0.1.0 - Oracle ODBC
# oracle.ntoledb.odp_net:10.2.0.1.0 -Oracle ODBC

My response filed ends up looking like this:

DEPENDENCY_LIST={"oracle.winprod:10.2.0.1.0","oracle.ntoramts:10.2.0.1.0","oracle.oo4o:10.2.0.1.0","oracle.odbc:10.2.0.1.0","oracle.ntoledb:10.2.0.1.0","oracle.ntoledb.odp_net:10.2.0.1.0","oracle.rdbms.util:10.2.0.1.0","oracle.javavm.client:10.2.0.1.0","oracle.sqlplus:10.2.0.1.0","oracle.dbjava.jdbc:10.2.0.1.0","oracle.ldap.client:10.2.0.1.0","oracle.rdbms.oci:10.2.0.1.0","oracle.precomp:10.2.0.1.0","oracle.xdk:10.2.0.1.0","oracle.swd.opatch:10.2.0.1.0","oracle.network.aso:10.2.0.1.0","oracle.oem.client:10.2.0.1.0","oracle.oraolap.mgmt:10.2.0.1.0","oracle.network.client:10.2.0.1.0","oracle.ordim.client:10.2.0.1.0","oracle.ons:10.1.0.3.0", "oracle.has.client:10.2.0.1.0"}
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
2
Note

Unattended setup is failing on windows 7 because of check on the build number. Win7 version is 6.1, oracle client check for version 6.0

Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
2
Command Line
Installation Command Line:
---------------------------

OUI.exe -NOWAIT -NOCONFIG -NOCONSOLE -FORCE -WAITFORCOMPLETION -SILENT -RESPONSEFILE "C:\Source\Response\clientadmin.rsp"

OR

Setup.exe -NOWAIT -NOCONFIG -NOCONSOLE -FORCE -WAITFORCOMPLETION -SILENT -RESPONSEFILE "C:\Source\Response\clientadmin.rsp"

(Both Oui.exe and Setup.exe worked fine for me. However, I feel using Oui.exe is better as it wait untill the installation completes. Where as Setup.exe disappears soon after the initial installation triggers).


Uninstallation Command Line:
-----------------------------

Setup.exe -deinstall -silent -noconsole -force -removeallfiles ORACLE_HOME="HomeName" REMOVE_HOMES={"PathToHome"}

Setup.exe can be found from the installed files in the destination machine. Eg: C:\Oracle\Product\10.2.0\Client_1\OUI\Bin\Setup.exe

HomeName is the name of the Oracle Client installed in the machine. Eg: "OraClient10g_home1"

PathToHome is the path where the Oracle files are installed in the destination machine. Eg: "C:\Oracle\Product\10.2.0\Client_1"

(The values of "HomeName" and "PathToHome" may vary according to the different Oracle products installed in to the machine.
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
2
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
-1
Note

@Nate630:

Thanks for the script, it helped me a lot! Nearing the end of the installation though, there are 2 pop-ups with the MSIexec help screen. I've looked through the script and the installer files, but there's no reference of an MSI or msiexec, so where does this come from?

Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
-5
Note

I just like to add: Contrary to what most people seem to say, I found repacking a lot better than using it's own unattended setup. It's fairly easy to repackage Oracle into a MSI and afterwards the deployment gives far less trouble (the setup always seems to find a excuse to fail again)

Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows

Inventory Records (1)

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

Versions

Oracle Client

Version

10

Questions & Answers (18)

Questions & Answers related to Oracle Oracle Client

5
ANSWERS
4
ANSWERS
1
ANSWERS
1
ANSWERED
4
ANSWERS
3
ANSWERS
5
ANSWERS
7
ANSWERS
10
ANSWERS

Blogs (0)

Blog posts related to Oracle Oracle Client

Reviews (0)

Reviews related to Oracle Oracle Client

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ