### Start Oracle Database Client Installation

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sscli/running-oracle-universal-installer-to-install-oracle-database-client.html

Use this command sequence to navigate to the directory containing the installation binaries and launch the Oracle setup wizard to begin the client installation.

```bash
$ cd /home/oracle_sw/
$ ./runInstaller
```

--------------------------------

### Start Oracle Database Setup Wizard

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/ntdbi/install-oracle-database.html

Run `setup.exe` from the Oracle home directory to launch the Oracle Database Setup Wizard and begin the installation process.

```cmd
C:\app\oracle\product\19.0.0\dbhome_1>setup.exe
```

--------------------------------

### Start Oracle Database Setup Wizard

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/axdbi/running-oracle-universal-installer-to-install-oracle-database.html

Navigate to the Oracle home directory and execute the runInstaller command to launch the Oracle Database Setup Wizard for installation.

```bash
$ cd /u01/app/oracle/product/19.0.0/dbhome_1
$ ./runInstaller
```

--------------------------------

### Start Oracle Database Client Setup Wizard

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sscli/installing-database-client-using-image-files.html

Execute these commands from the Oracle home directory to launch the `runInstaller` and begin the Oracle Database Client installation process.

```bash
$ cd /u01/app/oracle/product/19.0.0/client_1
$ ./runInstaller
```

--------------------------------

### Start Oracle Instant Client Installation on Linux

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/lacli/running-oui-instant-client.html

Use this command to launch the Oracle Instant Client setup wizard after extracting the client zip file.

```bash
$ ./runInstaller

```

--------------------------------

### Start Oracle Grid Infrastructure Setup Wizard

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/axdbi/installing-oracle-grid-infrastructure-for-a-standalone-server-with-a-new-database-installation.html

Execute this command from the Grid home directory to launch the Oracle Grid Infrastructure setup wizard and begin the installation process.

```bash
$ Grid_home/gridSetup.sh
```

--------------------------------

### Start Oracle Grid Infrastructure Installation Wizard

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/ntdbi/installing-software-binaries.html

Execute the setup executable to launch the Oracle Grid Infrastructure installation wizard and begin the software-only installation process.

```cmd
C:\> app\oracle\product\19.0.0\grid\setup.exe
```

--------------------------------

### Start Oracle Database Software Installation

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/riwin/installing-oracle-rac-and-oracle-rac-one-node-database-software.html

Navigate to the Oracle home directory and execute the setup program to begin the Oracle Database software installation. Ensure this command is run only from the Oracle home directory.

```cmd
cd C:\app\oracle\product\19.0.0\dbhome_1
setup.exe
```

--------------------------------

### Launch Grid Setup Wizard on Linux/UNIX

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwadd/oracle-clusterware-administration.html

Execute this command to start the Grid Setup Wizard on Linux or UNIX systems after a software-only installation.

```bash
Oracle_home/gridSetup.sh
```

--------------------------------

### Run Oracle Installer from Hard Disk

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/hpcli/running-oracle-universal-installer-to-install-oracle-database-client.html

Execute these commands to navigate to the downloaded installation binaries on a hard disk and start the Oracle Database Client setup wizard.

```bash
$ cd /home/oracle_sw/
$ ./runInstaller
```

--------------------------------

### SRVCTL Start ASM Examples

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwadd/server-control-command-reference.html

Examples demonstrating how to start an Oracle ASM instance on a specific node or on all nodes in a cluster/non-cluster database.

```bash
$ srvctl start asm -node crmnode1
```

```bash
$ srvctl start asm
```

--------------------------------

### Start Test DNS Server: Example

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwadd/oracle-clusterware-control-crsctl-utility-reference.html

Example of starting a test DNS server on a specific IP address and port with verbose output.

```bash
$ crsctl start testdns -address 192.168.29.218 -port 63 -v
```

--------------------------------

### Example: Starting Oracle Restart Components in an Oracle Home

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/configuring-automatic-restart-of-an-oracle-database.html

Concrete example demonstrating how to start components managed by Oracle Restart in a specific Oracle home, using a previously saved state file.

```bash
srvctl start home -oraclehome /u01/app/oracle/product/database_release_number/dbhome_1 -statefile /usr1/or_state
```

--------------------------------

### Example Local Installation Directory on Windows

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/otgiw/gateways-install-overview.html

This example shows a local directory path where installation media contents can be copied on a Windows system to facilitate faster installation.

```text
d:\install\Disk1
```

--------------------------------

### Run Oracle Database Client installer from Oracle home directory

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/axcli/installing-database-client-using-image-files.html

Navigate to the Oracle home directory and execute the runInstaller command to start the Oracle Database Client Setup Wizard. Must be run from the Oracle home directory only, not from $ORACLE_HOME/oui/bin/ or other locations.

```bash
$ cd /u01/app/oracle/product/19.0.0/client_1
$ ./runInstaller
```

--------------------------------

### Start Oracle Universal Installer

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/appcw/appc-gateway-installation.html

This command launches the Oracle Universal Installer from the installation media, assuming the media is mapped to the D: drive.

```cmd
D:\Disk1\setup.exe
```

--------------------------------

### Start Oracle Universal Installer

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/axdbi/checking-installed-oracle-database-contents-and-directory-location.html

Execute this command from the `$ORACLE_HOME/oui/bin` directory to launch the Oracle Universal Installer.

```bash
$ ./runInstaller
```

--------------------------------

### Run Setup with Response File

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwwin/continuing-upgrade-when-upgrade-fails-on-the-first-node.html

Navigate to the Grid home and run setup.exe with the -executeConfigTools flag and a specified response file to complete the upgrade.

```batch
C:\> cd Grid_home\crs\config
```

```batch
C:\Grid_home> setup.exe -executeConfigTools -responseFile Grid_home\install\response\gridinstall.rsp
```

--------------------------------

### Install TFA as Root on Linux/UNIX

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/atnms/quick-start-guide.html

Execute this command as the root user to install Oracle Trace File Analyzer. The installer will guide you through local or cluster setup.

```bash
$ ./installTFA-platform
```

--------------------------------

### Completing Installation with setup.exe and Response File

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwwin/continuing-incomplete-installations-on-first-nodes.html

After configuring a response file, use `setup.exe` with the `--executeConfigTools` flag and specify the response file path to complete the installation.

```cmd
C:\> cd app\19.0.0\grid\
setup.exe --executeConfigTools -gridinstall.rsp CRS_home/install/response/gridinstall.rsp 
```

--------------------------------

### Launch Grid Setup Wizard on Windows

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwadd/oracle-clusterware-administration.html

Execute this command to start the Grid Setup Wizard on Windows systems after a software-only installation.

```batch
Oracle_home\gridSetup.bat
```

--------------------------------

### Starting Oracle Grid Infrastructure Setup Wizard

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/uporw/upgrading-oracle-restart.html

Run the setup.exe from the new Grid home to initiate the upgrade process for Oracle Grid Infrastructure.

```cmd
C:\> C:\app\grid\product\19.0.0\grid\setup.exe
```

--------------------------------

### Start Oracle Grid Infrastructure Installer

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwlin/installing-oracle-standalone-cluster.html

Execute this command as the 'grid' user to initiate the Oracle Grid Infrastructure installer, which guides you through the cluster configuration.

```bash
$ /u01/app/19.0.0/grid/gridSetup.sh
```

--------------------------------

### Configure Grid Infrastructure with Response File Example

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwhpx/configuring-the-software-binaries-using-a-response-file.html

Example command showing how to navigate to the Grid Infrastructure home directory and run gridSetup.sh with a specific response file path.

```bash
$ cd /u01/app/19.0.0/grid
$ ./gridSetup.sh -responseFile /u01/app/grid/response/response_file.rsp
```

--------------------------------

### Example: Setting Up MOS and Collecting ORA-00600 Diagnostics

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/atnms/ondemand-diagnostic-collection.html

This interactive example demonstrates configuring My Oracle Support credentials with `tfactl setupmos` and then performing an ORA-00600 diagnostic collection that is automatically uploaded to a Service Request.

```bash
-bash-4.1# tfactl setupmos
Enter User Id: john.doe@oracle.com
Enter Password:          
Wallet does not exist ... creating
Wallet created successfully
USER details added/updated in the wallet
PASSWORD details added/updated in the wallet
SUCCESS - CERTIMPORT - Successfully imported certificate
-bash-4.1# su - oradb


-bash-4.1$ /opt/oracle.tfa/tfa/myserver69/tfa_home/bin/tfactl diagcollect -srdc ORA-00600 -sr 3-15985570811
Enter the time of the ORA-00600 [YYYY-MM-DD HH24:MI:SS,RETURN=ALL] : 
Enter the Database Name [RETURN=ALL] : 

1. Oct/23/2017 03:03:40 : [ogg11204] ORA-00600: internal error code, arguments: [gc_test_error], [0], [0], [], [], [], [], [], [], [], [], []
2. Sep/26/2017 10:03:10 : [ogg11204] ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [], [], [], []
3. Sep/26/2017 10:02:49 : [ogg11204] ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [], [], [], []
4. Sep/26/2017 10:02:33 : [ogg11204] ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [], [], [], []
5. Jan/09/2016 13:01:02 : [+ASM1] ORA-00600: internal error code, arguments: [ksdhng:msg_checksum], [9070324609822233070], [15721744232659255108], [0x7FFBDC07A9E8], [], [], [], [], [], [], [], []

Please choose the event : 1-5 [1] 1
Selected value is : 1 ( Oct/23/2017 03:03:40 )
Scripts to be run by this srdc: ipspack rdahcve1210 rdahcve1120 rdahcve1110 
Components included in this srdc: OS CRS DATABASE NOCHMOS
Use of uninitialized value $db_home in length at /opt/oracle.tfa/tfa/myserver69/tfa_home/bin/common/dbutil.pm line 186.
Collecting data for local node(s)
Scanning files from Oct/22/2017 21:03:40 to Oct/23/2017 09:03:40

Collection Id : 20180430080045myserver69

Detailed Logging at : /opt/oracle.tfa/tfa/repository/srdc_ora600_collection_Mon_Apr_30_08_00_45_PDT_2018_node_local/diagcollect_20180430080045_myserver69.log
2018/04/30 08:00:50 PDT : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom
2018/04/30 08:00:50 PDT : Collection Name : tfa_srdc_ora600_Mon_Apr_30_08_00_45_PDT_2018.zip
2018/04/30 08:00:50 PDT : Scanning of files for Collection in progress...
2018/04/30 08:00:50 PDT : Collecting additional diagnostic information...
2018/04/30 08:01:15 PDT : Getting list of files satisfying time range [10/22/2017 21:03:40 PDT, 10/23/2017 09:03:40 PDT]
2018/04/30 08:01:34 PDT : Collecting ADR incident files...
2018/04/30 08:02:21 PDT : Completed collection of additional diagnostic information...
2018/04/30 08:02:24 PDT : Completed Local Collection
2018/04/30 08:02:24 PDT : Uploading collection to SR - 3-15985570811
2018/04/30 08:02:27 PDT : Successfully uploaded collection to SR
.---------------------------------------.
|           Collection Summary          |
+------------+-----------+-------+------+
| Host       | Status    | Size  | Time |
+------------+-----------+-------+------+
| myserver69 | Completed | 559kB |  94s |
'------------+-----------+-------+------'

Logs are being collected to: /opt/oracle.tfa/tfa/repository/srdc_ora600_collection_Mon_Apr_30_08_00_45_PDT_2018_node_local
/opt/oracle.tfa/tfa/repository/srdc_ora600_collection_Mon_Apr_30_08_00_45_PDT_2018_node_local/myserver69.tfa_srdc_ora600_Mon_Apr_30_08_00_45_PDT_2018.zip
```

--------------------------------

### Start Grid Setup Wizard with Response File

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwwin/configuring-the-software-binaries-using-a-response-file.html

Use this command to start the Oracle Universal Installer (OUI) in Grid Setup Wizard mode for configuring Oracle Grid Infrastructure. It supports silent configuration using a response file.

```cmd
Grid_home\setup.exe [-debug] [-silent -responseFile filename]
```

```cmd
C:\> cd Grid_home
C:\> setup.exe -responseFile C:\app\19.0.0\grid\response\grid_setup.rsp
```

--------------------------------

### Displaying Oracle Universal Installer Command-Line Help

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/ntcli/running-oracle-universal-installe-using-the-response-file.html

Use this command to view all available command-line options for `setup.exe`, including parameters for silent installations and response file usage.

```cmd
DRIVE_LETTER:\setup.exe_location setup -help
```

--------------------------------

### PL/SQL Example: Get Change Tracking Info for a Model

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/rdfrm/SEM_APIS-reference.html

This example demonstrates how to enable change tracking for a model and then retrieve its change tracking status and start time using SEM_APIS.GET_CHANGE_TRACKING_INFO.

```PL/SQL
DECLARE 
  bEnabled  boolean;
  tsEnabled  timestamp;
  
BEGIN
  EXECUTE IMMEDIATE 'create table m1 (t SDO_RDF_TRIPLE_S)';
  sem_apis.create_sem_model('m1','m1','t');
 
  sem_apis.enable_change_tracking(sem_models('m1'));
 
  sem_apis.get_change_tracking_info('m1', bEnabled,  tsEnabled);
  dbms_output.put_line('is enabled:' || case when bEnabled then 'true' else 'false' end);
  dbms_output.put_line('enabled at:' || tsEnabled);
END;
/
```

--------------------------------

### Run Oracle Database Client Setup Wizard

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/ntcli/installing-oracle-database-client-using-image-files.html

Execute the setup.exe command from the Oracle home directory to launch the Oracle Database Client Setup Wizard and begin the installation.

```cmd
C:\app\oracle\product\19.0.0\clienthome_1>setup.exe
```

--------------------------------

### Setup for DBMS_MGD_ID_UTL Examples

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_MGD_ID_UTL.html

This SQL script demonstrates the initial setup required to run examples for the DBMS_MGD_ID_UTL package, including connecting as SYSDBA, creating a new user, granting necessary privileges, and connecting as the new user.

```SQL
SQL> connect / as sysdba;
Connected.
SQL> create user mgduser identified by password;
SQL> grant connect, resource to mgduser;
SQL> connect mgduser
Enter password: mgduserpassword
Connected.
SQL> set serveroutput on;
```

--------------------------------

### Record Installation Settings to a Response File

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/otgiw/gateway-response-files.html

Use this command to start Oracle Universal Installer in record mode, saving all entered settings to the specified response file. A concrete example shows a full path.

```bash
setup -record -destinationFile response_file_name
```

```bash
setup -record -destinationFile C:\response_files\install_oracle11g
```

--------------------------------

### Run Oracle Database Setup Wizard with Release Update Patch

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/axdbi/installing-seha-on-local-file-system.html

Start the Oracle Database Setup Wizard from the Oracle home directory, applying a specific Oracle Database Release Update patch during the installation process.

```bash
$ ./runInstaller -applyRU patch_directory_location/patch_ID
```

--------------------------------

### connect Command Examples

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/jjdev/ojvmjava-tool.html

These examples demonstrate connecting to a database using different service types ('thin' and 'oci') and providing user credentials.

```shell
connect -s thin@locahost:5521:orcl -u HR/<password>
```

```shell
connect -s oci@locahost:5521:orcl -u HR -p <password>
```

--------------------------------

### SQL Setup for prepareCall() Example

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/drdaa/API-ref-for-SQL-translation-of-JDBC-apps.html

SQL commands to grant privileges, create a sample stored procedure, and configure a SQL translation profile named 'FOO'.

```SQL
conn system/manager;
grant create sql translation profile to HR;
 
conn username/pwd;
 
create or replace procedure sample_proc (p_num number, p_vchar in out varchar2) AS 
begin 
    p_vchar := 'p_num'||p_num||',  p_vchar'||p_vchar;
end;
/
 
exec dbms_sql_translator.drop_profile('FOO');
exec  dbms_sql_translator.create_profile('FOO');
exec  dbms_sql_translator.register_sql_translation('FOO', 'exec sample_proc(:b1, :b2)', '{call sample_proc(:b1, :b2)}');

```

--------------------------------

### Complete Database Startup and Shutdown Example with JDBC

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/jjdbc/database-administration.html

This example demonstrates the full lifecycle of an Oracle database: starting it up with no restrictions, mounting and opening it, and then shutting it down using the IMMEDIATE and FINAL options. It requires specific setup for 'sysdba' logon.

```java
import java.sql.Statement;
import java.util.Properties;
import oracle.jdbc.OracleConnection;
import oracle.jdbc.pool.OracleDataSource;
/**
 * To logon as sysdba, you need to create a password file for user "sys":
 *   orapwd file=/path/orapw password=password entries=300
 * and add the following setting in init.ora:
 *   REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
 * then restart the database.
 */
public class DBStartup
{
  static final String DB_URL = "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=5221))"
+ "(CONNECT_DATA=(SERVICE_NAME=rdbms.devplmt.XYZ.com)))";

  public static void main(String[] argv) throws Exception
  {
// Starting up the database:
    OracleDataSource ds = new OracleDataSource();
    Properties prop = new Properties();
    prop.setProperty("user","sys");
    prop.setProperty("password","manager");
    prop.setProperty("internal_logon","sysdba");
    prop.setProperty("prelim_auth","true");
    ds.setConnectionProperties(prop);
    ds.setURL(DB_URL);
    OracleConnection conn = (OracleConnection)ds.getConnection();
    conn.startup(OracleConnection.DatabaseStartupMode.NO_RESTRICTION);
    conn.close();

// Mounting and opening the database
    OracleDataSource ds1 = new OracleDataSource();
    Properties prop1 = new Properties();
    prop1.setProperty("user","sys");
    prop1.setProperty("password","manager");
    prop1.setProperty("internal_logon","sysdba");
    ds1.setConnectionProperties(prop1);
    ds1.setURL(DB_URL);
    OracleConnection conn1 = (OracleConnection)ds1.getConnection();
    Statement stmt = conn1.createStatement();
    stmt.executeUpdate("ALTER DATABASE MOUNT");
    stmt.executeUpdate("ALTER DATABASE OPEN");
    stmt.close();
    conn1.close();

// Shutting down the database
    OracleDataSource ds2 = new OracleDataSource();
    Properties prop = new Properties();
    prop.setProperty("user","sys");
    prop.setProperty("password","manager");
    prop.setProperty("internal_logon","sysdba");
    ds2.setConnectionProperties(prop);
    ds2.setURL(DB_URL);
    OracleConnection conn2 = (OracleConnection)ds2.getConnection();
    conn2.shutdown(OracleConnection.DatabaseShutdownMode.IMMEDIATE);
    Statement stmt1 = conn2.createStatement();
    stmt1.executeUpdate("ALTER DATABASE CLOSE NORMAL");
    stmt1.executeUpdate("ALTER DATABASE DISMOUNT");
    stmt1.close();
    conn2.shutdown(OracleConnection.DatabaseShutdownMode.FINAL);
    conn2.close();
  }
}
```

--------------------------------

### Query Detailed Daemon Information

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/atnms/querying-status.html

Execute these commands to get comprehensive details about the running `orachk` or `exachk` daemon, such as its version, installation path, and start time.

```bash
$ ./orachk –d info
```

```bash
$ ./exachk –d info
```

--------------------------------

### View setup.exe Help Options for Oracle Database

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwwin/running-the-installer-using-a-response-file.html

Display all available command-line options for the Oracle Database installer. Run this command to see the full set of options supported by setup.exe.

```batch
db_home> setup.exe -help
```

--------------------------------

### Begin Application Installation in an Application Container (SQL)

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-application-containers-with-sql-plus.html

Initiate the installation of an application in the application root. This statement marks the start of the installation process, specifying the application name and version.

```SQL
ALTER PLUGGABLE DATABASE APPLICATION application_name BEGIN INSTALL 'application_version_number';
```

```SQL
ALTER PLUGGABLE DATABASE APPLICATION salesapp BEGIN INSTALL '4.2';
```

--------------------------------

### Example Output: GGHub Onboarding Playbook Prompts

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/haovw/task-3-configure-primary-and-standby-gghub-clusters-using-ansible-automation-prem.html

Illustrates the interactive prompts and required inputs when executing the `oracle.gghub.onboarding` playbook for GoldenGate Hub configuration.

```console
Example output:

GoldenGate - Enter the GoldenGate deployment name: maahub
GoldenGate - Enter the GoldenGate ORACLE_HOME: /u01/app/oracle/goldengate/gg23ai
Primary - Enter the GoldenGate primary group: maahuba
Primary - Enter the GoldenGate primary group node 1 (Ansible will ssh using this name):
 maahuba1
Primary - Enter the GoldenGate primary group node 2 (Ansible will ssh using this name):
 maahuba2
Primary - Enter the GoldenGate primary APPVIP IP address: 10.53.240.11
Primary - Enter the ASM DiskGroup name: DATA
Standby - Enter the GoldenGate standby group: maahubb
Standby - Enter the GoldenGate standby group node 1 (Ansible will ssh using this name):
 maahubb1
Standby - Enter the GoldenGate standby group node 2 (Ansible will ssh using this name):
 maahubb2
Standby - Enter the GoldenGate standby APPVIP IP address: 10.53.240.12
Standby - Enter the ASM DiskGroup name: DATA
GGHUB - Enter the path for acfs mount point: /opt/oracle/gghub/maahub
Patch File - Enter the local software repository directory that stores software patches:
 /u01/maagghub/stage
Patch File - Enter the remote directory in target machines for staging files:
 /u01/oracle/stage
Patch File - Enter the GoldenGate patch file name:
 p37777817_23802504OGGRU_Linux-x86-64.zip
Patch File - Enter the XAG patch file name: p31215432_190000_Generic.zip
Ansible - Sets the login user for the target machines: opc
Ansible - Sets the ansible_python_interpreter for the target machines: /usr/bin/python3.12
Ansible - Enter the Ansible inventory full path directory: /u01/maagghub/inventory
Password - Enter the password for Ansible Vault ([8=>length<=30][A-Z][a-z][0-9]):
confirm Password - Enter the password for Ansible Vault ([8=>length<=30][A-Z][a-z][0-9]):
Password - Enter the password for GoldenGate deployment ''
 ([8=>length<=30][A-Z][a-z][0-9][-!@%&*.#]):
confirm Password - Enter the password for GoldenGate deployment ''
 ([8=>length<=30][A-Z][a-z][0-9][-!@%&*.#]):
```

--------------------------------

### Example: Executing Grid Infrastructure Configuration with a Response File

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwaix/configuring-the-software-binaries-using-a-response-file.html

This example demonstrates navigating to the Oracle Grid Infrastructure home and executing the configuration wizard with a specific response file to initiate the configuration process.

```bash
$ cd /u01/app/19.0.0/grid
$ ./gridSetup.sh -responseFile /u01/app/grid/response/response_file.rsp
```

--------------------------------

### Start Oracle Listener: Example

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/configuring-automatic-restart-of-an-oracle-database.html

An example of starting a specific Oracle listener named 'listener'.

```bash
srvctl start listener -listener listener
```

--------------------------------

### Start Management Database (mgmtdb) Example

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwadd/server-control-command-reference.html

This example starts the management database on the 'crmnode1' node of the cluster.

```bash
$ srvctl start mgmtdb -node crmnode1
```

--------------------------------

### Previewing Parameters for Azure Backup Module Setup

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/azure-sbt-module.html

Run this command from the subdirectory containing the extracted setup files to preview the available parameters for the Oracle Database Cloud Backup Module for Azure.

```bash
$ java -jar az_setup.jar
```

```bash
$ java -jar az_setup.jar
```

--------------------------------

### Start Destination Example (Java)

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/adque/jms-basic-operation.html

Example demonstrating how to start both a JMS topic and a queue, enabling both enqueue and dequeue operations.

```java
TopicSession t_sess;
QueueSession q_sess;
Topic        topic;
Queue        queue;

(AQjmsDestination)topic.start(t_sess, true, true);
(AQjmsDestination)queue.start(q_sess, true, true);
```

--------------------------------

### Example: Create Wallet File

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/odpnt/featConnecting.html

An example of creating a wallet file at a specific Windows path using the `mkstore` utility.

```shell
mkstore -wrl c:\oracle\product\12.1.0\db_1\wallets -create
Enter password: password
```

--------------------------------

### Start Oracle ASM Disk Group: Example

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/configuring-automatic-restart-of-an-oracle-database.html

An example demonstrating how to start an Oracle ASM disk group named 'DATA'.

```bash
srvctl start diskgroup -diskgroup DATA
```

--------------------------------

### Start Oracle Grid Infrastructure Installer with Patch Options

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwaix/switching-oracle-grid-infrastructure-home-after-patching.html

Execute this command to start the Oracle Grid Infrastructure installer for a software-only installation, optionally applying Release Updates or one-off patches.

```bash
 $ /u01/app/oracle/product/19.17.0/grid/gridSetup.sh [-applyRU patch_directory_location]
[-applyOneOffs comma_separated_list_of_patch_directory_locations]
```

--------------------------------

### Example Directory Name for Installation Files

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/otgis/overview-of-gateways.html

This is an example directory name to create for organizing and storing downloaded Oracle installation archive files.

```plaintext
gateway
```

--------------------------------

### Execute setup.sql Script

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/adque/jms-service-types-examples.html

Use this SQL*Plus command to run the `setup.sql` script, which initializes the database environment for Oracle AQ JMS type examples.

```sql
sqlplus /NOLOG @setup.sql
```

--------------------------------

### GDSCTL: Start Specific Global Service Manager Example

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/gsmug/gdsctl-reference.html

Example of starting the global service manager named `gsm1` on the local host.

```gdsctl
GDSCTL> start gsm -gsm gsm1
```

--------------------------------

### Example: Display Configuration for a Specific Database

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/racad/server-control-utility-reference.html

This example shows how to display the configuration details for a database named 'main4'.

```bash
$ srvctl config database -d main4
```

--------------------------------

### Example: Show All IPS Configuration Settings

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/atnms/running-diagnostic-collection-commands.html

This example demonstrates viewing all Incident Packaging Service configuration settings, including interactive selection of Oracle Home and ADR base paths.

```bash
$ tfactl ips show configuration

Multiple ORACLE HOMES were found, please select one ...

option[0] /scratch/app/oradb/product/11.2.0/dbhome_11204
option[1] /scratch/app/11.2.0.4/grid

Pls select an ORACLE_HOME to be used for the ADRCI binary [0] ?0
/scratch/app/oradb/product/11.2.0/dbhome_11204 was selected


Multiple ADR basepaths were found, please select one ...

( ) option[0] /scratch/app/oradb
( ) option[1] /scratch/app/oragrid

Pls select an ADR basepath [0..1] ?0
/scratch/app/oradb was selected


Multiple ADR homepaths were found for /scratch/app/oradb, please select one ...

( ) option[0] diag/rdbms/racone/racone_2
( ) option[1] diag/rdbms/rdb11204/rdb112041
( ) option[2] diag/rdbms/ogg11204/ogg112041
( ) option[3] diag/rdbms/apxcmupg/apxcmupg_1
( ) option[4] diag/rdbms/apxcmupg/apxcmupg_2
    option[5] Done

Pls select a homepath [5] ?0
diag/rdbms/racone/racone_2 was selected

PARAMETER INFORMATION:
   PARAMETER_ID           1
   NAME                   CUTOFF_TIME
   DESCRIPTION            Maximum age for an incident to be considered for inclusion
   UNIT                   Days
   VALUE                  90
   DEFAULT_VALUE          90
   MINIMUM                1
   MAXIMUM                4294967295
   FLAGS                  0

PARAMETER INFORMATION:
   PARAMETER_ID           2
   NAME                   NUM_EARLY_INCIDENTS
   DESCRIPTION            How many incidents to get in the early part of the range
   UNIT                   Number
   VALUE                  3
   DEFAULT_VALUE          3
   MINIMUM                1
   MAXIMUM                4294967295
   FLAGS                  0

PARAMETER INFORMATION:
   PARAMETER_ID           3
   NAME                   NUM_LATE_INCIDENTS
   DESCRIPTION            How many incidents to get in the late part of the range
   UNIT                   Number
   VALUE                  3
   DEFAULT_VALUE          3
   MINIMUM                1
   MAXIMUM                4294967295
   FLAGS                  0

PARAMETER INFORMATION:
   PARAMETER_ID           4
   NAME                   INCIDENT_TIME_WINDOW
   DESCRIPTION            Incidents this close to each other are considered correlated
   UNIT                   Minutes
   VALUE                  5
   DEFAULT_VALUE          5
   MINIMUM                1
   MAXIMUM                4294967295
   FLAGS                  0

PARAMETER INFORMATION:
   PARAMETER_ID           5
   NAME                   PACKAGE_TIME_WINDOW
   DESCRIPTION            Time window for content inclusion is from x hours before first included incident to x hours after last incident
   UNIT                   Hours
   VALUE                  24
   DEFAULT_VALUE          24
   MINIMUM                1
   MAXIMUM                4294967295
   FLAGS                  0

PARAMETER INFORMATION:
   PARAMETER_ID           6
   NAME                   DEFAULT_CORRELATION_LEVEL
   DESCRIPTION            Default correlation level for packages
   UNIT                   Number
   VALUE                  2
   DEFAULT_VALUE          2
   MINIMUM                1
   MAXIMUM                4
   FLAGS                  0
```

--------------------------------

### Start Grid Infrastructure Installer to Switch Home and Apply Patches

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwlin/switching-oracle-grid-infrastructure-home-after-patching.html

Run the `gridSetup.sh` script with the `-switchGridHome` flag to initiate the switch to the new patched home. Optionally, use `-applyRU` or `-applyOneOffs` to apply patches during installation.

```bash
$ /u01/app/19.17.0/grid/gridSetup.sh -switchGridHome [-applyRU patch_directory_location] 
[-applyOneOffs comma_seperated_list_of_patch_directory_locations]
```

--------------------------------

### Perform Silent Installation of Oracle Database Examples

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/exmpl/index.html

These commands demonstrate how to perform a silent installation of Oracle Database Examples using response files. Silent installations are useful for automating deployments across multiple machines.

```Shell
$ /directory_path/runInstaller [-silent] -responseFile responsefilename
```

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

--------------------------------

### View setup.exe Help Options for Oracle Grid Infrastructure

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwwin/running-the-installer-using-a-response-file.html

Display all available command-line options for the Oracle Grid Infrastructure installer. Run this command to see the full set of options supported by setup.exe.

```batch
Grid_home> setup.exe -help
```

--------------------------------

### Start Instance and Mount Database

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/user-managed-recovery-advanced.html

Start a new instance and mount the database to prepare for recovery operations.

```sql
SQL> STARTUP MOUNT
```