memory target

Posted on 2012-09-15
Last Modified: 2012-09-18
QL> create pfile from spfile;

File created.

SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
SQL> exit
[oracle@wtu dbs]$ ls
hc_DBUA0.dat  init.ora      lkPROS     peshm_DBUA0_0  spfileorcl.ora
hc_orcl.dat   initpros.ora  orapworcl  peshm_orcl_0   spfilepros.ora
hc_pros.dat   lkORCL        orapwpros  peshm_pros_0
[oracle@wtu dbs]$ vi initpros.ora
[oracle@wtu dbs]$ export ORACLE_SID=pros
[oracle@wtu dbs]$ sqlplus /nolog

SQL*Plus: Release Production on Sat Sep 15 09:59:49 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> startup
ORA-01031: insufficient privileges
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
Question by:tomvv
    1 Comment
    LVL 16

    Accepted Solution

    Make sure that shared memory filesystem /dev/shm is set to at least max_target parameter value. This is a new feature in 11g.

    To set /dev/shm to 10G for instance:

    # mount -t tmpfs shmfs -o size=10g /dev/shm

    Also, to make this change persistent across system restarts, add an entry in /etc/fstab similar to the following:

    shmfs /dev/shm tmpfs size=10g 0

    Hope this helps.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now