-
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
-
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|