Tag Archives: Oracle

Installation Notes for Oracle 10g R2 on Solaris 10

Installation notes for Oracle 10g R2 on Solaris 10, Sun Fire 2900.

Posted in Databases, System Administration | Tagged , | Leave a comment

Oracle Database And nnfyboot

One I got an error according to nnfyboot when installing Oracle on Linux, so here is a script nnfyboot_fixbug:

Posted in Databases, System Administration | Tagged | Leave a comment

Securing Oracle Listener

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.

Posted in Databases, System Administration | Tagged , , | Leave a comment

Useful Oracle Shell Aliases And SQL*Plus Settings

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.

Posted in Databases, System Administration | Tagged , , | Leave a comment

Setup Storage For Oracle RAC

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.

Posted in Databases, System Administration | Tagged , | Leave a comment

Using Oracle LogMiner

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

Posted in Databases, System Administration | Tagged , | Leave a comment

Oracle Database Parameters

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

Posted in Databases | Tagged , | Leave a comment

Duplicate An Oracle Database With RMAN

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.

Posted in Databases, System Administration | Tagged , | Leave a comment

Dramatic Effect Of MBRC

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.

Posted in Databases, System Administration | Tagged , | Leave a comment

Testing Oracle I/O

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.

Posted in Databases, System Administration | Tagged , | Leave a comment

Oracle Shows RAID Configurations

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:

Posted in Databases, System Administration | Tagged , | Leave a comment

Using cluvfy To Verify Oracle RAC Node Setup

This post describes cluvfy used in RAC 10g. Starting from Oracle 11g this tool is integrated in the Oracle Universal Installer.

Posted in Databases, System Administration | Tagged , | Leave a comment

Installing Oracle RAC On Solaris

There are some steps required to setup Oracle Real Application Clusters:

Posted in Databases, System Administration | Tagged , , | Leave a comment

Setup Solaris For Oracle RAC

This post describes the setup of Solaris for Oracle 10g Release 2 Real Application Clusters.

Posted in Databases, System Administration | Tagged , , | Leave a comment