Author Archives: Roy

Restore database to new or redeployed ODA

Posted on October 23, 2012 by Roy

Doing a restore from an RMAN backup to a freshly deployed Oracle Database Appliance seems like a conceivable scenario, so I figured it would be nice to have tried it at least once. For this test, I have a backupset on … Continue reading →

Posted in ODA, Oracle, Technical | Tagged , , | 1 Comment

Erase and Rewind – Redeploying Oracle Database Appliance (2.3.0 image)

Posted on October 23, 2012 by Roy

After using an Oracle Database Appliance for a bit of testing, it was time to get it ready for production. I decided to start with a fresh deploy and re-initializing shared storage. Note that this is the 2.3.0 base image, … Continue reading →

Posted in General, ODA, Oracle | Tagged , , | 2 Comments

Designing an isolated front production network for ODA

Posted on October 19, 2012 by Roy

With the introduction of Oracle Engineered Systems the DBA is moved somewhat closer to infrastructure design decisions, and expected to at least have some opinions on the network design requirements for the database. As such, I’ve given some thought to … Continue reading →

Posted in ODA, Oracle, Technical | Tagged , , , | Leave a comment

Import data to a different tablespace using Data Pump

Posted on October 15, 2012 by Roy

In a previous article I looked at how one could force imp to place user objects in the default tablespace of a user, in cases where the originating tablespace was not available in the destination database. The newer Oracle Data … Continue reading →

Posted in Oracle, Technical | Tagged , , , , | Leave a comment

Import data to a different tablespace using imp

Posted on October 12, 2012 by Roy

In the old days, it was common to store objects from assorted users in the USERS tablespace. In more modern days, it sometimes seems more appropriate to store user objects in a tablespace dedicated to that schema. So, as I was transferring … Continue reading →

Posted in Oracle, Technical | Tagged , | 3 Comments

Documentation for odachk is now available on My Oracle Support.

Posted on October 12, 2012 by Roy

The documentation for Oracle Database Appliance Configuration Audit Tool is now available on My Oracle Support note 1485630.1. The odachk script, quite similar to the exachk tool on Exadata, verifies a large number of components in the ODA environment. This includes … Continue reading →

Posted in ODA, Oracle, Technical | Tagged , | Leave a comment

Benchmark tool for Windows network shares

Posted on October 10, 2012 by Roy

After some tinkering on my filer, I once again found myself looking for a simple tool to check the performance of a network share under Windows (SMB/CIFS). The usual disk benchmark tools such as Crystal DiskMark and AS SSD benchmark … Continue reading →

Posted in Technical | Tagged , , , | Leave a comment

No more iBooks for me

Posted on October 2, 2012 by Roy

I’m not sure why I’m surprised to find that the DRM protected books I bought from the Apple iTunes’s Music Store can’t be easily read in any other way than by the iBooks reader app, available only on iOS devices. … Continue reading →

Posted in General | Tagged | Leave a comment

SMS generation have reached Oracle HQ

Posted on September 23, 2012 by Roy

Oracle Database Appliance asked me to “pls wait…” during installation 🙂

Posted in General | Tagged , , | Leave a comment

DLNA compatible Desktop streams from VLC

Posted on September 19, 2012 by Roy

After a good bit of tinkering, I’ve come up with the following setup for generating a DLNA  compatible stream of a Windows or Linux desktop using Video Lan Connection. Note that there is no audio in this configuration, as it … Continue reading →

Posted in Technical | Tagged , , , | Leave a comment