1. Database Upgrade Guide
  2. Transferring Files from the UNIX Host to the Windows Host

Transferring Files from the UNIX Host to the Windows Host

To run Upgrade Tuner on UNIX upgrade files, you must first transfer the files to a Windows host.

To transfer files from the UNIX host to the Windows host

  1. Windows host. Create a target directory for the UNIX upgrade files, and share the directory.

  2. UNIX host. Copy the following scripts using FTP to the Windows computer target directory:

    • upgtuner_ftp_get.txt

    • upgtuner_ftp_put.txt

      The files are located in $SIEBEL_ROOT/bin.

  3. Windows host. In both scripts, replace placeholder parameters with actual values, as described in the following table.

    Placeholder Value

    &HostIP

    This value is the IP address of UNIX computer.

    &Username

    This value is the user name used to open an FTP session with the UNIX computer (for example sadmin).

    &WindowsTempDir

    This value is the full path of the target directory on the Windows computer. The target directory does not have to be within the Siebel Server installation. Avoid using a target directory that already contains upgrade files.

  4. Windows host. Use FTP and upgtuner_ftp_get.txt to move the files shown in the following table from the UNIX host to the target directory on the Windows host.

    File Location on the UNIX Host 
    summary.xml

    $SIEBEL_ROOT/log/upgrep_prod_VERSION

    For example, $SIEBEL_ROOT/log/upgrep_prod_8x/summary.xml.

    		 
    master_upgrep_prod_
VERSION.ucf

    $SIEBEL_ROOT/bin

    For example,$SIEBEL_ROOT/bin/master_upgrep_prod_8x.ucf.

    		 
    schema*.ddl

    DBSRVR_ROOT/DBPLATFORM

    For example, DBSRVR_ROOT/Oracle/schema.ddl, schema_t1.ddl, schema_t2.ddl.

    		 
    driver_upgrep_prod_
VERSION.ucf

    DBSRVR_ROOT/DBPLATFORM/upgrade/VERSION

    For upgrades from Siebel CRM version 8.1.1.10 on Oracle Database, an example would be DBSRVR_ROOT/Oracle/upgrade/v8_1_1_10/driver_upgrep_prod_v81110.ucf.

    		 
    *.sql

    DBSRVR_ROOT/DBPLATFORM/upgrade/VERSION

    For example, for upgrades from Siebel CRM version 8.1.1.10 on Oracle Database, an example would be DBSRVR_ROOT/Oracle/upgrade/v8_1_1_10/preschm.sql.

  5. Windows host. Navigate to the target directory containing the UNIX upgrade files, and open the summary.xml file in a text editor.

  6. Windows host. Near the beginning of the file, locate the element <SIEBEL_ROOT>, and edit the value to be the absolute path to the target directory containing the UNIX files that you copied to the Windows host.

  7. Windows host. Save the file, and exit.

  8. Windows host. Start Upgrade Tuner, and tune the UNIX upgrade files.

    Specify the target directory containing the UNIX upgrade files. The summary.xml file contains a flag that tells Upgrade Tuner to look for all the upgrade files in the target directory. You do not have to move the files.