Determining which process has locked a .dll

Working in a windows environment I occasionally run into an issue with a .dll that I'm trying to delete being locked by another process. I see this frequently when trying to remove files from my target system before a clone. There are a couple of ways you can determine which process has the .dll locked. A quick command line way to do it is tasklist /m <.dll in question>.
For instance tasklist /m CORE40.dll.

If the .dll is locked I would see output such as the following:
Image Name PID Modules
========================= ======== ====================
msdtc.exe 1152 CORE40.dll

You can also check out Metalink Note 454040.1 for a script (prepatch.bat) that will identify similar information for you.

Recreating Global oraInventory

I ran into a situation recently in one of our 11i environments where the Global oraInventory was missing. A missing oraInventory can cause issues when applying patches, so I wanted to correct the issue proactively. Luckily the Local oraInventory was still intact. Looking on Metalink I found Note: 295185.1 which describes how you can recreate the Global oraInventory. The note talks about downloading a patch, but more than likely you already have OUI 2.2, so you probably won't need it.

The steps are pretty simple:
1. Source your Applications environment file.
2. Change to your $IAS_ORACLE_HOME/appsoui/setup directory.
3. Execute the perl script "perl OUIsetup.pl"

"Demo It To Oracle" (DITO)

I have been playing around with various ways to effectively collaborate with a team when the team members are in different geographic locations. Obviously one option is to use web conference software. Being able to schedule a web conference can be difficult when your team members are half a world away and in a different time zone. Another option that I have been looking at recently is screen recording software. In particualr I have been looking at Cam Studio, mainly because of it's price tag (free).

Apparently I'm not the only one who sees a use for this technology. Today I received a message that Oracle is releasing "Demo It To Oracle" (DITO) to help troubleshoot service requests. The idea is that you can use Cam Studio to create a short video walking Oracle support through your issue. You then upload your video to your service request so that your analyst can see your issue first hand. This is seen as a possible alternative to doing an OWC (Oracle Web Conference). On the surface it sounds like a great idea, but we'll see how it works in parctice.

If you want to read more you can check out Metalink Doc ID 11.1

First Post

It seems today that almost everyone has a blog, and there are certainly no shortage of great blogs regarding Oracle.

I've decided that it's time that I jump on the bandwagon and start blogging as well. Mainly I will be trying to use this blog as a tool to more easily do knowledge sharing. I'm also hoping it will prevent me from having to "reinvent the wheel" when I need to explain things to people. I mainly plan to be blogging about the Oracle database as well as Oracle Applications (the e-business suite), although that is always subject to change.

-Brian