Oracle Database Discussions

Hi,

Greetings!!!
While applying CPU patch (CPUJAN2009) on oracle database 10g (please find details as below), I have encountered
following described error.

I was applying oracle CPUJAN2009 patch on sun solaris database server using "putty" tool. We regularly use putty
to connect our unix database servers for query and other purpose. Now while CPU patch was getting executed
(in putty "opatch napply -skip_subset -skip_duplicate" command was getting executed), my putty session got crashed
& terminated abnormally (please find attached log files in later section).

Now, I would like to know following points and would appreciate if you could answer:
1) Eventhough putty session got crashed (while CPU patch is getting applied), will opatch napply command
runs in unix background (like as nohup)?
2) How do I verify that oracle CPU patch (CPUJAN2009) got applied successfully or not? Curerntly I'm using
opatch lsinventory.
3) From "opatch lsinventory" command, I can make out that there are 50 Interim patches been applied as part of
this CPU patch (CPUJAN2009). Is this count (50) correct? But I'm not able to see any information about
7592354 patch in attached oracle lsinventory. Will "opatch lsinventory" command should show us
any info about 7592354?
4) CPU patch (CPUJAN2009) also gets executed at oracle database level? If yes, how do I verify from database
(are there any tables / views) that this CPU patch is applied correctly there? However, I can see one row
for 7592354 when execute select * from registry$history; in database.
5) Do you think due to putty session crashed, only oracle inventory is not updated successfully? If yes, then is
there any way that I can just update oracle inventory... so that next time if suppose there is a new CPU
patch available and I have to apply then there should not be any issue for the same.
6) I do have backup of oracle inventory & oracle home (before applying CPUJAN2009). Can I restore then & re-apply
the CPU patch? If yes, hope there will not be any impact on database side? or is it difficul to re-apply
the CPU patch and more mess-up the database / inventory?
7) If you think this oracle CPU patch is not applied correctly; can you please suggest us what needs to be done
to backout / rollback this CPU patch? Would appreciate, if you could provide us indetail steps for the same.

Oracle database & other related information:
============================================
Oracle Database 10g : 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 2 : 10.2.0.3.0
OUI version : 10.2.0.3.0
OPatch version : 10.2.0.4.6 / p6880880_102000_SOLARIS64.zip
Plateform: SunOS 5.10 / Solaris Operating System (SPARC 64-Bit) / Solaris 64-Bit
Oracle CPU patch applied : CPUJAN2009 / p7592354_10203_SOLARIS64.zip
Any previous CPU patch applied : NO
Any other database patchset applied : NO


However, currently my oracle database is up and running without any issue.

Could you please go through my above query and send us your inputs ASAP.

Thanks... Bhavesh R. Mehta