Up until recently, I’ve had the good fortune not have had to use Oracle to host the Presentation Server data store and so I’ve never had to script the Oracle client installation either. Fortunately it’s a pretty simple process:
For full details on the Oracle client setup, see the following page on the Oracle site:
A Oracle Database Client Advanced Installation Topics
This install script uses command line variables instead of a response file so that all installation components are in a single script. Full installation details are in the documentation that comes with the client. The last command copies the files that configure the Oracle client with a database connection. I created those configuration files by performing a manual installation and configuration on the first server with Presentation Server using Oracle to host the data store. These files are SQLNET.ORA and TNSNAMES.ORA and I’ve placed them in a folder named config ready for copy after setup is complete.
@ECHO OFF
ECHO Oracle 10g R2 Client..
SET OPTIONS=
SET OPTIONS=ORACLE_HOME=%SYSTEMDRIVE%\oracle\product\10.2.0\client_1
SET OPTIONS=%OPTIONS% ORACLE_HOME_NAME=OraClient10ghome1
SET OPTIONS=%OPTIONS% TOPLEVEL_COMPONENT={"oracle.client","10.2.0.1.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="Custom"
SET OPTIONS=%OPTIONS% oracle.client:DEPENDENCY_LIST={"oracle.winprod:10.2.0.1.0","oracle.network.client:10.2.0.1.0"}
SET OPTIONS=%OPTIONS% oracle.winprod:DEPENDENCY_LIST={"oracle.ntrdbms.admin:10.2.0.1.0","oracle.ntrdbms.perfmon: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"}
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 CONFIG\*.* %SYSTEMDRIVE%\oracle\product\10.2.0\client_1\NETWORK\ADMIN
This process should work for the Oracle 9i client as well.
