SQLcl connections – Lazy mans SQL*Net completion

Uncategorized
| Apr 30, 2015
Turloch posted this today, which is like aliases for SQL*Net connection URL's which are used to connections like this:

connect <USERNAME>/<Password>@URL


This works great and you can simplify your connection strings that you use.  Vadim wired this into the code completion and we can now code complete via key, a connection string that you have used before or you can set up a new now using the net command.


R12.2 Single file system

With the release of AD and TXK Delta 6, Oracle has provided the feature of single file system on development instances for R12.2. Here's what they have mentioned in support.oracle.com article: Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.6 and R12.TXK.C.Delta.6 (Doc ID 1983782.1)
Enhancements in AD and TXK Delta 6

4. New and Changed Features

Oracle E-Business Suite (more...)

Painting the Mona Lisa with SQL

Seven years after the first Obfuscated SQL Code Contest, a new one has been organised on the PL/SQL Challenge website. I had fun writing my first entry back then, but in the back of my mind I regretted not doing something with ASCII art. So the new contest was a good pretext for me to finally fill in that gap. Here is my entry for the second Obfuscated SQL Contest: SQL> select listagg 2 (chr

The Database Protection Series Continues- Database Hardening and Best Practices

In this installment, we’ll focus on database and server hardening as well as database security best practices. Instead of offering you my personal recommendations, I’ll provide you with recommended websites that offer an abundance of information on database security best practices. You must be very careful when you select an author or website to assist you in your goal of securing your organization’s sensitive database data stores.  I think that after reviewing this article, you’ll (more...)

EBS R12.2 Delta 6 Feature Review : Enhancement of adop console messages

ADOP console messages was always something that administrators needed changes. Delta 6 new features talks that there has been more enhancements done and running SQLs are displayed. Yes & True , it does but comparing to Delta 5 there are not much improvements. If you are from a older Delta version 2 or 3 , then Delta 6 upgrade might be interesting.

Instead of displaying the complete update statements , I can see messages like (more...)

EBS R12.2 Delta 6 Feature Review : EBS Technology Consistency Checker (ETCC)

With EBS R12.2 Delta 6 will not display a warning message when using the ADOP utility. An additional check is made every time ADOP tool is invoked which checks for the  recommended patches that are missing in the instance. This feature is ETCC and you will see something like this on the ADOP logs.

    [PROCEDURE] [START 2015/04/27 14:27:57] Performing database sanity checks
    [WARNING]   ETCC: The following database fixes are not (more...)

I’m speaking at SrOUG and beIT

Next month I’m honored to speak at two great conferences – SrOUG and beIT.         See you there! Kovachev

Solving RMAN-06059: Errror identifying file

When using RMAN to backup archivelog files, an error “RMAN-06059: Errror identifying file ” is returned. Previously the backups have been running successfully prior to this.

The post Solving RMAN-06059: Errror identifying file appeared first on VitalSoftTech.

EBS R12.2 Delta 6 Feature Review : Single File System Instance

With one of the main feature in 12.2 dual file system, there was always a need about having a single file system in 12.2 like 12.1.x and get away with the ADOP patching cycle. With Delta 6 AD and TXK you can. It is important to understand the feature and know its limitations.

There are two advantages of this single file system feature in 12.2

Oracle things that piss me off (pt 1)


This annoys me.
The fact that Oracle thinks it is appropriate to sell me to 'Ask' whenever I update my Oracle JRE. 


On my home machines,I've ditched the Oracle route for JRE. Java runtime is a requirement for running Minecraft (now owned by Microsoft) and they've now incorporated keeping the JRE updated as part of their updates. No attempts to install some crappy piece of spyware on my machine. 

And it is at (more...)

Refresh Multiple Materialized Views in One Go: No Data Found

To refresh multiple Materialized Views you can use the DBMS_MVIEW package, with the procedure aptly named Refresh. One method is to provide a comma-separated list of Materialized View names, or you can use an DBMS_UTILITY.UNCL_ARRAY to achieve the same objective.
When using the latter method, I stumbled upon this oddity (which is not in the current documentation, or at least I couldn't find it).

The procedure that I initially wrote was the following:

create (more...)

SQL Brainteasers: Guess the Card Game

In celebration of my trip to Vegas last week, here’s clues to card games in SQL form:

-- Q 1
select surname || first_name
from   actors
where  films in (
  'Kung Fu Panda',
  'Nacho Libre',
  'King Kong'
);

-- Q 2
select description
from   dishonest_act;

-- Q 3
select (select name 
        from   elements 
        where atomic_number = 79) || 
       (em / 2)
from   hinged_barrier;

-- Q 4
select replace(name, chr(107), chr(116))
 (more...)

Error deploying Oracle Composite with wrong encoding wsdl

We had some issues with deploying a composite which retrieves his wsdl for the partnerlinks from Nexus.
The supplier of the services adds the archive with the wsdl artifacts in Nexus, we download the dependency and after that we compile/validate the composite against the downloaded set of artifacts.

For one particular partnerlink the composite just wouldn’t compile.

Error message :

Validating composite "c:ReposcompositesmydomainobjectMyServicecomposite.xml"
c:ReposcompositesmydomainobjectMyServicecomposite.xml:21: error: Load of wsdl "oramds:/apps/xsd/nextgen/gm/services/mydomainobject/2/myservice.wsdl" failed
c:ReposcompositesmydomainobjectMyServicecomposite.xml:44:  (more...)

Is MERGE a bug?

A few years back I pondered whether DISTINCT was a bug.

My premise was that if you are depending on DISTINCT to return a correct result set, something is seriously wrong with your table design. I was reminded of this again recently when I ran across Kent Graziano's post on Better Data Modeling: Are you making these 3 beginner mistakes in your data models?. Specifically:
Instead of that, you should be defining a natural, or (more...)

Flipkart and Focus – 1 – Losing It?

This is the first of a series of articles I wrote for DNA in April on why I believed Flipkart (India's largest online retailer and among the most highly valued startups in the world) was at losing focus, at the wrong time, when faced with its most serious competition to date.

"Why Flipkart seems to be losing focus", appeared in DNA on Sunday, April 12, 2015.

Part I
Among all start-ups that have (more...)

ODTUG Mobile Day : "Going Mobile? Where is Oracle Taking You?"

Yesterday ODTUG organised the ODTUG Mobile Day in Utrecht the Netherlands. The event was supported by two local user groups, OGh and OBUG, and sponsored by eProseed NL. This full-day event was dedicated to Oracle's next-generation mobile development, infrastructure, and security solutions: "Going Mobile? Where is Oracle Taking You?". All of this was presented by the world’s leading ACE Directors

APEX Summer School 2015 – Online Webinare

Im Rahmen der APEX Summer School 2015 ( Twitter Handle: #apexsummer2015 ) werden wir 9 kostenlose Webinare zum Thema APEX 5 mit den Experten aus dem deutschsprachigen Raum durchführen:



Vielen Dank an Carsten Czarski für die Einladung und Organisation! Nicht zuletzt auch vielen Dank für die klasse Homepage des Webinars, alles 100% APEX 5 out-of-the-box! Ein einfaches und dennoch wirkungsvolles Beispiel dafür, was standardmäßig mit APEX 5 möglich ist:

APEX 5 ist seit letzter Woche (more...)

Destroying The Moon

Just under three years ago, I joined Enkitec when they acquired Sumneva.  The next three years brought a whirlwind of change and excitement - new products, additional training, and expanding the APEX practice from an almost nonexistent state to one of the best in the world.

Like all good things, that run has come to an end.  Last Friday was my final day at Accenture, and I am once again back in the arena of (more...)

Real Push Button Refresh with Raspberry Pi

Push Button

In this post, we’re going to perform a push button refresh of an Oracle Database, Application Express (APEX) installation, and Tomcat webserver.

“But Oracle Alchemist,” you’re probably thinking, “we know about that. You’ve told us about how Delphix can provision and refresh data.” And yes, you’d be right. But I wasn’t done yet.

We’re going to perform a refresh of an Oracle Database, APEX installation, and Tomcat running in Amazon Web Services, replicated from (more...)

Upgrading to Application Express 5.0 in Your Oracle Database Release 12.1 Multitenant Container Database (CDB)

Woo hoo! Oracle Application Express 5.0 has been released. Read all about it here.

The purpose of this blog post is to provide information on how to upgrade your 12.1 Multitenant Container Databases (CDBs) to APEX 5.0, and specifically ones where you have Oracle Application Express installed in CDB$ROOT (the root), and you are making use of Oracle Application Express 4.2.x in the PDBs in this CDB. There has been (more...)