1. As ORASID, execute command BRTOOLS. Select 1 = Instance management.
------------------------------------------------------------------------------- BR*Tools main menu 1 = Instance management 2 - Space management 3 - Segment management 4 - Backup and database copy 5 - Restore and recovery 6 - Check and verification 7 - Database statistics 8 - Additional functions 9 - Exit program Standard keys: c - cont, b - back, s - stop, r - refr, h - help -------------------------------------------------------------------------------
2. Select 4 – Alter database parameters.
------------------------------------------------------------------------------- Database instance management 1 = Start up database 2 - Shut down database 3 - Alter database instance 4 - Alter database parameters 5 - Recreate database 6 - Manage online redolog 7 - Manage data encryption 8 - Additional instance functions 9 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help -------------------------------------------------------------------------------
3. Select “c” to continue.
------------------------------------------------------------------------------- BRSPACE options for alter database parameter 1 - BRSPACE profile (profile) ....... [initSID.sap] 2 - Database user/password (user) ... [/] 3 ~ Alter parameter action (action) . [] 4 ~ Database parameter (parameter) .. [] 5 - Confirmation mode (confirm) ..... [yes] 6 - Scrolling line count (scroll) ... [20] 7 - Message language (language) ..... [E] 8 - BRSPACE command line (command) .. [-p initSID.sap -s 20 -l E -f dbparam] Standard keys: c - cont, b - back, s - stop, r - refr, h - help -------------------------------------------------------------------------------
4. Select “c” again to continue.
BR0259I Program execution will be continued... BR0291I BRSPACE will be started with options '-p initSID.sap -s 20 -l E -f dbparam' BR0280I BRTOOLS time stamp: 2013-09-16 11.48.11 BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
5. Select 1 = Change parameter value.
------------------------------------------------------------------------------- Alter database parameter main menu 1 = Change parameter value 2 - Reset parameter value 3 - Create init.ora from spfile 4 - Create init.mem from memory 5 - Show database parameters 6 - Show init.ora profile 7 * Exit program 8 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help -------------------------------------------------------------------------------
6. Select the parameter which listed to change. As an example, you want to add new value on parameter for _fix_control. Select 1.
------------------------------------------------------------------------------- List of database parameters for alter Pos. Parameter Modif. Spfile Inst. Deft. Value 1 - _fix_control both yes * no 5099019:ON 2 - _mutex_wait_scheme both yes * no 1 3 - _mutex_wait_time both yes * no 10 4 - _optim_peek_user_binds both yes * no FALSE 5 - _optimizer_use_feedback both yes * no FALSE 6 - active_instance_count spfile no * yes <null> 7 - aq_tm_processes both no * yes 0 Press <Rtn> - scroll, <n> - select, c - cont, s - skip, b - back, h - header
7. Select 5 – New parameter value (value) to add the new parameter and select “c” to continue.
------------------------------------------------------------------------------- Options for alter of database parameter '_fix_control' 1 * Parameter description (desc) ..... [bug fix control parameter] 2 * Parameter type (type) ............ [string] 3 * Current parameter value (parval) . ['5099019:ON'] 4 * Value in spfile (spfval) ......... [<same>] 5 - New parameter value (value) ...... ['5099019:ON','6055658:OFF'] 6 - Scope for new value (scope) ...... [both] 7 # Database instance (instance) ..... [] 8 ~ Comment on update (comment) ...... [] 9 - SQL command (command) ............ [alter system set "_fix_control" = '5099019:ON','6055658:OFF' scope = both] Standard keys: c - cont, b - back, s - stop, r - refr, h - help -------------------------------------------------------------------------------
8. The parameter changes will start and please be noted that some parameters will require a restart to active.
BR0259I Program execution will be continued... BR0370I Directory /oracle/SID/sapreorg/semcjtnc created BR0202I Copying /oracle/SID/112_64/dbs/spfileSID.ora BR0203I to /oracle/SID/sapreorg/semcjtnc/spfileSID.ora ... BR0280I BRSPACE time stamp: 2013-09-16 11.53.31 BR1016I SQL statement 'alter system set "_fix_control" = '5099019:ON','6055658:OFF' scope = both' executed successfully BR1031I Database parameter _fix_control altered successfully from ''5099019:ON'' to ''5099019:ON','6055658:OFF'' BR0280I BRSPACE time stamp: 2013-09-16 11.53.31 BR0477I Oracle pfile /oracle/SID/112_64/dbs/initSID.ora created from spfile /oracle/SID/112_64/dbs/spfileSID.ora
