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

rawsync, rsync for database on raw devices

    I took few hours to make some changes to rsync's source code, to fit for copy contents in raw devices to remote host's raw devices. I am an Oracle DBA, and some of our databases are using raw...

Posted on October 17, 2008 9:10 AM

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

How to pass parameters to your program in Shell script.

    I wrote some OCI program and compiled them into 32 bit executable on 64 bit Solaris machine. So I need to set the proper Oracle library path to get it work. I wrote a shell script to set...

Posted on September 27, 2007 2:14 PM