Tailing the Alert Log with SQLcl

Hopefully you’ve heard about the new SQL*Plus we’re building.

And hopefully you’ve heard about the new REPEAT command we put into it yesterday.

Here’s a quick example of how to build a little ‘monitor’ in just 2 commands, a total of 5 lines of code.

The SQL

SELECT To_Char(Originating_Timestamp, 'DD-MON-YYYY HH24:MI:SSxFF') Time_Entry,
       substr(message_text, 0, 75) || '...'  (more...)

There’s a New Tool in Oracle Payroll…it’s the Payroll Dashboard!

A new tool has been delivered in Oracle Payroll, to help you get ready for and progress through your payroll processing. It's the Payroll Dashboard! 

Have you tried the Payroll Dashboard yet?  Have questions on the setup or functionality?  Read on!

Delivered last year in Release 12.1 HCM RUP7 and Release 12.2.4, the Payroll Dashboard provides payroll and assignment information at-a-glance, to assist Payroll Professionals with payroll readiness, analysis (more...)

Tips on Submitting an Abstract to Conference

<.. The tech15 committee and my role
<…. Who plans the Tech15 content

The call for Papers for UKOUG Tech15 has gone out. This is how most of the content for a large conference is sourced, by asking the community to submit abstracts for consideration. With smaller conferences and user group meetings the organisers can often get enough talks by hassling asking people they know.

mail_image_preview_big

Firstly, I would encourage anyone who has considered talking at (more...)

How To Use The Docker 1.6 Windows Client

Newest Docker 1.6 release was pushed yesterday. Normally, no reason to go crazy, but this time I think, it's worth a blog. Because, it finally contains the first Docker Client for Windows. If you hated having to ssh into your instance and having to do everything via boot2docker: This is over now.
You can download official distribution of Docker Client for Windows by either installing it from the Chocolatey package manager (which I never (more...)

APEX 5: forgot the images?

On my play environment I usually use Oracle APEX with the Embedded PL/SQL Gateway, just because it's so easy.
When a new version of APEX is released, just like everybody else, I upgrade my play environment.
After the apexins.sql script is run, I always want to start playing with it immediately. Usually it is at this point where I just see a blank page... scratching my head wondering why it is not running,... having (more...)

New Oracle Audit Vault and Database Firewall “Training On Demand” Available


Written by James Spiller, Senior Principal Curriculum Developer

Time is at a premium and learning what you need to know has to fit into your busy schedule. Training On Demand courses can help you meet your requirements. You can watch recorded classroom and hands-on sessions in whatever increments fit your schedule.

Oracle Audit Value and Database Firewall (AVDF)

Monitor database activity. Block threats. Audit efficiently across the enterprise.

So I ask you:

Longer Young Collections with JDK7 as Compared to JDK6

If you have moved from JDK 6 to 7 and are observing some increase in the times that young collections take to do their job, then here's a remedy: -XX:+JavaObjectsInPerm.

In JDK7, class statics and interned strings were moved from PermGen to the Java Heap and that may contribute towards little increase in the young generation collection times. There is a option JavaObjectsInPerm which when enabled reverts that change i.e. class statics and interned (more...)

B2B 12c – Listening Channel activation and deactivation in bulk Bruno Neves Alves

clip_image002With the version 12c of B2B the possibility to activate and deactivate all listening channels in one single command was introduced. Previously, it was necessary to provide the name of the listening channels to perform the action, what, in scenarios with a considerable number of listening channels, made the task ineffective.

Different scenarios can be pointed out where this functionality is extremely useful:

· After importing a B2B configuration the channels are always in deactivated (more...)

MAF 2.1 – Debugger Improvements and Mobile REST Client by Andrejus Baranovskis

clip_image002I was blogging previously about Oracle Mobile Suite and REST service transformation from ADF BC SOAP service. Today I'm going to blog the next step in the same series - MAF client consuming REST service exposed from Oracle Mobile Suite ESB. I'm going to highlight improvements in debugging process for MAF, provided with the latest 2.1 release. I had couple of challenges implementing and mapping programmatic MAF client for REST service, all these were (more...)

Critical Patch Update for April 2015 released

The Critical Patch Update for April 2015 was released on April 14th, 2015.
Oracle strongly recommends applying the patches as soon as possible.

The Critical Patch Update Advisory is the starting point for relevant information. It includes the list of products affected, pointers to obtain the patches, a summary of the security vulnerabilities for each product suite, and links to other important documents. Supported products that are not listed in the "Affected Products and Components" (more...)

Goldengate Data Manipulation – When Inserts & Updates differ

One very useful aspect of Golden Gate is to allow the manipulation of data between the source and the destinations.

One recent problem that I encountered was to alter the data differently for inserts than for updates. This was caused by the receiving system needing to have some default data in columns which may or may not be supplied by the insert or update statements. This is slightly more complex than first imagined:

Solutions Catalog: Market Your Offerings To Over 30k Oracle Customers/Month

As an OPN member, you’re given a free profile on the OPN Solutions Catalog – a partner finder used by customers and Oracle sales reps. Take full advantage of this valuable marketing tool. Learn more!

Q4 FY15 Oracle Partner Store Enhancements

On April 20, the Oracle Partner Store (OPS) will will go live with enhancements benefiting its ordering and deal registration sections. Additional improvements to the user interface will also be released. For details on each enhancement please review the announcement.

Table Functions (Steven Feuerstein)

Wenn ich an PL/SQL denke, ist meine erste Assoziation dazu der Name Steven Feuerstein. Nun denke ich nicht furchtbar oft on PL/SQL, aber wenn der Herr Feuerstein über ein Thema schreibt, dem ich mit einer gewissen Regelmäßigkeit begegne, dann ist das allemal eine Verlinkung und Zusammenfassung der zugehörigen Artikel wert:

Thanks to all participants! Looking forward to next year event

Our Community Forum in Budapest has come to an end. Great real-time demo from FORS showing the database cloud they have now in place where partners can carry out proofs of concept and ISVs can test their applications with all the new DB12c Options (In-memory, Multitenant,...). We are all now ready to go to market with the sales plays presented by Olivier Tordo, equipped with the competitive information provided by Nick Drew and the (more...)

Lots of interaction in the second day of the Community Forum

Great second day of the Partner Community Forum. Packed agenda and a lot of interactions and one-to-one meetings. 

Erik Cramer got the award as a Top Contributor to the community in this second day. 

cramer_award

First day of Partner Community Forum in Budapest

On Tuesday we kicked off the Partner Community Forum in Budapest. Great presentations by Julian Dontcheff from Accenture, Erik Cramer from Atos, and Mike Revitt from CSC.

Johan Doruiter, SVP for Oracle Systems, EMEA pitched the partner community with a clear message: Now is the time to engage together and transform the customer business the partner business!

The first of the three awards to the Top Contributors to the Partner Community was awarded to Julien (more...)

Thanks to all participants! Looking forward to next year event

Our Community Forum in Budapest has come to an end. Great real-time demo from FORS showing the database cloud they have now in place where partners can carry out proofs of concept and ISVs can test their applications with all the new DB12c Options (In-memory, Multitenant,...). We are all now ready to go to market with the sales plays presented by Olivier Tordo, equipped with the competitive information provided by Nick Drew and the (more...)

Cloud Control 12c: Datenbank-Passwörter mit EMCLI regelmäßig ändern

Zum sicheren Betrieb einer Datenbank gehört das regelmäßige Ändern von Administrations-Passwörtern. Im Falle einer Oracle Datenbank betrifft dieses nicht nur die Datenbankbenutzer SYS und SYSTEM, sondern alle DBA-Benutzer und auch DBSNMP, der ja vom EM-Agenten für das Monitoring benutzt wird. Mit dem Enterprise Manager Commandline Interface (EMCLI) können Sie dieses einfach umsetzen. Lesen Sie in diesem Tipp, wie das funktioniert.

Séminaire Web : Oracle Developer Cloud Service

Vous souhaitez découvrir l'offre Oracle Developer Cloud Service ?
Alors