During creation of Oracle listener, error when adding local_listener to db parameters

Products

• Data Loss Prevention Enforce
• Data Loss Prevention Oracle Standard Edition 2

Issue/Introduction

After running the following command:

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

You receive an error message and the DB will not run

Cause

The command uses "scope = both", this requires that that the spfile both exists and can be written to.

Default file name for spfile = spfileprotect.ora

 

 

Resolution

Restart the database.

When back at the SQL prompt, instead of "scope = both", use "scope=memory" as part of the command. 

Create a new spfile that can be written to. 

Additional Information

Also, review the initprotect.ora file and comment out the local listener line (using #) or delete the line