1 2 3 Previous Next 34 Replies Latest reply: Apr 10, 2013 3:24 PM by cj RSS

    OS X Users! 11gR2 Oracle Instant Client 32 & 64-bit is now available

    cj
      To start a new thread for this (since there are four pages on the other big thread), the long awaited Instant Client 11.2 for OS X is available: https://blogs.oracle.com/opal/entry/os_x_users_11gr2_oracle
        • 1. Re: OS X Users! 11gR2 Oracle Instant Client 32 & 64-bit is now available
          836561
          I've tried to use it to compile PHP with instantclient 11R2 (64bit) and run as an apache module in a webserver (just as I've done many times before on another mac still running OSX 10.6 and using the Oracle 10R2 64-bit instantclient). My Instantclient directory has the basic file + sqlplus + SDK

          It seems to compile and install OK, But when I to start the apache webserver I get this error :

          httpd: Syntax error on line 148 of /usr/local/apache243/conf/httpd.conf: Cannot load modules/libphp5.so into server: dlopen(/usr/local/apache243/modules/libphp5.so, 10): Symbol not found: CSendHTTPRequest\n Referenced from: /usr/local/instantclient_11_2/libnnz11.dylib\n Expected in: flat namespace\n in /usr/local/instantclient_11_2/libnnz11.dylib

          I don't really know what this means. Any ideas?
          • 3. Re: OS X Users! 11gR2 Oracle Instant Client 32 & 64-bit is now available
            904276
            Same with python and cx_Oracle
            • 4. Re: OS X Users! 11gR2 Oracle Instant Client 32 & 64-bit is now available
              989297
              Yeah, looks like an undefined dependency in libnnz11.dylib.
              % for i in *lib; do echo $i; nm $i | grep _C_SendHTTPRequest; done
              libclntsh.dylib
              libheteroxa11.dylib
              libnnz11.dylib
                               U _C_SendHTTPRequest
              libocci.dylib
              libociei.dylib
              libocijdbc11.dylib
              libsqlplus.dylib
              libsqlplusic.dylib
              %
              I looked in the basiclite package as well, just out of curiosity, and it has the same missing dependency.

              Oh well, I'm sure they'll get around to fixing it by 2015!
              • 5. Re: OS X Users! 11gR2 Oracle Instant Client 32 & 64-bit is now available
                989560
                Confirmed the same issue trying to build Perl's DBD::Oracle. Here's hoping a new SDK zip is released soon.
                • 6. Re: OS X Users! 11gR2 Oracle Instant Client 32 & 64-bit is now available
                  cj
                  I've asked Oracle's porting group to look at this. Please give the details of your OS and the configuration options for Perl/Python/PHP etc.
                  • 7. Re: OS X Users! 11gR2 Oracle Instant Client 32 & 64-bit is now available
                    955469
                    % perl -V
                    Summary of my perl5 (revision 5 version 16 subversion 2) configuration:
                       
                      Platform:
                        osname=darwin, osvers=12.2.0, archname=darwin-2level
                        uname='darwin link.local 12.2.0 darwin kernel version 12.2.0: sat aug 25 00:48:52 pdt 2012; root:xnu-2050.18.24~1release_x86_64 x86_64 '
                        config_args=''
                        hint=recommended, useposix=true, d_sigaction=define
                        useithreads=undef, usemultiplicity=undef
                        useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef
                        use64bitint=define, use64bitall=define, uselongdouble=undef
                        usemymalloc=n, bincompat5005=undef
                      Compiler:
                        cc='cc', ccflags ='-fno-common -DPERL_DARWIN -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include',
                        optimize='-O3',
                        cppflags='-fno-common -DPERL_DARWIN -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include'
                        ccversion='', gccversion='4.2.1 Compatible Apple Clang 4.0 ((tags/Apple/clang-421.0.60))', gccosandvers=''
                        intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678
                        d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
                        ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
                        alignbytes=8, prototype=define
                      Linker and Libraries:
                        ld='env MACOSX_DEPLOYMENT_TARGET=10.3 cc', ldflags =' -fstack-protector -L/usr/local/lib'
                        libpth=/usr/local/lib /usr/lib
                        libs=-ldbm -ldl -lm -lutil -lc
                        perllibs=-ldl -lm -lutil -lc
                        libc=, so=dylib, useshrplib=false, libperl=libperl.a
                        gnulibc_version=''
                      Dynamic Linking:
                        dlsrc=dl_dlopen.xs, dlext=bundle, d_dlsymun=undef, ccdlflags=' '
                        cccdlflags=' ', lddlflags=' -bundle -undefined dynamic_lookup -L/usr/local/lib -fstack-protector'
                    
                    
                    Characteristics of this binary (from libperl): 
                      Compile-time options: HAS_TIMES PERLIO_LAYERS PERL_DONT_CREATE_GVSV
                                            PERL_MALLOC_WRAP PERL_PRESERVE_IVUV USE_64_BIT_ALL
                                            USE_64_BIT_INT USE_LARGE_FILES USE_LOCALE
                                            USE_LOCALE_COLLATE USE_LOCALE_CTYPE
                                            USE_LOCALE_NUMERIC USE_PERLIO USE_PERL_ATOF
                      Built under darwin
                      Compiled at Feb  1 2013 10:09:57
                      @INC:
                        /usr/local/lib/perl5/site_perl/5.16.2/darwin-2level
                        /usr/local/lib/perl5/site_perl/5.16.2
                        /usr/local/lib/perl5/5.16.2/darwin-2level
                        /usr/local/lib/perl5/5.16.2
                        .
                    
                    % uname -a
                    Darwin MacPro.local 12.2.0 Darwin Kernel Version 12.2.0: Sat Aug 25 00:48:52 PDT 2012; root:xnu-2050.18.24~1/RELEASE_X86_64 x86_64
                    Attempting to run "make test" on DBD::Oracle 1.56 results in this error (emphasis added):

                    Can't load '/usr/local/src/CPAN/build/DBD-Oracle-1.56-SnUFr0/blib/arch/auto/DBD/Oracle/Oracle.bundle' for module DBD::Oracle: dlopen(/usr/local/src/CPAN/build/DBD-Oracle-1.56-SnUFr0/blib/arch/auto/DBD/Oracle/Oracle.bundle, 2): Symbol not found: CSendHTTPRequest
                    Referenced from: /usr/local/oracle/instantclient/libnnz11.dylib
                    Expected in: flat namespace
                    in /usr/local/oracle/instantclient/libnnz11.dylib at /usr/local/lib/perl5/5.16.2/darwin-2level/DynaLoader.pm line 194.
                    • 8. Re: OS X Users! 11gR2 Oracle Instant Client 32 & 64-bit is now available
                      836561
                      I'm using OSX 10.8.2 (all updates applied) with the latest XCode installed (including the command-line tools)

                      I'm using Apache 243 configured using
                      ./configure prefix=/usr/local/apache243 enable-module=most --enable-shared=max

                      Also using PHP 5.4.11
                      ./configure prefix=/usr/local/php5411 with-zlib without-pear with-apxs2=/usr/local/apache243/bin/apxs --with-oci8=instantclient,/usr/local/instantclient_11_2

                      The instantclient directory is just the unzipped downloads from Oracle (64-bit versions) : Basic + SQLPlus + SDK
                      SQLPlus runs OK from this instantclient installation.

                      Edited by: 833558 on 07-Feb-2013 03:47
                      • 9. Re: OS X Users! 11gR2 Oracle Instant Client 32 & 64-bit is now available
                        cj
                        To keep you updated, a revised IC bundle is being tested.
                        • 10. Re: OS X Users! 11gR2 Oracle Instant Client 32 & 64-bit is now available
                          cj
                          Work is still in progress.
                          • 11. Re: OS X Users! 11gR2 Oracle Instant Client 32 & 64-bit is now available
                            cj
                            If you had issues, please re-download the bundle. It's been refreshed.

                            Thanks for your patience.
                            • 12. Re: OS X Users! 11gR2 Oracle Instant Client 32 & 64-bit is now available
                              904276
                              It works now! Thank you very much!
                              • 13. Re: OS X Users! 11gR2 Oracle Instant Client 32 & 64-bit is now available
                                992311
                                I'm getting an "Abort trap: 6" error using sqlplus in the new 64-bit instant client on OS X Lion (10.8.2) when doing an "insert into ... select" statement:
                                sqlplus XXXX/XXXX@XXX

                                SQL*Plus: Release 11.2.0.3.0 Production on Wed Feb 20 14:21:41 2013

                                Copyright (c) 1982, 2012, Oracle. All rights reserved.

                                Connected to:
                                Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
                                With the Partitioning, OLAP, Data Mining and Real Application Testing options

                                SQL> INSERT INTO XXX (XXX, XXX, XXX)
                                SELECT XXX, XXX, XXX FROM XXX WHERE XXX IS NOT NULL ORDER BY XXX, XXX ASC;
                                > 2
                                Abort trap: 6
                                Not sure if it matters, but the table I'm selecting from is empty in this particular case.
                                • 14. Re: OS X Users! 11gR2 Oracle Instant Client 32 & 64-bit is now available
                                  989297
                                  Outstanding, thanks Christopher and Oracle folks! I can now connect to Oracle via 64-bit python and the cx_Oracle module on os/x 10.8. (I haven't tried to run the "insert into select" statement below, but I'm willing to try to replicate if someone can produce a test case.)
                                  1 2 3 Previous Next