1 / 36

Oracle Client Deployment Within a Large Corporate Environment Revisited

Oracle Client Deployment Within a Large Corporate Environment Revisited. Steve Recsky Complete DBA Inc. A Partner of First4 Database Partners Inc. First4 Database Partners Inc. Original Scenario. Update/Install Oracle Client software onto 4000+ desktops Must use SMS for deployment

mercedes
Download Presentation

Oracle Client Deployment Within a Large Corporate Environment Revisited

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle Client Deployment Within a Large Corporate EnvironmentRevisited Steve Recsky Complete DBA Inc. A Partner of First4 Database Partners Inc. First4 Database Partners Inc.

  2. Original Scenario • Update/Install Oracle Client software onto 4000+ desktops • Must use SMS for deployment • Can’t use net change method • Wipe of existing Oracle Client installation deemed not feasible • Reconcile existing ODBC DSN definitions • Support all existing applications that utilize the Oracle Client First4 Database Partners Inc.

  3. Current Scenario • New client stack only rolled out for new base-builds • Installed directly after base OS image applied • Oracle client stack adds 45-minutes to base image build process First4 Database Partners Inc.

  4. Future Scenario • New client stack needs to be made available on new Windows 7 OS First4 Database Partners Inc.

  5. The Stack • Windows XP SP2 – 32bit • Oracle Versions Required7.3.48.1.7.49.2.0.810.2.0.411.1.0.711.2.0.1 • Cumulative Patch Update (CPU) or Patch Set Update (PSU) Above Red Line De-supported New requirement since last presentation First4 Database Partners Inc.

  6. Directory Structure • c:\oracle\product • 7.3.4 • 8.1.7 • 9.2.0 • 10.2.0\client_1 • 11.1.0\client_1 • 11.2.0\client_1 First4 Database Partners Inc.

  7. SMS Restrictions • Visual Basic Script • Windows Command Script (limited support) First4 Database Partners Inc.

  8. Clean Up • Clean up is no longer a viable option due to the unknown nature of both the base-build and custom Oracle client configuration First4 Database Partners Inc.

  9. Oracle Universal Installer (OUI)Modes of Installation • Interactive • Uses the graphical user interface to walk through the installation • Suppressed • Supplies the necessary information by using a combination of a response file or command line entries with certain interactive dialogs • Silent • Bypasses the graphical user interface and supply the necessary information in a response file First4 Database Partners Inc.

  10. Silent Install – 7.3.4 • See Metalink Note:73962.1 • From the SMS directory orainst.exe /silent /rspsrc 734.rsp /install appuser • No patching required First4 Database Partners Inc.

  11. Silent Install – 8.1.7.4 • 1.7.1.10 Installer setup.exe -responseFile 171_oui.rsp -silent -nowelcome –nowait • 8.1.7.0 Client setup.exe –responseFile 817_custom.rsp -silent –nowelcome • 8.1.7.4 Patch Set setup.exe -responseFile 8174_patchset.rsp -silent -nowelcome -nowait First4 Database Partners Inc.

  12. Silent Install – 9.2.0.8 • 9.2.0.1 Client setup.exe -responseFile 920_custom.rsp -silent -nowelcome -nowait -waitforcompletion • Stop Oracle MTS Recovery Service net stop OracleMTSRecoveryService • 9.2.0.7 Oracle Data Access Components setup.exe -responseFile ODBC_custom.rsp -silent -nowelcome -nowait –waitforcompletion setup.exe -responseFile OLEDB_custom.rsp -silent -nowelcome -nowait –waitforcompletion setup.exe -responseFile OO4O_custom.rsp -silent -nowelcome -nowait -waitforcompletion • 9.2.0.8 Patch Set setup.exe -responseFile 9208_patchset.rsp -silent -nowelcome -nowait -waitforcompletion First4 Database Partners Inc.

  13. Silent Install – 9.2.0.8 • Update OPatch - Patch 6880880 rename C:\oracle\product\9.2.0\OPatch OPatch.old mkdir C:\oracle\product\9.2.0\OPatch xcopy /Y /E …\OPatch C:\oracle\product\9.2.0\OPatch • Need Perl • Install Active Perl on Network • Apply CPU – Note 735216.1 – October 2008 SET PERL5LIB=…\Perl\lib SET ACTIVE_STATE_PERL=TRUE set ORACLE_HOME="C:\oracle\product\9.2.0" set INVENTORY_LOC="C:\Program Files\Oracle\Inventory" pushd …\dba\9i\Windows\32-bit\patch\7394394 …\perl\bin\perl %ORACLE_HOME%\OPatch\opatch.pl apply -oh %ORACLE_HOME% -silent popd First4 Database Partners Inc.

  14. Silent Install – 10.2.0.4 • 10.2.0.1 Client oui.exe -responseFile 1020_custom.rsp -silent -nowelcome -nowait -waitforcompletion • 10.2.0.4 Patch Set oui.exe -responseFile 10204_patchset.rsp -silent -nowelcome -nowait –waitforcompletion • Update OPatch - Patch 6880880 rename C:\oracle\product\10.2.0\client_1\OPatch OPatch.old mkdir C:\oracle\product\10.2.0\client_1\OPatch xcopy /Y /E …\6880880\OPatch C:\oracle\product\10.2.0\client_1\OPatch First4 Database Partners Inc.

  15. Silent Install – 10.2.0.4 • Must have a generated response file by this point by running OCM Response File Generation Utility: %ORACLE_HOME%\OPatch\ocm\bin\emocmrsp.bat • Apply CPU – Note 735216.1 – October 2008 set ORACLE_HOME="C:\oracle\product\10.2.0\client_1" pushd …\7386320 %ORACLE_HOME%\OPatch\OPatch apply -silent -ocmrf …\ocmrf\ocm.rsp popd First4 Database Partners Inc.

  16. Silent Install – 11.1.0.7 • 11.1.0.6 Client oui.exe -responseFile …\1110_custom.rsp -silent -nowelcome -nowait -waitforcompletion • 11.1.0.7 Patch Set oui.exe -responseFile 11107_patchset.rsp -silent -nowelcome -nowait –waitforcompletion • Update OPatch - Patch 6880880 rename C:\oracle\product\11.1.0\client_1\OPatch OPatch.old mkdir C:\oracle\product\11.1.0\client_1\OPatch xcopy /Y /E …\6880880\OPatch C:\oracle\product\10.2.0\client_1\OPatch • No October 2008 CPU for 11.1.0.7 First4 Database Partners Inc.

  17. Silent Install – 11.2.0.1 • 11.2.0.1 Client oui.exe -responseFile 1120_custom.rsp -silent -nowelcome -nowait -waitforcompletion • Update OPatch - Patch 6880880 rename C:\oracle\product\11.1.0\client_1\OPatch OPatch.old mkdir C:\oracle\product\11.1.0\client_1\OPatch xcopy /Y /E …\6880880\OPatch C:\oracle\product\11.2.0\client_1\OPatch • Apply Critical Patch Update August 2010 (9966925) set ORACLE_HOME=C:\oracle\product\11.2.0\client_1 pushd …\9966925 %ORACLE_HOME%\OPatch\OPatch apply -silent -ocmrf …\ocmrf\ocm.rsp popd First4 Database Partners Inc.

  18. Customizing and Creating Response Files • Creating a Response File With Record Mode setup -record -destinationFile C:\response_files\install_oracle910 (on Windows) ./runInstaller -record -destinationFile /private/temp/install_oracle91.rsp (on UNIX) • Response File Format • Variable Values • Comments • Headers • Response File Parameters First4 Database Partners Inc.

  19. Using OUI Exit Codes • OUI returns one of the following exit codes: • 0 • All installations were successful. • 1 • All installations were successful but some optional configuration tools failed. • -1 • At least one installation failed First4 Database Partners Inc.

  20. ORAPARAM.INI File • File includes information that defines the behavior of certain Oracle Universal Installer features • BOOTSTRAP • Set to TRUE or FALSE. This parameter instructs Oracle Universal Installer to attempt a bootstrap. Set to TRUE before cutting CDs, but set to FALSE once you have copied the staging area to the hard disk. First4 Database Partners Inc.

  21. PATH c:\oracle\product\11.1.0\client_1\bin;c:\oracle\product\10.2.0\client_1\bin;c:\oracle\product\9.2.0\jre\1.4.2\bin\client;c:\oracle\product\9.2.0\jre\1.4.2\bin;c:\oracle\product\9.2.0\bin;C:\Program Files\Oracle\jre\1.1.8\bin;c:\oracle\product\8.1.7\bin;C:\Program Files\Oracle\jre\1.1.7\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\IXOS\IXOS-eCONtext\bin;;c:\oracle\product\7.3.4\BIN; • PATH will have access to binaries in the same order they were installed First4 Database Partners Inc.

  22. OUI and PATH First4 Database Partners Inc.

  23. The New Project • Support new Wave 3 project • Windows 7 desktop • Sharepoint 2010 • Exchange 2010 • Office 2010 • Oracle Client Stack • Microsoft SQL Server Client Stack First4 Database Partners Inc.

  24. Application Virtualization • Virtualize the application so it has everything it needs to run by itself within a “bubble” and not affect any other applications • Oracle 7.3.4 Client • - Application 1 • Oracle 11.2.0 Client • Oracle ODBC Driver • - Application 2 • SQL Server 2008 R2 Client • - Application 3 First4 Database Partners Inc.

  25. Application Virtualization • Application run on the local PC and uses local resources • Application can be upgraded and its dependent software patched and/or migrated to new supportable releases • Application is secured so that end-users cannot corrupt the original installation First4 Database Partners Inc.

  26. Methods • Standalone • Applications are encapsulated into a single executable • Executables can run directly from any media (USB, CDROM, local disk, etc) • Centrally controlled access • Virtualized applications are distributed through a central deployment tool • Locally installed agent is typically required First4 Database Partners Inc.

  27. Some Solutions • Microsoft Application Virtualization (App-V) • Citrix XenApp • VMWare ThinApp • Novell ZENworks • Altiris • LANDesk • Endeavors Technologies – Application Jukebox • Xenocode Virtual Application Studio • Symantec Endpoint Virtualization Suite • AppZero First4 Database Partners Inc.

  28. Comparison Chart http://virtualfuture.info/wp-content/uploads/2009/08/ApplicationVirtCompChart2009.pdf First4 Database Partners Inc.

  29. Pros/Cons? • Con - Majority of solutions out there require infrastructure that serves up the virtualized applications to the desktops • Pro – Encapsulation; each application is in its own bubble • Con – Another layer to worry about • Pro – Only the database client required for each application are installed • Con – Must track which database clients are in use for patching • Pro – Patches can be specifically applied to meet the needs of a specific application First4 Database Partners Inc.

  30. Windows 7 Challenges Windows XP Version is 5.1.2600.5512 Windows 7 Version is 6.1.7600.16385 First4 Database Partners Inc.

  31. Oracle 7 and 8i • RunAS Administrator – Interactive First4 Database Partners Inc.

  32. Oracle 9i • Copied code locally and modified all setup.exe compatibility settings to XP • RunAS Administrator – Interactive • Will see 2 x PSAPI.dll errors • Process Status Helper First4 Database Partners Inc.

  33. Oracle 10g • RunAS Administrator – Interactive • Copied source code locally • Modified compatibility and runas properties on oui.exe executables First4 Database Partners Inc.

  34. Oracle 10g (continued…) • Added the following to the ...\client\stage\prereq\client\refhost.xml file:<!--Microsoft Windows 7--> <OPERATING_SYSTEM> <VERSION VALUE="6.1"/> </OPERATING_SYSTEM> First4 Database Partners Inc.

  35. Oracle 11g • RunAS Administrator – InteractiveExpected result: One of 5.0,5.1,5.2,6.0Actual Result: 6.1Check complete. The overall result of this check is: Failed <<<<Check complete: Failed <<<< • This continued to fail even with passing the installer option -ignoreSysPrereqs and modifying the oraparam.ini file. • Added the following to the ...\client\stage\prereq\client\refhost.xml file:<!--Microsoft Windows 7--> <OPERATING_SYSTEM> <VERSION VALUE="6.1"/> </OPERATING_SYSTEM> First4 Database Partners Inc.

  36. The EndSteve.Recsky@First4db.com First4 Database Partners Inc.

More Related