Hi All,
2 Node RAC with ASM on SuSE Linux 10 SP2. Oracle 11g R2.
I had initial Parameter setting as follows
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 1000M
sga_target big integer 1000M
SQL> SHOW PARAMETER PGA
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 333M
SQL> SHOW PARAMETER MEMORY
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 0
memory_target big integer 0
shared_memory_address integer 0
I changed them to
SQL> ALTER SYSTEM SET MEMORY_MAX_TARGET=3G SCOPE=SPFILE;
System altered.
SQL> ALTER SYSTEM SET MEMORY_TARGET=3G SCOPE=SPFILE;
System altered.
SQL> ALTER SYSTEM SET SGA_MAX_SIZE=2333M SCOPE=SPFILE;
System altered.
SQL> ALTER SYSTEM SET PGA_AGGREGATE_TARGET=0 SCOPE=SPFILE;
System altered.
SQL> ALTER SYSTEM SET SGA_TAGRET=0 SCOPE=SPFILE;
ALTER SYSTEM SET SGA_TAGRET=0 SCOPE=SPFILE
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM
SQL> ALTER SYSTEM SET SGA_TAGRET=0;
ALTER SYSTEM SET SGA_TAGRET=0
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM
I was unable to restart
SQL> startup force
ORA-00845: MEMORY_TARGET not supported on this system
I created pfile and tried to start, but in vain
SQL> create pfile='/home/oracle/aqadev.ora' from spfile='+AQADATA/aqadev/spfileaqadev.ora';
File created.
contents of my pfile (memory_target value is removed)
oracle@INBGEDV50:~> cat aqadev.ora
AQADEV2.__db_cache_size=524288000
AQADEV1.__db_cache_size=398458880
AQADEV2.__java_pool_size=4194304
AQADEV1.__java_pool_size=4194304
AQADEV2.__large_pool_size=4194304
AQADEV1.__large_pool_size=4194304
AQADEV1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
AQADEV2.__pga_aggregate_target=352321536
AQADEV1.__pga_aggregate_target=352321536
AQADEV2.__sga_target=1048576000
AQADEV1.__sga_target=1048576000
AQADEV2.__shared_io_pool_size=0
AQADEV1.__shared_io_pool_size=0
AQADEV2.__shared_pool_size=494927872
AQADEV1.__shared_pool_size=620756992
AQADEV2.__streams_pool_size=8388608
AQADEV1.__streams_pool_size=8388608
*.audit_file_dest='/u01/app/oracle/admin/AQADEV/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+AQADATA/aqadev/controlfile/current.260.781108849'
*.db_block_size=8192
*.db_create_file_dest='+AQADATA'
*.db_create_online_log_dest_1='+AQADATA'
*.db_domain=''
*.db_name='AQADEV'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=AQADEVXDB)'
AQADEV1.instance_number=1
AQADEV2.instance_number=2
*.memory_max_target=3221225472
*.open_cursors=300
*.pga_aggregate_target=0
*.processes=150
*.remote_listener='myhost.mysite.com:1521'
*.remote_login_passwordfile='exclusive'
*.sga_max_size=2446327808
*.sga_target=0
*.star_transformation_enabled='TRUE'
AQADEV2.thread=2
AQADEV1.thread=1
AQADEV1.undo_tablespace='UNDOTBS1'
AQADEV2.undo_tablespace='UNDOTBS2'
Tail of alert log file
Tue May 08 17:14:18 2012
Starting ORACLE instance (normal)
WARNING: You are trying to use the MEMORY_TARGET feature. This feature requires the /dev/shm file system to be mounted for at least 2449473536 bytes. /dev/shm is either not mounted or is mounted with available space less than this size. Please fix this so that MEMORY_TARGET can work as expected. Current available is 1401778176 and used is 171085824 bytes. Ensure that the mount point is /dev/shm for this directory.
memory_target needs larger /dev/shm
Why is it still reading memory_target, when it is not part of pfile?