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.

ougf

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.

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 (oracle-xe-11.2.0-1.0.x86_64.rpm.zip), unzipped it:

OMS Upgrade Fails At Repository Configuration With Error ORA-20251

Yesterday, one of my blog readers asked me how I didn’t encounter ORA-20251 error when upgrading my EM12c to EM13c. He also pointed My Oracle Support document (Doc ID 2095025.1). The document says a new record will be inserted into EM_COST_CENTERS table (in fact the table name is EM_COST_CENTERS_E but it’s not important) for all users whose department value is not blank during the upgrade. If there are more than one records with blank cost center then the second record will be considered as duplicate, resulting in the above error during the repository configuration.

Here’s the sample output:

I asked my reader to examine the EM users and he said there are not any EM users whose department value is not blank. So today, I examined the upgrade script and see that it’s not just about the department value. The upgrade scrip also tries to insert new “cost center” records for the users whose Line of business value is not blank.

New Oracle ACE Director: Me :-)

sampanya-500x305

I’m very proud to announce that I am accepted as an Oracle ACE Director. Now I’m part of a special club which has only 133 members (for now) in the world. It’s surely a milestone for my carrier. I would like to thank to Gurcan Orhan, Kellyn Pot’Vin-Gorman, Jeff Smith, Julian Dontcheff, Kamran Aghayev and Heli Helskyaho for being reference for my ACED nomination. I would also like to thank Oracle ACE program and committee members that approved my nomination.

I know that Oracle ACE Director title will put more responsibility to my shoulders. I have to be more active in the Oracle community in future. I have accepted the challenge and I’ll do my best!

I received another good news today for Turkish Oracle User Community. TROUG board member, Oracle Database Developer Choice Awards SQL 2015 Winner, Emrah Mete is accepted to Oracle ACE program. Congratulations Emrah!

OUGN 2016 Spring Conference

Between March 9th and 12th, I was in Oslo to speak at OUGN 2016 Spring Conference. It is my first time in Norway, so I thought it will be very cold and therefore I prepared well (brought thickest clothes with me) but the weather was surprisingly calm although the thermometer indicates 1-2 degrees celsius. I attended to the speakers dinner organized by OUGN Conference Committee. The dinner was great and I had a change to know some speakers and organisation committee.

ougn Speakers Dinner