Oracle Infogram 2014-09-08 12:12:00

Contribution by Angela Golla, Infogram Deputy Editor

My Oracle Support Patch Conflict Checker Tool
A new My Oracle Support Conflict Checker tool is available from the My Oracle Support Patches & Updates Patch Search results page.

This tool enables you to upload an OPatch inventory and check the patches that you want to apply to your environment for conflicts. If no conflicts are found, you can download the patches. If conflicts are found, the tool (more...)

Yolo: Get Your Wearable Tech On for the #OOW14 and #JavaOne Meetup

Just ordered a Tikker and a Moto 360 . I’ve now run out of wrist space for  smartwatches and fitness bands of all sorts, so maybe it’s time I retired something! Then again…

image

Motorola Moto 360 image from WSJ.com

The Motorola Moto 360 was launched last week (4-Sept-2014) and has sold out online already. Luckily,  I’ll be able to pick one up in store in my local Best Buy. The initial reviews are so-so (more...)

An idealized log management and analysis system — from whom?

I’ve talked with many companies recently that believe they are:

  • Focused on building a great data management and analytic stack for log management …
  • … unlike all the other companies that might be saying the same thing :)
  • … and certainly unlike expensive, poorly-scalable Splunk …
  • … and also unlike less-focused vendors of analytic RDBMS (which are also expensive) and/or Hadoop distributions.

At best, I think such competitive claims are overwrought. Still, it’s a genuinely (more...)

On Disney Parks, Data Science, Drones and Wearables

As the parent of a toddler, I have no choice but to pay attention to Disney and its myriad of products and services.

Case in point, this Summer we took our daughter to Disneyland for the first time, which was a whole thing. Pause to h/t Disneyland expert, Friend of the ‘Lab and colleague Kathy for all her park and travel protips.

Being who I am, I found myself wandering around Disneyland and California Adventure thinking (more...)

Oracle Priority Service Infogram for 04-SEP-2014


OpenWorld

Each week leading up to OpenWorld we will be publishing various announcements, schedules, tips, etc. related to the event.


From Brendan Tierney - Oralytics Blog: me at Oracle Open World 2014.

RDBMS


SQLNet

The network part of the DBA’s job often gets short shrift. That’s not a good thing, since it can be what (more...)

Behold: The Simplified UI Rapid Development Kit

Editor’s note: The recent release of the Oracle Applications Cloud Simplified User Interface Rapid Development Kit represents the culmination of a lot of hard work from a lot of people. The kit was built, in large part, by Friend of the ‘Lab, Rafa Belloni (@rafabelloni), and although I tried to get him to write up some firsthand commentary on the ADF-fu he did to build the kit, he politely declined. 

We’re developers (more...)

Sometimes the cause of a TNS error is ….

A couple of months ago one of my customers had a failed data ware house report. There was a ORA-12592 (TNS) error message generated.
I turned out not to be the only TNS error. During a couple of weeks similar TNS-errors were generated. Not only the ORA-12592 error but also ORA-12514 and ORA-12571 errors.

We did some extensive sqlnet tracing but we didn’t find the cause there.

Finally the cause turned out to be a (more...)

How to make a time consistent export dump using the expdp datapump utility

In those old days when there was the exp utility we made a time consistent export dump by using the consistent=y parameter.
But today, in fact a couple of years already, we mostly use the expdp datapump utility. How should we make a time consistent export using datapump?
For that we use the flashback_time or flashback_scn parameter. In this post I show you how to set the flashback_time parameter.

The flashback_time parameter needs as input (more...)

Monitor Dell PERC when running on Oracle Virtual Server 3.x

In this article I will try to explain how to monitor your Dell Raid Controller with Cloud Control when running Oracle Virtual server 3.x (OVS3.x).

Some time ago a physical drive broke down on one of our Dell PowerEdge Servers. Not causing any problem because it was configured in a raid set using the Dell build in PowerEdge Raid Controller( hereafter PERC). However, we did not notice this breakdown until also a second (more...)

How to hide login data of sql-scripts on Windows

One of the often given advices on hardening a database is to run scripts without broadcasting your login data at the same time. According to Arup Nanda in his famous articles on “Project Lockdown” you have three options to run your scripts without letting everybody in on your password secrets:

  1. Start your scripts under /nolog and add your login to the SQL-script your running
  2. Start SQL*Plus under /nolog and add the login at the beginning (more...)

Oracle Infogram 2014-09-02 11:32:00

Contributions by Angela Golla, Infogram Deputy Editor

Oracle Support and Services at OpenWorld
Oracle Support and Services will have many sessions and activities during Oracle OpenWorld, September 28th - October 2nd.  Topics include Tips and Best Practices from the Front Lines, Best Practices for Proactively Supporting E-Business Suite, Near Zero Downtime Database migration and more.  Click HERE for the complete list.  

Complément : Enterprise Cloud Infrastructure


Context in UX – What it is, what it isn’t, and why it’s important

Our location is relentlessly tracked by our mobile devices. Our online transactions – both business and social – are recorded and stored in the cloud. And reams of biometric data will soon be collected by wearables.  Mining this contextual data offers a significant opportunity to enhance the state of human computer interaction. But this begs the question: what exactly is ‘context’ ?

Consider the following sentence:8594672237_09fb6c89b3_z

“As Michael was walking, he observed a bat lying on the ground. (more...)

OOW : Préparer son parcours

SQL> Select * From Alert_XML_Errors;

Once you are able to show the xml version of the alert log as data in database table Alert_XML, it would be nice to checkout the errors with accompanying timestamps from within view Alert_XML_Errors. Like this, with the help of 2 types and a pipelined function.

su - oracle
. oraenv [ orcl ]
[oracle@localhost ~]$ sqlplus harry/*****
....
SQL> desc alert_xml
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
TEXT                                               VARCHAR2(400 CHAR)

SQL> CREATE OR REPLACE  (more...)

Oracle Priority Service Infogram for 28-AUG-2014


OpenWorld

Each week leading up to OpenWorld we will be publishing various announcements, schedules, tips, etc. related to the event.


And a few presentations both at OpenWorld and other conclaves: Upcoming Big Data and Hadoop for Oracle BI, DW and DI Developers Presentations


RDBMS

From The ORACLE-BASE Blog: A few more 12c articles. From (more...)

SQL> Select * From Alert_XML;

By mapping an external table to some text file, you can view the file contents as if it were
data in a database table. External tables are available since Oracle 9i Database, and from Oracle
11gR2 Database on, it is even possible to do some inline preprocessing on the file.

The following example of this feature picks up on standard output of shell script “get_alert_xml.sh”.
It isn’t referencing any file, but take notice of (more...)

Sqlnet tracing during nightly hours…

A TNS error at night…

Sometime ago my data warehouse colleague came to me with a TNS error. At night times he runs his batch jobs in order to update his data warehouse. That night one of his jobs did not run properly and generated an ORA-12592 error. He had to restart this job during daytime.

It turned out it was not the only occurrence of this TNS error. A couple of days later he (more...)

Complément : Analyse des performances sur du long terme

Oracle Infogram 2014-08-25 11:53:00

Contribution by Angela Golla, Infogram Deputy Editor

Oracle E-Business Suite Upgrades and Platform Migration


Customers increasingly face the prospect of upgrading older versions of the Oracle E-Business Suite product while considering hardware/operating systems upgrades and possible migrations across platforms - advances in technology as well as the formalization of lifecycle and support timelines for their hardware and software investments are prompting an increased interest for guidance and how to approach these multiple upgrade scenarios.

Note:1377213. (more...)