Link to home
Start Free TrialLog in
Avatar of jcob_l
jcob_l

asked on

memory-target

This is the error I see in standby server..
SQL> startup nomount
ORA-00845: MEMORY_TARGET not supported on this system
SQL> exit
Disconnected
[oracle@newmac dbs]$
 
Here is the initstand.ora
 
stand.__db_cache_size=213909504
stand.__java_pool_size=4194304
stand.__large_pool_size=4194304
stand.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environment
stand.__pga_aggregate_target=251658240
stand.__sga_target=369098752
stand.__shared_io_pool_size=0
stand.__shared_pool_size=138412032
stand.__streams_pool_size=0
*.audit_file_dest='/oracle/app/oracle/admin/stand/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/oracle/app/oracle/oradata/stand/control01.ctl','/oracle/app/oracle/flash_recovery_area/stand/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='/oracle/app/oracle/oradata/dest','/oracle/app/oracle/oradata/stand'
*.db_name='dest'
*.db_recovery_file_dest='/oracle/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest='/oracle/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=standXDB)'
*.fal_client='stand'
*.fal_server='dest'
*.log_archive_config='dg_config=(dest,stand)'
*.log_archive_dest_1='location=/backup valid_for=(all_logfiles,all_roles) db_unique_name=stand'
*.log_archive_dest_2='service=dest valid_for=(online_logfile,primary_role) db_unique_name=dest'
*.log_archive_dest_state_2='defer'
*.log_file_name_convert='/oracle/app/oracle/oradata/dest','/oracle/app/oracle/oradata/stand'
*.memory_target=620756992
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'



This is the memory target parameter..

How can I adjust this..
ASKER CERTIFIED SOLUTION
Avatar of johnsone
johnsone
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
check that your shared memory filesystem on the OS is big enough to contain the memory_target parameter.
have a look at this page: http://www.krenger.ch/blog/ora-00845-memory_target-not-supported-on-this-system/
It appears that your syntax requires a value expressed in K, M, or G.  It is adjustable with the ALTER SYSTEM command as documented here and elsewhere:

http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams133.htm
Avatar of jcob_l
jcob_l

ASKER

yes