They drove for hours, navigating through wet and winding roads. The unfamiliar site of baboons running along the roadside reminded them of their colleagues at work. Neither “Average speed prosecution” nor “Toll gates” bothered them. More »

The atmosphere is tense as Oracle collapses into a pool of sweat.“One” … “Two” …. “Three” – Oracle is back on his feet. Oracle tries to regain his balance as he dances around the ring. More »

This procedure details the steps involved in doing a partial restore of a database in order to restore a single table. More »

Failure to purge the self-service session and temporary data will over time result in performance issues and large volumes of temporary data being stored on-line. More »

 

Oracle E-Business Suite 12.1.X – PURGING SELF SERVICE SESSIONS

1  Introduction

Failure to purge the self-service session and temporary data will over time result in performance issues and large volumes of temporary data being stored on-line.

Even if you have not installed Oracle Self-Service Web Applications you may still need to purge self service sessions as some functions of the Self Service Web Applications are available to the base E-Business Suite Application. If those functions are used, the Self Service temporary objects will grow.

The Self Service purge concurrent program is not assigned to the System Administrator Responsibility by default. That is most probably the reason why most Administrators miss it.

Oracle EBS-Blank Page Appslogin/AppsLocal Login Page in R12

There were quite a few times that I have encountered this blank front-end issue. The root cause was not the same every time it was investigated. There are many reasons for this issue to occur which I have compiled to make it easier for Apps DBA’s. Listed below are some of them.

Ksplice Installation and Configuration

Patching your Linux System can be quite a long drawn affair requiring server, database and application downtime and scheduling this mission critical task can be a nightmare.

Although Linux is very secure and stable, the operating system still needs to be patched at least once every month.

Oracle’s purchase of Ksplice in 2011 brought with it the promise of zero downtime for its users. Ksplice offers a way to patch a Linux kernel without the need to reboot. You no longer have to wait for the weekend or time when there are no/not too many users to patch vulnerabilities and flaws.

Using Oracle LogMiner to determine the cause of high archivelog generation in a database

Oracle LogMiner is one of the most important but underused feature of the Oracle database. It allows us to query the contents of the (archived) redo log files using the SQL interface.

In this blog we describe in brief how to use Log Miner to extract the history of the activity in the database  from redo logs. For this specific example we were trying to determine why there was so much activity in the database between 01h00 and 02h00 leading to generation of a huge number of archives. This example was on an Oracle 10g Release 2 (10.2.0.5) database but the procedure can be used on other versions/releases.

Migrate a RAC Database to a Single Instance Database on another Server

You can use DBCA, RCONFIG or Enterprise Manager to migrate a Single instance database to a RAC database, but how do you convert a RAC database to a Single instance database?