Skip navigation.

Feed aggregator

Oracle #GoldenGate Parameter File Templates

DBASolved - 5 hours 39 min ago

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 page under “Oracle GoldenGate Parameter Templates”.  These files are in a small zip file that can be downloaded, unzipped and used in creating a basic uni-directional configuration.

By using these templates, you should be able to do:

  1. Review useful examples for each Oracle GoldenGate process (Manager, Extract, Pump, Replicat)
  2. With minor changes, quickly get uni-directional replication going
  3. Gain a base understanding of what how simple Oracle GoldenGate parameter files work

Enjoy!

about.me: http://about.me/dbasolved

 


Filed under: Golden Gate
Categories: DBA Blogs

2016 Mazda6 Interior Review

EBIZ SIG BLOG - 5 hours 51 min ago
If there's an ethical to the absolutely redesigned 2016 Mazda6 Interior Review  story, it's that there may be extra to lifestyles than "zoom-zoom." The previous-generation Mazda 6 had a whole lot of it, yet Mazda had a satan of a time getting the shopping for public to notice. which is as a result of American drivers usually do not care a lot about how their domestic sedans behave on winding united states of america roads. What they want is space, security, reliability, energy and magnificence -- and while the outdated 6 looked nice sufficient, its tight dimensions and lackluster acceleration averted it from succeeding in an increasingly more competitive marketplace.

the new 6 demonstrates that Mazda wasn't going to make the identical mistake twice. want room to chill out? It bargains one of the vital accommodating cabins of any midsize sedan, with Texas-sized front seats and a backseat match for 6-footers. acquired baggage, or in all probability 4 units of golf golf equipment? The midsize Mazda now options an impressively massive 16.6 cubic toes of trunk space. need energy? Mazda's received you covered with the biggest and strongest V6 on this worth bracket, though its gasoline financial system is disappointing. need to make a way commentary? then you definately shouldn't be shopping for a family sedan within the first position. but as such cars go, we think the brand new 6 manages to be tautly horny, in particular from the front, despite its additional 6.1 inches of length and 2.three inches of width. in contrast to the previous model, the 2016 Mazda6 Interior Review  used to be engineered namely for the North American market -- and it shows.

It additionally method introduced weight, as the enlarged 6 is roughly a hundred and fifty pounds heavier than its predecessor. yet you can nonetheless discover the sporty reflexes that consumers have come to expect from this efficiency-oriented brand. physique roll is minimal through domestic-sedan requirements, and the steerage is light however responsive. The 6 by no means allows you to omit its really extensive dimension, but its smartly-sorted chassis and light-on-its-ft character at pace places it 2nd most effective to the Nissan Altima within the fun-to-force category.

Wait a minute, you might be announcing -- how might the "zoom-zoom" household sedan fail to be the sportiest automobile in its class? Three causes: The Altima's significantly lighter, its physique motions are higher managed and its steering is tighter and more communicative. however so what? because the previous 6 validated (and the Toyota Camry continues to reveal), prime-notch riding dynamics don't a very best-promoting household sedan make. What the brand new 6 offers is the coveted combination of american-fashion measurement and energy, along with above-average handling for individuals who care about that kind of thing. authentic fans won't in finding the 6 to their liking -- however hiya, that is what the Mazdaspeed three is for.

in short, the 2009 Mazda 6 is at or close to the top of its class in most respects. As universal, although, we suggest check-riding as many rival models as conceivable earlier than making your resolution, including the Chevrolet Malibu, Honda Accord, Hyundai Sonata, Nissan Altima, Subaru Legacy and Toyota Camry. each has its own strengths and weaknesses, but few can suit the 6's all-round competence and attraction.
battery for mazda 6 key fob
The 2009 Mazda 6 is a entrance-wheel-pressure midsize sedan. There are seven trim ranges: i SV, i activity, i journeying, i Grand visiting, s recreation, s journeying and s Grand visiting. fashions with the i prefix include the 4-cylinder engine, whereas fashions with the s prefix come with the V6.

the worth leader i SV comes usual with sixteen-inch metal wheels, a manually top-adjustable driver seat, full power accessories, a six-speaker CD stereo machine with guidance-wheel-installed audio controls, air-conditioning and a tilt/telescoping steerage column. The i recreation adds cruise keep an eye on, an auxiliary enter jack and keyless entry. The i traveling edition steps up the function content material with 17-inch alloy wheels, foglights, a commute pc, a power driver seat, keyless ignition/entry, electroluminescent gauges, black patterned accent pieces and a leather-based-wrapped steerage wheel and shift knob. The i Grand travelling model provides xenon headlights, heated leather seats with a reminiscence perform for the driving force seat, Bluetooth connectivity, twin-zone automatic climate regulate, auto-dimming mirrors and an auditory blind-spot monitoring device.

The s fashions feature the corresponding i models' usual gear together with just a few enhancements -- the s sport comes with 17-inch alloy wheels and dual exhaust retailers, and the s traveling and s Grand travelling add 18-inch alloy wheels.

A comfort package for visiting models tacks on most of the Grand visiting's standard luxuries, while the Moonroof and Bose bundle adds a sunroof and an upgraded audio system to journeying and Grand journeying fashions. A navigation system is to be had most effective on the Grand journeying. other choices include faraway start, an in-sprint six-CD changer and satellite tv for pc radio.
mazda 6 check engine light
The front-wheel-pressure 2009 Mazda 6 is powered through either a 2.5-liter 4-cylinder engine or a three.7-liter V6. The 4 generates 170 horsepower and 167 pound-feet of torque, while the V6 pumps out 272 hp and 269 lb-ft. A six-velocity manual transmission is standard on 4-cylinder fashions, with a five-velocity automated non-compulsory on all however the i SV. A six-velocity computerized is necessary on V6-powered models.

gasoline-economy estimates stand at 20 mpg metropolis/29 freeway and 23 mixed for 4-cylinder fashions with the manual transmission, while the five-speed auto improves the 4's numbers to 21 mpg metropolis/30 freeway and 24 blended. These are classification-competitive numbers. however, if you go for the V6, estimates drop to 17 mpg city/25 freeway and 20 mixed, which is ready as bad because it gets on this phase.
common problems with mazda 6
Antilock disc brakes, balance control, front-seat facet airbags and entire-length facet curtain airbags are all same old on the aftermarket mazda 6 parts.
difference between mazda 3 and mazda 6
The mazda 6 bluetooth issues control structure is in most cases intuitive, with all major knobs and buttons naturally labeled and simply manipulated. it's sexy, too, with crimson backlighting for the gauges and a swish middle stack sweeping ahead towards the windshield, despite the fact that the atypical black-and-silver patterned plastic trim in journeying models and above is not going to strike everyone's fancy. materials high quality is hit-or-pass over, as the wealthy-feeling soft-contact subject material on the passenger side of the dashboard contrasts with low-cost arduous stuff on the driving force aspect. The emergency brake additionally feels a bit chintzy for this value point. The generously proportioned seats are somewhat at ease, then again, with abundant leg- and headroom all around. On the downside, energy-adjustable lumbar beef up is unavailable, and the not obligatory manually adjustable driver-facet lumbar toughen operates by the use of a labor-intensive knob.

in the audio department, the 6's usual stereo is just enough, and while the optional Bose gadget sounds markedly better, it lacks the clarity and wealthy bass response of the best stereos on this category. there may be better information on the cargo-carrying entrance, the place the sixteen.6-cubic-foot trunk units a new same old for domestic sedans. furthermore, it can be more desirable with the aid of upscale strut helps that do not impinge on the cargo area, and the 60/40-cut up-folding rear seats add to the 6's impressive hauling capabilities.
mazda 6 extended warranty
A awesome quantity of highway noise filters into the 6's cabin at velocity. Pavement imperfections barely ruffle the 6's composure, although, even when it is equipped with the non-compulsory 18-inch wheels. the bottom 2.5-liter engine produces wheezy noises and tepid acceleration, though the slick-shifting six-speed handbook shifter livens things up a little. The 5-pace automated is much less engaging but offers remarkably refined shifts. the large 3.7-liter V6 feels and sounds muscular, but it's a clean operator, even at greater engine speeds. unluckily, the six-pace computerized is not tuned for enthusiastic using -- downshifts are delayed, even in guide mode. handling is spectacular for a big household sedan, however the 6 would not really feel as tossable in corners as the Altima, and its guidance is lighter and looser than the nimble Nissan's. there may be most likely sufficient zoom on this chassis to placate folks that like to pressure, whereas the average client will relish the 6's reasonably compliant journey.
Categories: APPS Blogs

Oracle Technology Network Tuesday in Review / Wednesday Preview - Oracle OpenWorld and JavaOne

OTN TechBlog - 6 hours 19 min ago


Another Day of Oracle OpenWorld and JavaOne comes to a close.  The OTN Wearable Meetup was great thanks to the Oracle Usable Apps team and the folks who came and showed us their wearable tech. 

Special Activity in the OTN lounge, Moscone South Upper Lobby for Wednesday October 1st -

Oracle Spatial and Graph users Meetup – 4 to 5pm
Meet the product managers, developers, and other users of Oracle's Spatial, Graph, and Multimedia Database technologies in these informal meetups. Share your questions, experiences, and ideas. Experts will listen to your product feedback and answer questions about
•    Spatial and MapViewer features for location-enabled business apps and GIS systems. Hosted by the IOUG Oracle Spatial Special Interest Group
•    RDF Graph for social network, semantic, and linked data applications
•    Multimedia for image archives, medical image applications, and other media-related applications

Out of the OTN Lounge -

Annual Blogger Meetup - 5:30pm to 7pm - Jillian @ Metreon

Oracle OpenWorld 2014 – Datatype context…?!

Marco Gralike - 10 hours 40 min ago
The native JSON database functionality presentations are done. If you want to experience first hand what you can do with those new operators during Oracle...

Read More

Good UX - Don't Leave Home Without It

Floyd Teter - 14 hours 10 min ago
There was a time when I asserted that User Experience would be a differentiator for Oracle in selling Fusion Applications.  Lots has changed since then, so I think it’s time to change my own thinking.  What’s changed?


  • Oracle has a cloud platform
  • Fusion Applications is now Cloud Application Services
  • We’re seeing well-designed user experiences throughout Oracle’s offerings: Simplified UI in moving into the Applications Unlimited products, and is also evident throughout Oracle’s cloud services offerings.
  • Other enterprise application software companies now see the value of a well-designed user experience.  Look at the transition at Infor.  Check ADP’s announcement from earlier today.  Even the brand-W company that cannot be named recently released software that is a straight clone of Oracle’s Simplified UI.

OpenWorld has only reinforced my opinion.  Everyone here - Oracle product teams, Oracle partners, 3rd-party product providers - everyone is talking about and offering an enhanced UX.

So, I don’t consider good user experience design as a differentiator anymore.  I now see it as a necessity.  Enterprise software applications vendors must offer well-design UI to even have a seat at the table.

But what about custom-developed applications?  Good user experience still required.  You can’t expect user adoption without it.  In fact, I see the tools that facilitate good user experience design to be value-added products in and of themselves.


Good UX.  Don’t leave home without it.

Coding in PL/SQL in C style, UKOUG, OUG Ireland and more

Pete Finnigan - 14 hours 16 min ago

My favourite language is hard to pin point; is it C or is it PL/SQL? My first language was C and I love the elegance and expression of C. Our product PFCLScan has its main functionallity written in C. The....[Read More]

Posted by Pete On 23/07/14 At 08:44 PM

Categories: Security Blogs

Integrating PFCLScan and Creating SQL Reports

Pete Finnigan - 14 hours 16 min ago

We were asked by a customer whether PFCLScan can generate SQL reports instead of the normal HTML, PDF, MS Word reports so that they could potentially scan all of the databases in their estate and then insert either high level....[Read More]

Posted by Pete On 25/06/14 At 09:41 AM

Categories: Security Blogs

Automatically Add License Protection and Obfuscation to PL/SQL

Pete Finnigan - 14 hours 16 min ago

Yesterday we released the new version 2.0 of our product PFCLObfuscate . This is a tool that allows you to automatically protect the intellectual property in your PL/SQL code (your design secrets) using obfuscation and now in version 2.0 we....[Read More]

Posted by Pete On 17/04/14 At 03:56 PM

Categories: Security Blogs

Twitter Oracle Security Open Chat Thursday 6th March

Pete Finnigan - 14 hours 16 min ago

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 - 14 hours 16 min ago

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 - 14 hours 16 min ago

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 - 14 hours 16 min ago

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 - 14 hours 16 min ago

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

Day 2 at Oracle Open World - Best pratices

Yann Neuhaus - Tue, 2014-09-30 15:03

Today, in this post I will describe some best practices I learned in several sessions. It's always good to see what is adviced by other people that are confronting to other or same challenges.

Managing Oracle WebLogic Server with Oracle Enterprise Manager 12c

One session was related to the best pratices for managing WebLogic with Cloud Crontrol 12c.

- Use the administration functions:
Now you can, with Cloud Control 12c, do the WebLogic administration using its console. Starting and stopping the managed servers and applications were already possible but now you can do more like configuring the resources, deploying applications and so on.
As you are using the Cloud Control console you can sign in to several targets WLS servers. This means you have to enter each time the required password. By providing the credentials and saving them as the preferred ones (in Preferred Credentials) you avoid to enter the password each time.

- Automate Tasks accross domains with predefined jobs.
Predefined jobs can be used to start automatically WLST scripts and this against one or more domains. Like with the WLS console you can register your actions into a .py script, update it for your new targets, create the job and set the schedule. This can obviously be a script for configuration but also for monitoring or creating statistics.  

- Automatic response to issue via corrective action
By including corrective actions in templates you can apply them to managed servers. If the corrective action fails, by using rules you can send email in a second step to inform that there is an issue which need to be solved.

- use EMCLI to manage the credentials

- use APEX to query the Management Repository for reporting

Troubleshooting Performance Issues

An other session where best practices were explained was the "Oracle WebLogic Server: Best Practices for Troubleshooting Performance Issues". A very helpfull session, all chairs in the room were occupied and some people had to stand, meaning the session was expected.

Some general tips:  

  •  -verbose:gc to find out if the performance issues are related to the garbage collection behaviour  
  •  -Dweblogic.log.RedirectStdoutToServerLogEnabled=true  
  •  use the Java Flight Recorder (JFR)  
  •  use Remote Diagnostic Agent (RDA)  
  •  use WLDF to create an image of your system  
  •  Thread/heap dumps to see how your application is working

One of the first action you have to do is to read the log files as they can show you which kind of errors are logged; stuck threads, too many open files aso.

The same application can behave differently whether it is deployed on WebLogic running on Linux or on Windows. For instance a socket can remain in TIME_WAIT 4 minutes in Linux but only 1 minute under Windows.

In case you encounter OutOfMemory errors, log the garbage collector information

-verbose:gc -XX+PrintGCDetails -XX:PrintGCDateStamps -XX:-PrintGCTimeStamps

More information can be found in the document referred by ID 877172.1

Thread Dump
To analyze your application you can create a thread dump

  •  under Unix/Linux: kill -3
  •  jstack
  •  WLST threadDump()
  •  jcmd print_thread (for Java HotSpot)
  •  jcmd Thread.print (for Java 7)

More information can be found in the document referred by ID 1098691.1

Once the thread dump has been created you have to analyze it.
For that, several tools are available

  •  Samurai
  •  Thread Dump Analyzer (TDA)
  •  ThreadLogic

Some best practices I already know; one tool I want to test now is ThreadLogic to be trained in case I have to use it in a real case.

Let's see what will happen in the next days.

Plea For Tight Messages - OOW14

Floyd Teter - Tue, 2014-09-30 14:02
It’s so easy to lose track of time at Oracle OpenWorld.  I think I’m writing this on Tuesday, but can’t say for sure…

Lots of information being shared here:  incremental development of Simplified UI, a myriad of new cloud services announced (including a very cool Integration Cloud Service), new features for MySQL, new mobile applications for the E-Business Suite, Eloqua services for Higher Education, a visualization-oriented UI for OBIEE (and saw a very cool new visualization UI from the UX team, but I can’t talk about that yet), some interesting uses of Beacons…it’s like drinking from a firehose and darn near drowning in the attempt.  Info overload.

One of the cool things one gets to see at OOW: the rise of new third-party applications that improve and enhance Oracle products..  On Monday, I had the opportunity to sit down with the brain trust behind Xprtly!  What impressed me the most is the focus of their message - they’ve got it down to four slides (including a title).  Take a look and see if you get it.







So why do I bring this up?  Go back and read the second paragraph.  We’re all on information overload here.  The virtual noise level is incredible.  Tight, focused messages cut through the noise and get the point across.  Wish we saw more of this approach here…

Microsoft Hadoop: Taming the Big Challenge of Big Data – Part One

Pythian Group - Tue, 2014-09-30 11:12

Today’s blog post is the first in a three-part series with excerpts from our latest white paper, Microsoft Hadoop: Taming the Big Challenge of Big Data.

As companies increasingly rely on big data to steer decisions, they also find themselves looking for ways to simplify its storage, management, and analysis. The need to quickly access large amounts of data and use them competitively poses a technological challenge to organizations of all sizes.

Every minute, about two terabytes of data are being generated globally. That’s twice the amount from three years ago and half the amount predicted for three years from now.

Volume aside, the sources of data and the shape they take vary broadly. From government records, business transactions and social media, to scientific research and weather tracking, today’s data come in text, graphics, audio, video, and maps.

Download our full white paper which explores the impact of big data on today’s organizations and its challenges.

Categories: DBA Blogs

Packt Publishing - ALL eBooks and Videos are just $10 each or less until the 2nd of October

Surachart Opun - Tue, 2014-09-30 10:36
Just spread good campaign from Packt Publishing - It's a good news for people who love to learn something new - ALL eBooks and Videos are just $10 or less -- the more you choose to learn, the more you save:
  • Any 1 or 2 eBooks/Videos -- $10 each
  • Any 3-5 eBooks/Videos -- $8 each
  • Any 6 or more eBooks/Videos -- $6 each


Written By: Surachart Opun http://surachartopun.com
Categories: DBA Blogs

OCP 12C – Managing CDBs and PDBs

DBA Scripts and Articles - Tue, 2014-09-30 10:13

Connecting to a CDB or PDB Connecting to a CDB or PDB is not different of connecting to a standard database. When you create a PDB, it is automatically assigned a service which can be used to reach this specific PDB. You can either use the EZ connect syntax, the Oracle Net Service syntax or the [...]

The post OCP 12C – Managing CDBs and PDBs appeared first on Oracle DBA Scripts and Articles (Montreal).

Categories: DBA Blogs

Exadata: What’s Coming

Jason Arneil - Tue, 2014-09-30 10:09

This is based on the presentation Juan Loaiza gave regarding What’s new with Exadata. While a large part of the presentation focussed on what was already available, there are quite a few interesting new features that are coming down the road.

First of was a brief mention of the hardware. I’m less excited about this. The X4 has plenty of the hardware that you could want: CPU, memory and flash. You’d expect some or all of them to be bumped in the next generation.

New Hardware

This was skated over fairly quickly, but I expect an Exadata X5 in a few months. The X4 was released back in December 2013, first X4 I saw was January 2014. I wouldn’t be surprised if Oracle release the X5 on or around the anniversary of that release.

Very little was said about the new hardware that would be in the X5 except that the development cycle has followed what intel has released, and that cpu cores have gone up and flash capacity has gone up. No word was said on what CPU is going to be used on the X5.

The compute nodes on an X4-2 have Intel E5-2697 v2 chips this is a 12 core chip running at 2.7GHz. I’d expect an increase in core count. The X3 to X4 transition increased core count by 50%. If that happens again, we get to 18 cores. There is an Intel E5-2699 v3 with 18 cores but that’s clocked at 2.3GHz.

However, I think I’d be less surprised if they went with E5-2697 v3 which is 14 core chip clocked at 2.6GHz. That would be a far more modest increase in the number of cores. The memory speed available with this chip does go up though – it’s DDR4. Might help with In Memory option. I also wonder if they’ll bump the amount of memory supported – this chip (like the predecessor) can go to 768GB.

As I said, it was not mentioned which chip was going to be used, only that Intel had released new chips and that Oracle would be qualifying their use for Exadata over the coming months.

New Exadata Software

There was a bunch of interesting sounding new features coming down the road. Some of the ones that in particular caught my eye were:

The marketing friendly term “Exafusion”. Exafusion seems to be about speeding up OLTP, labelled as “Hardware Optimized OLTP Messaging” it’s a reimplementation of cache fusion. Messages bypass network stack leading to a performance improvement.

Columnar Flash Cache – This is Exadata automatically reformatting HCC data when written to flash as a pure column store for analytic workloads. Dual formats are stored.

Database snapshots on Exadata. This seems designed with pluggable databases in mind for producing fast clones for dev/test environments. Clearly something that was a gap with ASM as used on exadata, but ACFS does snapshots.

Currently the latest Linux release available on Exadata is 5.10. Upgrading across major releases is not supported – would have required reimaging. Not a pretty prospect. Thankfully Oracle are going to allow and enable upgrading in place to 6.5.

Some talk about reducing I/O outliers both in reading from hdd and in writing to flash.

Currently with IORM you can only enable or disable access to flash for a particular database. Full IORM seems to be coming for flash.

Final new feature that caught my eye was the long rumoured Virtualisation coming to Exadata. OVM is coming. The ODA for example has had VM capability for some time, so it’s in some ways an obvious extension. I’m expecting with the increasing number of cores lots of smaller organisations may not actually need all those cores and might think even if they could turn unused ones off, it’s a waste buying that hardware and not being able to use it.

I’m hoping to NOT see OVM on an Exadata in the wild anytime soon.

Software on Silicon

One final point almost tucked out of site, was that Juan had a little bullet point about “software on silicon”. Now this has me confused. My understanding is that when Larry was talking about this, it was specifically SPARC. That I can understand as Oracle controls what goes on the chip.

Ignoring the SPRAC Supercluster, there is no SPRAC on Exadata. So that leaves a closer collaboration with Intel or moving to SPARC. Collaborating closer with Intel is a possibility and Oracle had first dibs on the E7-8895 v2 for the X4-8.

I can’t imagine changing the compute nodes to SPARC that wouldn’t make sense. But “software on silicon” is a bit like offloading…

Exadata software is definitely keeping moving forward and the difference between running Oracle on Exadata compared with non-exadata is growing ever wider with each “exadata only” feature.


select a.b.c.d.e from t a

Laurent Schneider - Tue, 2014-09-30 07:37

I just learnt a new syntax. With 12.1.0.2, you can dive into your JSON document within sql, it looks a bit unusual to me


SQL> CREATE TABLE t
  (b CLOB CHECK (b IS JSON));
Table created.

SQL> insert into t(b) values 
  ('{"c":{"d":{"e":1}}}');
1 row created.

SQL> select a.b.c.d.e from t a;
C
----------------------
1

Largely inspired from Tom Kyte session