ora-00371 on startup uprade

[Chucks_k]

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

[davey23uk]

125Mb free

[Chucks_k]

Hi davey,

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

[Chucks_k]

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

[ixion]

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

[Chucks_k]

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