After altering (increasing) the ‘memory max target’ and ‘memory target’ of an Oracle database, you will have to run these statements as sysdba to restart the database. By not doing so, you will not have the necessary permission to perform some necessary tasks.
Sysdba grants the necessary privilege to administer the database.
Note: This requires a restart and do not necessarily have to restart the whole Db if it is in production, simply follow these commands before after modifying the ‘memory_max_target’ and ‘memory_target’ value of the Oracle Db. Simply run in sqlplus
sysys /as sysdba
Next
shutdown immediate
Next, enter the command as fast as possible
startup
This will ensure the changes are applied to the database.
Test to ensure the parameters are okay and changes propagated correctly.
show parameter memory