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

125Mb free

Hi davey,

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

Has anyone got any more ideas on this? Thanks in advance

Did your old DB have an spfile? It could be picking up the parameters from there...

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