How to Move OCR and Voting Disk to ASM Diskgroup in 11gR2

Case: Moving to Redhat Linux 5/Oracle Enterprise Linux 5, which does not support Raw filesytem. Steps: (these steps can be performanced on 11gR2) 1.) Check the current location of ocr file:

[root@host1 bin]# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 3004
Available space (kbytes) : 259116
ID : 798462606
Device/File Name : /mnt/cludata/ocrfile
Device/File integrity check succeeded
Device/File not (more...)

TIOBE Programming Community Index for August 2011

| Aug 30, 2011
PL/SQL is again in the 22nd place TIOBE Index (August 2011).
It's was in 21st last month.

Installing Oracle Forms/Reports on Red Hat 5 (64-bit)

My first installation of Forms/Reports services on a Weblogic server was not as easy as I would have expected so I thought I would share the steps.

First have a look at the Installation Guide for Oracle Portal, Forms, Reports and Discoverer


Invisible Indexes in Oracle 11g

Always wanted this – the ability to create an index on production without impacting the queries being fired by application but at the same time test the impact an index creation can cause. Invisible indexes are useful alternative to making an index unusable or to drop it. 
The optimizer ignores the index that are marked “Invisible” unless you set the initialization parameter “OPTIMIZE_USE_INVISIBLE_INDEXES” to TRUE. This parameter can be set both at a session level as well as system level.
Usage of Invisible Indexes
One can use invisible index for testing the impact of removing an index. Instead of (more...)

ORA-16072: a minimum of one standby database destination is required

This is a quick post regarding the error on the subject. This is the second time it happens to me, so I thought I will write a bit about it.

The problem:

I am refreshing one of my UAT environments (happens to be a Full Rack Exadata) using Oracle RMAN duplicate command. Then the following happens (on both occasions).

1.- Duplicate command fails (lack of space for restoring archivelogs, or any other error). This is can be fixed quite easy.

2.- following error while trying to open the database after restore and recover has finished:

SQL> alter database  (more...)

Very Large Migrations

| Aug 26, 2011
Most of the time SQL Developer does a good job of migrating a database from SQL Server, Sybase ,... To Oracle. But there are some tricks to help make very large migrations perform smoother.

This talks about Large migrations in terms of object numbers , not amount of data in tables.

If your migrating 50 databases at once, and each has 1,000 tables, 1,000 views , 1,000 procedures . That is a lot of meta data to churn through and sometimes we find
memory issues , open cursors ,... can be a problem.

We are always working to reduce the amount (more...)

Fun with EBS APIs, part II: Users and responsbilities (FND_USER_PKG)

In my previous post, I demo'ed some simple scripts to make changes to E-Business Suite profile options, using the API provided by the FND_PROFILE package. This post will look at the FND_USER_PKG package (no relation to the "ABS brake system"). While my examples only reference user creation and responsibility assignment, it's really worth reviewing the contents of the rest of the package; there's lots of useful stuff in there.

First things first

Disclaimer time! Are you surprised? I hope you're not surprised. Am I really copying this section from the previous post? Yup, I am!

  1. The example code presented (more...)

Unicode: Code Points in SQL or PL/SQL (New SQL Snippets Topic)

| Aug 24, 2011
A new topic has been added to the Unicode section on SQL Snippets. "Code Points in SQL or PL/SQL" examines various techniques for determining a character's Unicode code point. One technique involves creating a custom PL/SQL function called UNICODEPOINT(). When compared to other techniques UNICODEPOINT() proves to be faster, leaner, and more scalable. It also works on more Oracle versions than the other techniques.

Fun with EBS APIs, part I: Profile options (FND_PROFILE)

The E-Business Suite APIs are not just the realm of developers and data migration specialists. There are a number of APIs, particularly in the FND module, that can make life a lot easier for Apps DBAs. In my next two (maybe three, if I'm feeling ambitious) posts, I'll provide some examples of how to use PL/SQL to perform tasks that normally require slogging around in the EBS Forms interface.

First things first

Disclaimer time! Are you surprised? I hope you're not surprised.

  1. The example code presented in this series of blog posts uses APIs written by Oracle to manipulate data (more...)

EclipseLink: Multitenancy with Oracle VPD

As of EclipseLink Indigo (2.3.0) you have been able to use the @Multitenant feature to share a database schema between multiple tenants. Did you know that you can also use this feature together with the Oracle Virtual Private Database (VPD) support that has been available in EclipseLink since version 1.0?

This powerful combination of features allows for the shared tables to be managed directly on the database, and for inserts to be automatically associated with the proper client. Any SQL executed by EclipseLink (even if EclipseLink did not generate it - ie native queries) will go through (more...)

First public Beta version of SQL Navigator 6.6

| Aug 22, 2011
SQL Navigator 6.6 Beta build 2220 (expires 31 Oct 2011) is now available! See the full announcement.

Oracle APEX 4.1 released and it’s documentation

| Aug 19, 2011

Oracle Application Express 4.1 was released.

"This latest Oracle Application Express release is focused on enhancing existing
functionality and adds data upload capabilities."
- Oracle Press Release

Oracle Application Express 4.1 Documentation Library is also available.

Direct Path Reads – 11g Changed Behaviour

In 10g, serial full table scans for “large” tables used to always go through cache (by default). If table was small it was placed at most recently used (MRU) end of the buffer cache. If table is large it is placed at least recently used (LRU) end of the buffer cache.

In 11g, full table scan do not always go through the buffer cache. Decision to read via direct path or through cache is based (more...)

Oracle Forms Builder will not start

Well I ran into an error that I found posted out on the Internet with no solution listed. I just wanted to post my solution in case someone else is running into this.

Problem: "All of sudden" today when I started Oracle Forms Builder 9i (yes we are using 1996 technology) I got Microsoft Visual C++ Runtime Library error Assertion failed! FRM-10039:

Cause: A new Java Virtual Machine (JVM.DLL) was pushed out to our PCs. Users were having problems with it. While working out the user's JVM problems, I made a copy of JVM.DLL in the directory where (more...)

Trinidad 2.0.0 PPR Bug with JSF 2.0 outputText Tag

I am currently in the process of porting all of my Oracle AS 10G R2 (OC4J) applications over to WebLogic  10.3.5.  After upgrading Oracle JDeveloper to version 11.1.2 and hand converting an old ADF 10.1.3 application to Trinidad, I ran into a curios issue.  None of my components that used PPR (Partial Page Rendering) would respond to events.  Most notably, pop-up dialogs triggered  by Command Buttons, or Command Links.  The dialogs would not pop-up, but I could see the events executing in the backing beans. After a couple of weeks (more...)

Track and Trace E-Business Suite Concurrent Request – EBS Logs, O/S Process IDs, Locks

I often get asked to take a look at an Oracle eBusiness Suite concurrent request to see what it is doing, this can come from a few different angles:

  1. What requests are currently running?
  2. I have an operating system process that is taking too much CPU - what is it doing?
  3. Can you tell me where the request is at? I've clicked on the log but it doesn't show anything!
  4. My request is taking too long - can you check for blocking locks?

There are a number of strategies to track and trace where things are at for a running (more...)

Oracle enhanced adapter 1.4.0 and Readme Driven Development

I just released Oracle enhanced adapter version 1.4.0 and here is the summary of main changes.

Rails 3.1 support

Oracle enhanced adapter GitHub version was working with Rails 3.1 betas and release candidate versions already but it was not explicitly stated anywhere that you should use git version with Rails 3.1. Therefore I am releasing new version 1.4.0 which is passing all tests with latest Rails 3.1 release candidate. As I wrote before main changes in ActiveRecord 3.1 are that it using prepared statement cache and using bind variables in many (more...)

Tool to backup and restore Putty sessions

When you access servers at a customer site or in a hosting center you often have to use a Remote Desktop (RDP). These jump servers are often locked down so you cannot install programs or access the Registry via Regedit. This is frustrating if you use Putty and have a (more...)

The Helsinki Declaration (IT-version) 2011-08-05 05:40:00

Nice one:

Oracle Openworld 2011 Schedule Builder is Now Live

Oracle OpenWorld 2011 Content Management team announced today that the conference Schedule Builder is now online. Registered attendees can log in to search through hundreds of sessions, partner exhibits, and Oracle demos and find content of interest to enroll in sessions and build your conference agenda.

A recommendation engine powered by Oracle Data Mining provides a list of sessions, demos and exhibits that are most relevant to you. Once a session is added to the personal agenda, any session change information or communication is automatically sent. It also provides the conference organizers an idea about the popularity of a session. (more...)