Background documentation-7084: Parameter change not allowed Locate this document in the navigation structure

 

Explanation

You tried to modify the value of an installation parameter using a SET statement. The database system, however, could not modify the value for one of the following reasons:

  • The installation parameter is not modifiable.

  • The installation parameter is not modifiable when in the ONLINE or ADMIN operating state.

User Response

The following options are available:

  • Do without the modification.

  • If the installation parameter cannot be modified when in the ONLINE or ADMIN operating state, change the state of the database instance to OFFLINE, make the necessary modification, and then change the database instance back to the required operating state.