I tried to install the 9.2.0.6 patch on Windows.
Lots of error in the catpatch.sql and the sql called.:confused:
Does anybody succeed to install it ?
Thanks
www.lochert.fr
Printable View
I tried to install the 9.2.0.6 patch on Windows.
Lots of error in the catpatch.sql and the sql called.:confused:
Does anybody succeed to install it ?
Thanks
www.lochert.fr
Yes - what kind of errors are you getting?Quote:
Originally posted by plochert
I tried to install the 9.2.0.6 patch on Windows.
Lots of error in the catpatch.sql and the sql called.:confused:
Does anybody succeed to install it ?
Thanks
www.lochert.fr
what error did you get??? rerun catpatch.sql and spool the result to the file so we can look at it
Many "unable to open file ..."
And
ERROR at line 1:
ORA-03113: end-of-file on communication channel
BEGIN
*
ERROR at line 1:
ORA-03114: not connected to ORACLE
I tried to check the file but there are too many errors
did you do all the pre-requisites and set the shared pool size and java pool size?Quote:
Originally posted by plochert
Many "unable to open file ..."
And
ERROR at line 1:
ORA-03113: end-of-file on communication channel
BEGIN
*
ERROR at line 1:
ORA-03114: not connected to ORACLE
I tried to check the file but there are too many errors
Yes I did all except for shared_pool_size and java_pool_size : do I really need to set them to 150Mb ?
yep - if you didnt need to it, well - it wouldn't tell you to do it. Always follow the instructionsQuote:
Originally posted by plochert
Yes I did all except for shared_pool_size and java_pool_size : do I really need to set them to 150Mb ?
let us know if it works once you have changed them
OK I try tomorrow morning (6pm in France) with these values and I tell how the process is
Thanks
this is not rocket science, aside from a couple of alter sessions all that catpatch does is
@@utlil.sql
@@catalog.sql
@@catproc.sql
Can you run those scripts?
have u opened the db in migrate mode? (startup migrate)