Creating a new database on Windows

  1. If you have not co-located the database and the database server, make sure that each is in a healthy state.
  2. Follow the instructions in the
    Symantec Data Loss Prevention
    Installation Guide
    to install an Oracle database.
    This step assumes that the drive structure of the new database is the same as the drive structure of the old database. Perform the following tasks in the order presented:
    • Copy the contents of the
      \SymantecDLP_Backup_Files\Database
      directory to the
      \oracle\product\19.3.0.0\oradata\protect
      directory on the computer that hosts the new database. The information about the computers and directories is located on the Recovery Information Worksheet.
    • To open Oracle SQL*Plus, navigate to
      Windows > Start > All Programs > Oracle - OraDb
      <ver>
      _home1 > Application Development > SQL Plus
      . This navigation assumes the default locations from the Oracle installation process.
      This process is described in the
      Symantec Data Loss Prevention
      Installation Guide
      .
    • At the
      SQL>
      command prompt, to connect as the sysdba user, enter
      connect sys/
      password
      @protect as sysdba
      Where
      password
      is the password created for single- and two-tier installations.
      See the
      Symantec Data Loss Prevention
      Installation Guide
      .
    • At the
      SQL>
      prompt, enter
      startup
  3. If the drive structure of the new database is different from the drive of the old database, perform the following tasks in the order presented:
    • Edit the
      inittemp.ora
      file in the
      \SymantecDLP_Backup_Files\Recovery_Aid
      directory to reflect the drive structure of the new database. The information about this computer is in the Recovery Information Worksheet.
      The following parameters might need to be modified to accommodate differences in directory structure:
      *.background_dump_dest *.control_files *.core_dump_dest *.user_dump_dest
    • Rename the edited
      inittemp.ora
      file to
      initprotect.ora
      .
    • Copy the
      initprotect.ora
      file to the
      $ORACLE_HOME\database
      directory on the computer that hosts the new database.
    • Copy the contents of the
      \SymantecDLP_Backup_Files\Database
      directory to the
      \oracle\product\19.3.0.0\oradata\protect
      directory on the computer that hosts the new database. The information about this computer is in the Recovery Information Worksheet.
    • On the computer that hosts the new database, open Oracle SQL*Plus. Navigate to
      Windows > Start > All Programs > Oracle - OraDb19g_home1 > Application Development > SQL Plus
      .
      This navigation assumes that the default locations were accepted during the Oracle installation process that is described in the
      Symantec Data Loss Prevention
      Installation Guide
      .
    • At the
      SQL>
      command prompt, to connect as the sysdba user, enter:
      connect sys/
      password
      @protect as sysdba
      Where
      password
      is the password created for single- and two-tier installations.
      See the
      Symantec Data Loss Prevention
      Installation Guide
      .
    • At the
      SQL>
      prompt, enter:
      create spfile from pfile='%ORACLE_HOME%\database\ initprotect.ora';
    • To shut down, enter:
      shutdown
    • To start, enter:
      startup