ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Create the Oracle Database on Windows for Data Loss Prevention

book

Article ID: 172344

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

This article assumes you have already installed Oracle 12c per the Symantec Data Loss Prevention (DLP) Oracle 12c Implementation Guide.

Detailed instructions on how to install Oracle 12c on Windows can be found in the Symantec Data Loss Prevention Oracle 12c Enterprise Implementation Guide.

Resolution

Creating the Symantec Data Loss Prevention database on Windows

To create the Symantec Data Loss Prevention database on Windows

1 Set the ORACLE_HOME environment variable for your new installation. Open a command prompt, and enter:

  • set ORACLE_HOME=c:\oracle\product\12.1.0.2\db_1
  • If you installed Oracle 12c into a different location, substitute the correct directory in the above command.

2 Navigate to the C:\temp\Oracle\tools folder where you extracted the 12.1.0.2_64_bit_Installation_Tools.zip file.

3 Copy the database template file (Oracle_12.1.0.2_Template_for_DLP_v14.6_64_bit_WIN.dbt) from theC:\temp\Oracle\tools folder to the C:\oracle\product\12.1.0.2\db_1\assistants\dbca\templates folder.

4 (Optional) Rename the OraDb12c_home1 section of the Windows Start menu item to Oracle_12.1.0.2.

5 Open a command prompt, and execute the following command:

  • %ORACLE_HOME%\bin\dbca -progressOnly -responseFile C:\temp\Oracle\tools\responsefiles\Oracle_12.1.0.2_DBCA_WIN.rsp

6 Enter the SYS user password at the prompt.

7 Enter the SYSTEM user password at the prompt.

  • Follow these guidelines to create acceptable passwords:
  • Passwords cannot contain more than 30 characters.
  • Passwords cannot contain double quotation marks, commas, or backslashes.
  • Avoid using the & character.
  • Passwords are case-sensitive by default. You can change the case sensitivity through an Oracle configuration setting.
  • If your password uses special characters other than _, #, or $, or if yourpassword begins with a number, you must enclose the password in double quotes when you configure it.

8 The Database Configuration Assistant window appears.

  • The database creation process can take up to 20 minutes to complete. If the process fails or stops running, check the %ORACLE_HOME%\cfgtoollogs\dbca\SID folder. For example: C:\oracle\product\12.1.0.2\db_1\cfgtoollogs\dbca\protect.
  • When the database creation process is complete, a new Database Configuration Assistant window appears. It displays the database details.

9 Click OK.

10 If the database services OracleServicePROTECT and Distributed Transaction Coordinator are down, start them using Windows Services: Start > Control Panel > Administrative

Tools > Computer Management > Services and Applications > Services.

Perform the following procedure to create a TNS listener for the Symantec Data Loss Prevention database.

To create the TNS Listener:

1 (Optional) If you logged on as a domain user, you must set the sqlnet.ora file SQLNET.AUTHENTICATION_SERVICES=() value to none. Otherwise, proceed to step 2.

  • To set the sqlnet.ora file SQLNET.AUTHENTICATION_SERVICES=() value, perform the following steps in this order:
  • Open sqlnet.ora, located in the %Oracle_Home%\network\admin folder (for example, c:\oracle\product\12.1.0.2\db_1\NETWORK\ADMIN), using a text editor.
  • Change the SQLNET.AUTHENTICATION_SERVICES=(NTS)value to none: SQLNET.AUTHENTICATION_SERVICES=(none)
  • Save and close the sqlnet.ora file.

2 Start the Oracle Net Configuration Assistant by selecting Start > All Programs > Oracle 12.1.0.2 > Configuration and Migration Tools > Net Configuration Assistant.

3 On the Welcome panel, select Listener configuration and click Next.

4 On the Listener Configuration, Listener panel, select Add and click Next.

5 On the Listener Configuration, Listener Name panel, enter a listener name and the password for your Oracle Home User, then click Next.

  • Note: Use the default listener name, LISTENER, unless you must use a different name.

6 On the Listener Configuration, Select Protocols panel, select the TCP protocol and click Next.

7 On the Listener Configuration, TCP/IP Protocol panel, select Use the standard port number of 1521 and click Next.

8 On the Listener Configuration, More Listeners? panel, select No and click Next.

9 On the Listener Configuration Done panel, click Next.

10 Configure the Local Net Service Name in the Oracle Net Configuration Assistant.

11 On the computer that runs your Oracle database, open a command prompt.

  • The command window must run as Administrator. (See your Microsoft Windows documentation.)

12 Run the following command:

  • lsnrctl stop

13 Open the following file in a text editor:

  • %ORACLE_ HOME%\network\admin\listener.ora

14 Locate the following line:

  • (ADDRESS = (PROTOCOL = IPC)(KEY = <key_value>))

15 Change key_value to PROTECT.

16 Add the following line to the end of the file:

  • SECURE_REGISTER_LISTENER = (IPC)

17 Save the file and exit the text editor.

18 Run the following command:

  • lsnrctl start

19 Run the following commands to connect to the database using SQL Plus:

  • sqlplus /nolog
  • conn sys/<password> as sysdba

20 Run the following command:

  • ALTER SYSTEM SET local_listener = '(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PROTECT)))' SCOPE=both;

21 Run the following command to register the listener:

  • ALTER SYSTEM REGISTER;

22 Exit SQL Plus by running the following command:

  • Exit

23 Run the following command to verify the change:

  • lsnrctl services

24 The command output should display a message similar to the following:

Services Summary...

Service "protect" has 1 instance(s).

Instance "protect", status READY, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0 state:ready

LOCAL SERVER

The command completed successfully

Perform the following procedure to configure the Local Net Service Name for the Symantec Data Loss Prevention database.

1 If the Oracle Net Configuration Assistant is not already running, start it by selecting Start > All Programs > Oracle 12.1.0.2 > Configuration and Migration Tools > Net Configuration  

Assistant.

2 On the Welcome panel, select Local Net Service Name configuration and click Next.

3 On the Net Service Name Configuration panel, select Add and click Next.

4 On the Net Service Name Configuration, Service Name panel, enter "protect" in the Service Name field and click Next.

5 On the Net Service Name Configuration, Select Protocols panel, select TCP and click Next.

6 On the Net Service Name Configuration, TCP/IP Protocol panel:

  • Enter the IP address of the Oracle server computer in the Host name field.
  • Select Use the standard port number of 1521 (the default value).
  • Click Next.

7 On the Net Service Name Configuration, Test panel, select No, do not test and click Next.

  • Do not test the service configuration, because the listener has not yet started.

8 On the Net Service Name Configuration, Net Service Name panel, select accept the default name of "protect" and click Next.

9 On the Net Service Name Configuration, Another Net Service Name? panel, select No and click Next.

10 On the Net Service Name Configuration Done panel, select Next.

11 Click Finish to exit the Oracle Net Configuration Assistant.

Verify the database was created correctly

1 Open a new command prompt and start SQL*Plus: sqlplus /nolog

2 Log on as the SYS user: SQL> connect sys/[email protected] as sysdba

  • Where password represents the SYS password.

3 Run the following query: SQL> SELECT * FROM v$version;

4 Make sure that the output from the query contains the following information, which identifies the software components as version 12.1.0.2.

  • The output information should read:

           BANNER

           --------------------------------------------------------------------------------

           Oracle Database 12c Release 12.1.0.2.0 - 64-bit Production

            PL/SQL Release 12.1.0.2.0 - Production

            CORE 12.1.0.2.0 Production

            TNS for 64-bit Windows: Version 12.1.0.2.0 - Production

            NLSRTL Version 12.1.0.2.0 – Production

5 Exit SQL*Plus: SQL> exit