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.
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...)
Fishbowl’s GSA Portal Search Suite introduces JSR-286 portlet integration that brings Google search to Oracle WebCenter and Liferay Portal
Integrated Google search has arrived for Oracle WebCenter and Liferay Portal. Last week, Fishbowl Solutions announced GSA (Google Search Appliance) Portal Search Suite. This is Fishbowl’s fourth product for the Google Search Appliance, and introduces a productized integration that exposes Google search features like spelling suggestions, dynamic navigation, and document previews directly within the portal.
Previous integrations between the GSA and WebCenter or Liferay Portal had to be heavily customized to expose similar (more...)
The Grid Infrastructure filesystem was reporting that it was a bit full today (release 184.108.40.206). This was tracked down to the “crfclust.bdb” file, which records information about the cluster health for monitoring purposes. It was 26GB. It’s not supposed to get bigger than 1GB so this is probably a bug, but let’s explicitly resolve the size issue right now and search Oracle support later. Worst case, bdb (Berkerley Database) files get (more...)
Recently, there was an issue after a node was added to an existing Windows RAC cluster. After everything was set up, the local listener was not listening to the IP address (192.168.0.37) corresponding to the node’s hostname. Oracle version was 220.127.116.11.
The listener.ora was configured properly with the following line:
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
The above setting works properly in linux, but does not in Windows
Oracle 11g R1 also introduced the UNPIVOT function, allowing columns to be converted into rows.
ProblemI've created an example that lists cities by row, but two attractions as two columns, with pairing attributes describing the reason for the attraction.
create table aus_attractions(id number, city varchar2(50)
, attraction1 varchar2(50)
Do you validate your backup and what command do you use?
Lately, I have been using restore database validate preview summary to kill 2 birds with 1 stone.
The issue is RMAN will skip validation of archived log backupset when archived log exists.
Does this seem wrong to you?
Please take a look at a test case here
What do you think?
Permission issues is one of the key error , while setting up Hadoop Cluster, while debugging some error found below table on http://hadoop.apache.org/ . It’s a good scorecard to keep handy.
The following table lists various paths on HDFS and local filesystems (on all nodes) and recommended permissions:
Normally, when I create physical standby database, the configuration has the same directory structures and name values as production with the exception of db_unique_name.
But this time was not the case as shown below.
ANGEL:(SYS@xmenstby):PHYSICAL STANDBY> show parameter name NAME TYPE VALUE ------------------------- ----------- ---------------------------------------- cell_offloadgroup_name string db_file_name_convert string /oradata/xmenprod, /oradata/xmenstby db_name string xmenprod db_unique_name string angel_xmenstby global_names boolean FALSE instance_name string xmenstby lock_name_space string log_file_name_convert string /oradata/xmenprod, /oradata/xmenstby processor_group_name string service_names string xmenstby ANGEL:(SYS@xmenstby):PHYSICAL STANDBY>
As usual the latest version can be downloaded here.
This version in particular supports now the new 12c "Adaptive" plan feature - previous versions don't cope very well with those if you don't add the "ADAPTIVE" formatting option manually.
Here are the notes from the change log:
- GV$SQL_MONITOR and GV$SQL_PLAN_MONITOR can now be customized in the
settings as table names in (more...)
A quick fly through the options for conditional uniqueness.
Requirement #1: I want uniqueness on a column but only under certain conditions.
For example, I have an active flag and I want to make sure there is only one active record for a particular attribute but there can be many inactive rows.
create table t1 (col1 number not null ,col2 varchar2(24) not null ,is_active number(1) not null ,constraint pk_t1 primary key (col1) ,constraint (more...)
(Or: "How to build your own Oracle Cloud in 25 minutes"... ! )
After downloading the recently released Oracle Express Edition for 64-bit Windows, I decided to test it out on a Windows Server 2008 R2 running in the Azure cloud (recently renamed from "Windows Azure" to "Microsoft Azure").
Here are the high-level steps needed to get this up and running:
- Sign up for Azure and login to the management portal.
- Create a new Virtual (more...)
As announced by Kris Rice (who is the product manager for SQL Developer, Apex Listener and Oracle XE), the Oracle Express Edition (XE) Database version 11g is now (finally!) available for 64-bit Windows.
It's been a looong wait; the 64-bit version for Windows was expected to be released around the same time as the 32-bit version, some 3 years ago.
Anyway, it's here now, which is great! Thanks Kris! :-)
Oracle Express Edition 11g (more...)
There are couple of my “gotchas”
For almost five years, I have used RMAN very minimally.
Luckily, learning RMAN is like learning to ride a bike. One may not be able to perform wheelie, but one does not forget.
Please allow me to share the details on how to restore database to a new server, new database name, and new location using RMAN.
At source, database is using OMF and backup is located at /oradata/backup.
At target, database is not using (more...)
I have presented today on DOAG Development 2014 in Dusseldorf. For all non DOAG members – you can find the german presentation on slideshare too.
Filed under: Quality Assurances Tagged: 11g, 12c, acceptance test, ADF, Checkstyle, code coverage, commit test, Continous Integration, FindBugs, gui test, JaCoCo, JDeveloper, Jenkins, JUnit, Mockito, PMD, Powermock, Static Code Analysis, unit test
I insert a row into a table, roll it back, yet somehow I’ve created a new object in my database!
select count(*) from user_objects; COUNT(*) ---------- 2 insert into a_table values ('that create', 1, 'new object'); rollback; select count(*) from user_objects; COUNT(*) ---------- 3
There’s no triggers or other “trickery” involved – the code above is a copy-paste in a database where I have (more...)
I am not going to post on how to roll forward standby database as it has been written in many blogs already.
Instead, I am going to share what I have learned how it may have been done incorrectly using the wrong SCN.
Typically, select current_scn from v$database should work until it doesn’t.
But why take the chance and why not do it right the first time.
In reviewing Steps to perform for Rolling forward a standby (more...)
If you speak german and you are interested in quality assurance for your ADF projects you should come and attend my presentation at DOAG Development on 06/04/2014 in Dusseldorf.
I will show you, how you can implement in the JDeveloper IDE and in Continous Integration server Jenkins:
- static code analysis with PMD, FindBugs and Checkstyle
- Commit tests with JUnit, Mockito and Powermock for Mockito
- Code coverage for commit tests with JaCoCo
- Acceptance tests with JUnit (more...)