This BRSPACE function changes the value of database parameters. For more information, see Altering Database Parameters with BR*Tools.
Function options:
-a|-action: specifies the action to change the database parameter
Syntax: -a|-action change|reset|create
change changes a database parameter
reset resets a database parameter
create creates the init<DBSID>.ora file from the spfile
Default: None, since you must always specify an action
-c|-comment: lets you enter a comment on the parameter change
Default: No comment
-i|-instance: defines for which database instance the parameter change is to apply
Syntax: -i|-instance <instance>
<instance> changes the parameter of the specified instance
Default: changes the parameter for all instances
Note
You only need to specify database instances in an Oracle Real Application Cluster (RAC) system.
-p|-parameter: defines which database parameter is to be changed
Syntax: -p|-parameter <parameter>
<parameter> changes the specified parameter
Default: none, since you must always specify a parameter to change
Note
You must specify this option if you want to set a special parameter (that is, a “_” parameter). For more information, see SAP Note 744585.
-s|-scope: defines the scope of the parameter change
Syntax: -s|-scope memory|spfile|both
memory changes the parameter immediately for the specified running instances
spfile changes the parameter in the Oracle spfile for the specified instances, but this takes effect only after the instance has been restarted
both changes the parameter in both memory and spfile for the specified instances
Default: both
-v|-value: defines the new parameter value
Syntax: -v|-value <value>
<value> specifies the new parameter value
Default: none, since you must always specify the new parameter value.