Compailed problem: No defined ORACLE_HOME

kajko
2005-12-04
2012-12-13
  • kajko
    kajko
    2005-12-04

    HI.
    I am using a debian sarge. I try compiled a tora-13.18 for oracle.
    First I install a Oracle 10.1 and netmgr. Set tnsname.ora and ORACLE_HOME in .bashrc, then I run .configure it stop with error:
    checking for uic... /usr/share/qt3/bin/uic
    checking whether uic supports -L ... yes
    checking whether uic supports -nounload ... yes
    checking if STL implementation is SGI like... yes
    checking for oracle... /usr/local/oracle/instantclient10_1
    checking oci works... configure: error: Couldn't compile and run a simpile OCI app.
          Try setting ORACLE_HOME or check config.log.
          Otherwise, make sure ORACLE_HOME/lib is in /etc/ld.so.conf or LD_LIBRARY_PATH

    Than I try using a instant client 10-2 and 10-1 base on the help from INSTALL file.
    I go step by step.
    I set ORACLE_HOME:
    /install/tora/tora-1.3.18$ echo $ORACLE_HOME
    /usr/local/oracle/instantclient10_1
    I set TNS_ADMIN
    /install/tora/tora-1.3.18$ echo $TNS_ADMIN
    /usr/local/oracle/instantclient10_1/tns

    I went throw the forum but I couldn't find any help to solve my problem

    In config.log I found some lines corresponding to ORACLE:

    conftest.c:4: error: syntax error before "hda"
    conftest.c:4: error: `HDA_SIZE' undeclared here (not in a function)
    conftest.c:4: error: `ub4' undeclared here (not in a function)
    conftest.c:4: warning: data definition has no type or storage class
    conftest.c:4: error: storage size of `hda' isn't known
    configure:32098: $? = 1
    configure: program exited with status 1
    configure: failed program was:
    |
    |       #include <oci.h>
    |       Lda_Def lda;
    |       ub4     hda [HDA_SIZE/(sizeof(ub4))];
    |
    |       int main(int c, char **v) {
    |         return 0;
    |       }
    |
    configure:32120: error: Couldn't compile and run a simpile OCI app.
          Try setting ORACLE_HOME or check config.log.
          Otherwise, make sure ORACLE_HOME/lib is in /etc/ld.so.conf or LD_LIBRARY_PATH

    HAVE_ORACLE_FALSE=''
    HAVE_ORACLE_TRUE=''

    ORACLE_CXXFLAGS=''
    ORACLE_LDFLAGS=''
    ORACLE_LIBS=''

    Thank you for any information.
    Mariusz

     
    • marcel_grenier
      marcel_grenier
      2005-12-05

      Did you add $ORACLE_HOME/lib to your /etc/ld.so.conf
      file.

      This worked for me:

      create a new file called /etc/ld.so.conf.d/oracle.conf

      which contains
      /home/oracle/product/10g/lib

      then ran ldconfig

      after that it should compile.

       
    • marcel_grenier
      marcel_grenier
      2005-12-05

      P.S. My ORACLE_HOME is /home/oracle/product/10g yours will be /usr/local/oracle/instantclient10_1

       
    • kajko
      kajko
      2005-12-05

      Today I try install on another computer with Debian sarge.This same error.

      To /etc/ld.so.conf  I add :
      /usr/local/oracle/instantclient_10_2
      and I run ldconfig.
      I also created /etc/ld.so.conf.d/oracle.conf file
      but this also not help

      This is an error;
      checking for libpng... -lpng -lz -lm
      checking for libjpeg6b... no
      checking for libjpeg... -ljpeg
      checking for Qt... checking for X... (cached) libraries /usr/X11R6/lib, headers /usr/X11R6/include
      checking for IceConnectionNumber in -lICE... (cached) yes
      checking for libXext... (cached) yes
      checking for Xinerama... no

            libqt:     -lqt-mt -lpng -lz -lm -ljpeg  -lSM -lICE -lXext -lX11 -lSM -lICE ,
            libraries: /usr/lib,
            headers:   /usr/share/qt3/include using -mt
      checking for lrelease... /usr/share/qt3/bin/lrelease
      checking for lupdate... /usr/share/qt3/bin/lupdate
      checking for moc... /usr/share/qt3/bin/moc
      checking for uic... /usr/share/qt3/bin/uic
      checking whether uic supports -L ... yes
      checking whether uic supports -nounload ... yes
      checking if STL implementation is SGI like... yes
      checking for oracle... /usr/local/oracle/instantclient_10_2
      checking oci works... configure: error: Couldn't compile and run a simpile OCI app.
            Try setting ORACLE_HOME or check config.log.
            Otherwise, make sure ORACLE_HOME/lib is in /etc/ld.so.conf or LD_LIBRARY_PATH

      Thank you for any information
      Mariusz

       
      • Norbert Kiesel
        Norbert Kiesel
        2005-12-05

        Last time I checked the instancecliant dot _not_ support OCI (or was it just not PRO*C?).  Worth looking into before wasting more time.

         
        • kajko
          kajko
          2005-12-07

          What I have to disabled that tora will be compiled?
          When I read this forum I can see that people compiled tora with instanceclient only. Is any parameters which I shuld add to compailed tora and disabled OCI?
          Thank you for information
          Mariusz

           
        • Mike Johnson
          Mike Johnson
          2005-12-08

          You're smoking crack. :-)

           
    • Mike Johnson
      Mike Johnson
      2005-12-08

      "make sure ORACLE_HOME/lib is in /etc/ld.so.conf or LD_LIBRARY_PATH"

      This will probably fix your problem...

       
      • kajko
        kajko
        2005-12-12

        Finaly I installed a oracle DB 10.1 and I was able to compiled TORA.
        Then I copy folder tora to another computer where I have only a instante client and looks as it is working.
        But still how compiled it using only a instantclient?
        I arledy add path to
        /etc/ld.so.conf pointed to the main forlder of the client : /usr/local/oracle/instantclient10_1
        but this not help. The error message was clear.
        INSTALL file is also OK and I fallow it.
        Thank you for information
        Mariusz

         
        • Mike Johnson
          Mike Johnson
          2005-12-12

          Make sure you set ORACLE_HOME to /usr/local/oracle/instantclient10_1. Also make sure you have the SDK installed somewhere. For example, I compile with the options:

          --with-oracle-includes=/home/mrjohnson/instantclient/sdk/include/
          --with-oracle-libraries=/home/mrjohnson/instantclient/
          --with-oci-version=10G

          Otherwise, post the relevant parts of config.log for more help.

           
          • kajko
            kajko
            2005-12-13

            When I use those three lines I was able compiled tora with oracle client.
            Thank you very much. It is working.
            Mariusz