Category Archives: Technical

Designing an isolated front production network for ODA

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

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

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.

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

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

DLNA compatible Desktop streams from VLC

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

Make WordPress 3.4.2 show double hyphens

By default WordPress shortens two dashes or hyphens (–) to a single dash (-). Not very practical if you need to show a command that uses double-dash options such as the  “–all-databases” in the previous post about mysqldump over ssh. … Continue reading

Posted in Technical | Tagged | Leave a comment

Ubuntu 12.04 – Ruby on Rails Production

This looks to be a smooth guide for setting up a Ruby on Rails production environment on Ubuntu 12.04. http://excid3.com/blog/setting-up-ubuntu-12-04-with-ruby-1-9-3-nginx-passenger-and-postgresql-or-mysql/

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

The simplest of mysql backups

Running mysqldump over ssh is a simple way to copy or back up a mysql database from a remote system. Granted, it’s not suited for every scenario, but for a quick dump of the small database on my remote webserver, … Continue reading

Posted in Technical | Tagged , | Leave a comment