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> = 16.0, 16.0.1, 16.0.2, 16.1, 25.1 or 26.1
<DLPfullversion> = 16.0.10000.60631
<ORACLEversion> = 193000 or 19.3.0.0
<JREversion> = jdk8u322-b06, 8u322b06, jdk8u422-b05-jre, jdk-21.0.4_7-jre, jdk-21.0.9+10-jre

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

Prerequisites:
1. Download the Oracle Software to the Oracle Server:https://support.broadcom.com/
  
  Symantec_DLP_<DLPversion>_Platform_Win-IN_<DLPfullversion>.zip - This contains the Installation_Tools.zip
  WINDOWS.X64_<ORACLEversion>_db_home.zip - This contains the Oracle Standard install
2. Create the Oracle Tools directory:
  1. Create the following directory
    C:\Oracle_Installers\Tools
  2. Extract the "Symantec_DLP_<DLPversion>_Platform_Win-IN_<DLPfullversion>.zip" file
  3. Browse the installation directory for "DLP\<DLPversion>\New_Installs\Oracle_Configuration\<ORACLEversion>_64_bit_Installation_Tools_Win"
  4. Unzip the "<ORACLEversion>_64_bit_Installation_Tools_Win.zip" into the new "C:\Oracle_Installers\Tools" directory
3. Open Firewall Ports:
  Quick Configuration Guide for Windows Firewall
Installing Single Instance 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. Navigate to the oracle home directory:
  cd %ORACLE_HOME%
6. Run the "setup.exe" to launch the Oracle Database Installer
  
  setup.exe -noconfig -responseFile C:\Oracle_Installers\tools\responsefiles\singleinstance\Oracle_<ORACLEversion>_Standard_Edition_Installation_WIN.rsp
7. Select "Set Up Software Only", then select 'Next'
8. Select "Single instance database installation", then select 'Next'
9. Select "Standard Edition 2", then select 'Next'
10. Select "Create New Windows User". Set the username and password, then select 'Next'
  
  Username:oracle
  Password:<Your Oracle Home Windows Password>
11. Set the Oracle Base directory, then select 'Next'
  
  Oracle Base: C:\oracle
  Software Location: ** Make sure this is set correctly and matches the directory you extracted the Oracle Database into **
12. Click Install
13. Now that Oracle is installed, we need to prepare it for DLP
Create the DLP Database Instance:
1. Copy the database template file "Oracle_<ORACLEversion>_Template_for_64_bit_WIN.dbt" 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
  
  ** NOTE: The database path may vary slightly, for example "db_1" vs "db1".
2. Open Command Prompt as Administrator
3. Run the following command to create the database instance
  
  %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.
Configure the TNS Listener and Local NET Service Name
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)
2. Launch the Oracle Network Configuration Assistant (netca) to configure the Listener
3. Open Command Prompt (CMD) as Administrator
4. Run the following command to launch the Oracle Net Configuration Assistant
  
  %ORACLE_HOME%\bin\netca
5. Select "Listener configuration", then select 'Next'
6. Select "Add", then select 'Next'
7. Set the Listener name and enter the Oracle Home User's password, then select 'Next'
  
  Listener name: <name> (default is LISTENER)
  Oracle Home Password: <Your Oracle Home Windows Password>
8. Select the TCP protocol, then select 'Next'
9. Select which port the Listener will use. If using the default 1521, select "Use the standard port number of 1521", then select 'Next'
10. Select "No" as another listener is not needed, then select 'Next'
11. On the Listener Configuration Done page, select 'Next'. Do not close the GUI.
Create the Local NET Service Name configuration
1. With the netca gui still open, select "Local Net Service Name configuration", then select 'Next'
2. Select "Add", then select 'next'
3. Set the Service Name, then select 'Next'
  
  Service Name: protect (default)
4. Select TCP as the protocol, then select 'Next'
5. Specify the Host name of the Oracle Server and the port. The port should match the port previously set for the Listener. Then select 'Next'.
  
  Host Name: <DNS name or ip address of the Oracle Server>
6. On the test page, select "No, do not test", then select 'Next'.
7. Set the Net Service Name, then select 'Next'. The Net Service Name will default to the service name you entered earlier.
8. When prompted to configure another Net Service Name, select "No", then select 'Next'.
9. On the Net Service Name Configuration Done page, select 'Next'.
10. Select "Finish" to complete the configuration.
Verify the tnsnames.ora

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

Verify the HOST, PORT, and SERVICE_NAME are correct
Modify the "listener.ora" file
1. Open a new Comand Prompt (CMD) as Administrator
2. Run the following command:
  
  lsnrctl stop
3. Open the "listener.ora" file
  Path: %ORACLE_HOME%\network\admin\listener.ora
4. Change the "KEY=EXTPROC1521" value to "KEY=PROTECT"
5. Add the following line to the end of the "listener.ora" file
  SECURE_REGISTER_LISTENER = (IPC)
6. Save the changes and close the file
7. Back in Command Prompt, restart the listener
  
  lsnrctl start
8. Connect to the database as sysdba
  
  sqlplus sys as sysdba
9. Run the following commands
  
  ALTER SYSTEM SET local_listener = '(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PROTECT)))' SCOPE=both;
  ALTER SYSTEM REGISTER;
  Exit
10. Run the following command to verify the changes to the listener.ora
  
  lsnrctl services
Create the Oracle User account for Symantec Data Loss Prevention
1. Open a new Comand Prompt (CMD) as Administrator
2. Navigate to C:\Oracle_Installers\Tools
  
  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>
  
  If you see an error, this is expected behavior.
  
  ERROR at line 1:
  ORA-01918: user 'PROTECT' does not exist
4. Verify the user. In Command Prompt, run the following:
  
  sqlplus protect@protect
  
  Enter the protect user password when prompted
5. Run the following command to confirm tablespaces have been created:
  
  SELECT tablespace_name FROM user_tablespaces;
6. Close out the existing CMD window
7. Open a new Command Prompt (CMD) as Administrator
8. Log into the database with the following credentials:
  
  sqlplus sys as sysdba
9. Run the following command to confirm the database version
  
  SELECT BANNER_FULL FROM v$version;