Design, implement, manage, and maintain a highly flexible service-oriented computing infrastructure across your enterprise using the detailed information in this Oracle Press guide. Written by an Oracle ACE director, Oracle SOA Suite 12c Handbook uses a start-to-finish case study to illustrate each concept and technique. Learn expert techniques for designing and implementing components, assembling composite applications, integrating Java, handling complex business logic, and maximizing code reuse. Runtime administration, governance, and security are covered in this (more...)
Avoid using quotes and case sensitivities if you can.
1. Replace double quote with single quote.
Change reference is GETENV statement to use single quotes rather than double quotes, as example is :
2. Specify NOUSEANSISQLQUOTES in GLOBALS parameter.
The default is now USEANSISQLQUOTES.
When capturing and mapping object names, such as table names, Oracle GoldenGate always recognizes (more...)
I have seen several blogs demonstrating using database exception table for error handling.
Truth be told, I have never used the exception table method and curious to know what’s the difference.
Version 184.108.40.206.1 OGGCORE_220.127.116.11.0_PLATFORMS_151211.1401_FBO
First, there’s manual work to create database exception table for error handling.
Let’ me know how long it takes you to configure database exception table for error handling.
Second, with new features, you (more...)
At first, I was wondering what’s the true benefit of the new feature (checkprm) since there exists CHECKPARAMS which does this.
For someone lazy like me, it means not having to modify code to add and remove CHECKPARAMS from GoldenGate parameter files.
Once, there was oerr and now there is oggerr to look up error codes.
$ checkprm dirprm/e_hawk.prm
2016-06-11 07:29:47 INFO OGG-02095 Successfully set (more...)
Here’s a surprising (to me) execution plan from 18.104.22.168 – parallel execution to find one row in a table using a unique scan of a unique index – produced by running the following script (data creation SQL to follow):
set serveroutput off set linesize 180 set trimspool on set pagesize 60 alter session set statistics_level = all; variable b1 number exec :b1 := 50000 select /*+ parallel (3) */ id, v1 from (more...)
Here’s an execution plan from a recent OTN database forum posting:
------------------------------------------------------------------------------------------------ | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ------------------------------------------------------------------------------------------------ | 0 | UPDATE STATEMENT | | 1 | 231 | 160 (6)| 00:00:02 | | 1 | UPDATE | GS_TABLE | | | | | |* 2 | HASH JOIN SEMI | | 1 | 231 | 130 (0)| 00:00:02 | |* 3 | TABLE (more...)
I have 12c setup on OEL 6.7 on my VM and while trying to access EM express, I was receiving the error
Just for the notes, a user can log into EM Express using URL
and port details can be found using
lsnrctl status | grep HTTP or select dbms_xdb_config.getHttpsPort() from dual;
Clicking on the “Get Flash” takes you to abode flash page from where you can download the rpm for flash.
When building predictive models the data scientist can spend a large amount of time examining the models produced and how they work and perform on their hold out sample data sets. They do this to understand is the model gives a good general representation of the data and can identify/predict many different scenarios. When the "best" model has been selected then this is typically deployed is some sort of reporting environment, where a list is (more...)
While playing around 22.214.171.124 db, I ran my usual script to check tablespace usage details and it took ~59 secs (Elapsed: 00:00:59.02), which was high.
Ran the sql using “gather_plan_statistics” hint and below lines in the execution plan were of interest –
| 34 | HASH GROUP BY | | 1 | 6 | 3 |00:00:58.68 | 129K| 54801 | 1160K| 1160K| 758K (0)| | 35 | VIEW | DBA_FREE_SPACE (more...)
Why you might want to think twice about using INSERT ALL.
One of those things I knew and then forgot.
So, let’s say you’ve got three tables or a partitioned table or something like that.
Let’s use regional tables for simplicity.
drop table t1_r1; drop table t1_r2; drop table t1_r3; create table t1_r1 (col1 varchar2(2) not null ,col2 number not null ,check( col1 in ('R1'))); create table t1_r2 (col1 varchar2(2) not null ,col2 number not (more...)
Sometimes love isn’t fair
A teenager, just emerging from an awkward growing phase drives a tendency to spew non sensical permutations of varying cringe worthy affections toward their love target. The data points behind the intent are solid. Let’s go Boolean now:
Intent of good = 1 ;
attracted to target = 1;
ability to provide for target = 1;
time available = 1;
prior or current committed relationship = 0.
So here (more...)
This is really messed up. I chose GoldenGate because I did not want to mess around with streams.
When using Integrated Capture or Delivery, then knowing streams is a prerequisites.
Apologies as the format is not pretty.
The QUEUE table was indeed missing and this is what I get for monkeying around.
To resolve the issue – exec DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION();
GGSCI (arrow.localdomain as ggs_admin@hawk) 3> unREGISTER EXTRACT e_hawk DATABASE 2016-05-23 19:16:32 ERROR OGG-08221 Cannot (more...)
Alternate script prvtlmpg.plb (included in the Oracle GoldenGate installation directory) to the mining database to work around this limitation.
oracle@arrow:hawk:/u01/app/126.96.36.199/ggs01 $ ll prv* -rw-r-----. 1 oracle oinstall 1272 Dec 28 2010 prvtclkm.plb -rw-r-----. 1 oracle oinstall 9487 May 27 2015 prvtlmpg.plb -rw-r-----. 1 oracle oinstall 3263 May 27 2015 prvtlmpg_uninstall.sql oracle@arrow:hawk:/u01/app/188.8.131.52/ggs01 $
The other option in this (more...)
I typically don’t like to see WARNING if I can help it.
Goldengate 12c has some security features to allow/prevent unauthorized access.
Be careful. Incorrect IPADDR or PROG is used will prevent Pump Extract delivery to target server.
oracle@arrow:hawk:/u01/app/184.108.40.206/ggs01 $ tail -100 ggserr.log 2016-05-22 12:25:07 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start mgr. 2016-05-22 12:25:07 WARNING OGG-01877 Oracle GoldenGate Manager for Oracle, mgr.prm: Missing explicit accessrule (more...)
This blog post is more of a note for myself on configuring ASMLib.
ASMLib is an optional utility that can be used on Linux systems to manage Oracle ASM devices.
ASMLib consists of the following components:
An open source (GPL) kernel module package: kmod-oracleasm
An open source (GPL) utilities package: oracleasm-support
A closed source (proprietary) library package: oracleasmlib
On my Oracle VMBox, I performed the below steps –
1. Check the installed packages related to (more...)