Tag: Oracle

Installing APEX 4.0 and 3.2 on Oracle 10gR2 on Mac OS X Leopard (Intel)

Few days ago, I have put together the Quick Install Guide for Oracle 10g Release 2 on Mac OS X Leopard (Intel). I did mention that it would be cool to get APEX working as well but, apparently, APEX isn’t supposed to be running on Oracle 10g Release 2 Database on OS X as few people pointed our on the blogs. However, looks like few people did manage to run APEX on 10g using Embedded PL/SQL Gateway. ong story short, I was able to install APEX successfully using the native Mac OS X Oracle 10g Database and here is how…

Read More >

ORA-16069? You May Need A New Standby Controlfile

Here is how to recreate the standby controlfile in just 6 easy steps!. Trust me, it sounds more drastic than it is!

Read More >

Oracle E-Business Suite Patch Taxonomy, Part 1

E-Business Suite patching is very broad topic. I’m going to cover just a fraction of this vast theme, one that I believe is often overlooked. I decided to split it into two logical parts; Part 1) Oracle E-Business Suite patch terminology, and Part 2) Querying patches, patchsets, family packs. This blog could also be called “Oracle EBS patch evolution theory.” Like any other theory, it can be challenged and proven wrong. I tried to make it unbiased based purely on my experience and to present it in the way that makes sense in context of general patching activities.

Read More >

What Exactly is Swappiness?

This is an issue that keeps rearing its ugly head over and over again, and since it greatly affects performance, it is most important that DBAs of any DMBS running on Linux come to grips with it. So I decided to do some research and try different settings on my notebook. Here are my findings.

Read More >

Quick Install Guide for Oracle 10g Release 2 on Mac OS X Leopard & Snow Leopard

I was very surprised that Oracle released Oracle Database for Mac OSX, especially, version 10g now that 11g has been out for almost 2 years. There is no quick install guide for OS X but only a standard Oracle® Database Installation Guide 10g Release 2 (10.2) for Apple Mac OS X (Intel). It’s fine but if you want to install Oracle on your MacBook and not for production use then you might take some shortcuts and follow a quick instructions so I gathered my notes while installing just released Oracle Database 10.2.0.4 on my MacBook, here they are.

Read More >

Log Buffer #142: A Carnival of the Vanities for DBAs

Welcome to the 142nd edition of Log Buffer, the weekly review of database blogs.

Read More >

OraQuiz #1: Quote a job name in lowercase to drop it with DBMS_SCHEDULER

I have enjoyed reading Sheeri’s nice MySQL “Pop Quiz” series, and, knowing that practise greatly increases the retention time of information in our minds, I thought I would start a series of quizzes of my own, only to do with Oracle. Here’s a an easy one to begin with. How do you drop a job with job_name in lower case using DBMS_SCHEDULER on Oracle 10g?

Read More >

Sydney Oracle Meetup #2 — Performance Evening with Tanel Poder and Ric Van Dyke

I presented my session Under The Hood of Oracle Clusterware and it went quite well and even the demo worked so we didn’t get to the fun troubleshooting experience. I love when the audience is actively engaged and presentation is not “one-way” — lot’s of fun (and spare time to refill while someone else is talking). We had a nice break between two parts of the presentation and, instead of 10-15 minutes bio-break, it turned into 30 minutes of peers networking and, unfortunately, I had to interrupt it in order to continue. Note to myself, we should plan to have more free flowing discussions and also plan small meetups directly in a pub, maybe.

Read More >

Database Platform Migration — Webinar in Australia

I’m excited to announce that Paul Vallée, Pythian Founder and Executive Chairman, will be on-the-air online this week with a free webinar — Database Platform Migration: when is it strategically appropriate to migrate existing applications to an open-source platform? It’s based on our 10+ years experience supporting proprietary databases, such as Oracle and SQL Server, and open-source MySQL databases on the other hand and what we learned on the numerous migrations.

Read More >

Killing an Oracle Job Dead

If you ever thought it was easy to kill an oracle job, let me show you something that gave me a headache today. The steps are simple enough: remove/break all jobs in question, kill the jobs that are running, recompile the packages with new the version, and submit/un-break the jobs again. This time, however, things were not going as smoothly as I expected. Let’s have a look.

Read More >
Page 91 of 144« First Page...10...8990919293...100...Last Page »