Start, Restart and stop OHS Components

In Fusion Middleware 12c the Oracle HTTP Server is now configured as SystemComponents within a Weblogic Domain. This can be embedded in a FMW Domain, like SOA, OSB, or WebCenter.  Or it can be in a stand alone domain.

When configured, there are scripts to start and stop the system components in the bin folder of the domain: startComponent.sh and stopComponent.sh.

These scripts first do a readDomain() to read the domain before actually (more...)

Using VS Code for PL/SQL development

I've been using Sublime Text as my main editor for PL/SQL development for many years, but I'm now in the process of switching to Visual Studio Code (VS Code).



Some good reasons to use VS Code:
  • Multi-platform (Windows, OS X, Linux)
  • Free, open source
  • Lightweight, fast
  • Large ecosystem of extensions
  • Built-in Git support
  • Can be adapted to PL/SQL coding via a plsql language extension (syntax highlighting, go to/peek definition, go to symbol) and PL/SQL compilation (more...)

Publishing Oracle SOA Maven plugin by Maarten Tijhof

image


When setting up a continuous integration solution for Oracle SOA Suite code, it is best to work with mavenized projects, and thus rely on Oracle-provided maven plugins to do the tough job of compiling and deploying artifacts.

This way of working has been introduced by Oracle in the 12c range of products. There are no Maven plugins available for 11g Oracle products.
This post describes how to set up the plugin in a Binary Repository (more...)

End of an era …

Four years ago I wrote about a little volunteer project that my partner did.  A small association that provided outdoor experiences and facilities for kids with physical impairments needed a system to record member and volunteer details, plus a few other bits and pieces.  We built an Apex solution running on XE.  This week, they became part of a larger government initiative, and thus their Apex application was no longer needed and (more...)

adrci purging

I did not know this.

Is there a way to control Auto_Purge Frequency done by the MMON ? (Doc ID 1446242.1)

The automatic purge cycle is designed as follows.
(1) The first actual purge action will be 2 days after instance startup time
(2) The next automatic purge actions following this first purge is done once every 7 days

If you like to purge more often, then it will need to be done manually.

The (more...)

ADRCI Retention Policy and Ad-Hoc Purge Script for all Bases

|GREP ORA

As you know, since 11g we have a Automatic Diagnostic Repository (ADR). To better manage it, we also have a Command-line Interface, called ADRCI.
ADR contains all diagnostic information for database (logs, traces, incidents, problems, etc).

adr1

ADR Structure

View original post 349 more words


Oracle HCM Cloud Extensibility – The Easiest Win

I've been doing quite a bit of work lately with Oracle HCM Cloud user experience extensibility...presenting, helping partners and customers, etc.  Seems like a hot subject of late, with lots of folks wanting to know more.  So let's get into it a bit.

Working in the Oracle HCM Cloud Center of Excellence, I see quite a few opportunities for wins that come up repeatedly.  You know what kind of win I mean: something that's easy (more...)

SQLcl – Setting Up the Formatter

Just because you’re in a command line interface doesn’t mean you’re stuck with ugly code! Wait, if it’s my code, you’re stuck with ugly code. But if it’s YOUR code, then you’re not stuck with poorly formatted code. You can of course use the FORMAT command to format what’s... [Read More]

The latest in Oracle Partitioning – Part 2: Multi Column List Partitioning

This is the second blog about new partitioning functionality in Oracle Database 12c Release 2, available on-premise for Linux x86-64, Solaris Sparc64, and Solaris x86-64 and for everybody else in the Oracle Cloud . This one will talk about multi column list partitioning, a new partitioning methodology in... [Read More]

Find out the true benefit of Dashboards or Business Intelligence Software

In fact, the question should be "What should be the true benefit of Dashboards or Business Intelligence software? "
Whether you are using dashboard in excel, Dashboards in Microsoft Access, Quickbooks, business objects, Salesforce or big ERP like Oracle EBS or SAP, there are numerous tangible benefits of using InfoCaptor as your primary BI and dashboard app compared to other business intelligence software or reporting tools.

Now, well-designed dashboards are more interesting than most "old-fashioned" tabular reports [lot of the old sytle reporting software vendors have begun calling (more...)

Refreshing VDB With Sales History Data

Now that I’ve loaded a ton of transactions and did a bunch of work load on my source database with the SH sample schema and Swingbench, I’ve noted how little impact to the databases using different cloud tools, (which will come in a few later posts) now I’m going to show you how easy it is to create a new VDB from all of this, WITH the (more...)

Oracle Database 12c Release 2: Analytic Views & SQL Developer

One of the major new features in Oracle Database 12c Release 2 is Analytic Views. An analytic view is a type of view that can be used to easily extend the content of a star schema with aggregated data, measure calculations and descriptive metadata, and to simplify the SQL needed to access data. Analytic views layer a... [Read More]

A Performance Analytics Application Case Study: Challenges and Successes

The Performance Analytics application is a collection of open source technologies that aids users in: identifying performance bottlenecks, identifying causes for slow report execution, discovering areas for performance optimization, and gathering meaningful insights into the health of an OBIEE environment.

This post focuses on lessons learned after a successful Performance Analytics application installation, where within one day of being operational it enabled us to identify and isolate a long-standing memory issue. Here's how.

OBIEE Performance Analytics Dashboards

Overview

Rittman (more...)

MONDAY SPOTLIGHT: Updated whitepaper for Oracle Linux Management with Oracle Enterprise Manager 13c

Happy Monday to all Linux fans. Today we would like to highlight an updated whitepaper available here.  This whitepaper describes the comprehensive Oracle Linux management capabilities available in Oracle Enterprise Manager and has been updated for the latest version of Oracle Enterprise Manager 13c.

Oracle Enterprise Manager 13c enables customers to have complete visibility into their Oracle Linux environment. If the IT environment consists of a large investment in Oracle hardware, Oracle (more...)

Simple iptables Rules for Ubuntu/ Debian VPS

The following iptables rules are are a starting point to add basic firewall security to a public facing server, such as a public VPS. The primary focus is to stop any inbound traffic other than SSH, which is required for shell access. The biggest issue with public VPS providers is that often some iptables features

Log Buffer #507: A Carnival of the Vanities for DBAs

This Log Buffer edition covers Oracle, SQL Server and MySQL blog posts with a touch of Cloud.

Oracle:

Provisioning EBS on Oracle Cloud: Latest Enhancements

ORA-54002 when trying to create Virtual Column using REGEXP_REPLACE on Oracle 12cR2

Business rules, common sense and query performance

Problem with V$RECOVERY_AREA_USAGE view and FRA space not being reclaimed

Updated SQLcl: 2 New Commands, Bug Fixes, and 12cR2 Oh My!

SQL Server:

Windowing Functions: Tell me (more...)

Oracle SOA Suite: Find that composite instance!

When executing BPM or BPEL processes, they are usually executed in the context of a specific entity. Sometimes you want to find instances involved with a specific entity. There are different ways to make this easy. You can for example use composite instance titles or sensors and set them to a unique identifier for your entity. If they have not been used, you can check the audit trail. However, manually checking the audit trail, especially (more...)

Generate Rows based on a Column Value

My requirement is the following:

In a database table the activity, start time and the number of repetitions is stored, but for the report this needs to be expanded. The number of repetitions dictates the number of rows per activity, each incremented by five minutes from the start time.
To get things going a simplified table is created, as well as some sample data.

create table activities
(activity varchar2(10)
,activity_date date
,no_of_reps number
);

insert (more...)

SOA vs Microservices Architecture by The SOA mythbusters


imageSo, are you interested in SOA & Service Orientation technologies?, that’s great because we also are, and work with those every single day since a long time ago. As integration professionals, we’ve seen the SOA stack grow, change, incorporating new products and technology with each passing year.

We’re  Arturo Viveros and Rolando Carrasco, the SOA Myth Busters from Mexico, and as we go with this series we will  put to the test a number (more...)

Red Samurai and Oracle PaaS JCS Success – JET/ADF BC REST Cloud Production Application

I would like to share our success in Oracle PaaS service - Java Cloud (JCS). We have managed to implement JET/ADF BC REST system in short period of time and deploy it in production running on Oracle JCS. UI is implemented entirely with JET, while back-end REST services are running on top of ADF BC. Secure access is controlled by unique ID managed by server side ADF Security.

Production application implements custom invoice processing logic (more...)