Page 1 of 1

Oracle Issue

Posted: Sun Sep 13, 2015 2:08 pm
by Mike
Hello Team,

We have followed the oracle documtation properly and we are getting last error mentioned in the document.
Also followed the last three steps
I.e export HOME LIBRARY
EXPORT ***** Library
Cpan -I ODB::ORACLE.

But we are getting following error after some time...




CPAN.pm: Going to build P/PY/PYTHIAN/DBD-Oracle-1.74.tar.gz

Multiple copies of Driver.xst found in: /usr/local/lib64/perl5/auto/DBI/ /usr/lib64/perl5/vendor_perl/auto/DBI/ at Makefile.PL line 39
Using DBI 1.634 (for perl 5.010001 on x86_64-linux-thread-multi) installed in /usr/local/lib64/perl5/auto/DBI/

Configuring DBD::Oracle for perl 5.010001 on linux (x86_64-linux-thread-multi)

Remember to actually *READ* the README file! Especially if you have any problems.

Installing on a linux, Ver#2.6
Using Oracle in /usr/lib/oracle/12.1/client64
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

            If sqlplus failed due to a linker/symbol/relocation/library error or similar problem
            then it's likely that you've not configured your environment correctly.
            Specifically, your LD_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 INSTALLDIRS=site]
  PYTHIAN/DBD-Oracle-1.74.tar.gz
  /usr/bin/perl Makefile.PL INSTALLDIRS=site -- NOT OK
Running make test
  Make had some problems, won't test
Running make install
  Make had some problems, won't install
Failed during this command:
 PYTHIAN/DBD-Oracle-1.74.tar.gz               : writemakefile NO '/usr/bin/perl Makefile.PL INSTALLDIRS=site' returned status 512

cpan[2]> ^CCaught SIGINT, trying to continue
^CGot another SIGINTTerminal does not support GetHistory.
Lockfile removed.

You have new mail in /var/spool/mail/root
[root@DOHQDNAG02 bin]# cd /usr/lib/oracle/12.1/client64/bin/


Note: We are using proxy setting for internet access.

Thank you advance...

Re: Oracle Issue

Posted: Mon Sep 14, 2015 3:55 pm
by tgriep
I think there is a issue with installing the 12.2 Oracle 12.2 client.
Can you try again with the 11.2 client?

I also found this for running CPAN behind a proxy server. Take a look at it.
http://stackoverflow.com/questions/1154 ... init-proxy