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=2139 09504
stand.__java_pool_size=419 4304
stand.__large_pool_size=41 94304
stand.__oracle_base='/orac le/app/ora cle'#ORACL E_BASE set from environment
stand.__pga_aggregate_targ et=2516582 40
stand.__sga_target=3690987 52
stand.__shared_io_pool_siz e=0
stand.__shared_pool_size=1 38412032
stand.__streams_pool_size= 0
*.audit_file_dest='/oracle /app/oracl e/admin/st and/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/oracle/a pp/oracle/ oradata/st and/contro l01.ctl',' /oracle/ap p/oracle/f lash_recov ery_area/s tand/contr ol02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='/o racle/app/ oracle/ora data/dest' ,'/oracle/ app/oracle /oradata/s tand'
*.db_name='dest'
*.db_recovery_file_dest='/ oracle/app /oracle/fl ash_recove ry_area'
*.db_recovery_file_dest_si ze=4039114 752
*.diagnostic_dest='/oracle /app/oracl e'
*.dispatchers='(PROTOCOL=T CP) (SERVICE=standXDB)'
*.fal_client='stand'
*.fal_server='dest'
*.log_archive_config='dg_c onfig=(des t,stand)'
*.log_archive_dest_1='loca tion=/back up valid_for=(all_logfiles,al l_roles) db_unique_name=stand'
*.log_archive_dest_2='serv ice=dest valid_for=(online_logfile, primary_ro le) db_unique_name=dest'
*.log_archive_dest_state_2 ='defer'
*.log_file_name_convert='/ oracle/app /oracle/or adata/dest ','/oracle /app/oracl e/oradata/ stand'
*.memory_target=620756992
*.open_cursors=300
*.processes=150
*.remote_login_passwordfil e='EXCLUSI VE'
*.standby_file_management= 'AUTO'
*.undo_tablespace='UNDOTBS 1'
This is the memory target parameter..
How can I adjust this..
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=2139
stand.__java_pool_size=419
stand.__large_pool_size=41
stand.__oracle_base='/orac
stand.__pga_aggregate_targ
stand.__sga_target=3690987
stand.__shared_io_pool_siz
stand.__shared_pool_size=1
stand.__streams_pool_size=
*.audit_file_dest='/oracle
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/oracle/a
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='/o
*.db_name='dest'
*.db_recovery_file_dest='/
*.db_recovery_file_dest_si
*.diagnostic_dest='/oracle
*.dispatchers='(PROTOCOL=T
*.fal_client='stand'
*.fal_server='dest'
*.log_archive_config='dg_c
*.log_archive_dest_1='loca
*.log_archive_dest_2='serv
*.log_archive_dest_state_2
*.log_file_name_convert='/
*.memory_target=620756992
*.open_cursors=300
*.processes=150
*.remote_login_passwordfil
*.standby_file_management=
*.undo_tablespace='UNDOTBS
This is the memory target parameter..
How can I adjust this..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams133.htm
ASKER
yes
have a look at this page: http://www.krenger.ch/blog/ora-00845-memory_target-not-supported-on-this-system/