Skip navigation.

Feed aggregator

Twitter Oracle Security Open Chat Thursday 6th March

Pete Finnigan - Tue, 2014-04-22 11:05

I will be co-chairing/hosting a twitter chat on Thursday 6th March at 7pm UK time with Confio. The details are here . The chat is done over twitter so it is a little like the Oracle security round table sessions....[Read More]

Posted by Pete On 05/03/14 At 10:17 AM

Categories: Security Blogs

PFCLScan Reseller Program

Pete Finnigan - Tue, 2014-04-22 11:05

We are going to start a reseller program for PFCLScan and we have started the plannng and recruitment process for this program. I have just posted a short blog on the PFCLScan website titled " PFCLScan Reseller Program ". If....[Read More]

Posted by Pete On 29/10/13 At 01:05 PM

Categories: Security Blogs

PFCLScan Version 1.3 Released

Pete Finnigan - Tue, 2014-04-22 11:05

We released version 1.3 of PFCLScan our enterprise database security scanner for Oracle a week ago. I have just posted a blog entry on the PFCLScan product site blog that describes some of the highlights of the over 220 new....[Read More]

Posted by Pete On 18/10/13 At 02:36 PM

Categories: Security Blogs

PFCLScan Updated and Powerful features

Pete Finnigan - Tue, 2014-04-22 11:05

We have just updated PFCLScan our companies database security scanner for Oracle databases to version 1.2 and added some new features and some new contents and more. We are working to release another service update also in the next couple....[Read More]

Posted by Pete On 04/09/13 At 02:45 PM

Categories: Security Blogs

Oracle Security Training, 12c, PFCLScan, Magazines, UKOUG, Oracle Security Books and Much More

Pete Finnigan - Tue, 2014-04-22 11:05

It has been a few weeks since my last blog post but don't worry I am still interested to blog about Oracle 12c database security and indeed have nearly 700 pages of notes in MS Word related to 12c security....[Read More]

Posted by Pete On 28/08/13 At 05:04 PM

Categories: Security Blogs

Oracle 12c Security - SQL Translation and Last Logins

Pete Finnigan - Tue, 2014-04-22 11:05

There has been some big new security items added to 12cR1 such as SHA2 in DBMS_CRYPTO, code based security in PL/SQL, Data Redaction, unified audit or even privilege analysis but also as I hinted in some previous blogs there are....[Read More]

Posted by Pete On 31/07/13 At 11:11 AM

Categories: Security Blogs

Hacking Oracle 12c COMMON Users

Pete Finnigan - Tue, 2014-04-22 11:05

The main new feature of Oracle 12cR1 has to be the multitennant architecture that allows tennant databases to be added or plugged into a container database. I am interested in the security of this of course and one element that....[Read More]

Posted by Pete On 23/07/13 At 02:52 PM

Categories: Security Blogs

PeopleSoft and Heartbleed

Duncan Davies - Tue, 2014-04-22 09:00

Oracle have released a post detailing exactly whichheartbleed products are vulnerable to Heartbleed, which have fixes available and which aren’t vulnerable at all.

If you aren’t aware of what Heartbleed is, here’s a primer:

http://www.engadget.com/2014/04/12/heartbleed-explained/

There’s also an excellent web-comic here that explains quickly how the exploit works:

http://xkcd.com/1354/

Here is Oracle’s list:

http://www.oracle.com/technetwork/topics/security/opensslheartbleedcve-2014-0160-2188454.html

Happily, PeopleSoft is on the ‘not vulnerable’ list.

This doesn’t mean that you’re completely safe of course. You may well be using other components in your system that were impacted. At Succeed, for example, we use Amazon’s Elastic Load Balancer that was vulnerable but has now been patched.


Previewing Three Oracle Data Visualization Sessions at the Atlanta US BI Forum 2014

Rittman Mead Consulting - Tue, 2014-04-22 04:30

Many of the sessions at the UK and US Rittman Mead BI Forum 2014 events in May focus on the back-end of BI and data warehousing, with for example Chris Jenkins’ session on TimesTen giving us some tips and tricks from TimeTen product development, and Wayne Van Sluys’s session on Essbase looking at what’s involved in Essbase database optimisation (full agendas for the two events can be found here). But two areas within BI that have got a lot of attention over the past couple of years are (a) data visualisation, and (b) mobile, so I’m particularly pleased that our Atlanta event has three of the most innovative practitioners in this area – Kevin McGinley from Accenture (left in pictures below), Christian Screen from Art of BI (centre), and Patrick Rafferty from Branchbird (right), talking about what they’ve been doing in these areas.

NewImage

If you were at the BI Forum a couple of years ago you’ll of course know Kevin McGinley, who won “best speaker” award the previous year and most recently has gone on to organise the BI track at ODTUG KScope and write for OTN and his own blog, Oranalytics.blogspot.com. Kevin also hosts, along with our own Stewart Bryson, a video podcast series on iTunes called “Real-Time BI with Kevin & Stewart”, and I’m excited that he’s joining us again at this year’s BI Forum in Atlanta to talk about adding 3rd party visualisations to OBIEE. Over to Kevin…

“I can’t tell you how many times I’ve told someone that I can’t precisely meet a certain charting requirement because of a lack of configurability or variety in the OBIEE charting engine.  Combine that with an increase in the variety and types of data people are interested in visualizing within OBIEE and you have a clear need.  Fortunately, OBIEE is web-based tool and can leverage other visualization engines, if you just know how to work with the engine and embed it into OBIEE.

In my session, I’ll walk through a variety of reasons you might want to do this and the various approaches for doing it.  Then, I’ll take two specific engines and show you the process for building a visualization with them right in an OBIEE Analysis.  In both examples, you’ll come away with a capability you’ve never been able to do directly in OBIEE before.”

NewImage

Another speaker, blogger, writer and developer very-well known to the OBIEE community is Art of BI Software’s Christian Screen, co-author of the Packt book “Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial” and developer of the OBIEE collaboration add-in, BITeamwork. Last year Christian spoke to us about developing plug-ins for OBIEE, but this year he’s returned to a topic he’s very passionate about – mobile BI, and in particular, Oracle’s Mobile App Designer. According to Christian:

“Last year Oracle marked its mobile business intelligence territory by updating its Oracle BI iOS application with a new look and feel. Unbeknownst to many, they also released the cutting-edge Oracle BI Mobile Application Designer (MAD). These are both components available as part of the Oracle BI Foundation Suite. But it is where they are taking the mobile analytics platform that is most interesting at the moment as we look at the mobile analytics consumption chain. MAD is still in its 1.x release and there is a lot of promise with this tool to satisfy the analytical cravings growing in the bellies of many enterprise organizations. There is also quite a bit of discussion around building new content just for mobile consumption compared to viewing existing content through the mobile applications native to major mobile devices.

The “Oracle BI Got MAD and You Should be Happy” session will discuss these topics and I’ll be sharing the stage with Jayant Sharma from Oracle BI Product Development where we’ll also be showing some cutting edge material and demos for Oracle BI MAD.  Because MAD provides a lot of flexibility for development customizations, compared to the Oracle BI iOS/Android applications, our session will explore business use cases around pre-built MAD applications, HTML5, mobile security, and development of plug-ins using the MAD SDK.  One of the drivers for this session is to show how many of the Oracle Analytics components integrate with MAD and how an Oracle BI developer can quickly leverage the capabilities of MAD to show the tool’s value within their current Oracle BI implementation.

We will also discuss the common concern of mobile security by touching on the BitzerMobile acquisition and using the central mobile configuration settings for Oracle BI Mobile. The crowd will hopefully walk away with a better understanding of Oracle BI mobility with MAD and a desire to go build something.”

NewImage

As well as OBIEE and Oracle Mobile App Designer, Oracle also have another product, Oracle Endeca Information Discovery, that combines a data aggregation and search engine with dashboard visuals and data discovery. One of the most innovative partner companies in the Endeca space are Branchbird, and we’re very pleased to have Branchbird’s Patrick Rafferty join us to talk about “More Than Mashups – Advanced Visualizations and Data Discovery”. Over to Patrick …

“In this session, we’ll explore how Oracle Endeca customers are moving beyond simple dashboards and charts and creating exciting visualizations on top of their data using Oracle Endeca Studio. We’ll discuss how the latest trends in data visualization, especially geospatial and temporal visualization, can be brought into the enterprise and how they drive competitive advantage.

This session will show in-production real-life examples of how extending Oracle Endeca Studio’s visualization capabilities to integrate technology like D3 can create compelling discovery-driven visualizations that increase revenue, cut cost and enhance the ability to answer unknown questions through data discovery.”

NewImage

The full agenda for the Atlanta and Brighton BI Forum agendas can be found on this blog post, and full details of both events, including registration links, links to book accommodation and details of the Lars George Cloudera Hadoop masterclass, can be found on the Rittman Mead BI Forum 2014 home page.

Categories: BI & Warehousing

Governments getting serious about database security

Chris Foot - Tue, 2014-04-22 01:38

Complex networking, cloud computing and a list of other IT technologies have made data protection all the more difficult. The United States and Canada have implemented security compliance standards, but database experts are claiming that governments need to move past basic regulations and employ more intricate, thorough defense practices.

According to InfoWorld, Canadian authorities recently arrested 19-year-old Stephen Solis-Reyes for utilizing the Heartbleed bug to steal taxpayer information from the Canada Revenue Agency's website. CRA stated earlier this week that the vulnerability was leveraged to steal the Social Insurance Numbers of about 900 people, which caused the agency to temporarily prohibit citizens from filing online tax returns. The delinquent was charged with one count of unauthorized use of a computer and one count of mischief in relation to data. 

The fact that a reprobate as young as Solis-Reyes infiltrated a government website shows just how dexterous modern cybercriminals have become. For this reason, many public authorities have outsourced to remote database support providers capable of devoting an incredible amount of manpower and resources to deterring network intrusions. As it becomes more difficult to physically steal financial information, more deviants will turn to the Web and other IT-based avenues to obtain confidential intelligence. 

Moving past the basics 
It's not easy to gain access to a government database, but cybercriminals are quite capable of adapting to an environment known for its versatility. CIO noted that U.S. federal CIOs claimed that making infiltration difficult poses a challenge – public employees still need to connect with digital information. Simon Szykman, CIO at the Department of Commerce, stated that an answer to this conundrum is automated surveillance, enabling networked assets to search for and report potential security breaches. 

"We're now moving toward an area of much more automated and near real-time situational awareness where we have systems that themselves are able to verify that controls are being implemented," said Szykman, as quoted by CIO.

The National Oceanic and Atmospheric Administration told the news source that its database administration staff collects digital information from more than 20,000 devices. Due to automated monitoring, all of that data becomes centrally aggregated and analyzed, meaning that 1 billion events are processed every day. NOAA CIO Joe Klimavicz claimed that the organization blocks almost half a million malevolent Web connections each week. 

Automated processing allows in-house IT departments and researchers to focus on developing new security techniques while maintaining a continuous overview of all network activities. 

Cycle4Sam 5 - Riding 1000km in 6 days for $100k for Women's and Children's Hospital

Steve Button - Tue, 2014-04-22 01:07


I recently participated in a week long charity bike ride called Cycle4Sam, where funds are raised to support the palliative care unit at the Women and Children's Hospital of South Australia.

The ride is conducted on a bi-annual basis in honour of young Sam Roberts, who sadly passed away from a rare genetic disease at the age of 4. His parents, Marty and Michelle and his siblings Lucy and Charlie, created the Sam Roberts Family Fund in order to raise funds and provide help for other families who find themselves in the same situation.

http://www.cycle4sam.com/
As the major fundraising effort, the Cycle4Sam ride sees a group of riders raise funds through sponsors to participate in a ride of 1000km. This years ride started on April 12th from the regional South Australia city of Renmark and finished back in Adelaide on April 18th, covering 1000km over 6 days of riding.




Day 1 was run as a loop of the Riverland region, taking in Loxton, Berry and a number of other lovely little towns on the way back to Renmark.  A small ceremony was held at the start to honour and remember Sam and other little children who are suffering in the same way.





Day 2 was a transit stage, riding from Renmark to a small town along the River Murray called Walker Flat.



Day 3 took in a loop of the iconic Barossa Valley region  through the towns of Sedan, Angaston, Tanunda, Mt Prospect and back to Walker Flat.  This day had some nice climbing with the Sedan Hill and Menglers Hill included as the main climbs of the day on the back of the generally rolling terrain of the region.




Day 4 was another long day, riding from Walker Flat to the southern beach town of Carrackalinga.  A planned stop at the Woodstock winery to meet up with another family who were afflicted in the same way as the Roberts saw the day come to a slightly unscheduled but much welcomed end, with a short'ish bus transit down to the final stay over.


Day 5 was a rest-day, or more accurately a non-riding day for those of us with kids, which had us taking the kids for a lovely bike ride along the beach front from Normanville to Carrackalinga, followed by a King of the Mountain event up the Latvian Climb.  Tough work for little legs but they all did superbly.



Day 6 was a loop around the Fleurieu Peninsula taking in the lovely back road around Parawa down to Victor Harbor, down to Goolwa and back to Port Elliot for lunch.  A summit of the Crows Nest followed, by a ride up the Myponga Reservoir climb, closing by a screaming descent down to Carrackaling and back to Normanville.





Day 7 was the final day and took us back to Adelaide through the McLaren Vale, Mylor, Aldgate Valley, Stirling and down the freeway, where we were escorted by the SA Police through to the grounds of the Women's and Children's Hospital.



As part of the closing celebrations, the Roberts Family presented the Women's and Children's Hospital with a cheque for $100,000 that was raised by the event.



http://wchfgivinghearts.org.au/event/cycle4sam
I was in the company of an outstanding group of people performing an outstanding service for the community and I thank them all for the privilege of letting me share the event with them.





Indexing Foreign Key Constraints With Invisible Indexes (Invisible People)

Richard Foote - Tue, 2014-04-22 00:31
In my previous post I discussed when deleting rows from parent tables, how Bitmap Indexes based on the FK constraint can prevent the expensive Full Tables Scans (FTS) on the child tables but not the associated exclusive table locks. Last year, I discussed how it was possible in Oracle Database 12c to have multiple indexes on the same column list. […]
Categories: DBA Blogs

Abyssinian: Jazz at Lincoln Center Full Concert

Greg Pavlik - Mon, 2014-04-21 18:46
It's my opinion that the pinnacle of artistic contribution from the American experience is found in Jazz (proof that art and suffering go hand in hand?). And I remain convinced that one of the most important exponents of Jazz as not just "high art" but truly great art is Wynton Marsalis.

Check out this Jazz-meets-Gospel concert in full. A uniquely American synthesis; uniquely wonderful.

Divergent

Tim Hall - Mon, 2014-04-21 17:16

I’ve just got back from watching Divergent. It is a really good film!

Don’t believe any bullshit comparisons to that crappy Hunger Games. It is so much better than that rubbish! It’s probably a good idea not to read any summaries of the plot either, since it sounds kind-of stupid on paper. In the film it makes a lot more sense and just works.

Very pleased I went to see it. One of the better Sci Fi/action films I’ve seen is quite a while. Much more worthwhile than that spider-thing…

Cheers

Tim…

Divergent was first posted on April 22, 2014 at 12:16 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Simple Is The New Cool

Floyd Teter - Mon, 2014-04-21 17:05
We've all heard it: "simple is the new cool".  It's true.

We certainly see it in the UX world.  Simple designs for human interaction.  Tell me what I need to do, how to do it, and make it easy.  If I only had a dollar for every time I heard that mantra... And when we consider the market moving to the cloud, UX is the major differentiation - and simple is carrying the day every day.

That last paragraph?  Double-down on it for mobile.

And we see it in system architecture as well.  Big emphasis on unraveling institutional spaghetti bowls of interfaces, services and business processes in favor of simple, straight-forward enterprise architectures.

Packaged enterprise applications?  Sure.  How many times over the past five years have we heard and seen examples of "reconsider your customizations"?

And let's not forget about embedded analytics that blur the line between business intelligence and transactional reporting.  We're making it simpler to identify and understand the information we need, rather than getting wrapped around the axle about how to classify the source of that information.

Everywhere you look in the enterprise applications world these days, it's all about simplification.  Simple is the new cool.

So how do you start with simple?  You start with a strong focus on the problem you're trying to solve.  What are you making better?  And, by the way, problems like "our company needs to sell more software/services to end users"?  Not the type of problem I have in mind here.  Think about a warehouse working taking inventory.  A college freshman attempting to register.  An AP specialist attempting to identify and analyze payables trends.  Those are the types of problems you want to solve.  Those are the types of situations you want to make better.

Get focused.  Simple is the new cool.

SQL*Loader Express bug

Bobby Durrett's DBA Blog - Mon, 2014-04-21 15:41

I’m still studying for my Oracle 12c OCP exam and I was trying to run a simple example of using SQL*Loader Express and the first thing I did blew up and I think it is a bug.  When I load a table with one or two columns it works fine, but when I load a table with 3 or 4 columns the last column is not loaded.  Tell me this isn’t a special feature! :)

First I create the table with four columns:

create table test
(a varchar2(20),
 b varchar2(20),
 c varchar2(20),
 d varchar2(20));

Then I create a comma separated values file named test.dat with four values per line:

[oracle@ora12c dpsl]$ cat test.dat
a,b,c,d
f,g,h,i
j,k,l,m

Then I run sql*loader in express mode:

[oracle@ora12c dpsl]$ sqlldr system/xxxxxx table=test

SQL*Loader: Release 12.1.0.1.0 - Production on Mon Apr 21 07:32:43 2014

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

Express Mode Load, Table: TEST
Path used:      External Table, DEGREE_OF_PARALLELISM=AUTO

Table TEST:
  3 Rows successfully loaded.

Check the log files:
  test.log
  test_%p.log_xt
for more information about the load.

Then I query the newly loaded table:

ORCL:CDB$ROOT:SYSTEM>select * from test;

A                    B                    D
-------------------- -------------------- --------------------
a                    b                    d
f                    g                    i
j                    k                    m

Queue the mysterious music.  Actually, now that I look at it really it is the third column that is missing.  Maybe it doesn’t work with a column named C.

Sure enough, here it is with column C replaced with column X:

A                    B                    X                    D
-------------------- -------------------- -------------------- --------------------
a                    b                    c                    d
f                    g                    h                    i
j                    k                    l                    m

So, I guess SQL*Loader Express doesn’t work with columns named C?  Odd.

- Bobby

 

Categories: DBA Blogs

Get a plan to increase your confidence

TalentedApps - Mon, 2014-04-21 12:59

Image

Cross Posted from my Personal Blog

I managed to get through high school and college never taking a second language, even in the ’80s this required advanced maneuvers through the academic handbook.  Why would I do this?  Was I against taking a language?

Nope.  I desperately wanted to take a language, but I lacked confidence.

The only language offered in my high school was Spanish, and I wanted to take French or Japanese (it was the ’80s).

Later, when I went off to college, my 17 year old scholarship self, decided I would be unable to keep my required GPA taking a language, given I was already four years behind.

Recursive logic indeed, especially when you factor in the fact that I had an above average memory and a crazy serious work ethic [seriously,  I was so much older then...].  Looking back on this with the benefit of hindsight, I can say confidently, that the odds of me not being able to handle the rigor of a 101 language course was exactly 0.

So when I read that women have a confidence gap, looking for perfection in themselves before putting their hands up for consideration for professional opportunity, I recognize we need to take this seriously.  Especially when we look at the incredibly slow pace of progress for women in senior leadership in the west (in retrospect maybe I was onto something by not taking Japanese).

Image

 

So what to do?

I think it comes down to recognizing the need to have a strategy for being confident.  Being angry at men for being better at this than women, completely misses the point.

Confidence is a critical skill for professional success.  Odds are you could be better.

Work on it.

Some useful suggestions

  1. Get your body and your mind helping you by improving your inner monologue and Power Posing
  2. Get someone with perspective to help you compare your qualifications more objectively
  3. Do a better job recognizing that the fact that you are skeptical of your own qualification, is a sign of your competence

Don’t let a lack of confidence get in the way of your success, practice more, work harder, figure it out.

You can do this!

 

 

 

 


Switch to Integrated Replicat

DBASolved - Mon, 2014-04-21 12:15

Earlier I wrote a blog post about moving the Oracle Golden Gate Extract from “Classic”  capture to “Integrated” capture.   In this post, we will take a look at how to move a “Classic” replicat (apply) to an “Integrated” replicat (apply) process.

The initial step to migrate the replicat from “Classic” to “Integrated” are the same as the extract.  Look here for the initial details.  This post picks up when we are getting ready to stop the replicat and perform the migration.

Before we can do anything with the replcat, we need to be in GGSCI.

Code 1:


[oracle@oel oggcore_1]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.1.2.0.0 17185003 17451407_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Oct 29 2013 00:31:40
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.

 

GGSCI (oel.acme.com) 1>

Now, we need to stop the replciat (apply) process that we are using.

Code 2:


GGSCI (oel.acme.com) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
JAGENT      STOPPED
EXTRACT     RUNNING     EXT         00:00:09      00:00:00
EXTRACT     RUNNING     PMP         00:00:00      00:00:10
REPLICAT    RUNNING     REP         00:00:00      00:00:08

GGSCI (oel.acme.com) 2> stop replicat rep

Sending STOP request to REPLICAT REP ...
Request processed.

With the replicat stopped, we need to log into the database through GGSCI.

Code 3:


GGSCI (oel.acme.com) 3> dblogin userid ggate, password ggate
Successfully logged into database.

Next, we need to alter the replicat to make it integrated.

Code 4:


GGSCI (oel.acme.com) 4> alter replicat rep, integrated
REPLICAT (Integrated) altered.

Finally, we need to start the replicat.

Code 5:


GGSCI (oel.acme.com) 5> start replicat rep

Sending START request to MANAGER ...
REPLICAT REP starting

Once the replicat has been started, we can check the replicat and look at the details with the INFO option.

Code 6:


GGSCI (oel.acme.com) 7> info replicat rep, detail

REPLICAT   REP       Last Started 2014-04-21 14:06   Status RUNNING
INTEGRATED
Checkpoint Lag       00:00:00 (updated 00:00:03 ago)
Process ID           28410
Log Read Checkpoint  File ./dirdat/rt000000
                     2014-04-21 12:42:14.030503  RBA 6912167

INTEGRATED Replicat
DBLOGIN Provided, inbound server name is OGG$REP in ATTACHED state

Current Log BSN value: <NULL>

  Extract Source                          Begin             End

  ./dirdat/rt000000                       2014-04-21 12:42  2014-04-21 12:42
  ./dirdat/rt000000                       2014-04-21 12:42  2014-04-21 12:42
  ./dirdat/rt000000                       * Initialized *   2014-04-21 12:42
  ./dirdat/rt000000                       * Initialized *   2014-04-21 12:42
  ./dirdat/rt000000                       * Initialized *   First Record
  ./dirdat/rt000000                       * Initialized *   First Record

Current directory    /oracle/app/product/12.1.2/oggcore_1

Report file          /oracle/app/product/12.1.2/oggcore_1/dirrpt/REP.rpt
Parameter file       /oracle/app/product/12.1.2/oggcore_1/dirprm/REP.prm
Checkpoint file      /oracle/app/product/12.1.2/oggcore_1/dirchk/REP.cpr
Checkpoint table     ggate.checkpoint
Process file         /oracle/app/product/12.1.2/oggcore_1/dirpcs/REP.pcr
Error log            /oracle/app/product/12.1.2/oggcore_1/ggserr.log

From looking at the details of the replicat, you can see that it is now integrated and using the DBLOGIN that we provided earlier.

Enjoy!

twitter: @dbasolved

blog: http://dbasolved.com


Filed under: Golden Gate
Categories: DBA Blogs

Move from classic capture to integrated capture

DBASolved - Mon, 2014-04-21 11:50

Most Oracle Golden Gate installations, venture to say 80-90%, use the “Classic” capture architecture.  What I want to show in this post is how to switch from “Classic” capture to “Integrated” capture.

In the Oracle Golden Gate 12c documentation, the steps provided work but there are a few things that we need to be aware of when trying to switch to integrated capture mode.  The steps that are outlined here show you how to get around these missing steps.

Let’s get started!

With any replication environment, we want to identify where we are at within the replication cycle, i.e. what is the current transaction.  In code 1, we see how we can do this:

Code 1:


GGSCI (oel.acme.com) 2> send extract ext, showtrans

Sending SHOWTRANS request to EXTRACT EXT ...
No transactions found

Oldest redo log file necessary to restart Extract is:

Redo Log Sequence Number 150, RBA 194781712.

Notice that we have no pending transactions and that the Redo Log Sequence Number is 150 with an RBA of 194781712.  Now that we know where we are at with transactions, we need to ensure the correct permissions are associated with our GGATE user.

The documentation says to use DBLOGIN USERIDALIAS alias to log into the mining database.  In this environment, we are not using a mining database.  What we need to do is just make sure that the GGATE user has the right permissions.  This can be accomplished by using SQL*Plus or SQL Developer to grant permissions.  Image 1 shows how to grant the needed privileges for GGATE with the capture process.

Note: omitting the “capture” option will ensure permissions for both capture and apply processes.

Image 1:
image

With all the permissions set and knowing where we are with transactions we can now being to migrate the “Classic” extract to an “Integrated” extract.  Before we can migrate the extract; always make a backup of the dir* directories in the $GG_HOME.

Code 2:


[oracle@oel oggcore_1]$ zip gg_directories.zip ./dir*/*

Once the backup of the dir* is made; we can proceed by logging into the database from GGSCI.

Code 3:


GGSCI (oel.acme.com) 3> dblogin userid ggate, password ggate
Successfully logged into database.

Next, we need to stop the extract that we want to migrate to “Integrated”

Code 4:


GGSCI (oel.acme.com) 5> stop extract ext

Sending STOP request to EXTRACT EXT ...
Request processed.

Now, register that extract with the database.

Code 5:


GGSCI (oel.acme.com) 7> register extract ext database
Extract EXT successfully registered with database at SCN 26468050.

Before the upgrade we need to verify that the extract is ready to be upgraded. This is accomplished with the INFO command.

Code 6:


GGSCI (oel.acme.com) 9> info extract ext upgrade
ERROR: Extract EXT is not ready to be upgraded because recovery SCN 26468017 has not reached SCN 26468050.

Notice that we got an ERROR message.  This is because the extract is stopped and that the extract was registered with the database with SCN 26468050.  The SCN is currently at 26468017 and needs to be incremented to 26468050.  How can we do this if the extract is down?  It is real simple!  Start the extract.

Code 7:


GGSCI (oel.acme.com) 15> start extract ext

Sending START request to MANAGER ...
EXTRACT EXT starting

Once the extract has been successfully started, we need to stop the extract again.

Code 8:


GGSCI (oel.acme.com) 18> stop extract ext

Sending STOP request to EXTRACT EXT ...
Request processed.

Now, lets check to see if the extract is ready to upgrade.

Code 9:


GGSCI (oel.acme.com) 19> info extract ext upgrade
Extract EXT is ready to be upgraded to integrated capture.

Great!  Now the extract is ready to be upgraded.  Let’s upgrade it to an “Integrated” extract.

Code 10:


GGSCI (oel.acme.com) 20> alter extract ext upgrade integrated tranlog
Extract EXT successfully upgraded to integrated capture.

Now that the extract has been upgraded, we need to try and start the extract.

Code 11:


GGSCI (oel.acme.com) 21> start extract ext

Sending START request to MANAGER ...
EXTRACT EXT starting

Once the extract has started, we can see that it has stared and all the specific information related to the extract using the INFO command.

Code 12:


GGSCI (oel.acme.com) 25> info extract ext, detail

EXTRACT    EXT       Last Started 2014-04-21 12:42   Status RUNNING
Checkpoint Lag       00:00:05 (updated 00:00:05 ago)
Process ID           25943
Log Read Checkpoint  Oracle Integrated Redo Logs
                     2014-04-21 12:44:04
                     SCN 0.26486661 (26486661)

  Target Extract Trails:

  Trail Name                                       Seqno        RBA     Max MB Trail Type

  ./dirdat/lt                                          2       1449         50 EXTTRAIL

Integrated Extract outbound server first scn: 0.26468050 (26468050)

  Extract Source                          Begin             End

  Not Available                           2014-04-21 12:37  2014-04-21 12:44
  /oracle/app/oradata/bc11g/redo06_1.log  * Initialized *   2014-04-21 12:41
  /oracle/app/oradata/bc11g/redo06_1.log  2014-04-21 12:37  2014-04-21 12:41
  /oracle/app/oradata/bc11g/redo06_1.log  2014-04-15 11:09  2014-04-21 12:38
  /oracle/app/oradata/bc11g/redo06_1.log  2014-04-15 11:09  2014-04-15 11:09
  Not Available                           * Initialized *   2014-04-15 11:09

Current directory    /oracle/app/product/12.1.2/oggcore_1

Report file          /oracle/app/product/12.1.2/oggcore_1/dirrpt/EXT.rpt
Parameter file       /oracle/app/product/12.1.2/oggcore_1/dirprm/EXT.prm
Checkpoint file      /oracle/app/product/12.1.2/oggcore_1/dirchk/EXT.cpe
Process file         /oracle/app/product/12.1.2/oggcore_1/dirpcs/EXT.pce
Error log            /oracle/app/product/12.1.2/oggcore_1/ggserr.log

With the extract running in “Integrated” mode, we want to see if there are any errors in the GGSERR.log.  With the upgrade, there appears to be no real errors in the GGSERR.log; however, we will see two warnings.

OGG-01423 : references a default archive location
OGG-02045 : referring to streams_pool_size initialization parameter

These warning are interesting and bare more investigating; however, for now the extract has been upgraded to an “Integrated” extract.

Enjoy!

twitter: @dbasolved

blog: http://dbasolved.com


Filed under: Golden Gate
Categories: DBA Blogs

Get ahead of the competition with your greatest asset...Your Data!

WebCenter Team - Mon, 2014-04-21 11:13

Knowing more about your business—and knowing it faster than others—is the best way to power innovation and gain an edge on your competition.

There's hidden value in the data we capture after its initial use, but are your processes and siloed systems making it difficult to find that information? Join us this Wednesday at 2PM (ET) for this FREE webinar to hear AIIM Custom Research Director Bob Larrivee. He'll explain how you can organize content using ECM techniques and technologies, to provide a baseline structure to content, enabling better analytics and improved capability of linking the content to transactional data at the time of capture.

This webinar will also cover how to:

• deliver a more complete view of relevant content;

• maximize the value of your information;

• bring business intelligence to a new dimension.

Webinar: Business Process Opportunities: Increasing the Value of Transactional and Textual Data 
Date: Wednesday - April 23, 2014
Time: 2 PM (ET)
Cost: FREE
Speakers:
• Bob Larrivee, AIIM Director of Custom Research
• Lance Shaw, Oracle Senior Principal Product Marketing Director

Register Here and come prepared with your own questions for live discussion.