content top

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 about Oracle Standard Edition, talked about how we can create alternatives to Enterprise features to lower the license costs.

TROUG DBA SIG

Read 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:

For the ones who are not familiar with the find command, I’ll try to explain its parameters. The parameter “-type f” is not mandatory but it will help you find only “files” (and filter out directories etc). The parameter “exec” lets you run a command for the selected files. The brackets are replaced with the name of the selected file. The plus sign (+) will make the command line is built by appending each selected file name at the end.

Read 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 needs a lot of RAM (and may need swap).
  • Be sure that you do not have a “non-working http proxy configuration”. You don’t need internet access to install OID, but if you set a non-working http_proxy, opmnctl will not work and your configuration step will fail.
  • Download and install OID 11.1.1.6+ patchset – You can directly install OID from this patchset, you don’t need to install 11.1.1.1 and then upgrade it.
  • OID 11.1.1.6+ configuration tool can create the ODS schemas, so you don’t need to download and use RCU (repository creation utility) but RCU tool is still useful to clean ODS schemas in case you need to re-configure OID (after a failed configuration attempt).
  • First install only the software, then configure it using OID_HOME/bin/config.sh.
Read 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 reading the book, you may feel that all topics are approached with a perspective of a software developer not by a system (database) administrator.

List of chapters:

  1. Setting Up Enterprise Manager: As expected, the book starts with the installation chapter about EM12c but unexpectedly, it doesn’t cover how to set up EM12c step by step. It doesn’t give any details, only covers the concepts.
  2. Infrastructure as a Service: One of the best chapters of the book, it covers almost all topics about registering and using Oracle VM Manager, but still lack of some information such as installing required plugins.
  3. Database as a Service: In this chapter, the author explains how to build a DBaaS. The topics are organized to build any PaaS. It includes registering/creating storage servers, and give some information about chargeback system
  4. Enterprise Monitoring: This chapter covers the topics to build an automated monitoring system using Oracle Enterprise Manager. Incident handling is also mentioned in this chapter.
  5. Cloud APIs: Most interesting and promising chapter is surely “cloud APIs”, but unfortunately this chapter doesn’t go into details but just give some sample RESTful calls and JSON results.
Read 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:

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