Feed aggregator

Things that had me surprised with 10G Standard Edition

Vidya Bala - Mon, 2006-12-04 15:09
Well we know that Standard edition is a marketing joke - but it is something we cannot avoid considering when we can save about 30K per cpu.

The following features not being supported by standard edition had me surprised(there are a lot more but this caught my attention)

1)Reorgs: Online index build, online table reorg/redef, online index coalesce. Global index maintenance during DDL
(some of the above we may overcome with third party LiveReorg Products)
2)Recovery: block level media recovery, Tablespace point in time recovery.
3)With 10g Std edition incremental backup and recovery is supported but not with 9i Std Edition - think of it which means you always have to do a full bkups.4)Indexes : Bitmap indexes are not supported while Function based indexes are supported in 10G Std edition.
Categories: Development


Robert Vollman - Mon, 2006-12-04 13:57
Recently I invited anyone who has been considering joining the Oracle blogging community to jump right in. Please, help me encourage John H:Robert,Way cool blog. I really need to create one too. I like to adhere to best practices and love to read stuff from Tom K. and Steven F.!I have a question on regular expression check constraints and was wondering if you can help:alter table Robert Vollmanhttp://www.blogger.com/profile/08275044623767553681noreply@blogger.com2

Gartner Application Integration & Web Services Summit

Clemens Utschig - Fri, 2006-12-01 19:42
Over the next week a part of our team will head out to Gartner's AIWS Summit in Orlando - and we all look forward, as it is a great opportunity to meet other evangelists and customers to discuss the latest trends and stories around SOA, and Application Integration.

Dave Shaffer - Director of SOA Product Mgmt - and head of our group, Devesh Sharma - Mr. BPA, Jeff Hutchins - the mastermind of Oracle's B2B and me will be there. So if you are around, come by the booth to chat, see SOA Suite @ work or just for fun - to meet some of the faces behind Oracle's SOA strategy and offering.

For those who have not heart of it yet - visit http://www.gartner.com/2_events/conferences/apn17.jsp and hurry to register

c ya in orlando

Tips for using CVS with JDeveloper

Brenden Anstey - Thu, 2006-11-30 19:24
Server: Linux OS, CVS Version 1.11.1p1
Client: Windows XP, JDeveloper using ADF BC / Faces
Other tools (non-mandatory but good to have), PuTTy, PAgent, PGen PSftp

Overview of the Setup Process
Create a generic user to own the CVS Repositry and a group which all the CVS users will belong. Create a user for each developer and add them to the same group.
To create a server repository as the generic user the command is:
cvs -d /oracle/cvs/CVSROOT init

JDeveloper uses a private public key pair and SSH2 (other protocols available) to connect to the CVS. The key pair is generated in JDeveloper and the public key has to be manually added to the users authorized_keys file in the .ssh directory within the users home directory. The CVSROOT is the root directory of the CVS repository which is created by the CVS owner mentioned above.

Key Points About Using JDeveloper with CVS
Using JDeveloper with a CVS will break dependencies within the project which are normally enforced by JDeveloper in single user mode. When updating your project from the CVS the dependencies between objects are not enforced resulting in objects becoming out of sync. For instance a standard ADF BC View Object may consist of two files, its XML definition and View implementation file. It will also be referenced by one or more Application Module(s) and possibly a Viewlink. To prevent missing references and broken dependencies all the referenced / referencing objects must be included when committing and updating the CVS.
Open and close the project if there are dependency errors that do not seem to be correct.
CVS does not implement locking, it is the developers responsibility to make sure that the files they wish to work on are up to date. If two developers have worked on a file simultaneously a merge will be required when synchronising the CVS.

How do I know if my source is up to date with the CVS?
The key to getting the CVS JDev integration working properly is using the Pending Changes window effectively. Within this window are three tabs, Outgoing, Incoming and Candidates. Outgoing contains changed items which are not up to date with the CVS. Incoming displays items are new or the local copy is out of date with the CVS. Candidates are files not yet checked in with the CVS. The most important tab in the Pending Changes window is the Incoming Tab. Watch this one with care as incoming changes are NOT reflected in the Application Navigator unlike other file statuses. New files are not shown in the Application Navigator because they are not in the project but may be referenced by existing objects updated from the CVS. Using the Incoming tab is key to keeping the project in sync.

Minimising Pain and Suffering with CVS
Develop your model first and view second. If the model is not complete before development of the user interface it is worth finalising it first. The reason being is that the user interface (JSP's, pageDef's and Databindings.cpx) are a lot easier to fix than the data model when the project gets out of date and or needs to be merged. Most people will do this anyway, but it not always the case that the model is completed first.
Commit all changes regularly and especially before leaving at the end of the day. In the morning check the Incoming tab and update as necessary.
Occasionally perform a full checkout of your project from the CVS. This will cause any synchronisation issues to come to the surface and recover any missing files from backup if necessary.
Have the Li/Unix administrator include the CVS in the server backups.

Project Files and the CVS
The project JPR files often report conflicts which cannot be resolved by merging or committing changes. Fortunately JDeveloper is smart enough to pick up any stray/new files and add them to the project. Close and open the project and if all files are present force an unchanged commit of the project JPR file.

Bugs and Annoyances
View link files are continually 'touched' when the AM is updated resulting in them being in changed status continually even though they are not out of date with the CVS. This also clutters the Outgoing tab which is a pain if some of them are legitimately updated.
JDeveloper occasionally hangs when performing some CVS actions from the navigator. CVS actions issued from the Pending Changes window seem to be more reliable.
Occasionally some files are not recognised as an Object (such as a VO) and are displayed as their individual files in the Application Navigator. If this happens close and reopen your project and the object will reappear and its supporting files will be attached.

Further Reading
Oracle® Application Development Framework Developer’s Guide For Forms/4GL Developers (chapter 32 Working Productively in Teams) This manual can be downloaded from otn.oracle.com

Oracle APEX Application Migration Workshop is now on OTN!

Donal Daly - Thu, 2006-11-30 17:10
While the road to release has not been as smooth as I would have liked (down to me in parts :-) ) , we have finally published the early adopter version on OTN.

We very much welcome your feedback on it. Our plans is to have this as a standard feature of Oracle APEX 3.0, so you have the chance of your feedback making a difference in the final product in a short timeframe. I look forward to receving your feedback and making the product better because of it.

You will find more details about it here.

Enjoy, Donal

du and ls report very different file sizes for Oracle Tempfiles on NFS v3 mounted volume on NetApp filer under Solaris 9

Stephen Booth - Thu, 2006-11-30 10:03
We have a NetApp FAS filer attached via Gigabit Ethernet to a Sun V440 running Oracle databases the files for which are stored on the filer The NetApp volume is mounted under NFS version 3 at $ORACLE_BASE/oradata. Under that directory are 7 directories .snapshot, dctm, dchr, dctm_backup, dchr_backup, dctm_nobackup, dchr_nobackup. .snapshot is where the NetApp filer stores snapshots of the Stephen Boothhttps://plus.google.com/107526053475064059763noreply@blogger.com1

Develop with Oracle Fusion Middleware and win a trip to Oracle HQ

Clemens Utschig - Wed, 2006-11-29 23:32
Today - while looking for information on the OTN I fell over the below invitation ..

The Oracle Fusion Middleware Developer Challenge is looking for submissions in three exciting technology areas:
  • SOA-based applications or Web services

  • Web 2.0/Ajax-based user interfaces or mashups

  • Java-based applications demonstrating the combined use of Oracle and Open Source software
.. which can be found in full here.

Naturally we, all Oracle employees are excluded - so it's your term. Develop the coolest application on Oracle's new Fusion Middleware and win a trip to our Headquarters in Redwood Shores, California.

Oracle Open World 2006 slides and two new articles

Clemens Utschig - Wed, 2006-11-29 18:17
After being quiet for quite a while now, I thought to publish some information from my open world sessions and links to two of my (joint) articles that were recently published.

My slides about Advanced BPEL topics, including Compensation, Transactions, and WSIF can be found here.

Matt Shannon from the Content DB team and me teamed up to demo the integration between Content DB and Oracle BPEL PM, which currently evolves into a sample - slides are here

Also the introduction during Oracle XTreme that me and my whole team gave - on using all the components together to create a composite application is online - and to be found here

Attention: you need to login with cboracle/oraclec6

Also two recent articles were published, ..

One on Data Services in the Java Developers Journal, where Doug Clarke from Toplink PM team and me paired up, to write about "Accessing data in the Service Oriented World" is here.

The second one, where Jesus from TwoConnect, Heidi Buelow- one of my fellows on our team and I teamed up - to demonstrate "WSI with BPEL and WCF in the real world". It can be found here.

Also, to keep my fellow readers informed, I just started off with my best practice series on the SOA Suite, which explores patterns and best practices when using the components - more on this soon.

Design Goals for the Oracle APEX Application Migration Workshop

Donal Daly - Wed, 2006-11-29 10:18
We are in the home stretch now, to make the early adopter version of the Oracle APEX Application Migration Workshop available on OTN. We have released some more information about it on OTN and have created a new OTN forum to host discussions about migration from Microsoft Access to Oracle Application Express.

I thought it would be an opportune time, to outline some of our design goals behind this development. Firstly, we want to promote Database Refactoring, once you have gotten your schema and data migrated using the Oracle Migration Workbench. The better your Data Model is, the easier it will be to create good Oracle APEX applications. Currently we identify tables without primary or foreign keys and also promote the usage of UI defaults, a feature of Oracle APEX. We hope to expand on this in the future, based on feedback. A possibility could be to identify tables that could be leveraged as List of Values (LOV's) or try to identify incorrect usage of data types, e.g. dates being stored as varchar.

Our approach is one of Design Recovery. We want to provide as much information about the original Access Application that we could recover from the Access mdb file. We have taken a workshop approach, to provide the developer a productive environment to decide what Access objects they are interested in and should be in scope. You deal with any errors reported, so additional objects can also be included. By default all Access objects which we analyze and determine are valid are included in the scope your migration project by default.

Our goal is to only generate a native Oracle APEX application. We are not interested in emulating unique Access functionality. Access Applications could be classed as "rich client" applications whereas Oracle APEX applications are Web (Browser) based. It's a different UI paradigm, and this needs to be respected if you are to create, intuitive and useful applications. We don't migrate any VBA code, but we will show you the VBA code contained in your modules. You could then determine if this logic is still necessary and if so, could be reimplemented as PL/SQL procedures/functions.

We can generate either an application based on selected Access Forms or Reports or generate a maintenance style application which is a Report and a Form on each selected Tables and Views.
Our application generation leverages the Application Model behind the create application wizard.

I am looking forward to feedback on this new feature of Oracle APEX. I believe we have built a good foundation, to address additional feature requests we might receive. With input from the community we can ensure that the Application Migration Workshop increases the productivity of developers who seek to migrate Access applications to Oracle APEX, when it becomes a standard feature of Oracle APEX 3.0

Now back to the last round of testing...

Raise a Business Event from your OAF Page

Andries Hanekom - Tue, 2006-11-28 01:58

After quite a while of inactivity, due partly to a frantic schedule and the addition of a new obsession in the form of my new mountain bike, I am back on the horse and very excited to start blogging again. A Big thanks to Steven Chan for profiling the Oracle EBD Developer on his blog, just the kick I needed to get going again.

I recently had the opportunity to present the 11i/2.6 Implement Oracle Workflow course at Oracle South Africa, which turned me onto business events in a big way. Now I have previously blogged about launching an Oracle Workflow process from an OAF page using the oracle.apps.fnd.framework.webui.OANavigation class. In this post I would like to demonstrate how we can raise a business event through the Oracle Business Event System (OBES), which enables you to utilize the extensive functionality of the OBES to launch workflow processes and perform a number of diverse actions.

import oracle.apps.fnd.wf.bes.BusinessEvent;
import oracle.apps.fnd.wf.bes.BusinessEventException;
public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
super.processFormRequest(pageContext, webBean);

if (pageContext.getParameter("Submit") != null)
// Get Transaction
OAApplicationModule am = pageContext.getApplicationModule(webBean);
OADBTransactionImpl oadbTrx = (OADBTransactionImpl) am.getOADBTransaction();

// Create BE Object
String eventName = "companyabc.oracle.apps.xx.event.createrequest";
String eventKey = "1001-1";

BusinessEvent busEvent = new BusinessEvent(eventName, eventKey);

// Set Event Property
busEvent.setStringProperty("XX_TRX_TYPE", "NEW_REQUEST");

// Raise Event
catch (BusinessEventException exception)
// Set Message Tokens
MessageToken[] tokens =
{ new MessageToken("EVENT_EXCEPTION",

OAException eventErrorMessage = new OAException("XX",



recover database until cancel and online redo's

Vidya Bala - Mon, 2006-11-27 06:41
on a noarchivelog mode database, recover database until cancel will still prompt for archive logs.
This had me puzzled initially until I looked at the sequence number and realized, the sequence number corresponds to the online redolog (although the recovery command prompted for an archive log). When prompted if the appropriate online redolog is entered the Incomplete recovery will succeed.
Categories: Development

How people find this blog

Stephen Booth - Thu, 2006-11-23 02:38
I was just looking at my stat counter analysis for this blog, it's usually a good way to find out if anyone has linked to me. From the results it looks like the vast majority of people (around 97%) find this blog through a search engine, virtually all (over 99%) through Google. Most common search strings are or include "ORA-07445", "opmnctl failed to start process" and "ORA-01031".Stephen Boothhttps://plus.google.com/107526053475064059763noreply@blogger.com0

10g Release 3 Forms and Report Services?

Vidya Bala - Wed, 2006-11-22 14:11
while helping a colleague of mine install Forms and Reports Services , I realized that 10g Release 3 although available for download , the Forms and Reports Services component is not available for 10g Release 3 yet (only if I missed something). I was wondering if there was any talk on an ETA for Forms and Reports Services on 10g release 3.
Categories: Development

Informatica (PowerCenter) Key Concepts (PartI)

Vidya Bala - Wed, 2006-11-22 13:02
Informatica (PowerCenter) Key Concepts PartI:

This series will review the fundamental of the PowerCenter(7.1.2) Suite.
The key components of Informatica are PowerCenter Client Tools, Repository Server, Power Center Server and the Repository. The Repository Server and the PowerCenter Server constitute the ETL Layer which does the ETL process.

Below is how the client to server communication flow looks like:
The PowerCenter client sends a request to Repository Server.
The Repository Server verifies the connectivity information of the target database
The Repository Server starts a Repository agent Process
The Repository Server uses a Repository agent process to communicate with the Repository.
The PowerCenter Server process communicates with the repository to run scheduled workflows. When a workflow is run manually the Power Center Server uses the instructions configured in the mapping (stored in the Repository) to read , transform and write data.
(details on what a workflow and mapping is discussed below).

Below are the key PowerCenter Client Tools:

a)Repository Manager: To create and manage repository, create and manage users
b)Repository server admin console: To manage the Repository Server
c)Designer Tools:
(i)Source Analyzer: to import source definitions
(ii)Warehouse designer: to import target definitions
(iii)Transformation developer: a repository object that generates/modifies and parses data. This object can be reused .
(iv)Mapping: a mapping is nothing but a set of source and target definitions linked by transformation objects. A mapping is what represents the data flow from source to target.
Mapping Designer is used to create Mappings.
(v)Mapplet designer: A mapplet is a set of objects that you use to build reusable transformation logic.
(vi)Workflow: a workflow is a set of instructions that tells the Power Center Server how to execute a task. Workflow Manager can be used to create and run workflows. Workflow Monitor can used to monitor the running of workflows.(If you are new to the ETL world the above concepts may be overwhelming in the beginning, but as we go through other chapters you will be able to see how the concepts relate to the ETL process)
Categories: Development

Informatica for NewBie Sereis

Vidya Bala - Wed, 2006-11-22 10:59
with all the rush before the holidays for getting things done - I really wanted to start this series before the Holidays. As mentioned in my earlier post , for somebody with ETL experience it gets difficult to evaluate different tools because not many are available out there to download and evaluate. On the same note except for manuals there is not much information on the web for ETL tools in general. I am hoping this series will help a few Niewbie's to Informatica(to jumpstart their work with Informatica) and ETL concepts explained with Informatica (Thanks to Mark Rittman for pointing out a possible site for an evaluation copy - Mark, finding the eval copy and the eval license codes was a treasure hunt on edelivery).

The series will cover the following Topics
Informatica Fundamentals (PartI and Part II)
Informatica Eval Installation
Informatica Admin Tasks
Informatica Designer Tasks
Informatica getting familiar with Workflow Manager and Workflow Monitor
Other Things to remember about Informatica
things to remember in the ETL world(basic concepts)

If you are following this specific series - please drop in comments and let me know if the series helps you get familiar with the fundamentals of Informatica.
Categories: Development

Never volunteer

Stephen Booth - Tue, 2006-11-21 03:29
During his presentation on "Inside RAC" Julian Dyke appeared to suffer laptop difficulties so asked for 4 volunteers to assist in a demonstration. Being the helpful soul (i.e. idiot) that I am, I volunteered. Mr Dyke did seem remarkably wellprepared in terms of props, almost as if he had been expecting his laptop to have problems :-)!Photographic evidence (courtesy of Connor McDonald) can be Stephen Boothhttps://plus.google.com/107526053475064059763noreply@blogger.com1

Histogram problems

Stephen Booth - Sun, 2006-11-19 14:31
A question just appeared on the Oracle-L mailing list about whether there are any issues with using histograms. I've seen a number of presentations over the last couple of years that have warned about issues where you have histograms on highly skewed data and use bind variable (or have cursor_sharing=force, which synthesises bind variable from literals in queries), so I responded:On 19/11/06, A Stephen Boothhttps://plus.google.com/107526053475064059763noreply@blogger.com0

dbms_job, pended and drifting

Dong Jiang - Thu, 2006-11-16 15:26

Suppose we have a job submitted, interval is sysdate + 1 / 24 / 60, but the job is going to take 5 minutes, how will Oracle behave?
Looks like the sequence of events will be the following:
T0, Job #1 starts, the next run time is going to be sysdate(T0) + 1 minute.
T0 + 1 minute, The next job #2 starts, but is blocked by a QS lock, id2 in v$lock will tell the job id.
T0 + 5 minute, Job #1 completes, set sys.job$.next_date=greatest(T0 + 1/24/60, sysdate), effectively changing the this_date for job #2 to be sysdate. Job #2 starts.
Another issue is T0 is loosely guarenteed and could be off by couple of seconds, and even if the job completes within interval, the start time could drift if one uses sysdate only. To avoid drifting, use some calculation based on trunc(sysdate) instead of sysdate.

Null object_id in user_objects

Dong Jiang - Thu, 2006-11-16 13:09

When will Oracle have a null object_id, even if the doc says it’s NOT NULL?

An invalid database link.

An update: Actually, any database link.
It comes from the second branch of the union-all clause of user_objects:
select l.name, NULL, to_number(null), to_number(null),
l.ctime, to_date(null), NULL, ‘VALID’, ‘N’, ‘N’, ‘N’
from sys.link$ l
where l.owner# = userenv(‘SCHEMAID’);


Denis Goddard - Thu, 2006-11-16 00:22
Well, well, well.... apparently I have a "Boston or New Hampshire" accent.
I am QUITE sure it's a "New Hampshire" accent, thank you very much!

The strange thing is... my 2-year old son already has an almost ridiculous New England accent. He says "heyah" for "here", "cah" for "car", and so forth. The weird thing is, we can't figure out how he picked it up. We almost never watch TV, and when we do it's not local news, so the accent didn't come from there. He has had this accent ever since he started talking, just 1-2 months after we moved to Nashua.

Anyways, I'm from Wisconsin but my dad is from England (with a long spell in Canada) and he has a sort of vaguely British accent, which I assume I inherited slightly.

What American accent do you have?
Your Result: Boston

You definitely have a Boston accent, even if you think you don't. Of course, that doesn't mean you are from the Boston area, you may also be from New Hampshire or Maine.

The West
The Midland
North Central
The Northeast
The Inland North
The South
What American accent do you have?
Take More Quizzes


Subscribe to Oracle FAQ aggregator