No question at this time
DBA Top 10
1 M. Cadot 7200
2 B. Vroman 3100
3 J. PĂ©ran 2100
4 A. Kavsek 1400
5 P. Tsongayinwe 1300
6 P. Wisse 600
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48684
Total active users1329
Act. users last 24h2
Act. users last hour0
Registered user hits last week44
Registered user hits last month235
Go up

catbundle.sql psu apply going to hung state after applying July PSU Patch
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...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts 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:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
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