Search Oracle Blogs

List of Blogs maintained by Paweł Barut.

Thursday, December 21, 2006

Applying Oracle patch

Today I've installed patch for Oracle on Windows on top of database. I've noticed that my spool file generated by upgrade script was 33 MB big. It occurred that source of all oracle build-in packages were spooled. It was terrible experience to search for errors in this log file, as searching for 'ORA-' give hundreds results and I had to figure out if it is in comment of package, or real error.
Fortunately patch was installed successfully and everything runs fine.

Cheers, Paweł


Spanish Pinay said...


I was also trying to install on top of my db.. just a question though... part of the instruction in the readme files talks about running rman> upgrade catalog did you run this ONLY to the catalog database or to all other databases that is being managed by rman and has meta data information on the catalog database? I hope I did not confuse you with my question :)

Looking forward to your reply.

Paweł Barut said...

"upgrade catalog" is needed to be run only to catalog database.

Monsier One Liner said...

I am trying to install the patch on the Oracle Rel 2 DB ie on XP SP 2. And I am having no luck at all. The moment I apply the patch the service just ceases to run. I cannot restart the service without getting a Error 1503 "Service timed out in a .. fashion"!

Does this mean that I have to upgrade to before I can upgrade it to

Paweł Barut said...

I do not know the answer to your question. In my case I've applied, work with it for few months and then apply
You can try to shutdown all services manually before applying patch.
And remember to run catupgrd.sql after installing patch.
You should contact Oracle support for help.


Copyright © Paweł Barut
Printing from DOS to USB Printer