Change parameter with scope=both

[Former Member]

Hi guys, I am an Oracle's DBA, and I have a question:

Are there any way to modify an oracle parameter (for example: log_buffer) through BRTools with the option scope=both?, because the BRTools show me only the spfile option.

Thanks in advance.

[Former Member · Accepted solution]

log_buffer is a static parameter, hence using brtools you will have only spfile option.

If you choose any dynamic parameters like open_cursors, you will have the memory|spfile|both options as shown below

1 * Parameter description (desc) ..... [max # cursors per session]

2 * Parameter type (type) ............ [integer]

3 * Current parameter value (parval) . [800]

4 * Value in spfile (spfval) ......... [<same>]

5 ? New parameter value (value) ...... []

6 - Scope for new value (scope) ...... [both]

7 # Database instance (instance) ..... []

8 ~ Comment on update (comment) ...... []

9 - SQL command (command) ............ [alter system set open_cursors = scope = both]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

6

BR0280I BRSPACE time stamp: 2010-11-17 16.17.51

BR0663I Your choice: '6'

BR0280I BRSPACE time stamp: 2010-11-17 16.17.51

BR0681I Enter string value for "scope" (memory|spfile|both) [both]:

For static, you can see only spfile option

BR0657I Input menu 212 - please enter/check input values

-

---

Options for alter of database parameter 'sessions'

1 * Parameter description (desc) ..... [user and system sessions]

2 * Parameter type (type) ............ [integer]

3 * Current parameter value (parval) . [160]

4 * Value in spfile (spfval) ......... [<same>]

5 ? New parameter value (value) ...... []

6 - Scope for new value (scope) ...... [spfile]

7 # Database instance (instance) ..... []

8 ~ Comment on update (comment) ...... []

9 - SQL command (command) ............ [alter system set sessions = scope = spfile]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

6

BR0280I BRSPACE time stamp: 2010-11-17 16.14.37

BR0663I Your choice: '6'

BR0280I BRSPACE time stamp: 2010-11-17 16.14.37

BR0681I Enter string value for "scope" (spfile) [spfile]:

Regards

Senthil