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

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

cj Employee ACE
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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?
  • 2. Re: OS X Users! 11gR2 Oracle Instant Client 32 & 64-bit is now available
    988954 Newbie
    Currently Being Moderated
    Same problem here.
  • 3. Re: OS X Users! 11gR2 Oracle Instant Client 32 & 64-bit is now available
    904276 Newbie
    Currently Being Moderated
    Same with python and cx_Oracle
  • 4. Re: OS X Users! 11gR2 Oracle Instant Client 32 & 64-bit is now available
    989297 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    % 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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    Work is still in progress.
  • 11. Re: OS X Users! 11gR2 Oracle Instant Client 32 & 64-bit is now available
    cj Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    It works now! Thank you very much!
  • 13. Re: OS X Users! 11gR2 Oracle Instant Client 32 & 64-bit is now available
    992311 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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