DBA Tools

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