Community participation is not cheap!

I’m in a really privileged position where I’ve spent over a decade speaking at events all over the world. That has been made possible by being part of the Oracle ACE Program, and more recently the Oracle Developer Champion program, who have provided funding for some of the events I’ve participated in.

I guess it’s easy for someone on the outside looking in to think this is a really cushy number, but after my latest (more...)

How to test REST Service (POST) for EBS 12.1/12.2

Step 1: Deployed rest service in EBS

(Create package & body for inserting data into table & Create Business entity, then you create pls & upload it & Deployed)

Give grant to specific user, That particular responsibility should be assigned to user.

Note the “Responsibility Key”

Step 2: Install Chrome Rest Service Client

Step 3:  Now you have WADL file for you deployed service

Step 4:  Example POST Data

 

 

oracle.apps.fnd.isg.common.error.ISGException: Could not find the package.

When you’re trying to deploy rest service , you might be get the below issue

 

Error in the generating PLSQL package oracle.apps.fnd.isg.common.error.ISGException: Error in the generating PLSQL package at oracle.apps.fnd.isg.app.common.designer.db.DBServiceDesigner.generateArtifacts(DBServiceDesigner.java:494) at oracle.apps.fnd.isg.app.ebs.designer.db.DBRestDesigner.generateService(DBRestDesigner.java:52) at oracle.apps.fnd.isg.app.common.designer.AbstractServiceDesigner.designService(AbstractServiceDesigner.java:34) at oracle.apps.fnd.isg. (more...)

sqlplus: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file

When you’re doing clone on the Redhat 7, you may get the below error

 

“sqlplus: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file”

 

This is bug as per note Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)

 

you need to install “binutils” rpm package version as per noted in the documentation.

After installed also, you still get (more...)

Rest service configuration EBS 12.2

Follow the articles

Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2 (Doc ID 1311068.1)

  • Part B: Configuring Oracle E-Business Suite REST Services

If you can’t generate Ildt file after configured, you need to follow this document install PERL

https://docs.oracle.com/cd/E26401_01/doc.122/e20925/T511175T543269.htm#5464758

 

 

 

Column Stats

A little while ago I added a post-script to a note I’d written five years ago about gathering stats on a virtual column and had updated with a reference to a problem on the Oracle database forum that complained that stats collection had taken much longer after the addition of a function-based index. The problem related to the fact that the function-based index was supported by a virtual column that used an instr() function on (more...)

Optimizer Statistics Gathering – pending and history

How do you manage when you need to gather statistics on some tables in a critical environment? Some queries are too long because of stale statistics. But other queries on the same tables are ok. You cannot leave the inital problem without fixing it. Adding hints or SQL Profiles for the identified queries is not the right solution when you identified that stale statistics are the problem. But you want to reduce the risk of regression (more...)

All about ‘Autonomous Transaction Processing’ – Part I

There has been a lot of buzz about 'Self driving & Self tuning database', 'autonomous', 'automation', etc. since Oracle 18c announced. I have decided to do my homework and test/validate some of them. So, this blog post will focus about 'Autonomous Transaction Processing (ATP)', how this is helpful to an organization and what role a DBA can play.

Its nothing but another typical cloud offering from Oracle. To begin with, Oracle ATP is built upon (more...)

KeePass 2.40

I just noticed KeePass 2.40 was released a couple of days ago.

Downloads and Changelog available from the usual places.

You can read about how I use KeePass and KeePassXC on my Mac, Windows and Android devices here.

Cheers

Tim…


KeePass 2.40 was first posted on September 12, 2018 at 9:06 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading (more...)

Create Oracle Database 18c in 3 clicks!

After the Oracle Database 18c software install, the database creation is only 3 clicks using the Database Configuration Assistant! The Oracle defaults are OK!

Oracle18c Database on your Windows laptop in 6 clicks!

Oracle Database 18c (18.3) is available for download for windows platform since August 22, 2018. If you are new to Oracle or if you are a developer and need a database to play with, you can install an Oracle database quickly on your laptop with a few clicks.

Oracle Challenge #3 – Solution

This is the solution for Oracle Challenge #3. If you haven’t read the challenge, go and check it before you read the solution here. So, the challenge was to write different SQL statements to return the list of employees that earn the most in their department. As I said, there are 2 assumptions here, we … Continue reading Oracle Challenge #3 – Solution

Extending the root LVM Partition on Exadata

On an Oracle Exadata Database Machine, the ‘/’ (root) is defaulted to a size of 30Gb, which can easily fill up.  Luckily this is just a Logical Volume and there’s normally lots of space available on the Logical Volume Group which is usually untapped.

Extending ‘/’

Identify how much space is used and free on ‘/’ using df:

[root@v1ex1dbadm01 ~]# df -h /
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VGExaDb-LVDbSys1
                       30G   22G   (more...)

The full stack developer….is BACK for 2018!

Last year, I flexed my technology muscles Smile by building on the fine ground work of Lucas Jellema in using some Node, some REST, and some JSON to extract the full Oracle Openworld speaker catalogue, and then added some JSON parsing in the database, some SQL and slapped a nice helping on Application Express on top of it all, to end up with an Application Express rendition of the Oracle Openworld speaker catalogue.

So it (more...)

Where in the World is DBA Goth Girl- Sept 11-23

Tim and I just arrived back in Colorado yesterday and just arrived-  as in Grand Junction, Colorado on the western border of Utah.  Hauling a 42Ft. 5th wheel means that you make some considerations on how far you can go and how far you want to go.

It’s going to be a busy couple of weeks and this is what’s in the plans:

Microsoft Education Data Summit

I’ll be flying to Las Vegas tomorrow (more...)

POUG 2018

I just returned from a great Technical Oracle Conference hosted in Poland by my friends Kamil (@ora600pl) and Luiza (@LuizafromPoland)! They were kind enough to allow me to speak on the topics of SQL Translation Framework and Advanced Query Rewrite. It was my second year in a row to attend this conference and I must say I was extremely impressed by the content and the speakers and the venue and the professional handling of the (more...)

Which OS is “the best” for Oracle?

This question comes back to haunt me all the time, and did again last weekend, so for the sake of a few minutes here’s my opinion…

We can break down these types of questions into two main categories. People wanting to use unsupported operating systems, and people who what to know which is “the best” supported OS, so let’s deal with them separately.

Unsupported Operating Systems

Don’t do it! 🙂

I do installations on Fedora which (more...)

Oracle Database Backup Service Fails with: ORA-19511: – KBHS-00715: HTTP error occurred ‘oracle-error’ – ORA-29024

I discovered an Oracle Cloud Database Backup failing with:

Starting backup at 2018/09/08 20:00:04
current log archived
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 09/08/2018 20:00:07
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27023: skgfqsbi: media manager protocol error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   KBHS-00715: HTTP error occurred 'oracle-error'
KBHS-00712: ORA-29024  (more...)

Stats time

I wrote a note a couple of years ago explaining how I used to get a rough idea (with some errors) of how much time was spent in the overnight stats collection by each object. One of the nice little enhancements that appeared in 12c was the appearance of a couple of functions that can report information about this type of thing, and more. These are the dbms_stats function report_stats_operations() and report_single_stats_operation() with the following (more...)

Oracle OpenWorld 2018 : My Sessions

Oracle OpenWorld 2018 and Oracle Code One 2018 are just around the corner. The session catalogs have been around for a while, but they now include the date, time and location of the sessions.

This year I have three individual sessions, one group session and at least one shift in the Oracle Developer Community demo ground. If you are interested, here are my session details.

(more...)