Tuesday, August 27, 2013

Metalink outage

Gotta love it when you can't get to My Oracle Support.  Insert your wisecrack about them following MAA...

Monday, February 4, 2013

Second Oracle Exadata Virtual Conference

Hopefully you are already aware, but if not there is an online Exadata "Virtual Conference".  It is a 2 day event 2/6/2013 and 2/7/2013. Both days it is from 10AM - 1PM EST.  Day one is supposed to take you through a day in the life of an Exadata administrator and migration planning activities.  Day two is supposed to talk more about new features and capabilities as well how to optimize you investment in Exadata.  It's all done through Go To Meeting, so you don't have to worry about travel expenses, and best of all it is free.  I attended some of the sessions for the Virtual Conference last year and I found it to be very worthwhile.  Last year they also made recordings of the sessions available after the fact, so you could review them at your leisure.

Day 1 registration:   https://www1.gotomeeting.com/register/560212505
  • Arup Nanda - Exadata for Oracle DBAs
  • Doug Utzig - Exadata Software Maintenance Best Practices
  • James Steven Czuprynski - Demystifying IORM for Exadata
  • Christopher Douglas Bradham - Lessons Learned: A DoD Exadata Migration
Day 2 registration:   https://www1.gotomeeting.com/register/782184600
  • Mathew Steinberg - Exadata X3: What's New and Where Are We Going
  • Ananth Ram & Jigar Shah - Exadata in EBS – Techniques for  Proof-of-value  to  Production and Beyond!
  • Satyendra Kumar Pasalapudi - Exadata Evolution from V1 to X3 with Deep Dive into the features
  • Lawrence, Hin Luen, To - MAA Architecture and Operational Best Practices for Oracle Exadata

Check  out the following link for more information:  http://www.ioug.org/p/cm/ld/fid=89#Exadata

Wednesday, January 9, 2013

Oracle Virtual Sysadmin Day

In case you're not already aware Oracle is hosting it's First Virtual Sysadmin Day on 1/15/13.  It's a free event (registration is required).  There are 3 separate tracks:
  • Linux
  • Solaris
  • OVM
Here are some of the things that are going to be covered:
  • Create and manage ZFS pools and filesystems, safely update and restore your system using Boot Environments
  • Create and manage a virtualized Oracle Solaris environment using Oracle Solaris Zones and Network Virtualization
  • Install Oracle Linux using RPM and yum repositories; create storage volumes, prepare block devices, work with filesystems
  • Create and mount Btrfs in Oracle Linux, work with block devices and snapshots
  • Plan and deploy a virtualized infrastructure environment with Oracle VM
  • Virtualize and deploy enterprise applications in minutes using Oracle VM Templates
You'll be running the labs on your own machine using Virtualbox, so there is a little bit of pre-work to get prepared.  Overall it seems like a very cool idea, and I'm interested to see how it works.
Here is a link to a Wiki with all the details:  https://wikis.oracle.com/display/virtualsysadminday/Home
You can register here:

Thursday, September 29, 2011

Different Recovery Catalog settings based on Grid Control user

I was doing some work at a client site configuring RMAN backups through grid control.  I had already done all the needed configuration for my various backup settings and had specified the recovery catalog (or so I thought).  I did a test backup and everything looked good.  Later on I scheduled the backup to run daily.  The next morning I saw that the backup had completed successfully.  Everything seemed to be working as expected until I looked at the log and saw:
"using target database control file instead of recovery catalog"

I was sure I had configured the DB to use a recovery catalog, so I looked at the log for my prior test run.  Sure enough the test run had connected to the recovery catalog.  I realized that the main difference was that when I scheduled the job I had done so as a generic user.  We typically do this for these types of scheduled jobs, so we don't have to worry about a backup not running due to someones account being terminated.  My hypothesis was that Grid Control must keep track of recovery catalog info on a per user basis.  Sure enough when I logged in as the generic user it no longer showed that the database would use the recovery catalog.

This can be further verified with the following query:
SELECT t.target_name, t.target_type, cat.*
  FROM mgmt_targets t,
       mgmt_rcvcat_repos cat
 WHERE t.target_guid = cat.target_guid

Here you can see that there is in fact an em_user field, so the recovery catalog information can vary by Grid Control user.  We are currently using Grid Control, I'm not sure if the behavior is any different on other versions.

Thursday, May 14, 2009

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.

Friday, January 23, 2009

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"

Thursday, February 28, 2008

"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