How do you install perl DBD::Oracle on OSX Snow Leopard 10.6 -

-

i'm trying connect oracle 10.2.0.4 on remote system intel mac running osx 10.6 snow leopard. i've tried using perl cpan install dbd::oracle (dbi worked ok) compilation errors. provide easy follow guide?

getting mac install of perl play nicely oracle bit of pain - once it's running fantastic, getting running little frustrating..

the below has worked me on few different intel macs, there superfluous steps in there , not going same other platforms.

this require use of shell, root user , bit of cpaning - nothing onerous

first off create directory oracle pap - libraries, instant client etc

sudo mkdir /usr/oracle_instantclient64

download , extract 64 bit instant client packages oracle above directory

create symlink within directory 1 of files in there

sudo cd /usr/oracle_instantclient64 sudo ln -s /usr/oracle_instantclient64/libclntsh.dylib.10.1 libclntsh.dylib

the following dir hardcoded oracle instant client - god knows why - need create , symlink it

sudo mkdir -p /b/227/rdbms/ sudo cd /b/227/rdbms/ sudo ln -s /usr/oracle_instantclient64/ lib

need add couple of environment variables, edit /etc/profile , add them exist users:

export oracle_home=/usr/oracle_instantclient64 export dyld_library_path=/usr/oracle_instantclient64

now try , install dbd::oracle through cpan - fail, means dependencies downloaded , retrieves module us

sudo perl -mcpan -e shell install dbd::oracle

when fails exit cpan , head .cpan/build dir - if used automatic config of cpan it'll be

cd ~/.cpan/build

if didn't auto configure can find build directory following command in cpan

o conf build_dir

once in build dir dbd::oracle dir has been created (it'll called dbd-oracle-1.28-?) , cd it.

now need switch root user. root isn't enabled default in osx - details on enabling see post on apple website

once logged in root need set above environment variables root:

export oracle_home=/usr/oracle_instantclient64 export dyld_library_path=/usr/oracle_instantclient64

now while still logged in root need run makefile module, make, install

perl makefile.pl make make install

assuming worked without error log out of root: we're dbd'd up! if didn't work it's time bust out google on whatever errors you're seeing

now install dbi module

sudo perl -mcpan -e shell install dbi

now you're set - enjoy perly oracley new life

additional info user852637:

  1. correction step

    perl makefile.pl make install

    the last step should make install

  2. during make, may encounter error looks :

    lipo: can't open input file: /var/tmp//ccievtzm.out (no such file or directory)

    to correct must edit file "makefile" created after "perl makefile.pl" step , remove occurrences of following text :

    -arch ppc

    this eliminate error.

  3. the same error described in (2.) occur during installation of dbi module. must edit makefile created after perl makefile.pl step , remove occurrences of following text :

    -arch ppc

Comments

Post a Comment

Popular posts from this blog

Cursor error with postgresql, pgpool and php -

-
hey, struggling bit determine exact cause of error has been popping in our release environment. there not seem dealing particular error on google. this error message getting: sqlstate[34000]: invalid cursor name: 7 error: portal "" not exist the error pops when using pdo prepared statements. this setup our release environment: pgpool 3.0.1 (the postgresql backend in streaming replication mode!) php 5.3.5 postgresql 9.0 edit: architecture 64bit. the same error not manifest in our test environment (edit: forgot mention, standard test environment uses postgresql 9.0 without pgpool). thus, led suspect pgpool @ least partly suspect. does know probable causes error are? edit: ok, here example of kind of code causes error. $sql = 'select * '; $sql .= 'from "mytable" "mystuff" '; $sql .= 'where "mytable"."status" = 1 '; $sql .= 'and "mytable"."mytableid" = :table...
Read more

delphi - ESC/P programming! -

-
why need use because printers using tprinter prints weird hieroglyph @ beginning of printable area. my problem if send commands, nothing happens. esc e (#27 #69) - sending escape sequence didn't work expected. removed first letter , rest of string made bold. eg. hello -> ello . after changed esc e esc (#27 #69 #27), worked fine. example managed figure out, but... trying select character table "esc t n" (#27 #116 n), make "õäöü" work. command doesn't work. nothing happens! , command supported esc/p, esc/p 2 , 9-pin esc/p, should work fine. manual can found here . if has ever needed use esc/p commands maybe 1 can shed light how work them! thanks in advance! edit: in previous post asked more or less same question though answers how did send commands printer. (i'll change question there according answers!) i accepted ken's answer, because claimed way transferred commands wasn't best , got work escape command. problem after t...
Read more

c++ - error: use of deleted function -

-
i've been working on c++ code friend has written , following error have never seen before when compiling gcc4.6: error: use of deleted function ‘gamefsm_<std::array<c, 2ul> >::hdealt::hdealt()’ implicitly deleted because default definition ill-formed: uninitialized non-static const member ‘const h_t floppokergamefsm_<std::array<c, 2ul> >::hdealt::h’ edit: comes part of code using boost msm: boost webpage edit2: there no = delete() used anywhere in sourcecode. generally speaking, error mean? should looking when type of error occurs? i don't think other answers mentioning =deleted; syntax correct. error message says default constructor has been deleted implicitly . says why: class contains non-static, const variable, not initialized default ctor. class x { const int x; }; since x::x const , must initialized -- default ctor wouldn't initialize (because it's pod type). therefore, default ctor, need define 1 (and must ...
Read more