Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to change MEMORY_TARGET in 12.2 +ASM instance with clusterware

User_8P8IJDec 31 2017 — edited Jan 2 2018

I tried two ways.

1. Alter system set memory_target = <> scope =spfile; and then restarted the whole cluster as it didn't allow me to reboot ASM instance as only one node.

2. created pfile from spfile and modified it. Then created a new spfile from pfile and deleted the old spfile. Then restarted the whole cluster.

Both ways nothing happens. When i start the cluster by default the memeory_target is 1GB. How this works??

One more point : when i create a pfile from spfile and i see the changed value of memory target but that is not in memeory even after restart of clsuterware. How is it possible. It seems +ASM instance is not reading the spile in ASM DISKS represented by spfile parameter.

I really need help.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 30 2018
Added on Dec 31 2017
8 comments
1,916 views