Very simple oracle package for HTTPS and HTTP

I don’t like to import certificates, so i cannot use httpuritype for HTTPS pages and I decided to create package which will work with https as http.
It was pretty easy with java stored procedures :)

java source: xt_http.jsp
create or replace and compile java source named xt_http as
package org.orasql.xt_http;


Indianapolis, ECO, IOUG and Oracle Education Foundation, Ohm My!

I’ve been a bit busy traveling and speaking, but I wanted to discuss the great events I’ve been lucky enough to be part of the last couple weeks.

Indianapolis Oracle User Group

I spoke at the INOUG back on September 17th.  The user group in Indiana is incredibly welcoming and I had a great time with the wonderful attendees for my three back-to-back sessions.  We discussed AWR Warehouse, ASH and AWR Mining and a new (more...)

United States, China, and Pope Francis Pledge Action on Climate Change

By Elena Avesani, Principal Strategy Manager, Oracle

September 2015 marked two remarkable events in the fight against global warming. Pope Francis addressed a joint session of Congress on Sept. 24, the first time the head of the Roman Catholic Church has addressed the body, and called on Congress to protect our environment, laying out the argument presented in his June 2015 “Laudato Si” Encyclical Letter for a new partnership between science and religion to combat (more...)

SOACS plus ODCS – Chapter 12

In this series of posts and videos, we will explore creating and deploying a SOA composite using Oracle Developer Cloud Service.

< Previous Chapter | Next Chapter >

Chapter 12 - Populating Remote Maven Repository

If you followed a previous chapter, you should have your local Maven repository populated with the necessary SOA binaries. In order to build on the cloud, the project's remote Maven repository needs to be seeded with the same binaries. (more...)

La Customer Experience @Work

L’importanza di avere il cliente al centro dei processi e di dedicargli tutta l’attenzione possibile è un fattore ormai più che consolidato tra le aziende. Una visione customer-centrica risulta sempre più decisiva, sia in ambito business che consumer.

Oggi stiamo assistendo però a un nuovo fenomeno. Le organizzazioni di successo si stanno evolvendo verso la Customer Experience: il cliente è ancora al centro ma le aziende sono chiamate a definire, progettare, gestire e concretizzare (more...)

NPAPI Plugin Perspectives and the Oracle JRE

Java’s rapid rise to fame 20 years ago began with a tumbling duke applet running in the HotJava browser. Applets allowed richer development functionality at a time when browser capabilities were very limited, and provided centralized distribution of applications without requiring users to install or update applications locally.

HotJava’s support for applets was picked up by Netscape. In 1995 Netscape Navigator 2.0 and plugins became more popular to expand the kind of content that (more...)

User Defined Field Fact History

New to Analytics 15.2 release is the addition of historical facts and subject areas for user defined fields fact data such as project, wbs, activity, resource, and resource assignment for their cost
and number udf's.  For these UDF's to be available they will have had to been selected either from configStar or from the Analytics web configuration utility and have the UDF's and opted in.
Opting them in means that history will now (more...)

I Added a User in P6, How To Make Sure That User Gets into Analytics

A common question is what is the data flow for adding a user and getting that user into Primavera Analytics. For this example we are going to follow the P6 user flow.

1- Log into P6 application and add new user.  Give this user module access for P6 Analytics.  Assign Project Access and Responsible ManagerOBS to this user.
2- Run the Global Services Security Service.
3- Run StarETL process.
4- Make sure user (more...)

PDB Logging Clause… Again…

About 14 months ago I spotted a problem with the PDB Logging Clause. I opened an SR and several months later I got a patch, which unfortunately didn’t fix the issue, just altered the symptom somewhat. I wrote about that patch here.

Yesterday I got a new patch, which actually does fix the problem, so now the PDB Logging Clause works as documented!

I’ve updated the PDB Logging Clause article to reflect the change.

I realise (more...)

Database system target in pending status for standby database in OEM 12c

That’s not really a problem but annoying issue I had with OEM 12c. Once a standby database is promoted, the database system for the same is showing as metric collections error OR Status Pending.

The standby database doesn’t need its own system since it will join the primary database system. The solution is to associate the standby database with the primary system and then remove the standby database system.

For example – we’ve got primary (more...)

Cloud Control : Some minor issues (fixed)

em-12cSince the upgrade to Cloud Control, we’ve been having a couple of issues, mostly around EMCLI.

Some of our databases use Service Guard, so you don’t know which node they are running on. Rather than having an agent per package, we have one on each node. One of my colleagues wrote a little script to check which node the instance is running on, and relocate it if it has moved. This (more...)

VirtualBox, Oracle 12c and Macs

Just a quick comment about something I noticed while rebuilding a test VM on my Mac. There is a long lead up to this, so bear with me…


I use VirtualBox on three different host operating systems.

Mac : My main desktop is a Mac, so most of my tests are done using Oracle 12c on Oracle Linux 6 or 7, running under VirtualBox. Most of the VMs I use are quite old, but I (more...)

Using dynamic variables for shell scripting

So you may ask, why go through all the trouble?

Have you ever had to move scripts from one directories to another to find out the script is now broken?

This is due to the hard coding of the location for SQL script in the shell script.

When possible, I would like to separate shell / SQL scripts so they can be run individually and easier for debugging.

Don’t you hate it when copy/paste SQL (more...)

VirtualBox 5.0.6

VirtualBox 5.0.6 has been released.

It’s a maintenance release. You can find the downloads and changelog in the usual places.

Happy upgrading!



VirtualBox 5.0.6 was first posted on October 3, 2015 at 2:31 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Using sed to format controlfile trace

Do you find it cumbersome having to format controlfile trace?

For the most part, it’s a manual and tedious process.

Using sed, it may be possible to automate task.

RESUSE overwrites existing controlfile trace.

alter database backup controlfile to trace as ‘/tmp/cf.sql’ REUSE RESETLOGS;

ARROW:(SYS@hawklas):PRIMARY> alter database backup controlfile to trace as '/tmp/cf.sql' RESETLOGS;
alter database backup controlfile to trace as '/tmp/cf.sql' RESETLOGS
ERROR at line 1:
ORA-01277: file '/tmp/cf.sql'  (more...)

Online Partition Move fails with ORA-00932 –

Oracle 12c introduced feature to move table partitions and sub-partitions as online operations.So, this blog is related to this feature and the issue I faced.

The database was upgraded from to and this issue is seen in upgraded databases only.

Lets start!!!

SQL> create table sales_part
    (product char(25),channel_id number,cust_id number,
    amount_sold number, time_id date)
    partition by range (time_id)
    partition sale_jan values less than (to_date('01-02-2015','dd-mm-yyyy')),
    partition  (more...)

Pythian at Oracle Open World 2015


Are you excited for this year’s Oracle Open World 2015? Pythian will once again be attending and participating in a number of marquee presentations and events.

This event is an amazing opportunity to hear from the finest minds in the Oracle space from Pythian and across the indusrty. We will be sending our Oracle experts to deliver some compelling presentations, packed with best practices, expert tips and advice that you won’t want to miss (See (more...)

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

This Log Buffer Edition finds and publishes blog posts from Oracle, SQL Server and MySQL.


  • SCRIPT execution errors when creating a DBaaS instance with local and cloud backups.
  • Designing Surrogate vs Natural Keys with Oracle SQL Developer.
  • EBS General Ledger – Accounting Hub Reporting Cloud Service.
  • Oracle Database Standard Edition 2 is available.
  • Disable “Build After Save at JDeveloper” 12c.

SQL Server:

  • Learn where to get the latest installation and learning resources for the (more...)

The Data Warrior Goes to Oracle Open World 2015 (#OOW15)

Yes boy and girls, it is that time of year again. Time for the BIG show in San Francisco – OOW15 I will as usual, attend, but only for a few days this year (been away from home too much). My Talk I will be presenting my session Worst Practices in Data Warehouse Design (UGF9985) […]


Often, the biggest problem with regular expressions is that those who use them sometimes don’t use them correctly. A great example occurs in the Oracle Database with the REGEXP_LIKE function. For example, some developer use the following to validate whether a string is a number but it only validates whether the first character is a number.

  lv_input  VARCHAR2(100 (more...)