Need to Ps1 script for Oracle database client

TechUST 516 Reputation points
2024-10-27T19:22:09.4266667+00:00

I want to package the Oracle Database 19c client through PowerShell to deploy it via SCCM. Can you help me create the PowerShell script.

https://www.oracle.com/database/technologies/oracle19c-windows-downloads.html

1000106660

Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
1,009 questions
Microsoft Intune
Microsoft Intune
A Microsoft cloud-based management solution that offers mobile device management, mobile application management, and PC management capabilities.
5,176 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,577 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. XinGuo-MSFT 18,766 Reputation points
    2024-10-28T07:44:02.5233333+00:00

    Hi,

    You should be looking for the documentation for running the installation using a response file. Running Oracle Universal Installer Using the Response File

    After creating the response file, run Oracle Univeral Installer at the command line, specifying the response file you created, to perform the installation.

    DRIVE_LETTER:\setup.exe_location setup [-silent] "variable=setting" [-nowelcome] [-noconfig] [-nowait] -responseFile filename 
    

    Here is an example of a batch script that I use.

    The script runs with a single click to install the Oracle Client.

    cd "c:\src\oracle" powershell Expand-Archive c:\src\oracle\V982658-01.zip c:\src\oracle c:\src\oracle\client\setup.exe -silent -showprogress -nowait -noconfig -responseFile C:\src\oracle\client.rsp
    

    Here are some lines from my response file

    ORACLE_HOME=C:\oracle\product\19.0.0\client_1 oracle.install.client.customComponents=oracle.rdbms.util:19.0.0.0.0,oracle.sqlplus:19.0.0.0.0,oracle.network.client:19.0.0.0.0,oracle.odbc:19.0.0.0.0,oracle.ntoledb.odp_net_2:19.0.0.0.0
    

    Database Client Installation Guide for Microsoft Windows https://docs.oracle.com/en/database/oracle/oracle-database/19/ntcli/reasons-for-using-silent-mode-or-response-file-mode.html

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.