The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
How to install Oracle driver for DBI module on OS X 10.7 ?
I am having trouble installing DBD on OS X 10.7.
Installation from - cpan DBD::Oracle - produces the following errors.
How can I fix this?
Trying to find an ORACLE_HOME
Found /Library/Oracle/instantcli
WARNING: Setting ORACLE_HOME env var to /Library/Oracle/instantcli
WARNING: If these tests fail you may have to set ORACLE_HOME yourself!
Installing on a darwin, Ver#12.0
Using Oracle in /Library/Oracle/instantcli
Use of uninitialized value $sqlplus_release in pattern match (m//) at Makefile.PL line 1626.
Use of uninitialized value $sqlplus_release in print at Makefile.PL line 1635.
Use of uninitialized value $sqlplus_release in pattern match (m//) at Makefile.PL line 1636.
If sqlplus failed due to a linker/symbol/relocation/l
then it's likely that you've not configured your environment correctly.
Specifically, your DYLD_LIBRARY_PATH environment variable
set to include the directory containing the Oracle libraries.
I'm having trouble finding your Oracle version number... trying harder
WARNING: I could not determine Oracle client version so I'll just
default to version 8.0.0.0. Some features of DBD::Oracle may not work.
Oracle version based logic in Makefile.PL may produce erroneous results.
You can use "perl Makefile.PL -V X.Y.Z" to specify a your client version.
Oracle version 8.0.0.0 (8.0)
DBD::Oracle no longer supports Oracle client versions before 9.2
Try a version before 1.25 for 9 and 1.18 for 8! at Makefile.PL line 271.
Warning: No success on command[/usr/bin/perl Makefile.PL]
PYTHIAN/DBD-Oracle-1.68.ta
/usr/bin/perl Makefile.PL -- NOT OK
Running make test
Make had some problems, won't test
Running make install
Make had some problems, won't install
Installation from - cpan DBD::Oracle - produces the following errors.
How can I fix this?
Trying to find an ORACLE_HOME
Found /Library/Oracle/instantcli
WARNING: Setting ORACLE_HOME env var to /Library/Oracle/instantcli
WARNING: If these tests fail you may have to set ORACLE_HOME yourself!
Installing on a darwin, Ver#12.0
Using Oracle in /Library/Oracle/instantcli
Use of uninitialized value $sqlplus_release in pattern match (m//) at Makefile.PL line 1626.
Use of uninitialized value $sqlplus_release in print at Makefile.PL line 1635.
Use of uninitialized value $sqlplus_release in pattern match (m//) at Makefile.PL line 1636.
If sqlplus failed due to a linker/symbol/relocation/l
then it's likely that you've not configured your environment correctly.
Specifically, your DYLD_LIBRARY_PATH environment variable
set to include the directory containing the Oracle libraries.
I'm having trouble finding your Oracle version number... trying harder
WARNING: I could not determine Oracle client version so I'll just
default to version 8.0.0.0. Some features of DBD::Oracle may not work.
Oracle version based logic in Makefile.PL may produce erroneous results.
You can use "perl Makefile.PL -V X.Y.Z" to specify a your client version.
Oracle version 8.0.0.0 (8.0)
DBD::Oracle no longer supports Oracle client versions before 9.2
Try a version before 1.25 for 9 and 1.18 for 8! at Makefile.PL line 271.
Warning: No success on command[/usr/bin/perl Makefile.PL]
PYTHIAN/DBD-Oracle-1.68.ta
/usr/bin/perl Makefile.PL -- NOT OK
Running make test
Make had some problems, won't test
Running make install
Make had some problems, won't install
Asked:
10-
10
-
3
1 Solution
I have never seen Perl linked with instant client. It may be possible, but I haven't tried it. Based on the messages, it seems to be looking for SQL*Plus. Did you download and install that part of instant client? It is a separate file that you need to download. To me it seems like that is the first part of the error. After you have that, see what happens.
I downloaded instantclient_11_2
( Client Shared Library 64-bit - 11.2.0.3.0)
The value of DYLD_LIBRARY_PATH is
/usr/local/oracle/instantc
( Client Shared Library 64-bit - 11.2.0.3.0)
The value of DYLD_LIBRARY_PATH is
/usr/local/oracle/instantc
Try setting DYLD_LIBRARY_PATH to /Library/Oracle/instantcli
>>Client Shared Library
I don't see that file:
http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html
>>Client Shared Library
I don't see that file:
http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html
Thanks. Set DYLD_LIBRARY_PATH to /Library/Oracle/instantcli
and downloaded all files. Got the same error.
The contents of /Library/Oracle/instantcli
BASIC_LITE_README
glogin.sql
libocci.dylib
libsqlplus.dylib uidrvci
SQLPLUS_README
libclntsh.dylib
libocci.dylib.11.1
libsqlplusic.dylib
xstreams.jar
adrci l
ibclntsh.dylib.11.1
libociicus.dylib ojdbc5.jar
genezi
libnnz11.dylib
libocijdbc11.dylib
ojdbc6.jar
and downloaded all files. Got the same error.
The contents of /Library/Oracle/instantcli
BASIC_LITE_README
glogin.sql
libocci.dylib
libsqlplus.dylib uidrvci
SQLPLUS_README
libclntsh.dylib
libocci.dylib.11.1
libsqlplusic.dylib
xstreams.jar
adrci l
ibclntsh.dylib.11.1
libociicus.dylib ojdbc5.jar
genezi
libnnz11.dylib
libocijdbc11.dylib
ojdbc6.jar
I would check 2 things. First can you run SQL*Plus from the client? Second, is the SQL*Plus executable on the PATH?
Thanks - I found a typo in the .bash_profile for the Oracle path.
SQL*PLUS will now run from the client, eliminating the first install error.
There is a second error -
dyld: Library not loaded: /ade/b/1891624078/oracle/s
The full error message is:
Using Oracle in /Library/Oracle/instantcli
dyld: Library not loaded: /ade/b/1891624078/oracle/s
Referenced from: /Library/Oracle/instantcli
Reason: image not found
If sqlplus failed due to a linker/symbol/relocation/l
then it's likely that you've not configured your environment correctly.
Specifically, your DYLD_LIBRARY_PATH environment variable
set to include the directory containing the Oracle libraries.
I'm having trouble finding your Oracle version number... trying harder
WARNING: I could not determine Oracle client version so I'll just
default to version 8.0.0.0. Some features of DBD::Oracle may not work.
Oracle version based logic in Makefile.PL may produce erroneous results.
You can use "perl Makefile.PL -V X.Y.Z" to specify a your client version.
Oracle version 8.0.0.0 (8.0)
DBD::Oracle no longer supports Oracle client versions before 9.2
Try a version before 1.25 for 9 and 1.18 for 8! at Makefile.PL line 271.
Warning: No success on command[/usr/bin/perl Makefile.PL]
PYTHIAN/DBD-Oracle-1.68.ta
/usr/bin/perl Makefile.PL -- NOT OK
Running make test
Make had some problems, won't test
Running make install
Make had some problems, won't install
SQL*PLUS will now run from the client, eliminating the first install error.
There is a second error -
dyld: Library not loaded: /ade/b/1891624078/oracle/s
The full error message is:
Using Oracle in /Library/Oracle/instantcli
dyld: Library not loaded: /ade/b/1891624078/oracle/s
Referenced from: /Library/Oracle/instantcli
Reason: image not found
If sqlplus failed due to a linker/symbol/relocation/l
then it's likely that you've not configured your environment correctly.
Specifically, your DYLD_LIBRARY_PATH environment variable
set to include the directory containing the Oracle libraries.
I'm having trouble finding your Oracle version number... trying harder
WARNING: I could not determine Oracle client version so I'll just
default to version 8.0.0.0. Some features of DBD::Oracle may not work.
Oracle version based logic in Makefile.PL may produce erroneous results.
You can use "perl Makefile.PL -V X.Y.Z" to specify a your client version.
Oracle version 8.0.0.0 (8.0)
DBD::Oracle no longer supports Oracle client versions before 9.2
Try a version before 1.25 for 9 and 1.18 for 8! at Makefile.PL line 271.
Warning: No success on command[/usr/bin/perl Makefile.PL]
PYTHIAN/DBD-Oracle-1.68.ta
/usr/bin/perl Makefile.PL -- NOT OK
Running make test
Make had some problems, won't test
Running make install
Make had some problems, won't install
Sorry. I was typing when you posted.
Well, does libsqlplus.dylib exist? Are you sure you downloaded the sqlplus add on when you "downloaded all files". Did you unziup it?
Well, does libsqlplus.dylib exist? Are you sure you downloaded the sqlplus add on when you "downloaded all files". Did you unziup it?
Thanks, the sqlplus addon is in the folder:
/Library/Oracle/instantcli
It contains:
SQLPLUS_README
lib
libsqlplusic.dylib
glogin.sql
libsqlplus.dylib
sqlplus
The error seems to be referring to a missing folder:
/ade/b/1891624078/oracle/s
/Library/Oracle/instantcli
It contains:
SQLPLUS_README
lib
libsqlplusic.dylib
glogin.sql
libsqlplus.dylib
sqlplus
The error seems to be referring to a missing folder:
/ade/b/1891624078/oracle/s
Add /Library/Oracle/instantcli
The /ade looks like a bogus error message likely from not having ORACLE_HOME set properly. Look at the following errors that actually have your folder.
You can probably get around it by setting ORACLE_HOME to /Library/Oracle/instantcli
The /ade looks like a bogus error message likely from not having ORACLE_HOME set properly. Look at the following errors that actually have your folder.
You can probably get around it by setting ORACLE_HOME to /Library/Oracle/instantcli
Got farther, but still errors:
Installing on a darwin, Ver#12.0
Using Oracle in /Library/Oracle/instantcli
DEFINE _SQLPLUS_RELEASE = "1102000300" (CHAR)
Oracle version 11.2.0.3 (11.2)
Looks like an Instant Client installation, okay
Your DYLD_LIBRARY_PATH env var is set to ''
WARNING: Your DYLD_LIBRARY_PATH env var doesn't include '/Library/Oracle/instantcl
Oracle sysliblist:
**************************
I can't find the header files I need in your Oracle installation.
You probably need to install some more Oracle components.
For Instant Client that means the SDK package.
I'll keep going, but the compile will probably fail.
See the appropriate README file for your OS for more information.
**************************
client_version=11.2
DEFINE= -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0
Checking for functioning wait.ph
System: perl5.012004 darwin b1026.apple.com 12.0 darwin kernel version 12.0.0: tue may 15 23:31:29 pdt 2012; root:xnu-2050.6.70~1releas
Compiler: clang -Os -arch i386 -arch x86_64 -g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing -fstack-protector -I/usr/local/include
Linker: /usr/bin/ld
Sysliblist:
Linking with -lclntsh.
Checking if your kit is complete...
Looks good
LD_RUN_PATH=/Library/Oracl
Using DBD::Oracle 1.68.
Using DBD::Oracle 1.68.
Multiple copies of Driver.xst found in: /Library/Perl/5.12/darwin-
Using DBI 1.631 (for perl 5.012004 on darwin-thread-multi-2level
Generating a Unix-style Makefile
Writing Makefile for DBD::Oracle
Writing MYMETA.yml and MYMETA.json
*** If you have problems...
read all the log printed above, and the README and README.help.txt files.
(Of course, you have read README by now anyway, haven't you?)
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle.pm blib/lib/DBD/Oracle.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInf
cp lib/DBD/Oracle/Troubleshoo
cp dbdimp.h blib/arch/auto/DBD/Oracle/
cp ocitrace.h blib/arch/auto/DBD/Oracle/
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Object.pm blib/lib/DBD/Oracle/Object
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp mk.pm blib/arch/auto/DBD/Oracle/
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" /Library/Perl/5.12/darwin-
/usr/bin/perl /System/Library/Perl/5.12/
clang -c -I/Library/Perl/5.12/darwi
In file included from Oracle.xs:1:
./Oracle.h:37:10: fatal error: 'oci.h' file not found
#include <oci.h>
^
1 error generated.
make: *** [Oracle.o] Error 1
PYTHIAN/DBD-Oracle-1.68.ta
/usr/bin/make -- NOT OK
Running make test
Can't test without successful make
Running make install
Make had returned bad status, install seems impossible
Installing on a darwin, Ver#12.0
Using Oracle in /Library/Oracle/instantcli
DEFINE _SQLPLUS_RELEASE = "1102000300" (CHAR)
Oracle version 11.2.0.3 (11.2)
Looks like an Instant Client installation, okay
Your DYLD_LIBRARY_PATH env var is set to ''
WARNING: Your DYLD_LIBRARY_PATH env var doesn't include '/Library/Oracle/instantcl
Oracle sysliblist:
**************************
I can't find the header files I need in your Oracle installation.
You probably need to install some more Oracle components.
For Instant Client that means the SDK package.
I'll keep going, but the compile will probably fail.
See the appropriate README file for your OS for more information.
**************************
client_version=11.2
DEFINE= -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0
Checking for functioning wait.ph
System: perl5.012004 darwin b1026.apple.com 12.0 darwin kernel version 12.0.0: tue may 15 23:31:29 pdt 2012; root:xnu-2050.6.70~1releas
Compiler: clang -Os -arch i386 -arch x86_64 -g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing -fstack-protector -I/usr/local/include
Linker: /usr/bin/ld
Sysliblist:
Linking with -lclntsh.
Checking if your kit is complete...
Looks good
LD_RUN_PATH=/Library/Oracl
Using DBD::Oracle 1.68.
Using DBD::Oracle 1.68.
Multiple copies of Driver.xst found in: /Library/Perl/5.12/darwin-
Using DBI 1.631 (for perl 5.012004 on darwin-thread-multi-2level
Generating a Unix-style Makefile
Writing Makefile for DBD::Oracle
Writing MYMETA.yml and MYMETA.json
*** If you have problems...
read all the log printed above, and the README and README.help.txt files.
(Of course, you have read README by now anyway, haven't you?)
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle.pm blib/lib/DBD/Oracle.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInf
cp lib/DBD/Oracle/Troubleshoo
cp dbdimp.h blib/arch/auto/DBD/Oracle/
cp ocitrace.h blib/arch/auto/DBD/Oracle/
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Object.pm blib/lib/DBD/Oracle/Object
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp mk.pm blib/arch/auto/DBD/Oracle/
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" /Library/Perl/5.12/darwin-
/usr/bin/perl /System/Library/Perl/5.12/
clang -c -I/Library/Perl/5.12/darwi
In file included from Oracle.xs:1:
./Oracle.h:37:10: fatal error: 'oci.h' file not found
#include <oci.h>
^
1 error generated.
make: *** [Oracle.o] Error 1
PYTHIAN/DBD-Oracle-1.68.ta
/usr/bin/make -- NOT OK
Running make test
Can't test without successful make
Running make install
Make had returned bad status, install seems impossible
Look at:
(sorry for making you remove it)
"WARNING: Your DYLD_LIBRARY_PATH env var doesn't include '/Library/Oracle/instantcl
and
"./Oracle.h:37:10: fatal error: 'oci.h' file not found"
Do you have an oci.h under /Library/Oracle/instantcli
(sorry for making you remove it)
"WARNING: Your DYLD_LIBRARY_PATH env var doesn't include '/Library/Oracle/instantcl
and
"./Oracle.h:37:10: fatal error: 'oci.h' file not found"
Do you have an oci.h under /Library/Oracle/instantcli
Here is my .bash_profile.
Are there path errors here?
DYLD_LIBRARY_PATH=$DYLD_LI
TNS_ADMIN=/Library/Oracle/
PATH=$PATH:/Library/Oracle
CLASSPATH=$CLASSPATH:$ORAC
export DYLD_LIBRARY_PATH
export TNS_ADMIN
export PATH
export CLASSPATH
export ORACLE_HOME=/Library/Oracl
export LD_LIBRARY_PATH=$ORACLE_HO
export PATH=$ORACLE_HOME/bin:$PAT
Are there path errors here?
DYLD_LIBRARY_PATH=$DYLD_LI
TNS_ADMIN=/Library/Oracle/
PATH=$PATH:/Library/Oracle
CLASSPATH=$CLASSPATH:$ORAC
export DYLD_LIBRARY_PATH
export TNS_ADMIN
export PATH
export CLASSPATH
export ORACLE_HOME=/Library/Oracl
export LD_LIBRARY_PATH=$ORACLE_HO
export PATH=$ORACLE_HOME/bin:$PAT
Make it just:
export ORACLE_HOME=/Library/Oracl
Based on that change, you might need to tweak:
export LD_LIBRARY_PATH=$ORACLE_HO
But right now I'm not sure how.
My Unix is VERY rusty and my OSX is non-existent.
Were you able to locate a file oci.h somewhere under /Library/Oracle/instantcli
export ORACLE_HOME=/Library/Oracl
Based on that change, you might need to tweak:
export LD_LIBRARY_PATH=$ORACLE_HO
But right now I'm not sure how.
My Unix is VERY rusty and my OSX is non-existent.
Were you able to locate a file oci.h somewhere under /Library/Oracle/instantcli
Thanks. The updated paths were changed in the .bash_profile
oci.h is not on the system according to "locate".
Still producing an error:
CPAN.pm: Going to build P/PY/PYTHIAN/DBD-Oracle-1.
Multiple copies of Driver.xst found in: /Library/Perl/5.12/darwin-
Using DBI 1.631 (for perl 5.012004 on darwin-thread-multi-2level
Configuring DBD::Oracle for perl 5.012004 on darwin (darwin-thread-multi-2leve
Remember to actually *READ* the README file! Especially if you have any problems.
Trying to find an ORACLE_HOME
Found /Library/Oracle/instantcli
WARNING: Setting ORACLE_HOME env var to /Library/Oracle/instantcli
WARNING: If these tests fail you may have to set ORACLE_HOME yourself!
Installing on a darwin, Ver#12.0
Using Oracle in /Library/Oracle/instantcli
DEFINE _SQLPLUS_RELEASE = "1102000300" (CHAR)
Oracle version 11.2.0.3 (11.2)
Looks like an Instant Client installation, okay
Your DYLD_LIBRARY_PATH env var is set to ''
WARNING: Your DYLD_LIBRARY_PATH env var doesn't include '/Library/Oracle/instantcl
Oracle sysliblist:
**************************
I can't find the header files I need in your Oracle installation.
You probably need to install some more Oracle components.
For Instant Client that means the SDK package.
I'll keep going, but the compile will probably fail.
See the appropriate README file for your OS for more information.
**************************
client_version=11.2
DEFINE= -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0
Checking for functioning wait.ph
System: perl5.012004 darwin b1026.apple.com 12.0 darwin kernel version 12.0.0: tue may 15 23:31:29 pdt 2012; root:xnu-2050.6.70~1releas
Compiler: clang -Os -arch i386 -arch x86_64 -g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing -fstack-protector -I/usr/local/include
Linker: /usr/bin/ld
Sysliblist:
Linking with -lclntsh.
Checking if your kit is complete...
Looks good
LD_RUN_PATH=/Library/Oracl
Using DBD::Oracle 1.68.
Using DBD::Oracle 1.68.
Multiple copies of Driver.xst found in: /Library/Perl/5.12/darwin-
Using DBI 1.631 (for perl 5.012004 on darwin-thread-multi-2level
Generating a Unix-style Makefile
Writing Makefile for DBD::Oracle
Writing MYMETA.yml and MYMETA.json
*** If you have problems...
read all the log printed above, and the README and README.help.txt files.
(Of course, you have read README by now anyway, haven't you?)
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle.pm blib/lib/DBD/Oracle.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInf
cp lib/DBD/Oracle/Troubleshoo
cp dbdimp.h blib/arch/auto/DBD/Oracle/
cp ocitrace.h blib/arch/auto/DBD/Oracle/
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Object.pm blib/lib/DBD/Oracle/Object
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp mk.pm blib/arch/auto/DBD/Oracle/
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" /Library/Perl/5.12/darwin-
/usr/bin/perl /System/Library/Perl/5.12/
clang -c -I/Library/Perl/5.12/darwi
In file included from Oracle.xs:1:
./Oracle.h:37:10: fatal error: 'oci.h' file not found
#include <oci.h>
^
1 error generated.
make: *** [Oracle.o] Error 1
PYTHIAN/DBD-Oracle-1.68.ta
/usr/bin/make -- NOT OK
Running make test
Can't test without successful make
Running make install
Make had returned bad status, install seems impossible
oci.h is not on the system according to "locate".
Still producing an error:
CPAN.pm: Going to build P/PY/PYTHIAN/DBD-Oracle-1.
Multiple copies of Driver.xst found in: /Library/Perl/5.12/darwin-
Using DBI 1.631 (for perl 5.012004 on darwin-thread-multi-2level
Configuring DBD::Oracle for perl 5.012004 on darwin (darwin-thread-multi-2leve
Remember to actually *READ* the README file! Especially if you have any problems.
Trying to find an ORACLE_HOME
Found /Library/Oracle/instantcli
WARNING: Setting ORACLE_HOME env var to /Library/Oracle/instantcli
WARNING: If these tests fail you may have to set ORACLE_HOME yourself!
Installing on a darwin, Ver#12.0
Using Oracle in /Library/Oracle/instantcli
DEFINE _SQLPLUS_RELEASE = "1102000300" (CHAR)
Oracle version 11.2.0.3 (11.2)
Looks like an Instant Client installation, okay
Your DYLD_LIBRARY_PATH env var is set to ''
WARNING: Your DYLD_LIBRARY_PATH env var doesn't include '/Library/Oracle/instantcl
Oracle sysliblist:
**************************
I can't find the header files I need in your Oracle installation.
You probably need to install some more Oracle components.
For Instant Client that means the SDK package.
I'll keep going, but the compile will probably fail.
See the appropriate README file for your OS for more information.
**************************
client_version=11.2
DEFINE= -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0
Checking for functioning wait.ph
System: perl5.012004 darwin b1026.apple.com 12.0 darwin kernel version 12.0.0: tue may 15 23:31:29 pdt 2012; root:xnu-2050.6.70~1releas
Compiler: clang -Os -arch i386 -arch x86_64 -g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing -fstack-protector -I/usr/local/include
Linker: /usr/bin/ld
Sysliblist:
Linking with -lclntsh.
Checking if your kit is complete...
Looks good
LD_RUN_PATH=/Library/Oracl
Using DBD::Oracle 1.68.
Using DBD::Oracle 1.68.
Multiple copies of Driver.xst found in: /Library/Perl/5.12/darwin-
Using DBI 1.631 (for perl 5.012004 on darwin-thread-multi-2level
Generating a Unix-style Makefile
Writing Makefile for DBD::Oracle
Writing MYMETA.yml and MYMETA.json
*** If you have problems...
read all the log printed above, and the README and README.help.txt files.
(Of course, you have read README by now anyway, haven't you?)
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle.pm blib/lib/DBD/Oracle.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInf
cp lib/DBD/Oracle/Troubleshoo
cp dbdimp.h blib/arch/auto/DBD/Oracle/
cp ocitrace.h blib/arch/auto/DBD/Oracle/
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Object.pm blib/lib/DBD/Oracle/Object
cp lib/DBD/Oracle/Troubleshoo
cp lib/DBD/Oracle/Troubleshoo
cp mk.pm blib/arch/auto/DBD/Oracle/
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" /Library/Perl/5.12/darwin-
/usr/bin/perl /System/Library/Perl/5.12/
clang -c -I/Library/Perl/5.12/darwi
In file included from Oracle.xs:1:
./Oracle.h:37:10: fatal error: 'oci.h' file not found
#include <oci.h>
^
1 error generated.
make: *** [Oracle.o] Error 1
PYTHIAN/DBD-Oracle-1.68.ta
/usr/bin/make -- NOT OK
Running make test
Can't test without successful make
Running make install
Make had returned bad status, install seems impossible
Are you reading the output?
Look at the following:
Even though it found the correct PATH, it is still an issue since you have it in your profile:
Then this, what happened to it?:
MOST important:
Are you sure you have this unzipped (from the link above)?
Instant Client Package - SDK: Additional header files and an example makefile for developing Oracle applications with Instant Client
Download instantclient-sdk-macos.x6
Look at the following:
Even though it found the correct PATH, it is still an issue since you have it in your profile:
WARNING: Setting ORACLE_HOME env var to /Library/Oracle/instantclient_11_2 for you.
WARNING: If these tests fail you may have to set ORACLE_HOME yourself!
Then this, what happened to it?:
Looks like an Instant Client installation, okay
Your DYLD_LIBRARY_PATH env var is set to ''
WARNING: Your DYLD_LIBRARY_PATH env var doesn't include '/Library/Oracle/instantclient_11_2' but probably needs to.
MOST important:
You probably need to install some more Oracle components.
For Instant Client that means the SDK package.
Are you sure you have this unzipped (from the link above)?
Instant Client Package - SDK: Additional header files and an example makefile for developing Oracle applications with Instant Client
Download instantclient-sdk-macos.x6
Thanks!
I added the SDK containing the header files and was able to install with numerous warnings and one failed test. ORACLE_HOME and DYLD_LIBRARY_PATH are set in the .bash_profile but still throw warnings.
However, when I try to use the DBI to connect to Oracle the following error occurs:
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
The dsn string is: dbi:Oracle:host=test.com;s
<pre>install_driver(Oracle
Perhaps the DBD::Oracle perl module hasn't been fully installed,
or perhaps the capitalisation of 'Oracle' isn't right.
I added the SDK containing the header files and was able to install with numerous warnings and one failed test. ORACLE_HOME and DYLD_LIBRARY_PATH are set in the .bash_profile but still throw warnings.
However, when I try to use the DBI to connect to Oracle the following error occurs:
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
The dsn string is: dbi:Oracle:host=test.com;s
<pre>install_driver(Oracle
Perhaps the DBD::Oracle perl module hasn't been fully installed,
or perhaps the capitalisation of 'Oracle' isn't right.
>>ORACLE_HOME and DYLD_LIBRARY_PATH are set in the .bash_profile but still throw warnings.
Then my guess is the .bash_profile isn't getting sourced/executed.
>>install with numerous warnings and one failed test.
If you got a failed test, why would you try to just go ahead and use it?
If you post the install log/output/??? I'll take a look at it and see if anything jumps out at me.
Does Oracle.pm exist somewhere on the machine? From a Google on that message it looks like it is under a perl folder where you installed DBI.
Then my guess is the .bash_profile isn't getting sourced/executed.
>>install with numerous warnings and one failed test.
If you got a failed test, why would you try to just go ahead and use it?
If you post the install log/output/??? I'll take a look at it and see if anything jumps out at me.
Does Oracle.pm exist somewhere on the machine? From a Google on that message it looks like it is under a perl folder where you installed DBI.
Thanks.
Yes, Oracle.pm is in a number of locations:
/System/Library/Perl/Extra
/System/Library/Perl/Extra
/System/Library/Perl/Extra
/System/Library/Perl/Extra
Attached is the install output.
install-output.txt
Yes, Oracle.pm is in a number of locations:
/System/Library/Perl/Extra
/System/Library/Perl/Extra
/System/Library/Perl/Extra
/System/Library/Perl/Extra
Attached is the install output.
install-output.txt
Again, did you go through the install log? Many of the same issues.
>>WARNING: Your DYLD_LIBRARY_PATH env var doesn't include '/Library/Oracle/instantcl
Even though you keep saying the entries are in your bash profile, the installation isn't finding the entries.
Make sure DYLD_LIBRARY_PATH is properly set from the posts above.
>>For Instant Client that means the SDK package.
That one is pretty straight forward... I even mentioned the SDK above and you said you installed it (even after you had previously said you had ALL the files already).
>>/Oracle.h:37:10: fatal error: 'oci.h' file not found
Same error as before.
I'm not going to go through the entire log file you posted if you are just going to keep trying things that repeat the exact same errors as before.
I will gladly try to help as long as you are making process. Having the same errors repeating themselves is not making progress.
When you no longer get the same basic errors mentioned in this post that are repeats of several previous posts, comment back and I'll continue to help.
>>WARNING: Your DYLD_LIBRARY_PATH env var doesn't include '/Library/Oracle/instantcl
Even though you keep saying the entries are in your bash profile, the installation isn't finding the entries.
Make sure DYLD_LIBRARY_PATH is properly set from the posts above.
>>For Instant Client that means the SDK package.
That one is pretty straight forward... I even mentioned the SDK above and you said you installed it (even after you had previously said you had ALL the files already).
>>/Oracle.h:37:10: fatal error: 'oci.h' file not found
Same error as before.
I'm not going to go through the entire log file you posted if you are just going to keep trying things that repeat the exact same errors as before.
I will gladly try to help as long as you are making process. Having the same errors repeating themselves is not making progress.
When you no longer get the same basic errors mentioned in this post that are repeats of several previous posts, comment back and I'll continue to help.
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
What is the value of DYLD_LIBRARY_PATH?