DBA Tools

How to keep given gigabytes of archive log files with Perl

    When managing a lot of databases, finding a good policy to manage the archive log files is very important to make the work easy. Usually archive log files are placed on dedicate volumns, purge by space will help...

Posted on November 26, 2008 7:57 PM

Find archive log file by given sequence with perl

    I am writing some DBA scripts with perl, one of them is the archive log file related. I have to implement this feature for more works. The first version is implemented by UNIX find command. # # Get...

Posted on November 26, 2008 7:47 PM

Linux Kernel Parmaters for Oracle 10g RAC

    When installing Oracle RAC or database software, you need to make some changes to the Linux kernel parameters. # For Oracle 10g RAC kernel.sem=250  32000   100     128 kernel.shmmax=1048576000 kernel.shmmni=4096 kernel.shmall=2097152 fs.file-max=65536 net.core.rmem_default=262144 net.core.rmem_max=262144 net.core.wmem_default=262144 net.core.wmem_max=262144 net.ipv4.ip_local_port_range=1024  65000     Just...

Posted on January 9, 2008 12:40 PM

Mini VMWare Oracle RAC (3GB) on RedHat Linux

    I created a 4GB disk for the first node, choose the minimum installation of OS (RedHat Advanced Server 4 Update 5), and then installed the development packages and X-Window packages. But for the second node, I just created...

Posted on January 2, 2008 4:09 PM

Install the basic Linux X-Window for xterm

    When installing Oracle RAC on VMWare hosts, I don't want to install any desktop management system (both KDE and GNOME) for Oracle installer or other Java based configuration tools, it will make the VMWare host too big and...

Posted on December 31, 2007 8:38 PM

How to compile version independent OCI program on Linux/Unix?

    OCI is a very effective program interface to access Oracle database, I have wrote several DBA utilities with OCI interface. On Windows the compiled binary can run under Oracle 8i/9i/10g client environment. But on Linux/Unix, it cannot, because...

Posted on October 9, 2007 9:06 PM

How to compile Oracle Call Interface (OCI) program?

    On Linux/Unix we can use gcc to compile OCI source code. Use the following command to compile the text unload utility as 64 bit binary. gcc -m64 -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=64 -I${ORACLE_HOME}/rdbms/public -I${ORACLE_HOME}/rdbms/demo -L${ORACLE_HOME}/lib -lclntsh -o ociuldr.bin ociuldr.c    ...

Posted on September 28, 2007 2:07 PM