Ronny Egners Blog

A few months ago i tested yet another syslog implementation: rsyslog. Among all other available syslog implementation such as syslog or syslog-ng rsyslog offers some nice features such as:

• database support
  • MySQL
  • Postgres
  • Oracle
• Failover log destinations
• syslog over tcp
• fine grain output format control
• high precision timestamps
• filer on any message part
• compatible with syslog
• encryption support

So i took the oracle module for rsyslog and tried to get it working. A documentation did not relly exists so i wrote one which is part of the module now. Recently i took a look at rsyslogd again and did some test with rsyslog – especially how to store syslog messages and log oracle audit messages in a queryable way in an oracle database. My experiences will be covered in this article.

Disclaimer: All scripts, packages, procedures are released under the GPL. You can use them freely but on your own risk. However i would like you to send me the changes you made so i can perhaps improve the components.

Continue reading →

As of today (09th November 2009) Oracle 11g Release 2 is available for Solaris SPARC.

You can download it from OTN.

The release includes database, client and grid infrastructure (aka “clusterware” as well).

According to the release schedule Oracle 11g Release 2 for Solaris INTEL is most likely to be released next. Windows is scheduled for the second quarter in 2010. See my previous post for more information about possible release dates.

Beneath the battle of the operating systems (Windows vs.UNIX) there one argumentation after deciding for running oracle on Linux: The choice of the file system and the “correct” partition layout.

This article will sum up what file system are certified for running oracle on Linux (and other platforms as well) and will especially discuss the available file systems on Linux. My opinion regarding an optimal partition layout is written here.

Recommendations regarding the partition layout can be found in an older post here.

Continue reading →

This is a short article about ACFS and the acfs snapshots feature – a new 11g Release 2 feature: How to create, work with and drop a snapshot.

ACFS is the ASM Cluster File System and ships with Oracle 11g Release 2. For using ACFS first of all an ADVM volume must be created and an ACFS file system created on top of it. The same ACFS file system is available on all nodes in the cluster. The data itself is stored in an ASM disk group. More information can be found here. The documentation is available here and here.

Continue reading →

The following matrix shows a matrix of operating systems, database version and certification status. All information is taken from the database documentation and information freely available on the internet (e.g. oracle forums, blogs). The information is structured first into operating systems (Windows, Linux, Other) and further divided into version numbers and architecture (32-bit or 64-bit).

Table annotations

• n/a: “not supported or certified”; for this there might be several reasons, for instance:
  • operating system too old
  • mixing 32-bit operating system with 64-bit database or vice versa
  • database for this platform not available
• Projected: will be certified in the future; at this point of time this also counts as “not supported”

Windows

Linux

Solaris, HP-UX, AIX

Continue reading →

Data Pump is a great improvement of the old fashioned export and import utility. Data Pump is available since 10g Release 2 and offers some nice new features, for instance a API to be used to start exports and imports from within the database. Beside these features there is one major feature using data pump: SPEED. Data pump is by factors faster that traditional export/import.

A more comprehensive description about data pump can be found here or here. Documentation for version 11g Release 2 is available here.

One of the downsides of data pump – especially for unix dbas – is that data pump in oracle 10g is unable to compress the data (however it does compress metadata but savings are negligible) and is also unable to use pipes (which can be used to compress data if the software does not support this).Starting with 11g Release 1 the ability to compress data was added but required the expensive “Advanced Compression” license.

Another useful new data pump feature is the so called “network mode” which transfers the data to be imported over a database link instead of exporting the data into a file, transferring the file(s) to the destination server and importing the the export file(s).

This article is a short documentation about how to use data pumps network mode feature for importing data to remote (source and destination database are different) or local (source and destination database are the same) database instances. For general information how to use data pump or an introduction refer to the oracle documentation.

Continue reading →

The following post is a short description how to copy schema statistics from one schema to another. Basically there are two methods for doing this:

• using DBMS_STATS or
• using Data Pump

This is especially useful when doing large data transfers between either schemas or databases and statistics are needed fast. Remember that data density, row chaining or index cluster factor changed due to the data import and index rebuilds.

Continue reading →