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