Customers CX Newsletter – October 2014 release

It’s out! New, in-depth, Oracle Customer Experience newsletter for customers has just been published.  It’s stacked with press releases, product news, events, partner info, infographics, research, and loads more!  Get it now

11 Ways to Wreck Your Social Relationships

Social media marketing is all about building authentic relationships. It involves many of the things human relationships live and die by; knowing the person, trust, altruism, patience, etc. So it follows naturally the opposite traits would lead to relationship failure; narcissism, mistrust, selfishness and the like.

When you look at how some brands treat their fans, followers and customers on social, it kind of makes you wonder what their real world human relationships are like. (more...)

Peoplesoft HCM92 image #9

It has been released earlier this week, time to move to VMWare ESXi.
My workaround I described here is still working. To make it short, updating the ovf file as below:
1. ovf:capacity=(ovf:capacity*2)-64512 (I used diskMode=thin in the VM disks’ definition for the import)
2. <OperatingSystemSection ovf:id="101">
3. <Description>oracleLinux64Guest</Description>
       <vbox:OSType ovf:required="false">oracleLinux64Guest</vbox:OSType>
4. <vssd:VirtualSystemType>vmx-08</vssd:VirtualSystemType>

And the VM starts properly.

Enjoy,

Nicolas.

Announcement: Singapore Oracle Sessions

When I knew that the ACE Director, Bjoern Rost of Portrix Systems was coming to Singapore on his way to begin the OTN APAC tour, I suggested he stay at mine for a few days and sample all that Singapore has to offer.

Then a thought occurred to me. While he was here, why not setup an informal Oracle users meetup, much like the various ones at cities around the world like Sydney, Birmingham and (more...)

Oracle Event Processing 12c: java errors when deploying a new OEP project

Sometimes when you create a new OEP project in JDeveloper 12c and you deploy it for the first time, you might get a list of java errors. They might look a bit like this:


Exception in thread "SpringOsgiExtenderThread-118" org.springframework.beans.Fat
alBeanException: Error in context lifecycle initialization; nested exception is
com.bea.wlevs.ede.api.ConfigurationException:
Invalid statement: "select S.properties as properties,
>>cast<<@java(S.javaContent, com.oracle.oep.FraudCheckRequest.class).getOrde
rNumber() as orderNumber,
cast@java(S.javaContent, com.oracle.oep.FraudCheckRequest.class).getEmail()
as email,
cast@java(S.javaContent, com.oracle.oep.FraudCheckRequest.class).getTotalAmo
unt() as totalAmount
from ednInputChannel as S"
Description: Invalid call to function or constructor: cast
Cause: Probable causes are: Probable causes are: There is no symbol named com, o
r Attribute name com is invalid for STREAM or RELATION or VIEW., or Types com.or
acle.oep.FraudCheckRequest.class and com.oracle.oep.FraudCheckRequest not found
when referencing constructor or static method.., or Error while handling member
access to complex type. Constructor cast of type cast not found. or Probable cau
ses are: Probable causes are: There is no symbol named com, or Attribute name co
m is invalid for STREAM or RELATION or VIEW., or Types com.oracle.oep.FraudCheck
Request.class and com.oracle.oep.FraudCheckRequest not found when referencing co
nstructor or static method.., or Error while handling member access to complex t
ype. Constructor cast of type cast not found...
Action: Verify function or constructor for complex type exists, is not ambiguous
, and has the correct number of parameters.
at com.bea.wlevs.spring.ApplicationContextLifecycle.onApplicationEvent(A
pplicationContextLifecycle.java:146)
at org.springframework.context.event.SimpleApplicationEventMulticaster.m
ulticastEvent(SimpleApplicationEventMulticaster.java:97)
at org.springframework.context.support.AbstractApplicationContext.publis
hEvent(AbstractApplicationContext.java:324)
at org.springframework.context.support.AbstractApplicationContext.finish
Refresh(AbstractApplicationContext.java:929)
at org.springframework.osgi.context.support.AbstractOsgiBundleApplicatio
nContext.finishRefresh(AbstractOsgiBundleApplicationContext.java:235)
at org.springframework.osgi.context.support.AbstractDelegatedExecutionAp
plicationContext$4.run(AbstractDelegatedExecutionApplicationContext.java:358)
at org.springframework.osgi.util.internal.PrivilegedUtils.executeWithCus
tomTCCL(PrivilegedUtils.java:85)
at org.springframework.osgi.context.support.AbstractDelegatedExecutionAp
plicationContext.completeRefresh(AbstractDelegatedExecutionApplicationContext.ja
va:320)
at org.springframework.osgi.extender.internal.dependencies.startup.Depen
dencyWaiterApplicationContextExecutor$CompleteRefreshTask.run(DependencyWaiterAp
plicationContextExecutor.java:136)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.bea.wlevs.ede.api.ConfigurationException:
Invalid statement: "select S.properties as properties,
>>cast<<@java(S.javaContent, com.oracle.oep.FraudCheckRequest.class).getOrde
rNumber() as orderNumber,
cast@java(S.javaContent, com.oracle.oep.FraudCheckRequest.class).getEmail()
as email,
cast@java(S.javaContent, com.oracle.oep.FraudCheckRequest.class).getTotalAmo
unt() as totalAmount
from ednInputChannel as S"
Description: Invalid call to function or constructor: cast
Cause: Probable causes are: Probable causes are: There is no symbol named com, o
r Attribute name com is invalid for STREAM or RELATION or VIEW., or Types com.or
acle.oep.FraudCheckRequest.class and com.oracle.oep.FraudCheckRequest not found
when referencing constructor or static method.., or Error while handling member
access to complex type. Constructor cast of type cast not found. or Probable cau
ses are: Probable causes are: There is no symbol named com, or Attribute name co
m is invalid for STREAM or RELATION or VIEW., or Types com.oracle.oep.FraudCheck
Request.class and com.oracle.oep.FraudCheckRequest not found when referencing co
nstructor or static method.., or Error while handling member access to complex t
ype. Constructor cast of type cast not found...
Action: Verify function or constructor for complex type exists, is not ambiguous
, and has the correct number of parameters.
at com.oracle.cep.processor.cql.impl.CQLProcessorImpl.prepare(CQLProcess
orImpl.java:1141)
at com.oracle.cep.processor.cql.impl.CQLProcessorImpl.afterConfiguration
Active(CQLProcessorImpl.java:2788)
at com.bea.wlevs.spring.ActivationBeanPostProcessor.postProcessAfterCont
extInitialization(ActivationBeanPostProcessor.java:20)
at com.bea.wlevs.spring.DeferredBeanPostProcessor.afterConfigurationActi
ve(DeferredBeanPostProcessor.java:27)
at com.bea.wlevs.spring.ApplicationContextLifecycle.onApplicationEvent(A
pplicationContextLifecycle.java:113)
... 9 more

The solution to this is very simple.
Go back to JDeveloper, right-click on the project name and select Rebuild. Afterwards deploy again and the errors will be gone.

This has something to do with the java files not registering correctly in the project. Rebuilding the project will force those java files to be included correctly.

12.1.0.2 Introduction to Zone Maps Part II (Changes)

In Part I, I discussed how Zone Maps are new index like structures, similar to Exadata Storage Indexes, that enables the “pruning” of disk blocks during accesses of the table by storing the min and max values of selected columns for each “zone” of a table. A Zone being a range of contiguous (8M) blocks. I […]

Creating a WebLogic 12c Data Source Connection to Pivotal GemFireXD 1.3

I am going to show how you would create a WebLogic data source to Pivotal GemFireXD 1.3. In this example I am using the developer edition of Weblogic which known as "Free Oracle WebLogic Server 12c (12.1.3) Zip Distribution and Installers for Developers" You can download / configure it as follows.

http://www.oracle.com/technetwork/middleware/downloads/index-087510.html

Note: I am assuming you have WebLogic 12C running with GemFireXD also running. I am also (more...)

OBIEE How-To: A View Selector for your Dashboard

A common problem report developers face is user groups having different needs and preferences, and as a consequence these user groups want to see their data presented in different ways. Some users prefer to see a graph when others want a table is a classic example. So, how do we do this? It’s a no brainer… we use a view selector. View selectors give us a great amount of flexibility by allowing us to swap out (more...)

Script to count and recompile invalid objects

This is pretty simple, but I thought I would share it since it is helpful to me.  I have been preparing for a large migration which involves table, index, type, function, package, and procedure changes.  When I run a big migration like this I check for invalid objects before and after the migration and attempt to recompile any that are invalid.  By checking before and after the migration I know which objects (more...)

Metric Thresholds and the Power to Adapt

Metric thresholds have come a long way since I started working with OEM 10g.  I remember how frustrating it could be if an ETL load impacted the metric values that had to be set for a given IO or CPU load for a database when during business hours, a much lower value would be preferable.  Having to explain to the business why a notification wasn’t sent during the day due to the threshold (more...)

A World View

I’ve mentioned this before, but I thought I would show something visual…

The majority of my readers come from the USA and India. Since they are in different time zones, it spreads the load throughout the day. When I wake up, India are dominant.

MorningTraffic

In the afternoon the USA come online, by which time Russia have given up, but there is still a hardcore of Indian’s going for it! :)

AfternoonTraffic

I haven’t posted an evening shot as (more...)

BPM & SOA Application missing in JDeveloper 12c gallery

A few weeks ago I did a BPM12c Quickstart Installation under Oracle Linux 6. Everything went smoothly, as described in the install guide as well as on many blogs already.
But I found that most of those blogs did an installation under Windows, where I did it under Oracle Linux in Virtualbox.

You would think (as I did) that it shouldn't matter. However, it turns out that in JDeveloper I was missing the 'BPM Application' (more...)

first_rows und first_rows_n

Jonathan Lewis weist in seinem Blog darauf hin, dass die Optimizer-Modi first_rows und first_rows_n deutlich weniger gemein haben, als man vielleicht annehmen könnte. Während first_rows seit langem nur noch aus Gründen der Abwärtskompatibiltät unterstützt wird und diverse Heuristiken benutzt, um die Optionen des Optimizers einzuschränken, arbeiten die first_rows_n-Varianten strikt kostenbasiert, ohne dem Optimizer massiv in die Arbeit zu pfuschen. Tatsächlich gibt es allerdings einen Fall, in dem first_rows_n sich so verhält wie first_rows, nämlich die (more...)

Structured XML output from Oracle SQL query

Got an interesting question today: There are tables TABLE1, TABLE2 and a junction table that joins them called JUNCTABLE. Need the following output as XML


  
  


  
  

I know the output could be aggregated using XMLAGG, but I have never looked into how to format the tag names and attributed in the output like requested.

Data in my very simplified sample tables:

SQL> select * from table1;

        ID
----------
         1
         2
         3

SQL> select * from table2;

         (more...)

Mount ASM diskgroups with new ASM instance

Imagine you have 11gR2 Oracle Restart configuration with database files located in ASM.

After server crash you realized that local disks are corrupted and with local disks you lost all Oracle installations. Even though this is important system you don’t have database backup (always take backups!).

But you managed to save all ASM disks as they were located on separate storage.


This will be small beginner guide on how to help yourself in such (more...)

Cedar wins Silver – Fusion Partner of the Year 2014/15

If you follow any number of those in the Partner community on LinkedIn you’ll have seen many of us asking that you vote for us in the UKOUG’s annual Partner of the Year competition. All of the partners are really grateful for your votes as winning an award selected by end-users carries significant prestige.

I’m delighted that the company which I now work for – Cedar Consulting – were awarded 2nd place (Silver) for Fusion Partner of (more...)

Oracle Trivia Quiz

All the answers can be found in the November 2014 issue of the NoCOUG Journal. Which executive vice-president of product development at Oracle began as the PL/SQL product manager? (page 23) Which senior vice-president of server technologies at Oracle wrote the B-Tree indexing code back in the day? (page 23) What is the evil twin […]

Something new in 12c: FETCH FIRST x ROWS

In this post I want to show some example of using a new feature in 12c for selecting the first X number of records from the results set of a query.

See the bottom of this post for the background and some of the reasons for this post.

Before we had the 12c Database if we only wanted to see a subset or the initial set of records from the results of a query we (more...)

Living The Nightmare


Last week was excellent, The OTN Nordic Tour (still need to blog), rushing back for UKOUG Partner Awards where Certus won gold for Training & Fusion, a weekend with friends at the Dive Show and finally a quick visit to see my sister, her family and my daughter.

Monday I was travelling from Gloucester to Guildford and the trains were manic, first trains off peak on the Monday of half term, what was I thinking? (more...)

OTN APAC Tour 2014 : It’s Nearly Here!

airplane-flying-through-clouds-smallIn a little less than a week I start the OTN APAC Tour. This is where I’m going to be…

  • Perth, Australia : November 6-7
  • Shanghai, China : November 9
  • Tokyo, Japan : November 11-13
  • Beijing, China : November 14-15
  • Bangkok, Thailand : November 17
  • Auckland, New Zealand : November 19-21

Just looking at that list is scary. When I look at the flight schedule I feel positively nauseous. I think I’m in Bangkok for about 24 hours. It’s sleep, conference, fly. :)

After (more...)