The Oracle Service Bus is often used for service virtualization. Endpoints are exposed on the Service Bus which proxy other services. Using such an abstraction layer can provide benefits such as (among many other things) monitoring/logging, dealing with different versions of services, throttling/error handling and result caching. In this blog I will provide a small (Java) script, which works for SOA Suite 11g and 12c, which determines exposed endpoints on the Service Bus.
A recent posting on OTN reminded me that I haven’t been poking Oracle 12c very hard to see which defects in reporting execution plans have been fixed. The last time I wrote something about the problem was about 20 minhts ago referencing 184.108.40.206; but there are still oddities and irritations that make the nice easy “first child first” algorithm fail because the “depth” calculated by Oracle doesn’t match the “level” that you would get from (more...)
It is my assumption that inbound and outbound emailing has been configured – for example for a GMail account – as described in these two articles: GMail for inbound mail in SOA Suite 12c and GMail for outbound mail in SOA Suite 12c and that test mails can be sent and received.
The steps are:
- configure an email driver for SOA Suite for outbound and inbound emails
- configure an email address (one of the inbound (more...)
The following steps are what I did for installing 220.127.116.11 on Windows.
1. Download the Oracle installation ZIP files from the Oracle Downloads page.
2. Unzip the two 12c downloads files into the same directory.
3. Go to the newly created directory (it is probably called 'database') and you will find a file called setup.exe. Double click on this file.
After a couple of seconds you will see the Oracle Database (more...)
I was upgrading an Exadata test database from 18.104.22.168 to 22.214.171.124 and I came across a failure scenario I had not encountered before. I’ve upgraded a few databases to both 126.96.36.199 and 188.8.131.52 for test purposes, but this was the first one I’d done on Exadata. And the first time I’d encountered such a failure.
I started the upgrade after checking with the (more...)
This week I’ve been enjoying spending some time at Oracle Open World in San Francisco, CA. While here, I’ve been talking with everyone, friends old and new, and it came to my attention that it would be a good idea to have some useful templates for Oracle GoldenGate parameter files. With this in mind, I decided to create some generic templates with comments for Oracle GoldenGate processes. These templates can be found on my Scripts (more...)
A cool thing I heard at Open World 2014: we all know in SOA there are all these adapters you can use in your SCA components. In Oracle Integration Cloud Services (ICS) there are a lot of new SaaS adapters to integrate with SaaS applications like SalesForce for example. These adapters are build using a Cloud Adapter SDK and written in Java.
This exact SDK will be available for users as well, so we all (more...)
This year’s Oracle Open World is again all about Cloud and Mobile. However, this year it is getting more and more concrete. Apart from all the announcements of Process Cloud and integration cloud services there will be more JSON support in Oracle’s SOA Suite.
In Oracle SOA Suite 12C (12.1.3) the REST Adapter already made its appearance. This adapter makes it make your SCA component available as, and leverage REST services, using JSON. (more...)
In case you hadn’t noticed it, partitioning has finally reached clusters in 12c – specifically 184.108.40.206. They’re limited to hash clusters with range partitioning, but it may be enough to encourage more people to use the technology. Here’s a simple example of the syntax:
create cluster pt_hash_cluster ( id number(8,0), d_date date, small_vc varchar2(8), padding varchar2(100) ) -- single table hashkeys 10000 hash is id size 700 partition by range (d_date) ( partition (more...)
I started looking into In-Memory on RAC this week. Data can be distributed across RAC nodes in a couple of different ways. The default is to spread it across the available nodes in the cluster. So if you had a 2 node cluster, roughly 50% of the data in your table or partition would be loaded into the column store in each of the 2 instances.
SYS@dw1> alter table kso.skew inmemory; (more...)
When I normally start work on a new EM 12c environment, I would request to have a userid created; however, I don’t have a userid in this environment and I need access EM 12c as SYSMAN. Without knowing the password for SYSMAN, how can I access the EM 12c interface? The short answer is that I can change the SYSMAN password from the OS where EM 12c is running.
Before changing the SYSMAN password (more...)
In preparation for our upcoming 12c In-Memory Webcast @CaryMillsap, @TanelPoder, and I solicited questions from members of the universe at large on the interweb. We got a question about how In-Memory works with the 12c multi-tentant option and it got me thinking so I gave a quick try. As it turns out, it works about as you would expect. The basic idea is to turn it on for the container DB (which is where the (more...)
Here are the links to the important stuff:
One of the main features of this new release is that it (more...)
One question I get asked a lot is “how can I add additional agent software to OEM 12c”? The answer is pretty easy; just download and apply to the software library. Now what does that mean? In this post, I’ll explain how to download additional agents for later deployments to other platforms.
After logging into OEM 12c, go to the Setup -> Extensibility -> Self Update (Image 1).
If you go to Help -> Check for Updates, tick the Open source and Partner Extensions checkbox and press Next:
Select the ADF (more...)
A quick post to let you know about the two presentations that I’ll be doing at Oracle Open World 2014.
Session ID: UGF4482
Session Title: “Getting Started with SQL Pattern Matching in Oracle Database 12c“
Venue / Room: Moscone South – 301
Date and Time: 9/28/14, 13:30 – 14:15
Oracle’s 220.127.116.11 was released a few weeks ago (You can download it from OTN here: Oracle 18.104.22.168 Download). While technically a minor point release, it contains a couple of major features that would normally be rolled out in a more substantial version change like 12cR2 or perhaps V13. Of course the most highly anticipated feature is a new option (Oracle In-Memory Option) that provides a column (more...)