Altering Database Parameters with BR*Tools

You can use BR*Tools for Oracle to alter the database parameters as follows:

Note Note

This section describes how you alter database parameters.

Altering database parameters is part of Instance Management with BR*Tools.

For more information on the approach to database instance management, see Instance Management.

End of the note.

Start the procedure using BRGUI or BRTOOLS, or from the command line:

BRGUI or BRTOOLS:

Choose Instance Management Alter database parameters .
BRGUI or BRTOOLS displays the menu BRSPACE options for alter database parameter, where you specify the options with which you call BRSPACE.

Set the required options:

Menu Entry	Equivalent BRSPACE Command Option
BRSPACE profile (profile)	-p\|-profile
Database user/password (user)	-u\|-user
Alter parameter action (action)	-f dbparam -a\|-action
Database parameter (parameter)	-f dbparam -p\|-parameter
Confirmation mode (confirm)	-c\|-confirm
Scrolling line count (scroll)	-s\|-scroll
Message language (language)	-l\|-language
BRSPACE command line (command)	This shows you the BRSPACE -f dbparam command that is to be executed using the current settings.

BRSPACE starts and you see a message that includes Start of BRSPACE processing. From now on, BRSPACE writes a detail log.

You can use quick mode as follows:
- If you have already entered the action, continue with step 4.
- If you have already entered the parameter name and action, continue with step 7.
BRSPACE displays the Alter database parameter main menu.
Choose or confirm the required action:
- Change parameter value
- Reset parameter value
- Create init.ora from spfile
- Create init.mem from memory
If you chose Create init.ora from spfile or Create init.mem from memory, respond to the BRSPACE prompt asking you whether you want to start the function. You have now finished the procedure. See “Results” below.

If you have already entered the parameter name, continue with step 7 (quick mode).

BRSPACE displays the database parameter list:

List Entry	Meaning
Pos.	List sequence number
Parameter	Parameter name
Modif.	Modification attributes: no – unmodifiable yes – modifiable for the lifetime of an instance spfile – modifiable in spfile both – modifiable in spfile and for the lifetime of an instance defer – in subsequent sessions, modifiable in spfile and for the lifetime of an instance
Spfile	Whether parameter is specified in spfile: Yes – parameter is specified no – parameter is not specified inst – parameter is specified with an instance-specific value
Inst.	Database instance the parameter is set for: * means all instances
Deft.	Whether parameter has default value, yes / no
Value	Current parameter value

Select a database parameter.
BRSPACE displays the menu, Options for alter of database parameter.

Set the required options:

Menu Entry	Meaning
Parameter description (desc) – display only	Parameter description from V$PARAMETER
Parameter type (type) – display only	Type of parameter: Boolean, string, integer, file
Current parameter value (parval) – display only	Current parameter value
Value in spfile (spfval) – display only	Current value in spfile
New parameter value (value)	-f dbparam -v\|-value This entry is locked if reset parameter value was chosen
Scope for new value (scope)	-f dbparam -s\|-scope
Database instance (instance)	-f dbparam -i\|-instance
Comment on update (comment)	-f dbparam -c\|-comment
SQLPLUS command (command)	The SQL command that is to be executed using the current settings. For more information, see your Oracle SQL documentation.

Check the results in the BRSPACE Logs.

For more information about how to view the logs with BR*Tools, see Showing Profiles and Logs with BR*Tools.