sreimer
Reputation: 4998
Set Oracle system parameter back to default
The parameter in question is LOCAL_LISTENER. Previously when running SHOW PARAMETER LOCAL_LISTENER no value was returned. Some time ago this was changed to some value. We are now having listener issues and want to get it back to default. Do I use the same ALTER SYSTEM command, but with a blank string or is there some other way?
Upvotes: 0
Views: 525
Answers (1)
Related Questions
- How to change default Oracle 11g to 19c in cli Windows 10?
- Default value for paramteters not passed SQLPlus script
- How to change the value of the default systimestamp in oracle
- In Oracle, how do you change the 'default' database?
- Oracle set multiple system variables
- How do you set linesize, pagesize, and other environment parameters permanently in Oracle 10g?
- Opposite of Oracle "ALTER SYSTEM SET" Command
- How to change the V$NLS_PARAMETERS permanently?
- How to permanently save settings of SQL * Editor?
- Oracle 9.2 migrated to 11g - Default values