content top

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:

Read More

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 relevant) 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.

Read More

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 Twitter Statistics

As I mentioned in my previous post, OUGN Spring event is held on a cruise ship which does round trips between Oslo and Kiel. As I heard from other speakers, in previous years, there were not internet connection on the boat and people were totally isolated from the world (and social media). This year, we had internet connection almost everywhere even in our cabins. So we were able to use tweeter during the event. But at the end, we were on a boat, and when the boat didn’t have 3G/4G access, we couldn’t connect to the internet and it affected the number of tweets. After the event, I wondered total number of tweets with hashtag “#OUGN16”, so I wrote Python scripts (yes Python because Python is the language supported by EM CLI scripting engine) to fetch the tweets from the twitter and generated statistics for these tweets. I fetched only the tweets between May 9th and May 13th (including the May 13th) containing “OUGN16” (the official) hashtag.

Twitter provides tweets formatted as JSON, so for this time, I used “mongodb” to store the tweets. You know it’s designed to store JSON data, so it took my seconds to import the data to mongodb using “mongoimport”. Next time, I’ll hopefully use Oracle 12c and I’ll also publish a step by step guide to do it.

Read More

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

Read More
Page 1 of 3712345...Last »
content top