Show TOC

Altering Database Parameters with BR*ToolsLocate this document in the navigation structure

Context

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

  • Alter database parameter

  • Reset database parameter

  • Create init<DBSID>.ora profile from spfile

  • Create init<DBSID>.mem profile from memory

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.

Procedure


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

    • BRGUI or BRTOOLS:

      1. Choose Start of the navigation path Instance Management Next navigation step Alter database parameters End of the navigation path.

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

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

      3. Choose Continue.

        BRGUI or BRTOOLS prompts you to start BRSPACE.

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

      Note

      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.

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

  3. Choose or confirm the required action:

    • Change parameter value

    • Reset parameter value

    • Create init.ora from spfile

    • Create init.mem from memory

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

  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

    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

  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)

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

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

Results

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.