ora-00371 on startup uprade
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ora-00371 on startup uprade

  1. #1
    Join Date
    Dec 2001
    Posts
    337

    ora-00371 on startup uprade

    Hi all,

    I am upgrading a 9204 db to 10.2.0.1 on W2K, i have followed the manual upgrade procedure as described by Oracle. I have copied the new 10g init.ora to the %ORACLE_HOME%\database\ dir. I have edited it with the parameters as suggested by the upgrade script. I now have deleted the old Service and and created a new one, pointing to the new pfile. This all worked fine.

    I then logged into sqlplus and did:

    startup upgrade;

    I got the following error:

    ORA-00371: not enough shared pool memory, should be atleast 122596966 bytes.

    I have set the shared pool memory to 200MB. Yet this error came up.
    It looks like its picking up the old pfile. I also tried giving the pfile explicitily:

    startup upgrade pfile=\path\to\new\pfile

    I got the same error.

    Any one have any ideas? Am stumped.

    Thanks in advance,
    Chucks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    125Mb free

  3. #3
    Join Date
    Dec 2001
    Posts
    337
    Hi davey,

    I dont understand what u mean? Please can you explain?

  4. #4
    Join Date
    Dec 2001
    Posts
    337
    Has anyone got any more ideas on this? Thanks in advance

  5. #5
    Join Date
    Jun 2006
    Posts
    259
    Did your old DB have an spfile? It could be picking up the parameters from there...

  6. #6
    Join Date
    Dec 2001
    Posts
    337
    Hi there, yes it did. i thought of that and thats why i explicitly did startup upgrade pfile=the path to the new file.

    Alto, it still seems to be picking up the value from the spfile. Dont understand why

Posting Permissions

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


Click Here to Expand Forum to Full Width