Oracle 19c Quick Install Guide for Windows
search cancel

Oracle 19c Quick Install Guide for Windows

book

Article ID: 270005

calendar_today

Updated On:

Products

Data Loss Prevention Oracle Standard Edition 2

Issue/Introduction

This is a Quick Install guide for the Oracle Database Server

For the full "DLP Quick Install Guides" please visit the following link: DLP Quick Install Guides

Environment

Windows

Cause

This is a quick install guide for an Oracle Standard installation

Resolution

VERSION DISCLAIMER:
Please note that the following instructions are version agnostic, and can generally be used on any currently supported version. As such you will find several variables denoted such as "<DLPversion>" to indicate where a version number "should" be used. You will need to replace these variables with the appropriate version that you are attempting to use. Below are a few examples of such translations...

<DLPversion>  = 15.8, 16.0, 16.0.1 or 16.0.2
<DLPfullversion>  = 16.0.10000.60631
<ORACLEversion>  = 193000 or 19.3.0.0
<JREversion> = jdk8u322-b06 or 8u322b06

Note: Username and Passwords provided below are for example only, choose your own values to match your company requirements.

Download the Oracle Software: https://support.broadcom.com/group/ecx/productfiles?sellable=DAT71262&release=19&os=&servicePk=0&language=EN
Oracle 19c Implementation Guide: 

https://techdocs.broadcom.com/us/en/symantec-security-software/information-security/data-loss-prevention/16-0-2/implementing-the-database.html


Installation_Tools.zip: This is found in the DLP Platform Package "Symantec_DLP_<DLPversion>_Platform_Win-IN_<DLPfullversion>.zip"

Stand Alone Installation: When installing Oracle on its own server, please note that you MUST install the Oracle Client on the Enforce Server.

Downloading the Oracle Tools: Extract the "Symantec_DLP_<DLPversion>_Platform_Win-IN_<DLPfullversion>.zip" file
   1  - Browse the installation directory for "DLP\<DLPversion>\New_Installs\Oracle_Configuration\<ORACLEversion>_64_bit_Installation_Tools_Win"
   2  - Create the following directory…
          C:\Oracle_Installers\Tools
   3  - Unzip the "<ORACLEversion>_64_bit_Installation_Tools_Win.zip" into the new "C:\Oracle_Installers\Tools" directory 

Open Firewall Ports:
     Quick Configuration Guide for Windows Firewall

Installing Oracle: 
    1 - Create the "C:\oracle\product\<ORACLEversion>\db1" directory
       
    2 - Copy the contents of the "WINDOWS.X64_<ORACLEversion>_db_home.zip" into the "C:\oracle\product\<ORACLEversion>\db1" directory
    3 - Set the ORACLE_HOME environment variable
          Creating Environment Variables Quick Install Guide
    4 - Open CMD (Administrator)
    5 - CD %ORACLE_HOME%
    6 - Run the "setup.exe"
          setup.exe -noconfig -responseFile C:\Oracle_Installers\tools\responsefiles\singleinstance\Oracle_<ORACLEversion>_Standard_Edition_Installation_WIN.rsp
         
          
         


Create a New Windows User:
     Username: oracle
     Password: <Your Oracle Home Windows Password>
         


Set the Oracle Base directory
     Oracle Base: C:\oracle
     Software Location: ** Make sure this is set correctly and matches the directory you extracted the Oracle Database into **
         

 

Click Install


         
         
         


Now that Oracle is installed, we need to prepare it for DLP...

Create the DLP Database:
   1  - Copy the database template file "Oracle_<ORACLEversion>_Template_for_64_bit_WIN" into the Oracle "C:\oracle\product\<ORACLEversion>\db_1\assistants\dbca\templates" directory.
          Source: C:\Oracle_Installers\Tools\templates\singleinstance\Oracle_<ORACLEversion>_Template_for_64_bit_WIN.dbt
          Destination: C:\oracle\product\<ORACLEversion>\db_1\assistants\dbca\templates
   2  - Open CMD (Administrator)
   3  - Run the following command...
          %ORACLE_HOME%\bin\dbca -createDatabase -ProgressOnly -responseFile "C:\Oracle_Installers\Tools\responsefiles\singleinstance\Oracle_<ORACLEversion>_DBCA_WIN.rsp"
               
Enter SYS Password: <Your SYS Password>                  ** This is to CREATE the "SYS" password for the Database
               
Enter SYSTEM Password: <Your SYSTEM Password>          ** This is to CREATE the "SYSTEM" password for the Database
               
Enter Oracle Home User Password: <Your Oracle Home Windows Password>          ** This is the password for the user account that you created or used during the Oracle Installation
               
** Note: If you are having problems at this stage, it likely means you are lacking the necessary permissions. You can use Process Monitor to help identify local permissions issues if necessary.

** Memory warning message is due to the limited resources in the Broadcom lab environment and did not prevent the deployment.

Configure the TNS Listener:
    1 - If logged in as a Domain User, modify the sqlnet.ora file. Modify the value from NTS to None.
          Path: %ORACLE_HOME%\network\admin\sqlnet.ora
          Value: SQLNET.AUTHENTICATION_SERVICES=(none)

Launch the Oracle Network Configuration Assistant (netca):
   2  - Open CMD (Administrator)
     %ORACLE_HOME%\bin\netca
     
     
     
     Oracle Home Password: <Your Oracle Home Windows Password>

     
     
     
     

Create the Local NET Service Name configuration
     
     
     
     
     
     Hostname: This is the hostname of your Oracle Server

     
     
     
     
     
    3 - Click the "Finish" button to complete the configuration.

Verify the tnsnames.ora
     Path: %ORACLE_HOME%\network\admin\tnsnames.ora
     

Modify the "listener.ora" file:
    1 - Open CMD (Administrator)
          lsnrctl stop
    2 - Open the "listener.ora" file
          Path: %ORACLE_HOME%\network\admin\listener.ora
    3 - Modify the "KEY=EXTPROC1521" value to "KEY=PROTECT"
    4 - Add the following line to the end of the "listener.ora" file
          SECURE_REGISTER_LISTENER = (IPC)
       
   5  - Save the changes and Exit
   6  - restart the listener
          lsnrctl start
   7  - Connect to the database as sysdba
           sqlplus sys as sysdba
   8  - Run the following commands
          ALTER SYSTEM SET local_listener = '(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PROTECT)))' SCOPE=both;
          ALTER SYSTEM REGISTER;
          Exit
    9 - Verify the changes to the listener.ora
          - Open CMD (Administrator)
          lsnrctl services


         

Create the Oracle User account for Symantec Data Loss Prevention
    1 - Open CMD (Administrator)
    2 - CD C:\Oracle_Installers\Tools
    3 - Run the following command to log into SQLPlus and run the "oracle_create_user.sql" script
          sqlplus /nolog @oracle_create_user.sql
         
          SYS: <Your SYS Password>
          Service Name: protect
          Required username to be created: protect
          Password for new username: <Your PROTECT Password>


         

ERROR at line 1:
ORA-01918: user 'PROTECT' does not exist

This is expected behavior.

   4  - Verify the user
          sqlplus protect/protect@protect

          SELECT tablespace_name FROM user_tablespaces;
         
          - Close out the existing CMD window

   5  - Open a new CMD (Administrator)
   6  - Login with the following credentials
          sqlplus sys as sysdba
         

    7 - Run the following command
          SELECT BANNER_FULL FROM v$version;
         

Install SQL Developer:
     - While not strictly required, it is recommended that you take a moment to install the SQL Developer tool.
     - SQL Developer connects to your Oracle Database giving you a user interface that you can use to browse or run commands against the database if needed. 
     - SQL Developer Quick Install Guide

And don't forget to open your firewall See 

Quick install guide Configure Windows Firewall to allow connections to Oracle

Additional Information