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:
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: