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..
jcob_lAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

johnsoneSenior Oracle DBACommented:
Here is the text from the doc:

ORA-00845: MEMORY_TARGET not supported on this system
Cause: The MEMORY_TARGET parameter was not supported on this operating system or /dev/shm was not sized correctly on Linux.
Action: Refer to documentation for a list of supported operating systems. Or, size /dev/shm to be at least the SGA_MAX_SIZE on each Oracle instance running on the system.

To me, the most likely cause is that your system isn't configured with enough shared memory.  You would need to resize the shared memory parameters and restart.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RindbaekSenior ConsultantCommented:
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/
0
DavidSenior Oracle Database AdministratorCommented:
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
0
jcob_lAuthor Commented:
yes
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.