trying to disable AMM
I have a rac database running on rhel6 rdbms version 11.2.0.3 and the database was created with dbca and the aoutmatic memory option wa chosen during database creation which was a mistake because we are trying to configure our system to use large memory pages because the server has alot of ram and we want a large sga size of 128G.
A created a pfile from the spfile and have been trying to disable AMM by setting the memory_target annd the memory_max_target to zero and the manually setting the sga_target and the sga_max_target to 128g and I am also setting the pga_aggregate_target to 10G.
When I try and start the instance with the newly created pfile I keep getting the following message not matter what configuration I have tried...
ORA-00371: not enough shared pool memory, should be atleast 1204086121 bytes
Here are the original settings from the spfile, could anyone tell me what I am doing wrong because I just want ASMM because it is compatible with hugepages.
racprod1.__db_cache_size=134217728000
racprod2.__db_cache_size=134217728000
racprod1.__java_pool_size=536870912
racprod2.__java_pool_size=536870912
racprod1.__large_pool_size=536870912
racprod2.__large_pool_size=536870912
racprod1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
racprod1.__pga_aggregate_target=104152956928
racprod2.__pga_aggregate_target=104152956928
racprod1.__sga_target=155692564480
racprod2.__sga_target=155692564480
racprod1.__shared_io_pool_size=0
racprod2.__shared_io_pool_size=0
racprod1.__shared_pool_size=18790481920
racprod2.__shared_pool_size=18790481920
racprod1.__streams_pool_size=0
racprod2.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/racprod/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+DATA_DG/racprod/control01.ctl','+DATA_DG/racprod/control02.ctl'
*.db_block_size=16384
*.db_domain='quillcorp.com'
*.db_name='racprod'
*.db_recovery_file_dest='+RECOVERY_DG'
*.db_recovery_file_dest_size=78643200000
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=racprodXDB)'
racprod1.instance_number=1
racprod2.instance_number=2
*.log_archive_format='%t_%s_%r.dbf'
*.memory_target=242G
*.open_cursors=300
*.processes=3000
*.remote_listener='qlnplnxrac01.quillcorp.com:1521'
*.remote_login_passwordfile='exclusive'
*.sessions=3305
racprod2.thread=2
racprod1.thread=1
racprod2.undo_tablespace='UNDOTBS2'
racprod1.undo_tablespace='UNDOTBS1'