Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to set db parameter

unknown-2698904Aug 8 2014 — edited Aug 8 2014

Hi all,

11.2.0.3.11

aix6

Our db parameter LOCAL_LISTENER has value assigned.

SQL> show parameter listener

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

listener_networks string

local_listener string LISTENER_PROD1

remote_listener string

I want to set this to null.

Whicj command is correct?

a. ALTER SYSTEM SET LOCAL_LISTENER=NULL;

b. ALTER SYSTEM SET LOCAL_LISTENER=" "; << double quotes with 1 space

c. ALTER SYSTEM SET LOCAL_LISTENER=' '; << single quote with 1 space

d. ALTER SYSTEM SET LOCAL_LISTENER=''; << singe qoute with 0 space

e. ALTER SYSTEM SET LOCAL_LISTENER=""; << double quotes with 0 space

Thanks all,

This post has been answered by Suntrupth on Aug 8 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 5 2014

Added on Aug 8 2014

#general-database-discussions

2 comments

962 views