Create the Oracle Database on Windows for Data Loss Prevention
Article ID: 172344
Updated On:
Products
Issue/Introduction
Detailed instructions on how to install Oracle 19c on Windows can be found in the Symantec Data Loss Prevention Oracle Implementation Guide. This article assumes you have already installed Oracle 19c software.
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\19.0.0\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 19.0.0.0_64_bit_Installation_Tools.zip file.
3 Copy the database template file (Oracle_19.0.0.0_Template_for_DLP_v14.6_64_bit_WIN.dbt) from theC:\temp\Oracle\tools folder to the C:\oracle\product\19.0.0.0\db_1\assistants\dbca\templates folder.
4 (Optional) Rename the OraDb12c_home1 section of the Windows Start menu item to Oracle_19.0.0.0.
5 Open a command prompt, and execute the following command:
- %ORACLE_HOME%\bin\dbca -progressOnly -responseFile C:\temp\Oracle\tools\responsefiles\Oracle_19.0.0.0_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.
- Do not use the "@" or "&" characters.
- 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 your password begins with anything other than a letter, you must enclose the password in double quotes when you configure it.
- It is highly recommended to start your password with a letter.
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\19.0.0.0\db_1\cfgtoollogs\dbca\protect. The logs can provide information to repair or restart the database.
- 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\19.0.0.0\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 19.0.0.0 > 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.
- See “Configuring the local net service name” on the Symantec Data Loss Prevention Oracle Implementation Guide
- Note: You must click Finish to exit the Oracle Net Configuration Assistant before continuing with this procedure.
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 19.0.0.0 > 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/password@protect 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 19.0.0.0.
- The output information should read:
BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Release 19.0.0.0.0 - 64-bit Production
PL/SQL Release 19.0.0.0.0 - Production
CORE 19.0.0.0.0 Production
TNS for 64-bit Windows: Version 19.0.0.0.0 - Production
NLSRTL Version 19.0.0.0.0 – Production
5 Exit SQL*Plus: SQL> exit
Feedback
