content top

Reading Data From Oracle Data Files (without Connecting Database)

I attended the BGOUG Spring Conference last week as a speaker. While in BGOUG Conference, I had a chance to listen Kamil Stawiarski’s session about hacking Oracle. Kamil spoke about potential security issues of high level privileges such as create any index and create directory. At the end of the session, he also showed a tool written by himself. The tool (I do not remember its name right now), reads a datafile, searches for object ID (of a table) and parse and list the rows of the table.

I am aware that Oracle Support has a similar utility, and as I heard it’s called “DUL” (Data UnLoader). DUL is used to export data from data files in case there’s no possibility to open the database because of corruption. So the concept wasn’t new to me, but seeing the tool in action, made me want to write my own tool which is capable of extracting data from data files.

Read More

OUGF Harmony 2016 Spring Conference Twitter Statistics

If you didn’t come this page from my review about the OUGF Harmony16 Spring Conference, please don’t forget to read that one. This post is generated almost automatically by scripts to share the twitter statistics of the conference. The statistics cover the period between May 17 and May 20. I included three hashtags (#OUGF, #OUGF16, #Harmony16), because at the beginning of the conference, people (including me) did not used the official hashtag (#Harmony16).


Read More

OUGF Harmony 16 Spring Conference

Last week I took part in the OUGF (Oracle User Group Finland) Harmony 16 Spring Conference. It was a two day event, and held in Helsinki, between May 18th and 19th. In the conference, I gave two speeches: “Essential Linux commands for DBAs” and “Enterprise Manager 13c for DBAs”. Most people expect to me to speak about Enterprise Manager but in my first session, I spoke about the tools which can be used for monitoring Linux performance (i.e. sar, pidstat, top), profilers and tracing tools.


In my second session, I spoke about the features of Enterprise Manager for database administrators. I think people enjoyed my sessions, because I got good questions and positive feedback from the audience. By the way, thanks Ann Sjökvist for the photo.

Read More

TROUG Days 2016 İstanbul Twitter Statistics

TROUG Days İstanbul was held last week (April 28th to 29th) at İstanbul Technical University Technopark. I think we used social media, specially twitter very effective, so I wanted to publish some twitter statistics about the event like I did for OUGN Spring Event. The statistics cover the period between April 27 and April 30.

Before sharing the twitter statistics, I would like to write a few words about the event. I feel very proud to be a part of the organization team of TROUG Days İstanbul. It was the first two-day event organized by TROUG and everything went OK. It is a milestone for TROUG. We increased the expectations of TROUG members, and will surely organize a better one next year. I would like to thank our sponsors (Oracle Turkey, Axxana, Bilginç IT Academy) and all speakers. We had a great lineup including 10 Oracle ACE Directors, 7 Oracle ACEs, 3 Oracle ACE Associates.

When I say “speakers”, I remembered that we had a great speakers’ dinner thanks to ACE Program and our sponsors. I hope the speakers liked our hospitality and they will come again next year! After this brief summary of the event, here are the twitter statistics:

Read More

How to Install Oracle 11gR2 XE on Ubuntu

I wanted to import a datapump dumpfile to my laptop, and I wondered if I can install Oracle XE to ubuntu guest. I thought it would be easy because I installed Oracle 10g XE to ubuntu for several times, but I saw that Oracle doesn’t provide debian packages for Oracle 11g XE. So I needed to convert the RPM to debian package (and fix incompatibility problems). Therefor, I installed “alien” package and other required tools using apt-get:

Then I downloaded the zipped RPM (, unzipped it:

Read More
Page 5 of 40« First...34567...Last »
content top