Patch 9.2.0.6

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

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

---

Yes - what kind of errors are you getting?

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

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

---

did you do all the pre-requisites and set the shared pool size and java pool size?

Yes I did all except for shared_pool_size and java_pool_size : do I really need to set them to 150Mb ?

Quote:

---

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 ?

---

yep - if you didnt need to it, well - it wouldn't tell you to do it. Always follow the instructions

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)

I dit it

I try again...