Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Installing DBD::Oracle on Mac (El Capitaine)

by Sandy (Curate)
on Mar 03, 2016 at 16:24 UTC ( #1156743=perltutorial: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    cd /Library
    sudo mkdir Oracle
    ...
    sudo unzip instantclient-basic-macos.x64-11.2.0.4.0.zip
    sudo unzip instantclient-sdk-macos.x64-11.2.0.4.0.zip
    sudo unzip instantclient-sqlplus-macos.x64-11.2.0.4.0.zip
    
  2. or download this
    cd instantclient_11_2
    sudo mkdir network
    sudo mkdir network/admin
    
  3. or download this
      ORCL =
      (DESCRIPTION =
    ...
          (SERVICE_NAME = SID)
        )
      )
    
  4. or download this
    ORACLE_HOME=/Library/Oracle/instantclient_11_2
    DYLD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:/Library/Oracle/instantclient_11_
    +2
    ...
    export TNS_ADMIN
    export PATH
    export CLASSPATH
    
  5. or download this
    # required for the Oracle Client
    
    ...
    else
        setenv CLASSPATH $ORACLE_HOME
    endif
    
  6. or download this
    [~] sqlplus -v
    
    SQL*Plus: Release 11.2.0.4.0 Production
    
    [~]
    
  7. or download this
    dyld: Library not loaded: /ade/dosulliv_sqlplus_mac/oracle/sqlplus/lib
    +/libsqlplus.dylib
      Referenced from: /Users/sandy/Downloads/instantclient_11_2/sqlplus
      Reason: image not found
    
  8. or download this
    [~] sudo cpan
    Password:
    ...
    Enter 'h' for help.
    
    cpan[1]> install DBI
    
  9. or download this
    gunzip DBD-Oracle-1.75_2.tar.gz
    tar -xvf DBD-Oracle-1.75_2.tar
    cd DBD-Oracle-1.75_2
    
  10. or download this
    [~/Downloads/DBD-Oracle-1.75_2] perl Makefile.PL
    
    [... deleted stuff ...]
    ...
            
    [... more deleted errors ...]
    
  11. or download this
    #!/bin/sh
    # script to change the dynamic lib paths and ids for oracle instant cl
    +ient
    ...
        done
    done
    
  12. or download this
    [/Library/Oracle/instantclient_11_2] sudo bash ~/myScrips//fix_dyld.sh
    + 
    Password:
    ...
    
    [... deleted stuff...]
    
  13. or download this
    [~/Downloads/DBD-Oracle-1.75_2] sudo perl Makefile.PL
    Password:
    ...
    Writing Makefile for DBD::Oracle
    Writing MYMETA.yml and MYMETA.json
    
  14. or download this
    [~/Downloads/DBD-Oracle-1.75_2] make
    cp lib/DBD/Oracle/Object.pm blib/lib/DBD/Oracle/Object.pm
    ...
    Manifying blib/man3/DBD::Oracle::Object.3pm
    Manifying blib/man3/DBD::Oracle::Troubleshooting::Win32.3pm
    
  15. or download this
    [~/Downloads/DBD-Oracle-1.75_2] make test
    PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_h
    +arness(0, 'blib/lib', 'blib/arch')" t/*.t
    ...
    
    [... more errors ...]
    
  16. or download this
    sudo install_name_tool -change libclntsh.dylib.11.1 /Library/Oracle/in
    +stantclient_11_2/libclntsh.dylib.11.1 
    /Users/sandy/Downloads/DBD-Oracle-1.75_2/blib/arch/auto/DBD/Oracle/Ora
    +cle.bundle
    
  17. or download this
    [~/Downloads/DBD-Oracle-1.75_2] make test
    PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_h
    +arness(0, 'blib/lib', 'blib/arch')" t/*.t
    ...
    All tests successful.
    Files=38, Tests=9,  8 wallclock secs ( 0.11 usr  0.06 sys +  6.33 cusr
    +  0.96 csys =  7.46 CPU)
    Result: PASS
    
  18. or download this
    sudo make install
    
  19. or download this
    [~/Downloads] cat test_connection.pl 
    #!/usr/bin/perl
    ...
    [~/Downloads] perl test_connection.pl 
    [~/Downloads]
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perltutorial [id://1156743]
help
Chatterbox?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (9)
As of 2017-10-21 09:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My fridge is mostly full of:

















    Results (269 votes). Check out past polls.

    Notices?