I’d like to show how to setup a PostgreSQL database cluster and its basic usage.
Category Archives: Databases
Installation notes for Oracle 10g R2 on Solaris 10, Sun Fire 2900.
One I got an error according to nnfyboot when installing Oracle on Linux, so here is a script nnfyboot_fixbug:
When an Oracle database is deployed on an internet host, you can use Oracle’s builtin security options to allow access only from certain clients. In this case I didn’t want to setup complex firewall rules or use a SSH tunnel.
Today I had to drop 2.604 tables from an SQL Server database… too much to tell the customer to “do it by hand” using Management Studio ;-)
Inspired by Christian’s blog entry about rlwrap (german), I decided to share my functions and settings for Bourne Again shell and Oracle SQL*Plus.
iSCSI is one of many options to provide shared storage for Oracle RAC. I use it regularly as I can setup a virtual machine to provide iSCSI storage.
I just gave an Oracle backup & recovery workshop for a customer, talking about Oracle in general, DataPump and Recovery Manager (RMAN). At the end we came across LogMiner to find a certain SCN of a DDL statement. As I … Continue reading
Short tutorial on how to install MySQL 5.5 on Mac OS X 10.6.
Since Oracle 9i there are much more dynamic parameters which can be changed at runtime. So it’s a good thing to use server parameter files (SPFILEs) instead of plain text parameter files (PFILEs). I will use MYDB as instance name … Continue reading
It’s easy to duplicate a database with RMAN. Since Oracle 10g it will even create the duplicate database for you — you only have to create the instance.
The Oracle parameter db_file_multiblock_read_count, often shorted “MBRC”, is a mighty one. If set to the wrong value your database may suffer from bad I/O. It’s up to you to test and find the right value for it.
Starting with Oracle 11g there’s a new way to test I/O subsystems. The procedure DBMS_RESOURCE_MANAGER.CALIBRATE_IO tests your disks for different I/O workloads by issuing 1 MB random reads to your datafiles and reports the actual performance.
I just found a nice SQL statement on asktom.oracle.com showing possible states of RAID 01 and 10 arrays in case of a disk failure:
This post describes cluvfy used in RAC 10g. Starting from Oracle 11g this tool is integrated in the Oracle Universal Installer.
There are some steps required to setup Oracle Real Application Clusters:
This post describes the setup of Solaris for Oracle 10g Release 2 Real Application Clusters.
Yesterday I had to help a customer with very bad query performance of their SQL Server 2008 with a 1-terabyte datawarehouse. I found that tempdb filled up the C: drive and was not layouted correctly. As recommended by Microsoft you … Continue reading