TROUG DBA/Developer SIG 2014

This is a late post (sorry for all Turkish Oracle Users waiting for the presentations) about TROUG DBA/Developer SIG 2014. We successfully organized a hybrid SIG meeting on February 13th, but I could find time to write a blog post about it till today. My company (Innova) hosted the meeting, I would like to thank my manager for his support. There were 5 presentations, and all of them were in Turkish. I made a presentation (more...)

Finding And Deleting Old Files (on Unix and Windows)

I needed to write short scripts to delete old files on a Windows Server. It’s a very easy task on UNIX flavors but the limited capacity of Windows command line made me worried. You can use a simple “find” command to find old files on UNIX. For example, the following command will be enough to find and delete files older than 7 days:

find /folder/ -type f -mtime +7 -exec rm {} +

For the (more...)

Tips And Tricks For Installing Oracle Internet Directory

One of our customer needed to integrate OID with Siebel, and they asked me to install OID on a test server. I probably encountered all possibly errors during the installation but completed it successfully. Here are some tips for the ones who’re planning to install OID:

  • Use JRockit instead of regular Java. Install it before you install Weblogic. So Weblogic will detect and use it.
  • Make sure that you have enough RAM (and swap). Weblogic (more...)

Book Review: Managing IaaS and DBaaS Clouds with Oracle Enterprise Manager Cloud Control 12c

Managing IaaS and DBaaS Clouds with Oracle Enterprise Manager Cloud Control 12c I try to read and review all books about Enterprise Manager Cloud Control 12c (EM12c). The last one I read is, “Managing IaaS and DBaaS Clouds with Oracle Enterprise Manager Cloud Control 12c”. As you can understand from the name, the book focuses mainly on how you can build and manage IaaS and DBaaS using EM12c and it is about only 110 pages. The author, Ved Antani works as Technical Director with Electronic Arts. While (more...)

Unable to Register with Red Hat Network

We want to install Oracle E-Business Suite on Red Hat Linux 6.2. To be able to use RHN Repository to install packages, we tried to register our system but when we issued “rhn_register” we got the following error:

[Sat Jan 25 16:55:24 2014] rhn_register
Traceback (most recent call last):
  File "/usr/sbin/rhn_register", line 76, in <module>
  File "/usr/share/rhn/up2date_client/", line 74, in run
    sys.exit(self.main() or 0)
  File "/usr/sbin/rhn_register", line 58, in  (more...)

How to Add RAC Databases to Enterprise Manager Cloud Control 12c

It’s been asked several times to me how to add RAC (Clustered Databases) to Enterprise Manager 12c. Finally I found time to get screenshots and prepare a step-by-step guide. The interesting point about adding Clustered Databases is, when you try to discover (and add) a cluster databases like you do a stand-alone database, EM12c does not show you an error but the process doesn’t complete. It makes users to feel like there’s a bug. In (more...)

TROUG Ankara Meeting

keynoteIstanbul is the biggest city of Turkey with more than 15 million population, and the largest companies of Turkey are located in Istanbul. So as you may expect, Istanbul is the heart of IT industry and most TROUG (Turkish Oracle User Group) members are located there. Therefore we (TROUG) preferred to organize our own events in Istanbul (and gave only a few presentations at the universities outside Istanbul). This year, we decided to expand our (more...)

Enterprise Manager 12c Host Availability Page (Status History)

Some servers were unreachable today, fortunately they were all monitored by Oracle Enterprise Manager 12c, so I see them on the summary page and contacted the related sysadmin staff to fix the problems. I’ve not set up notification mails yet (this is a new implementation), so I didn’t get emails (more...)

Exadata x4 High Performance Disks

As I see, the data sheet of Exadata x4-2 says Oracle used 10.000 RPM disks for high performance. You probably know that Exadata provides 2 alternative configurations for hard disks. You may pick high performance (but low capacity) disks, or you may pick high capacity (but low performance) disks. (more...)

Oracle Partner Events: 12c Roadshow And Delivering DBaaS

Oracle Database 12c Partner Roadshow

On November 5th and 6th, I attended to Oracle Database 12c Partner Roadshow in Istanbul. During this 2-day partner-only (and free) briefing, François Pons from Oracle Server Technologies, gave detailed technical information about new features of Oracle 12c to Oracle partners in Turkey. Although it was not a workshop, Mr. (more...)