Altering Database Parameters with BR*Tools 

Use

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

·        Alter database parameter

·        Reset database parameter

·        Create init<DBSID>.oraprofile from spfile

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.

Procedure

...

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

¡        BRGUI or BRTOOLS:

                                                  i.       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.

                                                ii.       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.

                                               iii.       Choose Continue.

BRGUI or BRTOOLS prompts you to start BRSPACE.

                                               iv.       Choose Continue to start BRSPACE.

¡        Command line:

...

Enter at least the following command:

brspace –f dbparam

You can enter more parameters, including the parameter name and action, if required. For more information, see BRSPACE -f dbparam.

Whichever way you start the procedure – with BRGUI or BRTOOLS, or from the command line – you can use quick mode if you know the object name, in this case the parameter name. For more information, see How to Use BR*Tools.

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

BRSPACE displays the Alter database parameter main menu.

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

       3.      Choose or confirm the required action:

¡        Change parameter value

¡        Reset parameter value

¡        Create init.ora from spfile

       4.      If you chose Create init.ora from spfile, respond to the BRSPACE prompt asking you whether you want to start the function. You have now finished the procedure. See “Results” below.

       5.      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
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

       6.      Select a database parameter.

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

       7.      Set the required options:

Menu Entry	Meaning
Parameter description (desc) – display only	Parameter description from V$PARAMETER
Parameter type (type)	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.

       8.      To start processing with the selected options, choose Continue.

Results

Check the results in the BRSPACE logs.

·        The summary log space<DBSID>.logdisplays the return code.

·        The detail log s<encoded timestamp>.dbp displays the details.

·        The parameter change log param<DBSID>.log logs all parameter changes.

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