To: (ADDRESS = (PROTOCOL = IPC)(KEY = [CORRECT VALUE]))
add the following line to the end of the "listener.ora" file: SECURE_REGISTER_LISTENER = (IPC)
Save & Close "listener.ora"
run the following command in CMD to start the listener(open a new window as administrator if you closed the previous one) lsnrctl start
run SQL Plus in the CMD windows sqlplus /nolog
connect to the database conn sys/<password> as sysdba
run the following command ALTER SYSTEM SET local_listener = '(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PROTECT)))' SCOPE=both; **note that it is case sensitive and sensitive to spaces, recommend to copy/paste the command
run the following command to register the listener ALTER SYSTEM REGISTER;
exit SQL exit;
verify the change to the listener: lsnrctl services
Configure Local NET Service name:
open the "Oracle Net Configuration Assistant"
Start > All Programs > Oracle 220.127.116.11 > Configuration and Migration Tools > Net Configuration Assistant
Select the "Local Net Service Name Configuration"
enter "protect" as the service name
Hostname: IP Address of the Oracle Server (or FQDN) use the standard port number of 1521
use the default service name of "protect"
select "No, do not test"
click "Finish" to close the assistant
Create the Oracle User Account for DLP:
change directory to where you extracted your Oracle Tools
open SQL Plus: sqlplus /nolog
run the "oracle_create_user.sql" script: @oracle_create_user.sql
you will be prompted for the following information
Verify the database is setup correctly: Open CMD
- open SQL Plus
- Log on as the SYS user
connect sys/<SYS Password>@protect as sysdba
connect sys/Prot3ctD3mo@protect as sysdba
- Run the following query
SELECT * FROM v$version;
confirm the versions listed are all showing the correct version (18.104.22.168)
exit SQL Plus
Subscribing will provide email updates when this Article is updated. Login is required.