• Tracing concurrent requests (2)

    I’ve already blogged about tracing concurrent requests here: Tracing a single concurrent request, but I found myself using a bit different approach when needed. The thing is that concurrent managers are setting Module (which usually /not allways/ contains the short name of the concurrent program) and Action (which contains value “Concurrent Request”) information for database sessions executing concurrent requests, therefore it’s easy to switch on tracing from the very begining of execution of the requests for a particular concurrent program using DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (works on DB 10g+).

    Read on →

  • R12 cross-platform migration of ApplTier from HP-UX PA-RISC to HP-UX Itanium

    I’ve been working on a proof of concept migration of  11.5.10.2 on HP-UX v11.11 PA-RISC to R12.1.2 on HP-UX v11.31 Itanium for past couple of weeks. This is not a complete reference on how to make that happen, but still, there are some gotchas I had to workaround in cross-platform migration phase. Here is the list of issues and solutions to the problems spotted during application of the customer-specific update patch (provided by uploading manifest file created with perl adgenpsf.pl to http://updates.oracle.com/PlatformMigrating )

    Read on →

  • Notification Mailer troubleshooting (Part 2)

    In Part 1 we described the main steps involved in the Notification/Email sending process in an EBS environment. Today I will give you some practical hints on how to troubleshoot the notification sending process.

    Read on →

  • Notification Mailer troubleshooting (Part 1)

    This is the first article in series of articles dedicated to a “Notification Mailer” or in other words to an email sending functionality in EBS. We will talk about what steps involved in the email sending process and what tools and methods Apps DBAs have to troubleshoot each of these steps. From my 8 years (since 2001) experience working with EBS as Apps DBA it looks like “Notification Mailer” is one of the grey areas for Apps DBAs which aren’t described well enough and on the other hand we are asked to troubleshoot it on regular basis. As it is my very first personal article I would appreciate any feedback from your side. Please do not hesitate to leave comments, proposals or recommendations at the bottom of the page or dropping an email to me.

    Read on →

  • 11i and 10gR2 support has been extended

    On May 4th Oracle announced that the 1st year extended support fee for several products had been waived, which practically means that almost-premium support is extended by one year this way 11i is supported till November 2011 and 10gR2 - till July 2011.

    Read on →