Tag: DBA Lounge

Windows PowerShell for the SQL Server DBA

Most people think Windows administrators make a living with their right-hand—you know, right-clicking and left-clicking the user interface to get things done. I’ve spent a fair amount of time writing VBScript scripts to administer Windows servers and workstations and automating repetitive tasks. One reason for me moving into Windows PowerShell is its roots in the Microsoft .NET Framework, as I have done a fair amount of .NET programming. But what is Windows PowerShell anyway?

Read More >

Scalable Internet Architectures

My old friend and collaborator Theo Schlossnagle at OmniTI posted his slides from his Scalable Internet Architectures talk at VelocityConf 2009. The slides are brilliant even without seeing Theo talk and I highly recommend the time it takes to flip through them, for anyone who is interested in systems performance. If anyone took an mp3 of this talk I’m dying to hear it, please let me know. Here’s the slide deck. Let me know your thoughts.

Read More >

Installing Oracle 11gR1 on Ubuntu 9.04 Jaunty Jackalope

Welcome, readers! It’s time for another update to our series of posts on installing Oracle on Ubuntu Linux. In this edition, we’ll be installing Oracle 11g R1 on Ubuntu 9.04, both 32-bit. This time, I’ve used VirtualBox to run a virtual machine (VM) to perform our work.

Read More >

Ubuntu 9.04 (Jaunty Jackalope), vpnc, and resolvconf

Connecting to a cisco vpn device with vpnc on jaunty. If you use vpnc and vpnc-disconnect to bring the connection up and down, all works fine. If you leave the connection idle too long and are disconnected from the other end, the resolv.conf is not always updated. This is a problem because, when you do a DNS lookup in a browser you’ll experience delays, the DNS servers from your vpn connection are no longer available. The easiest way to check this is to login to your vpn and check the contents of /etc/resolv.conf.

Read More >

Announcing Sydney Oracle Meetup #6 – Storage for Oracle Databases

This meetup will be focused on storage technologies for Oracle database. It looks like a short presentation on Oracle Automatic Storage Management is in order – quite a few people are missing the concepts of the Oracle flagman storage storage solution and it’s useful to understand the approach whether you use it now or not.

Read More >

How to Recover Data from a Dead MacBook

This post might seem outside of our focus, but life brings all kinds of challenges. A friend of mine bought a MacBook when she was on vacation in the USA. Her Mac completely broke down. The service guys told her she’d need to replace the motherboard, which would cost almost the same as a new computer. The problem was her Mac wouldn’t even start, and all the data she had on a hard-drive was stuck in the neat white box without any signs of life. Sure, I said, I’m a computer guy I can recover it, can’t I?

Read More >

Pythian Video: Oracle RAC — Why VIPs?

One of the topics that beginners RAC DBA’s (along with network engineers supporting Oracle database infrastructure) are confused about is the Virtual IP usage in Oracle RAC starting from Oracle Clusterware 10g. With this videocast, I will try to clarify those concerns once and for all. I have embedded the video here in a smaller window so you might want to go directly to YouTube for the full-size version of “Pythian Video: Oracle RAC – Why VIPs”.

Read More >

Ottawa Perl Mongers: Moose & Daemons

The Ottawa Perl Mongers will be meeting once again at the Pythian headquarters. There will be two presentations given: Yanick Chanpoux will be presenting on Moose. Tim Procter (myself) will be presenting on Portable Perl Daemons. The focus is on developing light-weight background processes that will be compatible with both Unix and Windows systems. Additionally, I will be demonstrating communications with the daemon and child processes over TCP from an independent controller. The presentations are now available online thanks to Andrew Ross at the Free and Open Source Software Learning Centre. Comments are welcome.

Read More >

Oracle RAC Workload Management: A Webinar by Alex Gorbachev

When I posted my RAC Workload Management whitepaper, it was downloaded by many but it turned out that not everyone has half a day to go through such level of details and, frankly, not everyone is interested in how those features are implemented. This prompted me to put together a webinar that does high level overview of available options to balance workload properly with Oracle Real Application Clusters.

Read More >

Setting up Virtual Hosts for Database and Applications Tiers in 11i

In this post I would like to share with you the virtual hosts set-up (two nodes each on the application tier, and two on the DB tier) for a customer using 11.5.9.

Read More >
Page 35 of 60« First Page...10...3334353637...40...Last Page »