Log Directory Structure in Cluster Ready Service:

$ORA_CRS_HOME/crs/log--->contains trace files for the CRS resources$ORA_CRS_HOME/crs/init--->contains the trace files of the CRS daemon during startup.Good Place to start with any CRS login problems.$ORA_CRS_HOME/css/log---->The Cluster Synchronization (CSS) logs indicate all actions sych as reconfigurations,missed check -inbs,connects and disconnects from the client CSS listener.In some cases,

Expert Oracle Application Express

If your interested in Oracle APEX, there is a new book available. This book is special, it's 13 chapters from 13 APEX guru's on the on the topics they know best. This book can help you take your APEX development skills to the next level. If your looking for an (more...)

K-Scope Video Interview

It was great to catch up with the Oracle APEX community at K-Scope in Long beach this past June. The enthusiasm and success stories were really phenomenal. Here is a video, in which I attempt to side step questions of our Oracle APEX 4.1 release date.

Here is the (more...)

What I learned at Quest Northeast – Part 1

| Jul 29, 2011
Quest’s annual Northeast conference, held last week at the Mohegan Sun in Connecticut, is always a great source of news, information and gossip.  This year was no exception.  There was no earth-shaking news about either JD Edwards or PeopleSoft, but the era when dramatic things happen to either of them is long past.  Instead, executives [...]

GlassFish 3.1.1 Ships with EclipseLink 2.3!

GlassFish 3.1.1 shipped today which makes it the first application server with the new multi-tenancy and extensible persistence unit support as well as all the other new features included in EclipseLink 2.3. If you're a GlassFish developer and you're upgrading to 3.1.1 you can find out all about the new features available in EclipseLink 2.3 on the EclipseLink Wiki.

To wet your appetite, Alexis Moussine-Pouchkine posted a screencast of building a multi-tenant enabled application on a pre-release build of GlassFish 3.1.1 on his blog and now would be a great time to check it out!

Shaun Smith, EclipseLink Team

MySQL Group By is a little too indulgent

After 30 years of Oracle, I've found myself using MySQL recently. I came across a little thing that surprised me. I'm by no means the first to trip over this - I found this 2006 post from Peter Zaitsey on the same topic.

MySQL lets you write a group by statement that references columns that aren't in the group by, and aren't aggregates. For example:

mysql> select table_name, column_name, count(*)
-> from information_schema.columns
-> where table_schema = 'information_schema'
-> group by table_name
-> limit 5;
| table_name | column_name | count(*) |

Oracle Database 11g Security and Compliance Solutions Free Webseminar

| Jul 26, 2011
28 of July 2011 - Free Webseminar "Oracle Database 11g Security and Compliance Solutions" by Tom Kyte
As the amount of digital data within organizations continues to grow at unprecedented rates, so does the value of that data and the challenges of safeguarding that data. Two thirds of sensitive and regulated data resides in databases, yet most IT Security programs fail to address database security and the primary sources of threats that databases face today: insecure applications and privileged users.

Managing Chartfields and Trees Across PeopleSoft and Hyperion

If you’re implementing Hyperion applications to complement your PeopleSoft Financials application, one decision you’ll have to make relatively early is which tool to use to manage your core dimensions and their associated hierarchies.  Here are the options:

Native Functionality
Hyperion EPMA
Hyperion Data Relationship Management

So which one is the right choice?  Based on my research and discussions with Christopher Dwight, a member of Oracle’s Master Data Management practice, here’s what I have learned:

The native functionality basically means you’ll maintain your dimensions in each application separately.  So if you want to add a department, you’ll have (more...)

Plagiarism: The Sincerest Form of Flattery

As the saying goes, "Imitation is the sincerest form of flattery". Copying published articles with acknowledging the author is called plagiarism. There are several sites on the world wide web that have copied blog posts from this blog and posted it in its entirety without any mention of the author or even a link to the original post. Some of the sites are selling illegal 'brain dump' question banks and that devalues the intent of this blog author to provide a forum for hard working certification candidates to prepare for exams and pass them with proper preparation and (more...)

How to transfer files from ASM to another ASM or filesystem or DBFS…

I had a requirement of transferring files from our PROD ASM to our UAT ASM as DBFS is proving to be slow.

The problem:

We are currently refreshing UAT schemas using Oracle Datapump to DBFS and then transferring those files to UAT using SCP.

DBFS does not provided us with the performance we need as datapump files are quite big. Same export onto ASM or NFS proves to be much, much faster.

We are currently testing exports to ASM, but, how to move dmp files from PROD ASM to UAT ASM?

The solution:

The answer for us is using DBMS_FILE_TRANSFER. (more...)

O ícone de gravar

| Jul 23, 2011
Eu não tinha ainda pensado nisto: o ícone para "gravar" ("salvar" em português do Brasil) é na grande maioria das aplicações um desenho de uma diskete floppy e, um grande número de potenciais utilizadores dessas aplicações numa viram uma diskette (quanto mais usaram uma :-) ) pelo que, esse ícone não se torna "óbvio". Alterar para um CD ou DVD também não será uma boa opção :-).
Há uns meses atrás o meu amigo Vítor postou sobre a importância dos ícones e da escolha das suas cores. Os ícones devem ser suficientemente intuitivos (não crípticos) e distintos nas aplicações (more...)

163 ACEs In This Deck

If Oracle OpenWorld 2011 content catalog was a deck of cards, there would be 163 Aces in the deck. The Oralce Technology Network (OTN) Blog lists the Oracle ACE holders presenting at Oracle OpenWorld in a blog post appropriately titled: Are You Kidding Me? 163 Oracle ACE Sessions at Oracle OpenWorld

The Who's Who of the Oracle Universe is presenting and it is a very humble feeling to be included in the list. I hope to feature some of the illustrious names in the 'Meet The Experts' section of this blog. If you are attending Oracle OpenWorld 2011, add the (more...)

Correction: Lawyers don’t run Oracle

It seems that the case of the mysterious disappearing Oracle websites is not part of a devious strategy by Oracle Legal to remove all useful Oracle info from the interweb.

I’ve heard from reliable sources that a new Oracle wiki will be appearing shortly – hopefully running Oracle WebCenter? And (more...)

VirtualBox 4.1 released

| Jul 22, 2011
Released on the 19th VirtualBox 4.1 has several new features like VM clones, enhanced wizard for creating new virtual disks, Windows Aero support, increased capability for very large hosts,...

For any developer interested in trying Oracle DB there are several appliances (pre-built images) available.
Also available are some other appliances for several free and/or open-source Operating Systems.

Oracle Certified Specialist – Time To Get Specialized

About 2 years ago, Oracle Partner Network (OPN) launched the OPN Specialized program. Specialization achievement has a key component of competency development. Partners who earn specialization in at least one area (and up to four areas) are eligible for entry to the Gold level. Those partners who obtain five or more specializations qualify for the elite Platinum partner program level, which is the highest partner program level offered by Oracle.

Oracle Certification Program team has launched Oracle Certified Specialist credentials to certify Oracle Partners for their specialization level. OPN Certified Specialist credential identifies those Oracle Partners who have completed specified requirements for select Oracle (more...)

Oracle Database Firewall – What is it?

It all started with acquisition of Secerno, a database firewall vendor, in 2010. Secerno's product “DataWall” helped analyze how databases are accessed so that DBA’s can set up policies to control the access.
The database firewall has the ability to analyze SQL statements sent from database clients and determine whether to pass, block, log, alert, or substitute SQL statements, based on a defined policy. Users can set whitelist and blacklist policies to control the firewall. It can detect injected SQL’s and block them.  According to Oracle, the database firewall can do the following -

6 Degrees of Separation

Oracle Certification Program (OCP) Team has become social-media savvy over the years. Today, there are less than six degrees of separation between you and the tirelessly working Oracle Certification Team who have launched more than 100 new certification exams in the last 3 years. Gone are the days where you e-mailed the OCP Team and waited weeks for an answer. Now there are 6 social media channels to reach them.

They are as follows:

  1. Facebook - Like their Facebook page and get status updates on latest announcements
  2. Twitter - Follow @oraclecert
  3. YouTube - Subscribe to the Oracle Certification channel
  4. Blog - (more...)

Oracle: Rename single/RAC Database

Method 1: Recreate control file with the new DB name, the old tried and tested method.
Method 2: Use new utility called NID
Steps to rename Databases using the new NID utility:
1.) Stop database

[oracle@testing1]~% srvctl status database -d test
Instance test1 is running on node testing1
Instance test2 is running on node testing2

srvctl stop database -d test

2.) startup mount the database:

[oracle@testing1]~% sqlplus / as sysdba

SQL*Plus: Release 11. (more...)

Using OSGi to explain the difference between Factory and Broker pattern

Osgi in Action: Creating Modular Applications in JavaAfter some heated discussions about OSGi on The Server Side decided to put together a series of articles on the topic. Quite rightly I think, Peter Kriens has the honour of getting the series started. His article on developing modular applications provides one of the clearest explanations of the differences (more...)

Certification Preparation Showcase: uCertify PrepKit

Oracle Certified Professionals Blog is introducing a new feature called Certification Preparation Showcase to introduce blog readers to certification preparation education providers and their products. These independent review will highlight the features available in the offerings so that blog readers are aware of the vendors. This blog does not endorse or recommend any specific vendor. Certification candidates should use their best judgement before buying any products or services reviewed on this blog. OCP Advisor hopes that Certification Preparation Showcase will assist blog readers in the evaluation of certification related products or services.

The first product which is being reviewed in (more...)