Tag: Oracle

Sending Timezone-Aware Email with UTL_SMTP

I’m back again with another in what I hope will be a long line of “Quick Tips for Newbies” series. At Pythian, we are spread across multiple timezones, since it wasn’t too long ago that everyone was in Ottawa, this is something that still presents little quirks. One such quirk involved email generated by one of our internal Oracle instances—via a stored procedure that used UTL_SMTP to send the messages—did not have timezone information in the “Date” email header. As a result, they would be stamped with the hour in Eastern timezone (Ottawa time), but the mail clients would think that hour was local. Even if you aren’t sending email to all the ends of the Earth, it won’t hurt to make your messages timezone-aware. I’m sure it will save some confusion and frustration down the line. Here`s how.

Read More >

Alex Gorbachev Presenting at InSync09

InSync09 is the first conference in Australia focused on Oracle applications which in the past few years multiplied immensely in numbers — e-Business Suite, JD Edwards, JD Edwards, Hyperion, Siebel, BEA, PeopleSoft. There is also significant focus on SOA. The presentation that I’m doing is titled “Making Oracle E-Business Suite R12 Highly Available”. It’s more an architectural paper to show what are the paths and how to plan the environment for high availability and what technologies can be used. Obviously, I will touch some of the DBA friendly topics like RAC and DataGuard but it definitely won’t be focused on the database tier only. It’s actually going to be quite an experience as I’m not really an Apps DBA myself so learning curve has been quite steep. I do, however, have good advisers in this are so it should be fine.

Read More >

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 >

Tom Kyte Video on “Why Upgrade to Oracle 11g?”

Tom Kyte speaks for about an hour on the newest features in Oracle 11g, including how many new features and enhancements there are. The presentation itself can be downloaded from Tom’s site and the video can be directly played in your browser on YouTube, the link is available here.

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