Applying 10.2.0.4 Patch 42 (January 2011)

Release 10.2.0.4 for Microsoft Windows (32-Bit)
You should administer one Oracle product, one Oracle home at a time, for its particular Bundle Patch Update. Each Oracle home will have its own requirements. We are updating Oracle Database as below.

Upgrading from 10.2.0.1 to 10.2.0.4 (Win)

Oracle 10g Release 2 (10.2.0.4) Patch Set 3 for Microsoft Windows (32-Bit) 

Identify the Oracle Database Installation
This is not a complete software distribution. You must install it in an existing Oracle Database 10g Oracle home. To identify Oracle home directories, view the/etc/oratab file.

Alt+Ctrl+Del on Remote Desktop

In order to send Ctrl-Alt-Del keystrokes to remote computer connected via Remote Desktop client, just press the following workaround
Ctrl+Alt+End

Using and Disabling the Automatic Diagnostic Repository (ADR) with Oracle Net for 11g

Trace Files Viewing Method 
C:\Users\inam>adrci
ADRCI: Release 11.2.0.1.0 - Production on Tue Jan 25 13:56:20 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
No ADR base is set

Alter system kill session and ORA-00031: session marked for kill

Today we face a problem on our development database.
problem is :- One of user's sesssion is killed by "alter system kill session" but that session was being a huge DML operation with the wait "HS Message sent to agent".

Export did not include some table in dump file

Today a .NET developer took a dump for a schema and noticed that a table was not included in the exported file. I observed that table was newly created and was not used at all before exporting. So I just inserted a row in the table save it and then delete and save. After this this table was exported as others.

WUT-121 upon downloading file from AS

Today one of the developer complained that he is getting WUT-121 as below while trying to download a file from the Application Server.

PING with Timestamp

We were getting ORA-3113 errors for some web clients and after investigations, I found that this is due the many network dropouts on all Oracle related servers. I just ran the simple pingtest as below