Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Location
    Jordan
    Posts
    137

    Unanswered: Full exp Problem

    hi there

    when I try to make full export using this command :

    exp system/password full=y file=c:\x.dmp consistent=y

    It gives me this message :

    Unable to allocate 4032 bytes of shared memory





    my configuration like this:

    shared memory = 240 MB
    Buffer cashe = 160 MB
    Large Pool = 16 MB

    (I have win2000 server and 1 GB memory)

    can anyone help be to solve it...


    thanx

  2. #2
    Join Date
    Jan 2004
    Location
    Scottsdale, AZ
    Posts
    106
    Does your value for ORACLE_SID match the database instance you want to export.
    "Take Control!
    Make The Choice!
    Accept The Consequences!
    Deal With The Results! "

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    good point, you need to add the sid unless you are running this command line from the server that hosts the db you are exporting.

    exp system/password@sid full=y file=c:\x.dmp consistent=y
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    I've seen this error with JAVA pool size and/or Large reserved pool set too small with either 8.1.7 or 8.1.6 ...

    You can get around most of those shared pool errors with

    _db_handles_cached = 0

    in initxxx.ora ... Undocumented parameter ... see Metalink

    HTH
    Gregg

  5. #5
    Join Date
    Feb 2004
    Location
    Jordan
    Posts
    137
    Originally posted by gbrabham
    I've seen this error with JAVA pool size and/or Large reserved pool set too small with either 8.1.7 or 8.1.6 ...

    You can get around most of those shared pool errors with

    _db_handles_cached = 0

    in initxxx.ora ... Undocumented parameter ... see Metalink

    HTH
    Gregg
    hi

    I don't think that the problem caused of JAVE or Larg pool
    because I don't use any java in my Database neither Application

    Also, (to mr. Duck>>> I use @SID but it's not working)

  6. #6
    Join Date
    Feb 2004
    Location
    Riyadh
    Posts
    24
    Hello,
    What Greg said was correct. To prove his point and clarify your doubt, i am attaching a doc from Metalink for your reference.

    HTH,
    Sudhakar
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •