Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Saturday, January 29, 2011

Applying Patch 42 (January 2011)

Release 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 to (Win)

Oracle 10g Release 2 ( 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.

Wednesday, January 26, 2011

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

Tuesday, January 25, 2011

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

Trace Files Viewing Method 
ADRCI: Release - 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

Sunday, January 23, 2011

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".

Tuesday, January 18, 2011

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.

Monday, January 10, 2011

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.

Tuesday, January 04, 2011

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