Thursday, October 17, 2013

Trouble installing oracle on Windows

So, while installing Oracle on Windows 7 (64-bit), the Oracle installer would just sort of shut down unceremoniously.

I found a log file C:\Program Files\Oracle\Inventory\logs.  It wasn't, however, very revealing.  The last message was simply "INFO: Get view named [QuickInstallUI]"

So, poking around on the internet lead me to a thread over at forums.oracle.com that discussed this issue, but the only thing that worked for me was to create another user and run the install as that user.

Crazy. But it worked.  Wanted to pass it along.

Monday, October 14, 2013

DB2 Backup Naming convention

I had a hard time finding this on the internet, so I thought I'd post after I found it in a book.

The naming convention for a DB2 file system backup will be:
Alias.Type.Instance.Node.Catalog_Node.MonthHourSecond.Sequence
Example:
MyDB.0.DB2INST.NODE00000.CATN0000.20131015131259.001
   ↑       ↑        ↑                ↑                   ↑                ↑   ↑  ↑     ↑   ↑     ↑
Alias     |    Instance          |           Catalog Node     |    |   |      |    |      |
       Backup Type       Node                              Year  |   |      |    |      |
                                                                            Mon  Day  |  Sec   Seq
                                                                                           Min

Reference:
Understanding DB2: Learning Visually with Examples Second Edition
Page 745
14.4.6 The Backup Files
Raul F. Chong Clara Liu Sylvia F. Qi Dwaine R. Snow 

The Database is not accessible after creating Always On Availability Group

 Having created a fully functional SQL Server Always On Availability Group, I connect using SSMS. Upon trying to expand the database, I get ...