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

Sandy's scratchpad

by Sandy (Curate)
on Jun 01, 2004 at 19:06 UTC ( #358416=scratchpad: 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
Domain Nodelet?
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (4)
As of 2021-11-28 12:12 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?