Technical

jeremy.schneider's picture

RAC Attack – Oracle Cluster Database at Home

First of all, the RAC Attack deep dive at Collaborate went great – thanks to everyone who participated! The room was full (20 participants) and I got evaluations from about half of them. Here’s a summary of the eval results:

  • 100% class met expectations, would recommend to others
  • 66% easy to follow, could use skills in working environment
  • 100% already familiar with oracle, 90% use oracle daily
  • 0 negative reviews of instructor (phew!)
  • 1 negative review of curriculum: said practice exercises weren’t relevant but training manual was still above average.
  • 0 negative “comments”

There were several positive comments such as this: “I would recommend this class to others. This setup is perfect to pick up new skills and expose what ifs w/out worrying about pressing the wrong button.”

jeremy.schneider's picture

BYO Oracle RAC on EC2

Over the past year or so I’ve had a number of conversations about running Oracle RAC on Amazon’s EC2 cloud platform. Chet Justice had suggested a long time ago that I try it, but I never quite found the time. Last fall at the Oak Table Symposium in Michigan, Jeremiah Wilton told me he hadn’t yet done it and I spent the last night scheming with Charles Schultz about getting started. But it wasn’t until this week that I finally found the time to try. (To be fair, I’ve been quite busy lately — our first kid was born on February 2nd, a beautiful little girl!)

jeremy.schneider's picture

Binding DBLINK to a Network Interface

Just thought I’d do a quick post on this one; came out of a conversation about a month or two ago.

We had a single-instance database running on a failover cluster (RHCS). A database link existed for a related database and the connection had to pass through a firewall. The problem was the firewall: it had a rule which only allowed connections from the VIP.

The database server has two IP addresses – a system IP and a VIP. Is there any way to bind the dblink to one specific interface? (Note: we would still like the system IP to be used for other traffic.)

I couldn’t think of a way for Oracle to do that. But we did find a workaround, of sorts (though not perfect) – by using the operating system route command.

jeremy.schneider's picture

Large ASM Adoptions and Lessons Learned

Seems like December came quickly this year…  and UKOUG is only one week from Monday!

This will be my first year attending UKOUG – and I will be giving a new presentation called “Large Scale ASM Adoptions and Lessons Learned.”  I was personally involved in a very large ASM adoption project and I’m also talking to a few other acquaintances with similar experiences.  I will be summarizing our collective stories and lessons learned in this presentation.  My session will be Monday morning (Nov 29) at 10:25 am – please stop by!

However there’s another way you are invited to participate in my UKOUG session.  Do you know anybody who has been involved in an ASM adoption?  Have you been involved in one?  I have created a web survey with the questions that I’m asking my acquaintances about their experiences with ASM.

jeremy.schneider's picture

OpenWorld Haiku

I arrived home in Chicago around 1am Saturday morning on a slightly delayed flight direct from San Francisco. What a week – I’m only now getting back into my normal routine!

It’s nothing spectacular, but I wrote this short Haiku (poem) on Sunday…

OpenWorld: crush, splat…
Brain worked overtime last week!
Still catching up sleep.

Haha… ok… so I think that I’m finally caught up on sleep now that it’s Thursday. But it was a busy week!

OpenWorld was worth the plane ticket, for both learning and networking opportunities. My two favorite sessions were at oracle closed world and the unconference, respectively… but there were plenty of great “official” openworld sessions too!

dannorris's picture

unplumb (or unbinding) NICs on Linux

I’ve been quiet for a long time now, but this entry hopefully will shake the cobwebs off and get me back into the habit.

I recently had a need to “unplumb” (from Solaris fame) or make interfaces on Linux “disappear” from the ifconfig list. It could be that I don’t know how to completely deconfigure an interface, but I didn’t find any methods to unassign an IP address from a Linux Ethernet interface after it was assigned. You can take interfaces down (ifconfig eth3 down) and reconfigure them to assign different addresses, but not remove the address completely.

dannorris's picture

Collaborate 09: Don’t miss these sessions

Collaborate 09 starts on Sunday, May 3 (a few days from now!) in Orlando. I’ve been offline for several weeks (more on that later), but will be returning to the world of computers and technology in full force in Orlando. I’ve had a few inquiries about whether or not I’ll be at Collaborate, so I thought I’d resurrect my blog with a post about where I’ll be and some of the highlights I see at Collaborate 09.

First, where I’ll be presenting:

dannorris's picture

Exadata front and center

Just in case you were like me and did not tune in for Oracle’s quarterly earnings concall, there were some interesting highlights. As many of you (well, there aren’t that many of you that read this, but…) know, I’ve been very interested in Exadata since its announcement at Oracle OpenWorld 2008 in October. While some observed that Larry’s introduction keynote was rather brief, I didn’t take it as a sign of disinterest at all. According to the concall earlier this week, quite the opposite.

Here are some choice excerpts from the transcript that I find telling about the future of Exadata:

Larry Ellison:

“So, that’s looking back. Now looking forward, I think the most exciting product we’ve had in many, many years is our Exadata Database Server.”

dannorris's picture

Start Database Services automatically after instance startup

Those of us that have dealt with RAC environments for a while are familiar with the behavior of Oracle Services in an Oracle Cluster. Services are an essential component for managing workload in a RAC environment. If you’re not defining any non-default services in your RAC database, you’re making a mistake. To learn more about services, I strongly recommend reading the definitive whitepaper by Jeremy Schneider on the topic.

dannorris's picture

Install to go-live, 3 days

This has been an interesting week, but not really that surprising.

I was called back to a previous client site where I had previously helped with some Oracle Application Server (10.1.2.2) post-install configuration. In that previous visit, I got oriented to the environment they use and the packaged application they were deploying. The packaged application uses JSP, Oracle Forms, and Oracle Reports (possibly also Discoverer). The deployment environment is all Microsoft Windows servers with two Oracle Application Server homes per application server since the vendor’s deployment requires that JSPs be deployed in a separate O_H from the Oracle Forms and Oracle Reports environment (that’s the first eyebrow-raise I did, but whatever).

This customer had an environment that was configured by the vendor for testing purposes and it works fine. However, it uses HTTP and they want to use HTTPS for all client-server traffic. They also wanted to be able to manage the environment and be better equipped to support it, so they left the vendor-installed environment as is and built a new environment on new servers so they’d get first-hand views of the install and configuration procedures. Since all the application servers are virtual machines, they could easily create additional machines.

Syndicate content