Viewing ASM trace files in VIM: Which Way Do You Use?

cafepress_womens_cap_sleeve_tshirt

A couple of people have asked me recently about a classic problem that most DBAs know: how to view ASM trace files in the VIM editor when the filenames start with a + character. To my surprise, there are actually quite a few different ways of doing it. Since it’s come up, I thought I’d list a few of them here… If you have another one to add, feel free to comment. I know that (more...)

New issue of OTech Magazine

The summer edition of OTech magazine has just been published – 111 pages packed with information from international Oracle technology experts.

Authors and topics are:

  • Sten Vesterli – The Spiritual Programmer
  • Scott Weseley – APEX 5.0 New Features
  • Patrick Barel – Dear Patrick
  • Emma Groomes & Crystal Walton – KScope 2014
  • Anar Godjaev – How to protect your sensitive data using Oracle Data Vault
  • Debra Lilley – Women in IT Initiative
  • Lonneke Dikmans – (more...)

New issue of OTech Magazine

The summer edition of OTech magazine has just been published – 111 pages packed with information from international Oracle technology experts.

Authors and topics are:

  • Sten Vesterli – The Spiritual Programmer
  • Scott Weseley – APEX 5.0 New Features
  • Patrick Barel – Dear Patrick
  • Emma Groomes & Crystal Walton – KScope 2014
  • Anar Godjaev – How to protect your sensitive data using Oracle Data Vault
  • Debra Lilley – Women in IT Initiative
  • Lonneke Dikmans – (more...)

drop table people

Wenn es bei xkcd einen Strip mit SQL-Queries gibt, muss er hier verlinkt werden - auch wenn's vielleicht eher um ein philosophisches Problem geht.

OTech Magazine – Summer 2014

OTech Magazine – Summer 2014

OTech magazineThe fourth issue of OTech Magazine, the independent magazine for Oracle professionals, is available. For the summer 2014 issue there are some more personal articles included. Titles vary from The Spiritual Programmer to The Next Generation: Oracle SOA Suite 12c and back via How to protect your sensitive data using Oracle Data Vault.

Download OTech Magazine – Summer 2014 here.

deltalounge

PeopleSoft HCM PUM Image with PeopleTools 8.54

I just noticed that the HCM PUM image is now available on PeopleSoft support.  You can download it for the HCM updates, but you can also take a peak at what PeopleTools 8.54 looks like.  Here’s the link:   PeopleSoft Update Image HCM 9.2.008

Resources

Share

How to hide login data of sql-scripts on Windows

One of the often given advices on hardening a database is to run scripts without broadcasting your login data at the same time. According to Arup Nanda in his famous articles on “Project Lockdown” you have three options to run your scripts without letting everybody in on your password secrets:

  1. Start your scripts under /nolog and add your login to the SQL-script your running
  2. Start SQL*Plus under /nolog and add the login at the beginning of your (more...)

Oracle 12c (12.1.0.2.0) database step by step installation guide on redhat linux 5.6

 

Download Document here

Oracle 12c database installation guide on redhat linux 5.6


OTech Magazine Issue #4: Summer 2014 Published


OTech Magazine - The independent magazine for Oracle professionals. Yesterday fourth issue of the OTech Magazine, the independent magazine for Oracle professionals published.



 In this issue also included my article: Oracle Database 12c: Cross Platform Transport non-CDB to PDB using RMAN Backup Sets





You can download online OTech Magazine #4 Isssue - Summer 2014

Summary of article

We can create a PDB using upgraded database (non-CDB) and can be adopt the 12.1 non-CDB into (more...)

ADF 12c Courses Now Online 

Once again the ADF PMs have been hard at work to provide us all with great training content. This time in the form of a full online course.

Oracle University has begun the First Global Teach of the Oracle Middleware 12c: Build Rich Client Applications with ADF course online.

This course covers all the useful features of ADF Business Components including  how to build and test reusable business services. After creating the application they drill (more...)

New Tips and Techniques page

In case you haven’t noticed it – and chances are you haven’t noticed because I just created it! :) – I’ve added a new page called “Tips and Techniques” to the website. It’s where I keep a random collection of odd items I’ve come across that might be of interest yet don’t deserve a full blog post. It’s sort of like a FAQ list, but not necessarily with the “F”. :)

You can reach it either via (more...)

Block size and multirow DML peformance

While 8k is the default block size, Oracle supports other block sizes, too. Smaller block sizes (more commonly, 4k) are encouraged for OLTP workloads to reduce concurrency, and even smaller block size, 2k, is recommended for databases running on “Advanced format” (or “4K”) storage. Oracle documentation warns us of possible implications when storing larger rows in 2k/4k blocks, such as potentially larger space overhead due to metadata, or even possibility of row chaining. What it (more...)

ApacheTomcat: How to sustain planned/unplanned Oracle database downtime & Runtime Load Balancing w UCP

See our brand new white paper  http://bit.ly/1ApSIqr 

LOB Length

It’s funny how you can make little savings in work all over the place in Oracle if you’re prepared to look a little closely at what’s going on. Here’s a quirky little example with LOBs and function calls that might just have some greater relevance in other situations. Here’s a little data set, and two queries that I might run against it:


create table tbl(
	c1      clob
)
lob (c1) store as c_lob(
	disable storage  (more...)

Zone Map Zone ID’s

Just a quick follow up to my previous post on how Zone ID's are calculated.

Let's take the following example:
SQL> select rid, sys_op_zone_id(rid) zone_id
2 from
3 (
4 select chartorowid('AAAS5KAAHAAABYDAAA') rid
5 from dual
6 );

RID ZONE_ID
------------------ ------------
AAAS5KAAHAAABYDAAA 324580438021

Recalling that extended ROWID has the following format (a nice picture from Oracle Documentation):



In the binary format that would correspond to:
  • Data Object Number -- 32 bits
  • Relative File (more...)

Accessing ADF Iterator Binding from Value Change Listener

This is a quick hint about how to access ADF iterator binding from value change listener method. Let's say you have generic value change listener, reusable with any kind of input components and you want to get information about underlying ADF BC View Object structure in that listener. Value Change Listener provides access to UI Component, we should evaluate component expression and look up in the bindings for component binding name.

Here is the sample (more...)

OBIEE automatic redirect to a Dashboard via mod_rewrite

Normally end users would like to have a simple URL access for Oracle Business Intelligence Enterprise Edition (OBIEE) 11g like http://webhost:7777 and than to be automatically redirected to their Dashboard, instead of typing endless complex URL's.

Assuming you have following standard implementation of an OBIEE environment which contains an Oracle HTTP Server (OHS) configured with mod_wl_ohs to be proxied to point to your WebLogic Server hosting OBIEE and an OBIEE Server, you can simply use (more...)

Developer Interviews (#DI 2) Claus Ibsen (@davsclaus) About All Things Camel

In the second edition of my developer interview series I had a chance to talk to Claus Ibsen (@davsclaus). He works for Red Hat on open source integration software such as JBoss Fuse and is Apache Camel committer. You may also know him for his book "Camel in Action".
We talked about his history in integration technologies and looked at the latest developments which are upcoming for the Camel 2.14 (more...)

OUG Mexico

We (Gorcan, Glen, Debra and I) arrived into Mexico around 10pm and had a few minutes wait for our local user group contact to meet us. They had arranged transportation to our hotel.

2014 08 08 07 35 022014 08 08 07 35 07

The next morning (Friday) was the day of the OUG Mexico conference. We were collected from the hotel and taken to the conference venue. Our transport had to made a number of trips to/from the conference venue to cater for all the (more...)

Oracle 11204 Clusterware upgrade – ASM glitch

Yet another tough challenge thrown at my team right after the disaster recovery (DR) simulation drill which performed barely couple of weeks ago. The new task (challenge) in hands is to upgrade the existing four cluster environments from 11.2.0.2 to 11.2.0.4 as Oracle already stopped supporting v11.2.0.2.

Although last week we had a 3 node successfully upgrade track record, we encountered ASM upgrade troubles whilst running (more...)