Scripted Install of Oracle Java 8 on Ubuntu 16.04

Please see Install Oracle Java In Debian/ Ubuntu using apt-get for more information. [crayon-59844b9392d4e955734194/]  

Identity Columns Compared

It’s interesting to see the way different databases implement automatic numbering. Oracle Database 12c is the closest to PostgreSQL in some significant ways. However, its probably more accurate to say Oracle Database 12c copied PostgreSQL’s implementation. At least, that’s my conjecture because Oracle added a way to reset the START WITH value of the indirect sequence. However, I prefer the MySQL approach because the automatic numbering sequence is a property of the table and a (more...)

Löschung von Oracle Komponenten

Da ich mich selbst schon mehr als einmal darüber geärgert habe, wie schwer es ist, solide Aussagen über die Deinstallation von Oracle-Komponenten zu finden, finde ich die entsprechende aktuelle Artikelserie von Mike Dietrich extrem nützlich. Darin erläutert der Autor, was man in 11.2 und 12.2 tun muss, um folgende Komponenten zu entfernen:
  • APEX
  • OWM (Workspace Manager)
  • DV (Database Vault)
  • OLS (Label Security)
  • SDO (Spatial)
  • CONTEXT (Text Indizes)
  • ORDIM (Multi Media)
  • XOQ (OLAP API)
  • (more...)

What Employers Want : Communication Skills

It’s important you can present yourself in a confident and professional manner when it comes to interviews, but this also carries over into a work environment.

Once you get a job you need to be able to communicate effectively with your colleagues and with your customers/users. I know you think your silent genius act makes you look special, but it doesn’t. The initial interaction between humans involves building rapport. It’s kind-of difficult to build rapport (more...)

Event Mapping: Fluid Landing Page "Dot" Buttons

The bottom of a Fluid landing page contains dots that identify how many landing pages the user can view as well as the position of the current landing page within the user's landing page collection. This piece of information is quite useful on a swipe-enabled mobile device, but somewhat meaningless on my mac. A few months ago I was helping a PeopleSoft customer with their Fluid implementation. This rather brilliant customer made those dots clickable (more...)

Windows Datapump Export

The purpose of the script is to perform full database export keeping 3 export copies.
If export is successful, then fullexp*.dmp will be renamed with _1.dmp suffix added to filename.
If export is unsuccessful, then code will exit, skipping rename operations.

Note: there should never be .dmp file without # suffix unless export is unsuccessful.

In hindsight, directoryName should be using variable (ORACLE_SID) versus hardcode.

SET ORACLE_SID=DB01
SET directoryName=D:\DB01\export

expdp '/ as sysdba' (more...)

Video applying web scale patterns – Codemotion 2017

Video applying web scale patterns – Codemotion 2017

During my holiday the video of my applying web scale patterns at Codemotion Amsterdam 2017 was released on youtube.

deltalounge

LEAP#328 555 Timer VCO

The control terminal of the 555 timer can be used to adjust the upper and lower thresholds with an applied voltage. This produces a very simple voltage-controlled oscillator. The few measurements I’ve taken show that control adjustments have as much impact on duty cycle as frequency. That may be what you want … or not! As always, all notes, schematics and code are in the Little Electronics & Arduino Projects repo on GitHub hero_image

Successful Evangelism

I’ve been asked what it takes to be a successful evangelist and realizing that what makes one successful at it, is often like holding sand in your hands- no matter how tightly you hold your fists, it’s difficult to contain the grains.

The term evangelist is one that either receives very positive or very negative responses.  I’m not a fan of the term, but no matter if you (more...)

Travis Law

Travis Law

Travis’s Law:

Our product is so superior to the status quo that if we give people the opportunity to try it, they will defend it and demand its right to exist.

Travis Law is a quote from a speech by Travis Kalanick founder of Red Swoosh and wider known Uber. In his CEO role at Uber, there have been quite some scrimmages with local governments and unions. This law is one of the (more...)

Rebuilding Indexes

One of the special events that can make it necessary to rebuild an index is the case of the “massive DML”, typically a bulk delete that purges old data from a table. You may even find cases where it’s a good idea to mark a couple of your indexes as unusable before doing a massive delete and then rebuild them after the delete.

Despite the fact that a massive delete is an obvious special (more...)

What Employers Want : Self-Sufficiency

Of the people and companies I spoke to, self-sufficiency was a common thread. They were looking for traits like the following in prospective employees.

  • The ability to learn for themselves. Of course companies will be looking to train you, but they don’t want a wet lettuce that sits waiting for the next handout of knowledge. You have to take some personal responsibility.
  • Willing to make decisions. There are a lot of people who refuse to (more...)

Reading AWR Report – Part 3

After talking a bit about the AWR report (if you haven’t read the previous posts, you can find part 1 here and part 2 here), I think one of the best ways to understand it is to talk about real examples. In this part I’ll give you a few examples and tips regarding the report. … Continue reading Reading AWR Report – Part 3

How to exit of ed in SQL*Plus

I from time to time get stuck in ‘ed‘ on SQL*Plus because the editor not defined like this:

SQL> select * from duall;
select * from duall
 *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> ed
Wrote file afiedt.buf
22
^C
?
^Z
?

The Ctrl-C and Ctrl-Z, wouldn’t get you out.

The solution is simple, type ‘q‘ and press ‘Enter‘, then set editor using (more...)

September AZORA meeting

The September AZORA meeting has a great lineup of speakers. AZORA is the Arizona Oracle User Group. Republic Services is providing us with an excellent place to meet off of the 101. I’m looking forward to it. Check it out if you are in the Phoenix area.

Bobby

Oracle 12c Release 2 Summer Event Live Stream

Join our live stream on August 8th and watch two ACE Directors, Richard Niemiec and Nitin Vengurlekar talk about their favorite new features of Oracle 12c Release 2, Oracle DBaaS, RAC, ASM, partitioning and encryption. Register at this link.


Below is the agenda of the live stream. All times are in PST:


  • 7:30 - 8:30 Understanding 12cR2 Grid Infrastructure, RAC, and ASM/ACFS.
    In this session, Nitin Vengurlekar will take a deep-dive into the new features (more...)

Oracle Big Data Cloud Service CE: Working with Hive, Spark and Zeppelin 0.7

In my previous post, I mentioned that Oracle Big Data Cloud Service – Compute Edition started to come with Zeppelin 0.7 and the version 0.7 does not have HIVE interpreter. It means we won’t be able to use “%hive” blocks to run queries for Apache Hive. Instead of “%hive” blocks, we can use JDBC interpreter (“%jdbc” blocks) or Spark SQL (“%sql” blocks).

The JDBC interpreter lets you create a JDBC connection to any (more...)

What Employers Want : Enthusiasm

When I looked through the feedback I received from a variety of people and companies I kept seeing the same words and phrases. I think when you read them you will understand why.

  • Enthusiasm
  • Passion
  • Energy
  • Intelligence
  • Fresh thinking
  • Diversity of talent/interest

Companies are not necessarily looking for the finished article. They are looking for people who can adapt, grow and bring something to the company. This is especially true of graduate employees. It’s going (more...)

Apex Reports: One Link, Multiple Destinations

Every Interactive Report has an optional set of “Link” attributes that allow you to specify the location where the user should be redirected if they click a link next to a record in the report. You can choose “Link to Custom Target” and use the Link Builder to easily specify the target application, page, item values to pass, and other attributes.

linkbuilder1

What if the report combines different entities, and you need to direct the user (more...)

Basic Index Compression Made Simple (It Ain’t Easy)

I’ve discussed Index Compression a number of times as it’s an excellent way of minimizing the size of indexes without unnecessary, expensive index rebuilds. One of the nice features of Advanced Index Compression is that not only does it potentially compress indexes more effectively than possible with Basic Index Compression, but that it also eliminates […]