Unsetting a parameter in the spfile using alter system
Is there any way to unset a parameter using the ALTER SYSTEM command? Currently I have LOCAL_LISTENER set and I want to null it out, but don't want to shut down the db. I found another posting that says to do this:
ALTER SYSTEM SET LOCAL_LISTENER=NONE scope=both;
but got an error:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'NONE'
Also tried this:
ALTER SYSTEM RESET LOCAL_LISTENER scope=both;
But since it originally had a default value, that's what it was reset to instead of null.
Any ideas?