Although the initialization parameters can be modified, they cannot be modified using the specified command
SQL> show parameter inmemory_size;
NAME TYPE VALUE
------------------------ ----------- ------
inmemory_size big integer 0
SQL> alter system set inmemory_size=200m scope=spfile;
alter system set inmemory_size=200m scope=spfile
*
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this option
Check the v$parameter data dictionary view to see if a parameter can be changed in the session or at the system level
SQL> select isses_modifiable, issys_modifiable from v$parameter where name='inmemory_size'; ISSES_MODIFIABLE ISSYS_MODIFIABLE ---------------- ---------------- FALSE IMMEDIATE
In summary, I restarted the CDB and executed the command again after successful execution.
Enumeration value of issys_modifiable
| FALSE | Indicates that the parameter cannot change its value during the life cycle of the instance; the database needs to be restarted for the change to take effect |
| IMMEDIATE | The value indicates that it is dynamic and can be set to change the current active instance and restart the database in the future |
| DEFFERED | It is also dynamic, but the change will only affect subsequent sessions, the currently active session will not be affected and retain the old parameter values |
Similar Posts:
- How to Solve Rac ORA-01102 error: cannot mount database in EXCLUSIVE mode
- PING[ARC2]: Heartbeat failed to connect to standby ‘gqtzdb_dg’. Error is 16047
- Resolution of ora-00600 Issues [4194]
- How to Solve Error: Oracle11g alarm log error ora-04030
- Error: [$compile:nonassign] Expression used with directive ‘uibTab’ is non-assignable
- Streams AQ: enqueue blocked on low memory wait event causes slow expdp export
- [Solved] Oracle Error: SGA_MAX_SIZE cannot be set to more than MEMORY_TARGET
- Sometimes ora-04062 error occurs when database is running stored procedure
- lgwr terminating the adg database instance due to error 4021 [How to Solve]
- oracle ORA-39700: database must be opened with UPGRADE option