Creating a new database on Windows
- If you have not co-located the database and the database server, make sure that each is in a healthy state.
- See creating-the-database-on-windows-v120001063-d324e6184.html#v120001063_v120001064 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\Databasedirectory to the\oracle\product\19.3.0.0\oradata\protectdirectory 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 toWindows > Start > All Programs > Oracle - OraDb. This navigation assumes the default locations from the Oracle installation process.<ver>_home1 > Application Development > SQL Plus
- At theSQL>command prompt, to connect as the sysdba user, enterconnect sys/password@protect as sysdbaWherepasswordis the password created for single- and two-tier installations.
- At theSQL>prompt, enterstartup
- 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 theinittemp.orafile in the\SymantecDLP_Backup_Files\Recovery_Aiddirectory 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 editedinittemp.orafile toinitprotect.ora.
- Copy theinitprotect.orafile to the$ORACLE_HOME\databasedirectory on the computer that hosts the new database.
- Copy the contents of the\SymantecDLP_Backup_Files\Databasedirectory to the\oracle\product\19.3.0.0\oradata\protectdirectory 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 toWindows > Start > All Programs > Oracle - OraDb19g_home1 > Application Development > SQL Plus.This navigation assumes that the default locations were accepted during the Oracle installation process. See creating-the-database-on-windows-v120001063-d324e6184.html#v120001063_v120001064 for additional details.
- At theSQL>command prompt, to connect as the sysdba user, enter:connect sys/password@protect as sysdbaWherepasswordis the password created for single- and two-tier installations.
- At theSQL>prompt, enter:create spfile from pfile='%ORACLE_HOME%\database\ initprotect.ora';
- To shut down, enter:shutdown
- To start, enter:startup