This is a continuation from my previous post - Developing WebCenter Content Cross Platform iDoc Enabled Components for Mobile, ADF, Sharepoint, Liferay.
You can see a video of JIVE Forums integration with a JS Taskflows vs ADF Taskflow running in WebCenter Portal here -
Click here for hi-resolution
This post is aimed at Web Developers, Designers and Marketing web teams who aren’t familiar with ADF and want to create reusable dynamic taskflows without the need to (more...)
So over the last couple of months I’ve been thinking and tinkering with code – “Whats the best approach for creating a WebCenter Content (WCC) components that I can consume and reuse across multiple platforms and environments?”
Is it… pagelet producer or maybe an iFrame; but these solutions just weren’t good enough or allowed the flexibility I really wanted.
I needed a WCC Solution that could easily be consumed into Mobile either cordova (Hybrid (more...)
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.
Permissions for both HDFS and local fileSystem paths
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
------------------------- ----------- ----------------------------------------
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
log_file_name_convert string /oradata/xmenprod, /oradata/xmenstby
service_names string xmenstby
Over the past couple of months I worked with a few clients in order to conduct an assessment on dashboard and analysis design. In most cases I was noticing that the dashboards were overflowing with content to the point that there was really no discernible “story” or “flow” to the information. Most of the dashboards were an overwhelming hub of large tables, excess dashboard prompts, and complicated charts and graphs. Many times the client complaints (more...)
A new version 4.1 of the XPLAN_ASH utility is available for download.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)
(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...)
When working with Oracle GoldenGate, understanding the System Change Number (SCN) is important. The SCN is an internal number maintained by the database that keeps track of the changes made to the database for recovery purposes. The SCN is also important when working with Oracle GoldenGate. In many environments, instantiation of Oracle GoldenGate environments require knowing where to start the replicat from.
To find the current SCN for the database, Oracle has made this pretty (more...)
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
, acceptance test
, code coverage
, commit test
, Continous Integration
, gui test
, 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;
insert into a_table
values ('that create', 1, 'new object');
select count(*) from user_objects;
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...)
For a couple of weeks now, I’ve been trying to figure out a way to identify the size of data for transactions that are getting processed over a give period of time with Oracle GoldenGate. When I started to think through the process, I keyed in on the Relative Byte Address (RBA). What is the RBA? From reading Oracle’s GoldenGate documentation, the RBA is mostly a marker within the trail file to (more...)
So there I was, working on another database duplication project, the requirement is to save the existing database links.
Sounds pretty easy, right?
SELECT OWNER, DB_LINK, DBMS_METADATA.GET_DDL('DB_LINK',DB_LINK,OWNER) as DDL FROM DBA_DB_LINKS;
Wrong and I know why I am getting bald. Pulling my hair out.
After searching for hours, I found DBMS_METADATA.GET_DDL database link password missing
Another 220.127.116.11 Bug.
I believe the bug was introduced when I modified user’s password as (more...)
This is the third part of the video tutorial "Analysing Parallel Execution Skew". In this part I show how to analyse a parallel SQL execution regarding Parallel Execution Skew.
If you don't have a Diagnostics / Tuning Pack license the options you have for doing that are quite limited, and the approach, as demonstrated in the tutorial, has several limitations and shortcomings.
Here is the video:
If you want to reproduce or play around with (more...)
Come join me and Ted Zwieg at Collaborate14 on our presentation Taking UX and development to the next level.
Fri, Apr 11, 2014 (09:45 AM – 10:45 AM) : Level 3, San Polo 3501A.
Here is our session overview -
Taking the WebCenter Portal User Experience to the Next Level!
|Learn techniques to create unique, award winning portals that not only supports todays need for Mobile responsive and adaptive content but take the (more...)|