Blog Aggregator - Amardeep Sidhu

As you already know, I’ve spent a whole week near Redwood, California. Saying that the week has been difficult to manage is a euphemism:

My heater engine broke at home (I didn’t even know it had an engine!), almost leaving my children in the cold for a night. Thank you, people have been so helpful that […]

I got to troubleshoot an amazing situation a few weeks ago. I think, we can all agree that assuming we are on a supported configuration of a production release of Oracle, it is essentially inconceivable that allowing a single query to run on your system can flip another query’s plans and cause major performance issues […]

Whenever two or three developers gather together they will argue over the best tool for editing code. Once they’ve chewed the spearmint out of that they will commence a heated discussion on ways to measure code quality. But I think this cartoon by Thom Holwerda pretty much nails it.

Yes, another R12 post. It’s all I’ve been doing lately.

When I first installed 11.5.3, I just went with the default two-tier architecture; Web & Forms on the middle-tier and Reports & CCM on the db host. After a while, I realized that was a mistake for my environment. I should have put everything but the db on the middle-tier. Live and learn, I guess.

R12 was my chance to partially correct

Check RAID controller type on HP-UX – Integrity servers

HP-UX Integrity running on Itanium processor like rx6600 model comes with SAS (serially attached SCSI) drives and inbuilt raid controller. To check if you have SAS RAID controller card installed on your Integrity Itanium rx6600 running HP-UX server and to determine the device address for the SAS controller

To check what RAID controller is installed on Integrity Itanium rx6600 servers, run ioscan with fnd option

Run ioscan –fnd sasd :

Where –f is used to display full listing

-n is used to display device filename

-d is used to print hardware controlled by specified driver

Hope you all enjoyed it. From the few people I’ve talked to, the DUL topic seems to be one of those, like it or not with no middle ground types of things. Regardless, if you have any questions, don’t hesitate to ask.

Unable to boot Solaris Sun Fire server from disk/CDROM:

Fixing Sun Fire Solaris boot error:

I ran into problem working on Sun Fire server last week when i rebooted the server to install some Solaris patches and server didn’t came backup. When I tried to connect to CONSOLE I received following error messages:

If you notice Timeout waiting for ARP/RARP packet message on Solaris console this indicates that boot device is missing. I wasn’t able to get to OK prompt so I couldn’t try Solaris open boot diagnostic command to see boot –device and boot-disks state. To get to CONSOLE use LOM (lights out management) press #. keys .

For switching from Solaris console to LOM:

Running Power on command from lom will turn power on the Sun Fire server and drop it to OK .

From OK prompt on Solaris Sun Fire server, run following commands. For directly returning to OK (Solaris open boot prom ) from LOM prompt run the break command from lom :

Sometimes you look at a change in the optimizer arithmetic and think “Why did that take so long to appear?” Here’s an example that’s probably going to cause a lot of heartache over the next couple of years as people go through the upgrade process. I have a query that looks like this:
select
padding
from
t1
where
n1 = 2
and n2 = 2
;

Here […]

Some rambling thoughts…
Oracle Database Administrator or Data Administrator?
Oracle continues to add features/functionality that makes the dutiful Database Administrator look a lot more like a Data Administrator. Some would argue it started with ASM since volume management was placed into the hands of the DBA. I’d argue it started with RMAN since that feature was one […]

Kenny Tilton writes a blog that is mostly about LISP programming, but today he posted about database troubleshooting, and he anecdotally illustrates and elaborates on a law of troubleshooting that I strongly agree with: Always solve the first problem. Based on the way this law is named, I suspect it is his own.
In a nutshell, […]