Go up

Next thread:	More Efficient Procedure ?
Prev thread:	truncate data from partitions

Message	Score	Author	Date
Hi All, We have applied July 2015 PSU patch to 11......		indrajit chatterjee	Aug 17, 2015, 21:26
Hi, > Any idea what needs to be done ... Jus......		Ales Kavsek	Aug 17, 2015, 23:24
Thanks Ales but the point here is there no log gen......		indrajit chatterjee	Aug 18, 2015, 21:20
Hi, post the result of: $ ls -l $ORACLE_BASE......		Ales Kavsek	Aug 18, 2015, 22:55
Here is the output which shows the logs from the p......		indrajit chatterjee	Aug 19, 2015, 00:55

Follow up by mail

Click here

---

Subject:	catbundle.sql psu apply going to hung state after applying July PSU Patch
Author:	indrajit chatterjee, India
Date:	Aug 17, 2015, 21:26, 2557 days ago
Os info:	AIX 6.1
Oracle info:	11.2.0.3
Message:	Hi All, We have applied July 2015 PSU patch to 11.2.0.3 database and after that when we tried to execute catbundle.sql script it got stuck for more than 9 hours and it is still in the same state. Any idea what needs to be done as the patch is not reflecting from the database end since we are not able to run catbundle.
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: catbundle.sql psu apply going to hung state after applying July PSU Patch
Author:	Ales Kavsek, Slovenia
Date:	Aug 17, 2015, 23:24, 2556 days ago
Score:
Message:	Hi, > Any idea what needs to be done ... Just a couple from me :)....: - press <ENTER>, sometimes helps ;-) - check logs (what else?); both of course, alert.log and catbundle log (-> $ORACLE_BASE/cfgtoollogs/catbundle). Find out at which point the PUS apply hanged. Btw. in the directory I mentioned above should be generated "PSU apply rollback", just in case you'll need to rollback changes done to the dictionary. Good luck! Regards, Ales
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: catbundle.sql psu apply going to hung state after applying July PSU Patch
Author:	indrajit chatterjee, India
Date:	Aug 18, 2015, 21:20, 2556 days ago
Message:	Thanks Ales but the point here is there no log generated for catbundle script as it is not getting completed at all.
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: catbundle.sql psu apply going to hung state after applying July PSU Patch
Author:	Ales Kavsek, Slovenia
Date:	Aug 18, 2015, 22:55, 2555 days ago
Message:	Hi, post the result of: $ ls -l $ORACLE_BASE/cfgtoollogs/catbundle There you should see at least the log catbundle_PSU_<db>_APPLY_<timestamp>.log and catbundle_PSU_<db>_GENERATE_<timestamp>.log. If you don't see those logs, you did not run properly the catbundle script at all (if this is true, then kill the process and rerun the script). Regards, Ales
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: catbundle.sql psu apply going to hung state after applying July PSU Patch
Author:	indrajit chatterjee, India
Date:	Aug 19, 2015, 00:55, 2555 days ago
Message:	Here is the output which shows the logs from the previously ran catbundle script. We ran it properly this time as well and we guess there is some issue from the database end due to which it is getting hung everytime. We have killed it twice and ran it twice but no luck. total 1084 -rw-r----- 1 oracle oradba 21 May 9 2012 catbundle_PSU_U411_APPLY_2012May09_15_23_46.log -rw-r--r-- 1 oracle oradba 574 May 10 2012 catbundle_PSU_U411_APPLY_2012May10_09_17_16.log -rw-r--r-- 1 oracle oradba 1038453 Jul 13 19:39 catbundle_PSU_U411_APPLY_2015Jul13_19_37_48.log -rw-r----- 1 oracle oradba 1626 May 9 2012 catbundle_PSU_U411_GENERATE_2012May09_15_23_46.log -rw-r--r-- 1 oracle oradba 23917 May 10 2012 catbundle_PSU_U411_GENERATE_2012May10_09_17_16.log -rw-r--r-- 1 oracle oradba 26975 Jul 13 19:37 catbundle_PSU_U411_GENERATE_2015Jul13_19_37_47.log
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here