Re: Perl GD module install error

[Michael Nhan]

Hi,

This is not dbi related error or issue.  But if you look at the error 
given:


Could not find gdlib-config in the search path. Please install libgd 
2.0.28 or higher.


It tells you that you need to install this package/library.  It can't find 
the gdlib-config file that is part of the libgd.



Regards,

Michael



On Wed, 7 Oct 2015, Amjath Kassali wrote:


Date: Wed, 7 Oct 2015 07:24:25 +
From: Amjath Kassali 
To: "dbi-users@perl.org" ,
"dbi-users-h...@perl.org" 
Subject: Perl GD module install error


Hello,

 

We are trying to install perl GD (GD-2.41) module in our application server. We 
detected the error
message is given. Kindly help to advice. How to resolve this error message.

 

perl Makefile.PL

 

Notice: Type perl Makefile.PL -h for command-line option summary.

 

**UNRECOVERABLE ERROR**

Could not find gdlib-config in the search path. Please install libgd 2.0.28 or 
higher.

If you want to try to compile anyway, please rerun this script with the option 
--ignore_missing_gd.

 

Very much appreciated your help. Thanks

 

 

Linux version : Linux dbdacapp01 2.6.32-504.el6.x86_64 #1 SMP Tue Sep 16 
01:56:35 EDT 2014 x86_64
x86_64 x86_64 GNU/Linux

 

[IMAGE]

Amjath Kassali

GIO Singapore Operations – IT Database Support

Singapore Telecommunications Limited

 

T: +65 6555 8743  M: +65 8298 1830

01 Serangoon North Ave 5, #06-00

Singtel Building,Singapore 554915

 

 





--
---//---
Time flies like the wind. Fruit flies like bananas.
--- Groucho Marx

Either write something worth reading or do something worth writing.
--- Benjamin Franklin

A meeting is an event at which the minutes are kept and the hours are lost


This email message is a private communication. The information transmitted, 
including attachments, is intended only for the person or entity to which it is 
addressed and may contain confidential, privileged, and/or proprietary 
material. Any review, duplication, retransmission, distribution, or other use 
of, or taking of any action in reliance upon, this information by persons or 
entities other than the intended recipient is unauthorized by the sender and is 
prohibited. If you have received this message in error, please contact the 
sender immediately by return email and delete the original message from all 
computer systems. Thank you.

RE: DBD::Oracle installation on AIX

[Michael Nhan]

Hi,

Where does your oracle installation reside?  Did you install the oracle 
aix client/aix-instant client?   Is there a libclntsh.so somewhere in 
those paths you listed.  What kind of oracle installation exists on this 
aix box?


regards,

Michael

On Fri, 13 Sep 2013, Manimegalai Visvanathan wrote:


Date: Fri, 13 Sep 2013 12:34:53 -0700
From: Manimegalai Visvanathan mvisvanat...@wsgc.com
To: 'Michael Nhan' mn...@genome.wustl.edu
Cc: 'dbi-users@perl.org' dbi-users@perl.org
Subject: RE: DBD::Oracle installation on AIX

Hi Michael,

Thanks for your reply :)

Can you please let me know, which path I have to export to get the oracle 
libraries? I have tried with /app/oracle/product/11.1.0 but its not accepted. 
Please find the error:

$ perl Makefile.PL
Using DBI 1.628 (for perl 5.008008 on aix-thread-multi) installed in 
/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBI/

Configuring DBD::Oracle for perl 5.008008 on aix (aix-thread-multi)

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

 The ORACLE_HOME environment variable value 
(/app/oracle/6362104/files/jdbc/lib/ojdbc5.jar/oracle) is not valid.
 It must be set to hold the path to an Oracle installation directory
 on this machine (or a machine with a compatible architecture).
 For an Instant Client install, the directory should include an sdk 
subdirectory.
 See the README.clients.txt file for more information.
 ABORTED!



/app/lawson/WebSphere/AppServer/etc/wim/setup/database/oracle
/app/lawson/WebSphere/AppServer/etc/wim/setup/federation/oracle
/app/lawson/WebSphere/AppServer/etc/wim/setup/lookaside/oracle
/app/lawson/WebSphere/hrfindev/AppServer/etc/wim/setup/database/oracle
/app/lawson/WebSphere/hrfindev/AppServer/etc/wim/setup/federation/oracle
/app/lawson/WebSphere/hrfindev/AppServer/etc/wim/setup/lookaside/oracle
/app/lawson/WebSphere/hrfintst/AppServer/etc/wim/setup/database/oracle
/app/lawson/WebSphere/hrfintst/AppServer/etc/wim/setup/federation/oracle
/app/lawson/WebSphere/hrfintst/AppServer/etc/wim/setup/lookaside/oracle
/app/lawson/WebSphere/hrfinuat/AppServer/etc/wim/setup/database/oracle
/app/lawson/WebSphere/hrfinuat/AppServer/etc/wim/setup/federation/oracle
/app/lawson/WebSphere/hrfinuat/AppServer/etc/wim/setup/lookaside/oracle
/app/oracle
/app/oracle/6362104/files/jdbc/lib/ojdbc5.jar/oracle
/app/oracle/6362104/files/jdbc/lib/ojdbc5_g.jar/oracle
/app/oracle/6362104/files/jdbc/lib/ojdbc6.jar/oracle
/app/oracle/6362104/files/jdbc/lib/ojdbc6_g.jar/oracle
/app/oracle/product/11.1.0/.patch_storage/6362104_Dec_20_2007_01_56_03/files/jdbc/lib/ojdbc5.jar/oracle
/app/oracle/product/11.1.0/.patch_storage/6362104_Dec_20_2007_01_56_03/files/jdbc/lib/ojdbc5_g.jar/oracle
/app/oracle/product/11.1.0/.patch_storage/6362104_Dec_20_2007_01_56_03/files/jdbc/lib/ojdbc6.jar/oracle
/app/oracle/product/11.1.0/.patch_storage/6362104_Dec_20_2007_01_56_03/files/jdbc/lib/ojdbc6_g.jar/oracle
/app/oracle/product/11.1.0/.patch_storage/6362104_Dec_20_2007_01_56_03/original_patch/files/jdbc/lib/ojdbc5.jar/oracle
/app/oracle/product/11.1.0/.patch_storage/6362104_Dec_20_2007_01_56_03/original_patch/files/jdbc/lib/ojdbc5_g.jar/oracle
/app/oracle/product/11.1.0/.patch_storage/6362104_Dec_20_2007_01_56_03/original_patch/files/jdbc/lib/ojdbc6.jar/oracle
/app/oracle/product/11.1.0/.patch_storage/6362104_Dec_20_2007_01_56_03/original_patch/files/jdbc/lib/ojdbc6_g.jar/oracle
/app/oracle/product/11.1.0/sqlj/doc/runtime/javadoc/oracle
/app/oracle/product/11.2.0/sqlj/doc/runtime/javadoc/oracle
/home/oracle
/p00b/devgen/oracle

Thanks in Advance :)

Regards,
Manimegalai V
WSI - Unix Support
Williams- Sonoma, Inc.

[Please include itunix24x7supp...@wsgc.com in cc for all your communications]

Please consider the impact to the environment before printing this email

-Original Message-
From: Michael Nhan [mailto:mn...@genome.wustl.edu]
Sent: Friday, September 13, 2013 12:29 PM
To: Manimegalai Visvanathan
Cc: 'dbi-users@perl.org'
Subject: Re: DBD::Oracle installation on AIX

is oracle libraries and installation really in /app/oracle/client/jdk/jre?
oracle library is needed for DBD-Oracle.  Oracle binary is not the same as the 
Java from oracle.  Just making sure you were not confusing the 2.

Michael



On Thu, 12 Sep 2013, Manimegalai Visvanathan wrote:


Date: Thu, 12 Sep 2013 15:13:11 -0700
From: Manimegalai Visvanathan mvisvanat...@wsgc.com
To: 'dbi-users@perl.org' dbi-users@perl.org
Subject: DBD::Oracle installation on AIX


Hi Team,

 

I need one help from you…

 

While installing in DBD::Oracle perl module am facing some challenges. Can you 
please help me to fix that issue.

 

Server OS: AIX

 

Am not able to run the make command:

 

 

$ perl -V

Summary of my perl5 (revision 5 version 8 subversion 8) configuration:

  Platform:

    osname=aix, osvers=5.3.0.0, archname=aix-thread-multi

    uname='aix akash79 3 5 00011a85d600 '

    config_args='-desr -Dinstallprefix=/usr/opt/perl5 -Dprefix=/usr/opt/perl5 
-Dcc

Re: DBD::Oracle installation on AIX

[Michael Nhan]

is oracle libraries and installation really in /app/oracle/client/jdk/jre? 
oracle library is needed for DBD-Oracle.  Oracle binary is not the same as 
the Java from oracle.  Just making sure you were not confusing the 2.


Michael



On Thu, 12 Sep 2013, Manimegalai Visvanathan wrote:


Date: Thu, 12 Sep 2013 15:13:11 -0700
From: Manimegalai Visvanathan mvisvanat...@wsgc.com
To: 'dbi-users@perl.org' dbi-users@perl.org
Subject: DBD::Oracle installation on AIX


Hi Team,

 

I need one help from you…

 

While installing in DBD::Oracle perl module am facing some challenges. Can you 
please help me to fix that issue.

 

Server OS: AIX

 

Am not able to run the make command:

 

 

$ perl -V

Summary of my perl5 (revision 5 version 8 subversion 8) configuration:

  Platform:

    osname=aix, osvers=5.3.0.0, archname=aix-thread-multi

    uname='aix akash79 3 5 00011a85d600 '

    config_args='-desr -Dinstallprefix=/usr/opt/perl5 -Dprefix=/usr/opt/perl5 
-Dcc=xlc_r -Duseshrplib -Dusethreads'

    hint=recommended, useposix=true, d_sigaction=define

    usethreads=define use5005threads=undef useithreads=define 
usemultiplicity=define

    useperlio=define d_sfio=undef uselargefiles=define usesocks=undef

    use64bitint=undef use64bitall=undef uselongdouble=undef

    usemymalloc=n, bincompat5005=undef

  Compiler:

    cc='cc_r', ccflags ='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE 
-qmaxmem=-1 -qnoansialias -DUSE_NATIVE_DLOPEN
-DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong',

    optimize='-O',

    cppflags='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 
-qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT'

    ccversion='9.0.0.2', gccversion='', gccosandvers=''

    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321

    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8

    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', 
lseeksize=8

    alignbytes=8, prototype=define

  Linker and Libraries:

    ld='ld', ldflags =' -brtl -bdynamic -b32'

    libpth=/lib /usr/lib /usr/ccs/lib

    libs=-lbind -lnsl -lgdbm -ldbm -ldb -ldl -lld -lm -lcrypt -lpthreads -lc 
-lbsd

    perllibs=-lbind -lnsl -ldl -lld -lm -lcrypt -lpthreads -lc -lbsd

    libc=, so=a, useshrplib=true, libperl=libperl.a

    gnulibc_version=''

  Dynamic Linking:

    dlsrc=dl_aix.xs, dlext=so, d_dlsymun=undef, ccdlflags='  
-bE:/usr/opt/perl5/lib/5.8.8/aix-thread-multi/CORE/perl.exp'

    cccdlflags=' ', lddlflags='-bhalt:4 -bexpall -G -bnoentry -lpthreads -lc'

 

 

Characteristics of this binary (from libperl):

  Compile-time options: MULTIPLICITY PERL_IMPLICIT_CONTEXT

    PERL_MALLOC_WRAP USE_ITHREADS USE_LARGE_FILES

    USE_PERLIO USE_REENTRANT_API

  Built under aix

  Compiled at Jun  2 2009 16:11:40

  @INC:

    /usr/opt/perl5/lib/5.8.8/aix-thread-multi

    /usr/opt/perl5/lib/5.8.8

    /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi

    /usr/opt/perl5/lib/site_perl/5.8.8

    /usr/opt/perl5/lib/site_perl

    .

 

export ORACLE_HOME=/app/oracle/client/jdk/jre

$ sudo perl Makefile.PL

Using DBI 1.628 (for perl 5.008008 on aix-thread-multi) installed in
/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBI/

 

Configuring DBD::Oracle for perl 5.008008 on aix (aix-thread-multi)

 

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

 

Installing on a aix, Ver#5.3

Using Oracle in /app/oracle/client/jdk/jre

Can't find sqlplus. Pity, it would have helped.

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.

$ sudo make

make: There must be an existing description file or specify a target.

$ sudo make install

make: Cannot find a rule to create target install from dependencies.

Stop.

 

Please help me to fix this issue.

 

Regards,

Manimegalai V

WSI - Unix Support

Williams- Sonoma, Inc.

 





--
---//---
Time flies like the wind. Fruit flies like bananas.
--- Groucho Marx

Either write something worth reading or do something worth writing.
--- Benjamin Franklin

A meeting is an event at which the minutes are kept and the hours are lost


This email message is a private communication. The information transmitted, 
including attachments, is intended only for the person or entity to which it is 
addressed and may contain confidential, privileged, and/or proprietary 
material. Any review, duplication, retransmission, distribution, or other use 
of, or taking of 

Re: Retrieving the CURRENT default database name

[Michael Nhan]

http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database

A simple select database(); returns the current active database.

Does that not do what you want?


michael



On Mon, 22 Oct 2012, Meir Guttman wrote:


Date: Mon, 22 Oct 2012 19:19:24 +0200
From: Meir Guttman m...@guttman.co.il
To: dbi-users@perl.org
Subject: Retrieving the CURRENT default database name

Dear mavens,
My application interacts with a MySQL DBMS. There I am using subroutines and
packages that set the various attributes passed to the DBI connect method.
Also, I later switch databases based on a user's input by executing a USE
'DB_name' SQL statement.
What I am after is a way to debug my application and/or log a particular run
to verify what was actually selected as the default database name at any
given juncture. A bug there might be devastating
Unfortunately, a real SQL maven says
(http://forums.mysql.com/read.php?10,571841,571848) that no SQL statement
exists to retrieve the currently set database.
I searched the web to find a way to do so, without success. Is there a DBI
(or DBD?) way to do so?
Regards
Meir

Re: Problems installing DBI on AIX5

[Michael Nhan]

Can you run make and post the result of that?

Michael

Re: Problems installing DBI on AIX5

[Michael Nhan]

On Fri, 3 Aug 2012, Don Walters wrote:


Date: Fri, 3 Aug 2012 10:34:42 -0500
From: Don Walters donrwalt...@gmail.com
To: dbi-users@perl.org
Subject: Re: Problems installing DBI on AIX5


I don't have an AIX box turned on right now but xlc must support -c (it
means compile but do not link). What does perl -V output? Do you really have
a full AIX compiler installed or is this one of those silly mini compilers.




srvdfj239 / # perl -V
Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
 Platform:
   osname=aix, osvers=5.3.0.0, archname=aix-thread-multi-64all
   uname='aix akash79 3 5 00011a85d600 '
   config_args='-desr -Dinstallprefix=/usr/opt/perl5
-Dprefix=/usr/opt/perl5 -Dcc=xlc_r -Duseshrplib -Dusethreads'
   hint=recommended, useposix=true, d_sigaction=define
   usethreads=define use5005threads=undef useithreads=define
usemultiplicity=define

---snip---

can you do run:
lslpp -l |grep -i xlc
and post the result.  xlc should support the -c options for sure if memory 
serves.  This will show if xlc is installed and the version.


Michael

Re: Issue with DBD:Oracle 1.34 module on 64 bit Linux machine

[Michael Nhan]

kiran,

Sounds like a permission issue with the oracle library.  Make sure the 
library is accessible by the user running the script.  Make sure the 
directory where the library resides and the library itself is accessible 
by the user.  make sure the LD_LIRARY_PATH contains the path the library 
if its not install in the standard library path.


michael



On Fri, 9 Dec 2011, kiran kumar wrote:


Date: Fri, 9 Dec 2011 19:10:50 +0530
From: kiran kumar kirankumar...@gmail.com
To: dbi-users@perl.org
Subject: Issue with DBD:Oracle 1.34 module on 64 bit Linux machine

Hi,



I have installed DBD:Oracle 1.34 module on 64 bit Linux machine with root
user and when I run it root user its working file,

But when I run it using non root user, I am getting the error



“install_driver(Oracle) failed: Can't load
'/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: libclntsh.so.10.1: cannot open shared object file:
No such file or directory at
/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.

at (eval 3) line 3

Compilation failed in require at (eval 3) line 3.

Perhaps a required shared library or dll isn't installed where expected

at ./PreciseMedia_update.pl line 32”



Please help me.



Attached is the list of logs required.



Let me know if further information is required.



Thanks in Advance.


Regards,

Kiran P



--
---//---
Time flies like the wind. Fruit flies like bananas.
--- Groucho Marx

Either write something worth reading or do something worth writing.
--- Benjamin Franklin

A meeting is an event at which the minutes are kept and the hours are lost

Re: How to uninstall DBI

[Michael Nhan]

Get a new version of DBI from cpan, then compile it and install.  it 
should overwrite and update the version that is installed.




On Mon, 10 Oct 2011, Zhao, Yanhong wrote:


Date: Mon, 10 Oct 2011 09:32:54 -0400
From: Zhao, Yanhong yanhong.z...@teradata.com
To: dbi-users@perl.org
Subject: How to uninstall DBI

Hi, All



Is there anybody knows how to uninstall or upgrade DBI on SUSE Linux 10?
It was installed from Source.

Looking forward for your reply.



Thanks.



Zhao Yanhong






--
---//---
Time flies like the wind. Fruit flies like bananas.
--- Groucho Marx

Either write something worth reading or do something worth writing.
--- Benjamin Franklin

A meeting is an event at which the minutes are kept and the hours are lost

Re: Building 32-Bit ONLY Perl on Mac OSX

[Michael Nhan]

Hi,

You are trying to build 32bit application on a 64bit osx.  You will need 
to tell both the compiler and the linker that you want to build 32bit 
apps.  Gcc is easy enough with the -m32 flag.  ld is a little trickier. 
On linux, I have to link using ld -melf_i386 instead of plain ld.   Run 
ld -V to see what emulation modes are available to you.  I don't have a 
64bit macosx to help you.  Building 32bit perl on a 64bit os will require 
you to change the make file to build with gcc -m32 and get the ld to link 
with the proper parameter.  You may have to temporarily move ld to ld.bin 
and make a script that calls ld.bin -melf_i386 (or whatever fits your neeed) 
as ld so it links properly if you can't get the makefile do you what you 
want.


Regards,

Michael



On Tue, 15 Jun 2010, kai.schwerm...@bill-x.de wrote:


Date: Tue, 15 Jun 2010 22:48:54 +0200
From: kai.schwerm...@bill-x.de
To: dbi-users@perl.org
Subject: Building 32-Bit ONLY Perl on Mac OSX

Hi DBI-Users,

my question isn't directly related to DBI, but i need to compile a 386/32
Bit ONLY Perl Binary on Mac OSX 10.6 (SnowLeopard),
not only but also because we only have a 32 Bit Oracle Instant Client...

No Matter what Config-Params i tried, the only thing i get is the
following:

...file was built for i386 which is not the architecture being linked
(x86_64)...

Does anyone have an idea or a good link?

BTW, this problem seems to happen also on 64-Bit Linux...

Thanks in advance for any idea

Kai
--
Kai Schwermann, Geschäftsführer
bill-X GmbH
Möserstr. 34  49074 Osnabrück, Germany
Tel. +49-541-71008-0   Fax +49-541-71008-499
http://www.bill-X.deschwerm...@bill-x.de


--
---//---
Time flies like the wind. Fruit flies like bananas.
--- Groucho Marx

Either write something worth reading or do something worth writing.
--- Benjamin Franklin

A meeting is an event at which the minutes are kept and the hours are lost

Re: Stupid Oracle question

[Michael Nhan]

Hi,

Yes.  Its in the DBI docs.

Michael

On Thu, 6 May 2010, Bruce Johnson wrote:


Date: Thu, 6 May 2010 11:30:59 -0700
From: Bruce Johnson john...@pharmacy.arizona.edu
To: DBI Users Mailing List dbi-users@perl.org
Subject: Stupid Oracle question

If $dbh is my database handle, to roll back the current transaction I do: 
$dbh-rollback(); right?


The DBD::Oracle docs don't explicitly say





--
---//---
Time flies like the wind. Fruit flies like bananas.
--- Groucho Marx

Either write something worth reading or do something worth writing.
--- Benjamin Franklin

A meeting is an event at which the minutes are kept and the hours are lost

Re: Perl 5.6.1 supports DBI module

[Michael Nhan]

Hi,

DBI-1.605 was the last version not to require perl 5.8.  Even though the 
Readme doesn't state it, version 1.606 and newer requires 5.8.10 in the 
Makefile.PL and will not let you create a makefile without some editing of 
the Makefile.PL to ignore that requirement.


Regards,

Michael






On Thu, 18 Mar 2010, Peram, Sudhakara wrote:


Date: Thu, 18 Mar 2010 23:32:26 +0800
From: Peram, Sudhakara sudhakara.pe...@pfizer.com
To: dbi-users@perl.org
Subject: Perl 5.6.1 supports DBI module

Hello All



I am working on Perl 5.6.1 version for my web application. I want to
know whether perl5.6.1 supports the DBI module or not, if it supports
the what is the version of DBI module.



Please let me know the answers.



Thanks in advance.





Regards

Sudhakara Reddy Peram

Desk: +91 - 40 - 30674037

Mobile: +91 - 9618909018






--
---//---
Time flies like the wind. Fruit flies like bananas.
--- Groucho Marx

Either write something worth reading or do something worth writing.
--- Benjamin Franklin

A meeting is an event at which the minutes are kept and the hours are lost

RE: Errors Installing

[Michael Nhan]

Hi,

Try setting your LD_LIBRARY_PATH to include the OH/lib or add the OH/lib 
to the ld.so.conf of your machine.



Can't load
'/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/O
ra cle/Oracle.so' for module DBD::Oracle: libclntsh.so.10.1: cannot
open shared object file: No such file or directory at


since the directory containing the library is accessible to everyone, its 
very likely it doesn't know where to look since OH/lib isn't in the 
standard library path for the compiler/linker.


Michael

Re: Errors Installing

[Michael Nhan]

Hi,

What did you set as ORACLE_HOME and LD_LIBRARY_PATH during your 
compilation?  Did you not do a make test?  Where did you install the full 
oracle client (oracle_home setting)?  Is the 
ORACLE_HOME/lib/libclntsh.so.10.1 read-able by the user running the 
script?


Michael


 On Tue, 22 Sep 2009, MANGISETTY, 
Tilak wrote:



Date: Tue, 22 Sep 2009 16:44:53 +0100
From: MANGISETTY, Tilak tilak.mangise...@oup.com
To: dbi-users@perl.org
Cc: tim.bu...@pobox.com
Subject: Errors Installing 


Hi,

Does DBD-Oracle-1.14.tar.gz supports Oracle 10g
10201_client_linux_x86_64, I have installed this tar file on my Linux
Operating System which running RHEL 5.4, perl version 5.8.8.
Extracted the files then done the following things from the command line
1. perl Makefile.pl
2. make
3. make install

I am getting the following error

Can't load
'/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Ora
cle/Oracle.so' for module DBD::Oracle: libclntsh.so.10.1: cannot open
shared object file: No such file or directory at
/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.
at lib//allscripts.pm line 225
Compilation failed in require at lib//allscripts.pm line 225.
BEGIN failed--compilation aborted at lib//allscripts.pm line 225.
Compilation failed in require at editorial.pl line 27.
BEGIN failed--compilation aborted at editorial.pl line 27.

I will be very thankful if any one can help me out.


Regards,

TILAK MANGISETTY
Operations Analyst
Information Technology Service Delivery
Oxford University Press,
Oxford, UK,  0X2 6DP
Tel: +44(0)1865353854
Mobile:+44(0)7733000703
E-mail:tilak.mangise...@oup.com



Oxford University Press (UK) Disclaimer

This message is confidential. You should not copy it or disclose its contents 
to anyone. You may use and apply the information for the intended purpose only. 
OUP does not accept legal responsibility for the contents of this message. Any 
views or opinions presented are those of the author only and not of OUP. If 
this email has come to you in error, please delete it, along with any 
attachments. Please note that OUP may intercept incoming and outgoing email 
communications.



--
---//---
Time flies like the wind. Fruit flies like bananas.
--- Groucho Marx

Either write something worth reading or do something worth writing.
--- Benjamin Franklin

A meeting is an event at which the minutes are kept and the hours are lost

RE: :Oracle, cursor_sharing, and ORA-01008

[Michael Nhan]

Hi,

Could you be running into bug 5254759 slated to be fixed in 11i?


Regards,

Michael




Date: Wed, 31 Jan 2007 15:45:43 -0700
From: Reidy, Ron [EMAIL PROTECTED]
To: Andrew McFarlane [EMAIL PROTECTED], dbi-users@perl.org
Subject: RE: :Oracle, cursor_sharing, and ORA-01008

Well, first of all, the poster on that forum did not state any reason
why he took that road (did Oracle support suggest this; was there a bug,
etc.), so I would take this with a large grain of salt until that route
is closed.

What version of the Oracle client are you running on your web server?
Is there some sort of incompatibility between the client and 10.2.0.3?
Can you connect via SQL*Plus from that web server?

Is there anything in the 10.2.0.3 release notes that suggest there is an
issue regarding cursor_sharing?

Have you logged an SR with Oracle support?  If not, you probably should.

--
Ron Reidy,
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: Andrew McFarlane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 31, 2007 3:31 PM
To: dbi-users@perl.org
Subject: DBD::Oracle, cursor_sharing, and ORA-01008

I ran into a problem with queries executed on an intranet site.  The web

server was running with Apache on a Windows XP Pro machine using DBI
1.53
and DBD::Oracle 1.19.  The database server was upgraded from Oracle
10.2.0.2
to 10.2.0.3.

As soon as the upgrade happened, all of my queries failed that were
using
bound variables with the error: ORA-01008:  not all variables bound

I found a message on forums.oracle.com (
http://forums.oracle.com/forums/thread.jspa?messageID=1647779#1647779 )

that described the same issue as I was having.  As you can see from that

thread, the resolution was to change the server setting of
cursor_sharing to
EXACT.

Other Oracle clients such as SQL*Plus were able to query the server
successfully before the configuration change was made.

My questions are--why did I have to make the configuration change?  Why
can
SQL*Plus handle the queries but Oracle::DBD 1.19 could not?

Thanks.

Andrew McFarlane

_
Valentine's Day -- Shop for gifts that spell L-O-V-E at MSN Shopping
http://shopping.msn.com/content/shp/?ctId=8323,ptnrid=37,ptnrdata=24095;
tcode=wlmtagline


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.




---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart; 
and, in our own despair, against our will,

 comes wisdom to us by the awful grace of God.
--- Aeschylus

RE: DBD::Oracle-1.19 installation errors

[Michael Nhan]

Hi,

Is the cgi script using the same perl which the new dbd-oracle 1.19 was 
just installed with?  The error suggest that its detecting verion 1.14 
module files when its expecting version 1.19 so dynloader dies due to 
version conflict.  DynaLoader isn't having a problem, its reporting the 
problem.  The problem is that there are version conflict in the 
DBD-Oracle.  There are dbd-oracle 1.14 files in the modules lib along with 
1.19 and its picking up missmatching version.  Locate the version 
conflicted files and update the 1.14 file with the 1.19 ones to get rid of 
the conflict.  The problem file is probably Oracle.so , most likely the 
make install was not able to overwrite it.  Try deleting it manually and 
doing another make install in the DBD-Oracl-1.19 to get the file 
installed.


Regards,

Michael


  Date: Tue, 30 Jan 2007 11:06:11 -0500

From: Pham, Tri [EMAIL PROTECTED]
To: Michael Nhan [EMAIL PROTECTED]
Cc: dbi-users@perl.org, Rahrig, Robert [EMAIL PROTECTED],
Unix Sys Admin [EMAIL PROTECTED]
Subject: RE: DBD::Oracle-1.19 installation errors

Michael,

  Thank you for your respond. My DBA gave me the user/password, the
make test and make install were completed with no error but I got
the new error when I try execute the cgi script. The errors are related
to DynaLoader module. The DynaLoader module version 1.04, it come with
new Perl 5.8.2.

httpwas1stg:/usr/WebSphere/ihs/htdocs/voice/mbhp ./dcMBHPChecks.cgi
h1Software error:/h1
preinstall_driver(Oracle) failed: DBD::Oracle object version 1.19 does
not match bootstrap parameter 1.14 at
/usr/opt/perl5/lib/5.8.2/aix-thread-multi/DynaLoader.pm line 249.
Compilation failed in require at (eval 10) line 3.

at dcFunctions.pl line 762
/pre
p
For help, please send mail to this site's webmaster, giving this error
message
and the time and date of the error.

/p
[Mon Jan 29 16:58:20 2007] dcMBHPChecks.cgi: install_driver(Oracle)
failed: DBD::Oracle object version 1.19 does not match bootstrap
parameter 1.14 at
/usr/opt/perl5/lib/5.8.2/aix-thread-multi/DynaLoader.pm line 249.
[Mon Jan 29 16:58:20 2007] dcMBHPChecks.cgi: Compilation failed in
require at (eval 10) line 3.
[Mon Jan 29 16:58:20 2007] dcMBHPChecks.cgi:
[Mon Jan 29 16:58:20 2007] dcMBHPChecks.cgi:  at dcFunctions.pl line 762

I appreciate for your help.

Thanks,

Tri Pham

-Original Message-
From: Michael Nhan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 30, 2007 10:05 AM
To: Pham, Tri
Cc: dbi-users@perl.org; Rahrig, Robert; Unix Sys Admin
Subject: Re: DBD::Oracle-1.19 installation errors

Hi,

Speak with your dba and ask to he/she to grant the user you are using in

the db permission to select on v$session.

Regards,
Michael



Date: Mon, 29 Jan 2007 16:13:04 -0500
From: Pham, Tri [EMAIL PROTECTED]
To: dbi-users@perl.org
Cc: Rahrig, Robert [EMAIL PROTECTED],
Unix Sys Admin [EMAIL PROTECTED]
Subject: DBD::Oracle-1.19 installation errors

To DBI support group,



   I try to install DBD::Oracle-1.19 on our IBM AIX 5.3 server. Perl
5.82. I got these errors when I run the command make test. I already
ran perl Makefile.PL and make which have no error. I appreciate

for

your help.



[EMAIL PROTECTED]:/workarea/DBI/DBD-Oracle-1.19# make test

   PERL_DL_NONLAZY=1 /usr/bin/perl -MExtUtils::Command::MM -e
test_harness(0, 'blib/lib', 'blib/arch') t/*.t

t/01baseok


t/10general.ok


t/15nls.ok


t/20select..ok


t/21nchar... Database and client versions and character
sets:

Database 9.2.0.1.0 CHAR set is US7ASCII (Non-Unicode), NCHAR set is
AL16UTF16 (Unicode)

Client 9.2.0.1 NLS_LANG is 'unset', NLS_NCHAR is 'unset'

t/21nchar...ok


t/22nchar_al32utf8..ok


t/22nchar_utf8..ok


t/23wide_db.skipped

   all skipped: Database character set is not Unicode

t/23wide_db_8bitskipped

   all skipped: Database character set is not Unicode

t/23wide_db_al32utf8skipped

   all skipped: Database character set is not Unicode

t/24implicit_utf8...ok


t/25plsql...ok


t/26exe_array...ok


t/30longok


   122/470 skipped: various reasons

t/31lob.ok 8/9DBD::Oracle::db selectrow_array failed:
ORA-00942: table or view does not exist (DBD ERROR: error possibly

near

* indicator at char 103 in '

SELECT cache_lobs + nocache_lobs AS temp_lob_count

FROM v$temporary_lobs templob,

 *v$session sess

WHERE sess.sid = templob.sid

AND sess.audsid = userenv('sessionid') ') [for Statement 

SELECT cache_lobs + nocache_lobs AS temp_lob_count

FROM v$temporary_lobs templob,

 v$session sess

WHERE sess.sid = templob.sid

AND sess.audsid = userenv('sessionid') ] at t/31lob.t line 58.

# Failed test (t/31lob.t at line 166)

#  got: undef

# expected: '0'

t/31lob.NOK 9# Looks like you failed 1 tests of 9.


t/31lob

RE: about dbi building error.

[Michael Nhan]

Hi,
	Yes you can do that.  Just open the makefile in an editor and 
change all the CC reference to the gcc equivalent.  This mean not just the 
CC to gcc but cc style linker to gcc style linker (I think linker is the 
correct word, anyway things like -kPIC to -fPIC and -X04 to its 
equivalent.  The easier thing to do would be to get perl compiled with gcc 
and then all modules you build would then use gcc and you won't have to 
change every makefile.  There should be a perl installation for download 
from http://www.sunfreeware.com which is compiled with gcc.



Regards,
Michael



Date: Tue, 23 Jan 2007 02:10:30 -
From: Nancy Ni [EMAIL PROTECTED]
To: Michael Nhan [EMAIL PROTECTED]
Cc: dbi-users@perl.org
Subject: RE: about dbi building error.


If my unix system currently uses gcc to compile c program,then what
should I do without installing a new sun compiler?can change the make
file for c compile?
Thanks  regards,
Nancy

-Original Message-
From: Michael Nhan [mailto:[EMAIL PROTECTED]
Sent: Monday, January 22, 2007 10:52 PM
To: Nancy Ni
Cc: dbi-users@perl.org
Subject: Re: about dbi building error.

Hi,

If you choose to use the sun compilers to compile DBI, you must
install the sun compilers. Sun does not come with the compilers
preinstalled.   That's why you are getting /usr/ucb/cc:  language
optional software package not installed.  Have your sys-admin install
the
Forte CC compilers for you.

Regards,
Michael



  Date: Mon, 22 Jan 2007 10:50:24 -

From: Nancy Ni [EMAIL PROTECTED]
To: dbi-users@perl.org
Subject: about dbi building error.

Dear Sir./Ms.



My current server perl version is:

This is perl, version 5.005_03 built for sun4-solaris

The Bundle about DBI I using is DBI-1.37.

During building it,there is some error appearing:





sunbilldev% make

/bin/sh -c true

/bin/sh -c true

/bin/sh -c true

cc -c   -xO3 -xdepend-DVERSION=\1.37\ -DXS_VERSION=\1.37\

-KPIC

-I/usr/perl5/5.00503/sun4-solaris/CORE -DDBI_NO_THREADS Perl.c

/usr/ucb/cc:  language optional software package not installed

make: *** [Perl.o] Error 1

sunbilldev% make test TEST_VERBOSE=1

/bin/sh -c true

/bin/sh -c true

/bin/sh -c true

cc -c   -xO3 -xdepend-DVERSION=\1.37\ -DXS_VERSION=\1.37\

-KPIC

-I/usr/perl5/5.00503/sun4-solaris/CORE -DDBI_NO_THREADS Perl.c

/usr/ucb/cc:  language optional software package not installed

make: *** [Perl.o] Error 1



can u tell me what's wrong with it and how to continue to install it
successfully?





Thanks  Regards,



Nancy Ni






---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart;
and, in our own despair, against our will,
 comes wisdom to us by the awful grace of God.
--- Aeschylus




---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart; 
and, in our own despair, against our will,

 comes wisdom to us by the awful grace of God.
--- Aeschylus

Re: about dbi building error.

[Michael Nhan]

Hi,

	If you choose to use the sun compilers to compile DBI, you must 
install the sun compilers. Sun does not come with the compilers 
preinstalled.   That's why you are getting /usr/ucb/cc:  language 
optional software package not installed.  Have your sys-admin install the 
Forte CC compilers for you.


Regards,
Michael



  Date: Mon, 22 Jan 2007 10:50:24 -

From: Nancy Ni [EMAIL PROTECTED]
To: dbi-users@perl.org
Subject: about dbi building error.

Dear Sir./Ms.



My current server perl version is:

This is perl, version 5.005_03 built for sun4-solaris

The Bundle about DBI I using is DBI-1.37.

During building it,there is some error appearing:





sunbilldev% make

/bin/sh -c true

/bin/sh -c true

/bin/sh -c true

cc -c   -xO3 -xdepend-DVERSION=\1.37\ -DXS_VERSION=\1.37\ -KPIC
-I/usr/perl5/5.00503/sun4-solaris/CORE -DDBI_NO_THREADS Perl.c

/usr/ucb/cc:  language optional software package not installed

make: *** [Perl.o] Error 1

sunbilldev% make test TEST_VERBOSE=1

/bin/sh -c true

/bin/sh -c true

/bin/sh -c true

cc -c   -xO3 -xdepend-DVERSION=\1.37\ -DXS_VERSION=\1.37\ -KPIC
-I/usr/perl5/5.00503/sun4-solaris/CORE -DDBI_NO_THREADS Perl.c

/usr/ucb/cc:  language optional software package not installed

make: *** [Perl.o] Error 1



can u tell me what's wrong with it and how to continue to install it
successfully?





Thanks  Regards,



Nancy Ni






---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart; 
and, in our own despair, against our will,

 comes wisdom to us by the awful grace of God.
--- Aeschylus

Re: Oracle RAC connection

[Michael Nhan]

Hi,

Connecting to rac is the same as connecting to any normal oracle database. 
It still uses the tnanames aliases.  With the tnsnames.ora file for a rac 
database, you can specify if the alias is to connect to specific node or 
use the service and allow for the listener to connect you to a random 
node.  But as far as DBI is concern its all the same.


Regards,
Michael

  Date: Thu, 21 Sep 2006 00:20:04 +0300

From: Sagiv Barhoom [EMAIL PROTECTED]
To: dbi-users dbi-users@perl.org
Subject: Oracle RAC connection

hi all
I am looking for a tutorial or how to which explain how to 
connect to
Oracle RAC. I have connected to simple Database but here I don't 
know what

is the host name sid etc'
could you please  refere me where to start?




---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart; 
and, in our own despair, against our will,

 comes wisdom to us by the awful grace of God.
--- Aeschylus

Re: Connecting to Oracle.

[Michael Nhan]

It would help if you could include os type.  But to answer your question
1) no, but it helps when troubleshooting.  Usually if sqlplus works, then 
you know that the client libraries/software and connnectivity is good.

2) depends on the os of choice.


Date: Fri, 7 Jul 2006 

15:50:41 +0100

From: [EMAIL PROTECTED]
To: dbi-users@perl.org
Subject: Connecting to Oracle.

Guys,

Can anyone answer following questions please

1) Do I have to install sqlplus to connect to Oracle database from Perl

2) What , how and where can I get the modules required.

RE: Oracle connect hangs forever

[Michael Nhan]

Hi,

Note:340091.1 may be of interest to you concerning listener hanging on 
10g.


Regards,

Michael



Date: Tue, 25 Apr 2006 15:19:27 -0600
From: Reidy, Ron [EMAIL PROTECTED]
To: [EMAIL PROTECTED], dbi-users@perl.org
Subject: RE: Oracle connect hangs forever

Get a 10046 trace of the process.  This will tell you exactly what the
DB is waiting for.

I have had no issues with the TNS listener to date.l

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: Scott T. Hildreth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 2:28 PM
To: dbi-users@perl.org
Subject: Oracle connect hangs forever

I plan on using Sys::SigAction to wrap an alarm around the connect, but
I thought I would post to see if anyone else has seen this problem.  I
have
a process that runs in cron every 2 minutes, it processes files that are
ftp'd
into our site.   I set a lock file so that if the previous run is still
running
it will not start up and send an email indicating that a previous
process is still
running.  Well we moved to this processing was moved to a new server
which is running
Oracle version 10.2.0.1.0.   I've been having a problem where this
process is hanging
for serveral hours (occurs over night) until it is killed.  I run an
strace on the pid
and it is hanging on a read of fd 6, which is the Oracle tns listener.
I don't believe
any thing has processed, because there are no raised errors.  I think
that it has to be
hanging on the connect, since I believe the tns listener accepts a
connection and then
gives the connect process a direct socket to Oracle.  As I stated
earlier,  I was
wondering if anyone else on the list has problems with 10g tns listener?

 Perl: 5.008008(i686-linux)
 OS  : linux   (2.6.14.6)
 DBI : 1.50
 DBD::mysql  : 3.0002
 DBD::Sponge : 11.10
 DBD::SQLite : 1.11
 DBD::Proxy  : 0.2004
 DBD::Oracle : 1.16
 DBD::Multiplex  : 1.98
 DBD::File   : 0.33
 DBD::ExampleP   : 11.12
 DBD::DBM: 0.03


LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 25-APR-2006
15:27:25


Thanks,
STH




---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart; 
and, in our own despair, against our will,

 comes wisdom to us by the awful grace of God.
--- Aeschylus

Re: DBI versiion

[Michael Nhan]

print $DBI::VERSION,\n;



Date: Wed, 05 Apr 2006 13:43:30 -0700
From: Jie Zhang [EMAIL PROTECTED]
To: dbi-users@perl.org
Subject: DBI versiion

Hi,

We're using oracle 8 and 9.  I have code running on different machines.  One 
machine comes out different warnings as the other.  I want to check the 
version of DBI.


How do I find out the version of the DBI libraries I'm using?

thanks,

Jie




---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart; 
and, in our own despair, against our will,

 comes wisdom to us by the awful grace of God.
--- Aeschylus

Re: Oracle schema comparison

[Michael Nhan]

Hi,

Look into Toad by quest software.  It has a schema comparison tool.

Regards,
Michael


Date: Thu, 16 Jun 2005 11:11:12 -0400
From: Steve Sapovits [EMAIL PROTECTED]
To: dbi-users@perl.org
Subject: Oracle schema comparison


Does anybody know of any good tools (free or otherwise) for comparing
two Oracle schemas?  I'd want to be able to compare tables, indices,
sequences, etc. to see what one has and another doesn't.  In an ideal
world I'd also be able to compare the actual data in the tables, but
the primary need is to be able to see if tables and indices match.




---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart; 
and, in our own despair, against our will,

 comes wisdom to us by the awful grace of God.
--- Aeschylus

Re: Oracle 9i RAC on Linux

[Michael Nhan]

No issues.  We are using oracle 9i and 10g rac with dbi on sparc solaris 
and linux respectively.




Date: Thu, 26 May 2005 12:09:36 -0400
From: Steve Sapovits [EMAIL PROTECTED]
To: dbi-users@perl.org
Subject: Oracle 9i RAC on Linux


Has anyone used DBI in an Oracle 9i RAC configuration on Linux?  If
so, were there any issues moving to RAC?




---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart; 
and, in our own despair, against our will,

 comes wisdom to us by the awful grace of God.
--- Aeschylus

RE: Perl Performance Help.

[Michael Nhan]

Divya,
Here are some of the statistics :
a) We are using Oracle 8i DB. The query (or the DBMS) takes only 6 seconds
to return data to Perl.
So the query execution takes 6 seconds...  How long does it take to get 
all the rows back in sqlplus (I mean how long does it take for sqlplus to get 
all 20K rows)?

c) So we conclude that it is mainly an issue with fetchrow especially when
the number of records are high. We tried other possible options like
$stmt_handle-fetch()
$stmt_handle-bind_columns()
$stmt_handle-fetchall_arrayref()
$stmt_handle-fetchrow_array()
$stmt_handle-fetchall_hashref()
@records = @{ $db_handle-selectall_arrayref($sql_stmt) };
Have you taken a look at RowCacheSize?  If you are expecting 20K rows, 
does setting this parameter to 1 help?   Have you try tuning sqlnet 
(setting larger SDU and larger TDU)?

Regards,
Michael

RE: Can't locate DBI.pm

[Michael Nhan]

Lalitha,
My problem is:
To install perl it is asking cc
The perl source requires a compiler not necessarily cc.  Install gcc.  Put 
the path to gcc before the path to /usr/ucb/cc.  When you run configure 
within in the perl source, it should detect you have gcc and use it.

I downloaded gcc from freeware,
To install gcc: if I have cc in path it is giving  /usr/ucb/cc:
language optional software package not installed error.
The binaries from freeware (http://www.sunfreeware.com/indexsparc9.html) 
should install fine without cc.  You should be  able to uncompress the 
package and do a pkgadd on the package to install  it.  It should install 
gcc into /usr/local/bin.  To make use of the gcc,  simply put 
/usr/local/bin in your path before /usr/ucb.

Regards,
Michael

RE: Can't locate DBI.pm

[Michael Nhan]

Hi,
Can you compile by setting the CC flag to gcc, ie:
make CC=gcc
If this works and you don't get errors, then all is well.  If you get 
errors complaining about KPIC and other forte CC options, you will either 
have to modify the makefile (not fun).  Or start over by compiling your 
own perl using gcc.

Regards,
Michael
Date: Wed, 27 Apr 2005 16:06:18 -0400
From: Chekuri, Lalitha [EMAIL PROTECTED]
To: Reidy, Ron [EMAIL PROTECTED],
Michael Nhan [EMAIL PROTECTED]
Cc: dbi-users@perl.org
Subject: RE: Can't locate DBI.pm
Hi ron, thanks for your input. When I try to install, it is saying cc is
not there. Then I started installed gcc3.3 from gcc site. Now to install
that also it is saying cc is not there.. what is going on
Can you please help...Lalitha
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 26, 2005 6:28 PM
To: Chekuri, Lalitha; Michael Nhan
Cc: dbi-users@perl.org
Subject: RE: Can't locate DBI.pm
Google is your friend ...
http://www.google.com/search?q=install+perl+modulessourceid=mozilla-sea
rchstart=0start=0ie=utf-8oe=utf-8client=firefox-arls=org.mozilla:e
n-US:official
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Chekuri, Lalitha [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 26, 2005 3:33 PM
To: Michael Nhan
Cc: dbi-users@perl.org
Subject: RE: Can't locate DBI.pm
How do I compile?
-Original Message-
From: Michael Nhan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 26, 2005 5:28 PM
To: Chekuri, Lalitha
Cc: dbi-users@perl.org
Subject: Re: Can't locate DBI.pm
Are you sure this is the perl where DBI is installed.  If you reinstall
solaris 9, the prebuilt perl on the box from the install will not have
the
DBI and DBD-Oracle installed.  You will need to compile these yourself.

Date: Tue, 26 Apr
2005 12:10:21 -0400
From: Chekuri, Lalitha [EMAIL PROTECTED]
To: dbi-users@perl.org
Subject: Can't locate DBI.pm
Hi,
I have fresh install Solaris 9. We have some perl scripts to run. I am
getting Can't locate DBI.pm error to execute the file. We access
oracle 9 from this perl script. Can some one help me to fix this
problem?
My Perl version is:
This is perl, v5.6.1 built for sun4-solaris-64int
(with 48 registered patches, see perl -V for more detail)
Copyright 1987-2001, Larry Wall
Thanks
Lalitha Chekuri
703-526-2025

---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart;
and, in our own despair, against our will,
 comes wisdom to us by the awful grace of God.
--- Aeschylus
This electronic message transmission is a PRIVATE communication which
contains
information which may be confidential or privileged. The information is
intended
to be for the use of the individual or entity named above. If you are
not the
intended recipient, please be aware that any disclosure, copying,
distribution
or use of the contents of this information is prohibited. Please notify
the
sender  of the delivery error by replying to this message, or notify us
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

		---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart; 
and, in our own despair, against our will,
 comes wisdom to us by the awful grace of God.
		--- Aeschylus

Re: Can't locate DBI.pm

[Michael Nhan]

Are you sure this is the perl where DBI is installed.  If you reinstall 
solaris 9, the prebuilt perl on the box from the install will not have the 
DBI and DBD-Oracle installed.  You will need to compile these yourself.


Date: Tue, 26 Apr 
2005 12:10:21 -0400
From: Chekuri, Lalitha [EMAIL PROTECTED]
To: dbi-users@perl.org
Subject: Can't locate DBI.pm
Hi,
I have fresh install Solaris 9. We have some perl scripts to run. I am
getting Can't locate DBI.pm error to execute the file. We access
oracle 9 from this perl script. Can some one help me to fix this
problem?
My Perl version is:
This is perl, v5.6.1 built for sun4-solaris-64int
(with 48 registered patches, see perl -V for more detail)
Copyright 1987-2001, Larry Wall
Thanks
Lalitha Chekuri
703-526-2025

		---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart; 
and, in our own despair, against our will,
 comes wisdom to us by the awful grace of God.
		--- Aeschylus

RE: :Oracle install problem On Solaris 8

[Michael Nhan]

include oracle_home/lib in your ld_library_path

Date: Tue, 19 Apr 2005 13:14:34 -0500
From: Hemanth Kumar [EMAIL PROTECTED]
To: Hemanth Kumar [EMAIL PROTECTED], dbi-users@perl.org
Subject: RE: :Oracle install problem On Solaris 8
I was able to remove those errors by installing OCI libraries but now I
am facing the following problem.
/usr/local/sparc-sun-solaris2.8/bin/ld: cannot find -lclntsh
collect2: ld returned 1 exit status
Any body aware of this error?
Thanks
Hemanth
-Original Message-
From: Hemanth Kumar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 19, 2005 12:19 PM
To: dbi-users@perl.org
Subject: DBD::Oracle install problem On Solaris 8
I am trying to install DBD 1.3 with DBI 1.37 on Solaris and the database
version is Oracle 9.2.
When I run the make command it returns the following error:
In file included from Oracle.h:20,
from Oracle.xs:1:
dbdimp.h:44: ocidfn.h: No such file or directory
dbdimp.h:57: ociapr.h: No such file or directory
make: *** [Oracle.o] Error 1
Any ideas please...
Thanks
Hemanth

		---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart; 
and, in our own despair, against our will,
 comes wisdom to us by the awful grace of God.
		--- Aeschylus

RE: :Oracle install problem On Solaris 8

[Michael Nhan]

just make a link from libclntsh.so.9.0 to libclntsh.so (ln -s 
libclntsh.so.9.0 libclntsh.so)


Date: Tue, 19 Apr 2005 16:36:16 -0500
From: Hemanth Kumar [EMAIL PROTECTED]
To: Michael Nhan [EMAIL PROTECTED]
Cc: dbi-users@perl.org, [EMAIL PROTECTED]
Subject: RE: :Oracle install problem On Solaris 8
But I don't have the file libclntsh.so under ORACLE_HOME/lib. So I tried
to generate the file by running $ORACLE_HOME/bin/genclntsh which throws
the following error:
Undefined   first referenced
symbol in file
nnfyboot
/export/home/oracle/OraHome1/lib/libn9.a(nnfgt.o)
ld: fatal: Symbol referencing errors. No output written to
/export/home/oracle/OraHome1/lib/libclntsh.so.9.0
cat: cannot open /tmp/clntst9.3879/*.nm
sort: can't stat /tmp/clntst9.3879/*.objs: No such file or directory
usage: ar -d[-vV] archive file ...
  ar -m[-abivV] [posname] archive file ...
  ar -p[-vV][-s] archive [file ...]
  ar -q[-cuvV] [-abi] [posname] [file ...]
  ar -r[-cuvV] [-abi] [posname] [file ...]
  ar -t[-vV][-s] archive [file ...]
  ar -x[-vV][-sCT] archive [file ...]
ar: creating /export/home/oracle/OraHome1/lib/libclntst9.a
Created /export/home/oracle/OraHome1/lib/libclntst9.a
When I run the the make command with -s option and the symbol nnfyboot
it returns the following
searching oracle lib/libn9.a ...
[12]| 0|   0|NOTY |GLOB |0|UNDEF  |nnfyboot
Please find the log file of make and all the steps mentioned in the
README file by Tim.
Thanks
Hemanth
-Original Message-
From: Michael Nhan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 19, 2005 4:23 PM
To: Hemanth Kumar
Cc: dbi-users@perl.org
Subject: RE: :Oracle install problem On Solaris 8
include oracle_home/lib in your ld_library_path

Date: Tue, 19 Apr 2005 13:14:34 -0500
From: Hemanth Kumar [EMAIL PROTECTED]
To: Hemanth Kumar [EMAIL PROTECTED], dbi-users@perl.org
Subject: RE: :Oracle install problem On Solaris 8
I was able to remove those errors by installing OCI libraries but now
I am facing the following problem.
/usr/local/sparc-sun-solaris2.8/bin/ld: cannot find -lclntsh
collect2: ld returned 1 exit status
Any body aware of this error?
Thanks
Hemanth
-Original Message-
From: Hemanth Kumar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 19, 2005 12:19 PM
To: dbi-users@perl.org
Subject: DBD::Oracle install problem On Solaris 8
I am trying to install DBD 1.3 with DBI 1.37 on Solaris and the
database version is Oracle 9.2.
When I run the make command it returns the following error:
In file included from Oracle.h:20,
from Oracle.xs:1:
dbdimp.h:44: ocidfn.h: No such file or directory
dbdimp.h:57: ociapr.h: No such file or directory
make: *** [Oracle.o] Error 1
Any ideas please...
Thanks
Hemanth

---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart; and, in
our own despair, against our will,
 comes wisdom to us by the awful grace of God.
--- Aeschylus
		---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart; 
and, in our own despair, against our will,
 comes wisdom to us by the awful grace of God.
		--- Aeschylus

make.log
Description: make.log

RE: :Oracle install problem On Solaris 8

[Michael Nhan]

Okay, does your oracle client work? Can you connect to the oracle server 
using the sqlplus with your present client install?


Date: Tue, 19 Apr 2005 16:40:43 -0500
From: Hemanth Kumar [EMAIL PROTECTED]
To: Michael Nhan [EMAIL PROTECTED]
Cc: dbi-users@perl.org
Subject: RE: :Oracle install problem On Solaris 8
The thing is the lib directory under ORACLE_HOME doesn't have the file
libclntsh.so.9.0 either.
Thanks
Hemanth
-Original Message-
From: Michael Nhan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 19, 2005 4:39 PM
To: Hemanth Kumar
Cc: dbi-users@perl.org; [EMAIL PROTECTED]
Subject: RE: :Oracle install problem On Solaris 8
just make a link from libclntsh.so.9.0 to libclntsh.so (ln -s
libclntsh.so.9.0 libclntsh.so)

Date: Tue, 19 Apr 2005 16:36:16 -0500
From: Hemanth Kumar [EMAIL PROTECTED]
To: Michael Nhan [EMAIL PROTECTED]
Cc: dbi-users@perl.org, [EMAIL PROTECTED]
Subject: RE: :Oracle install problem On Solaris 8
But I don't have the file libclntsh.so under ORACLE_HOME/lib. So I
tried
to generate the file by running $ORACLE_HOME/bin/genclntsh which
throws
the following error:
Undefined   first referenced
symbol in file
nnfyboot
/export/home/oracle/OraHome1/lib/libn9.a(nnfgt.o)
ld: fatal: Symbol referencing errors. No output written to
/export/home/oracle/OraHome1/lib/libclntsh.so.9.0
cat: cannot open /tmp/clntst9.3879/*.nm
sort: can't stat /tmp/clntst9.3879/*.objs: No such file or directory
usage: ar -d[-vV] archive file ...
  ar -m[-abivV] [posname] archive file ...
  ar -p[-vV][-s] archive [file ...]
  ar -q[-cuvV] [-abi] [posname] [file ...]
  ar -r[-cuvV] [-abi] [posname] [file ...]
  ar -t[-vV][-s] archive [file ...]
  ar -x[-vV][-sCT] archive [file ...]
ar: creating /export/home/oracle/OraHome1/lib/libclntst9.a
Created /export/home/oracle/OraHome1/lib/libclntst9.a
When I run the the make command with -s option and the symbol nnfyboot
it returns the following
searching oracle lib/libn9.a ...
[12]| 0|   0|NOTY |GLOB |0|UNDEF  |nnfyboot
Please find the log file of make and all the steps mentioned in the
README file by Tim.
Thanks
Hemanth
-Original Message-
From: Michael Nhan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 19, 2005 4:23 PM
To: Hemanth Kumar
Cc: dbi-users@perl.org
Subject: RE: :Oracle install problem On Solaris 8
include oracle_home/lib in your ld_library_path

Date: Tue, 19 Apr 2005 13:14:34 -0500
From: Hemanth Kumar [EMAIL PROTECTED]
To: Hemanth Kumar [EMAIL PROTECTED], dbi-users@perl.org
Subject: RE: :Oracle install problem On Solaris 8
I was able to remove those errors by installing OCI libraries but now
I am facing the following problem.
/usr/local/sparc-sun-solaris2.8/bin/ld: cannot find -lclntsh
collect2: ld returned 1 exit status
Any body aware of this error?
Thanks
Hemanth
-Original Message-
From: Hemanth Kumar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 19, 2005 12:19 PM
To: dbi-users@perl.org
Subject: DBD::Oracle install problem On Solaris 8
I am trying to install DBD 1.3 with DBI 1.37 on Solaris and the
database version is Oracle 9.2.
When I run the make command it returns the following error:
In file included from Oracle.h:20,
from Oracle.xs:1:
dbdimp.h:44: ocidfn.h: No such file or directory
dbdimp.h:57: ociapr.h: No such file or directory
make: *** [Oracle.o] Error 1
Any ideas please...
Thanks
Hemanth

---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart; and, in
our own despair, against our will,
 comes wisdom to us by the awful grace of God.
--- Aeschylus
---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart;
and, in our own despair, against our will,
 comes wisdom to us by the awful grace of God.
--- Aeschylus

		---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart; 
and, in our own despair, against our will,
 comes wisdom to us by the awful grace of God.
		--- Aeschylus

Re: running Oracle export in perl

[Michael Nhan]

escape the @,
my $r=system(exp file=users.dmp transport_tablespace=y tablespace=users
userid=\'sys/[EMAIL PROTECTED] as sysdba\');


 Date: Mon, 28 Feb 2005 18:05:59 -0500
 From: Tiffany Thang [EMAIL PROTECTED]
 To: dbi-users@perl.org
 Subject: running Oracle export in perl

 Hi,
 The following exp command ran find on Unix command prompt.

 $ exp file=users.dmp transport_tablespace=y tablespaces=USERS
 userid=\'sys/[EMAIL PROTECTED] as sysdba\'

 When I tried calling it in Perl,
 my $rc=system(exp file=users.dmp transport_tablespace=y
 tablespaces=USERS userid=\'sys/[EMAIL PROTECTED] as sysdba\');

 I got the following error messages:
 Possible unintended interpolation of @testdb in string at myexport.pl line 5.
 Global symbol @testdb requires explicit package name at myexport.pl line 5.

 I guess it's treating @testdb like an array. How can I escape @ or is
 there another way of executing exp in Perl?

 Thanks.

 Tiff


---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart;
and, in our own despair, against our will,
 comes wisdom to us by the awful grace of God.
--- Aeschylus

Re: NLS issues if using DBD::Oracle from mod_perl2

[Michael Nhan]

Hi,

Does the webuser have these configure (apache.conf with env?)?  If
not then the web account(nobody) may not have these env setup.

Michael

 Date: Mon, 7 Feb 2005 10:55:12 -0800
 From: Juan Jose Natera [EMAIL PROTECTED]
 To: Reidy, Ron [EMAIL PROTECTED]
 Cc: DBI Users dbi-users@perl.org
 Subject: Re: NLS issues if using DBD::Oracle from mod_perl2

 Hi Ron:

 ORACLE_HOME: /u01/app/oracle/OraHome_1
 TWO_TASK: servicename
 NLS_LANG: AMERICAN_AMERICA.UTF8

 As I said, this works from the command line, (if I don't go through
 mod_perl), the paths are fine, I have only one perl installed


 On Mon, 7 Feb 2005 11:49:16 -0700, Reidy, Ron
 [EMAIL PROTECTED] wrote:
  What are the values of your Oracle environment (ORACLE_HOME, ORACLE_SID, 
  NLS*)?  How are they set?  Are they correct (refer to correct directories, 
  etc.)?  ARe you sure you are using the correct perl?
 
  -
  Ron Reidy
  Lead DBA
  Array BioPharma, Inc.
 
 
  -Original Message-
  From: Juan Jose Natera [mailto:[EMAIL PROTECTED]
  Sent: Monday, February 07, 2005 11:45 AM
  To: DBI Users
  Subject: NLS issues if using DBD::Oracle from mod_perl2
 
  Hello,
 
  I am getting this error while trying to connect to an Oracle server
  from a custom perl module:
 
  DBI connect('','x',...) failed: ERROR OCIEnvNlsCreate (check
  ORACLE_HOME and NLS settings etc.)
 
  I get this error _only_ if I use my module from mod_perl2,  otherwise
  it works fine (a command line script that uses the same module for
  example).
 
  By googling I found that this has to do with the NLS environment
  variable, which was not set, though LANG is en_US.UTF-8.
 
  I added a line like this to my httpd.conf
 
  PerlSetEnv NLS_LANG AMERICAN_AMERICA.UTF8
 
  But it didn't work. I get the same connection error.
 
  Any pointer?
 
  Thanks in Advance.
 
  Juan Natera
 
  This electronic message transmission is a PRIVATE communication which 
  contains
  information which may be confidential or privileged. The information is 
  intended
  to be for the use of the individual or entity named above. If you are not 
  the
  intended recipient, please be aware that any disclosure, copying, 
  distribution
  or use of the contents of this information is prohibited. Please notify the
  sender  of the delivery error by replying to this message, or notify us by
  telephone (877-633-2436, ext. 0), and then delete it from your system.
 
 


---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart;
and, in our own despair, against our will,
 comes wisdom to us by the awful grace of God.
--- Aeschylus

RE: :Oracle question

[Michael Nhan]

Are you closing your cursor once they are no longer needed?  What do you
have set in terms of cursor sharing?


Michael

 Date: Wed, 17 Nov 2004 15:38:59 -0700
 From: Reidy, Ron [EMAIL PROTECTED]
 To: Giovanni Borri [EMAIL PROTECTED], [EMAIL PROTECTED]
 Subject: RE: :Oracle question

 What is your error?

 Have you (or your DBA) looked into increasing max_open_cursors?

 -
 Ron Reidy
 Lead DBA
 Array BioPharma, Inc.


 -Original Message-
 From: Giovanni Borri [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, November 17, 2004 10:16 AM
 To: [EMAIL PROTECTED]
 Subject: DBD::Oracle question


 hi Tim,

 I have a question for you about the use of DBD::Oracle library.
 It's almost 3/4 years that we are using your library to connect to Oracle
 database. I this days we are facing a problem and i don't know if it is a
 problem of the library or what.
 What seems to happen is that when we open a connection to the database and run
 some query, after a number of query that we have run seems that we fill the
 number of possible cursor per connection. The workaround we have used to not
 facing the problem is to open the connection, run a defined number of query
 and then close the connection. However this workaround affect the performance
 of the database.
 Can you please let me know.

 Thanks in advance
 Giovanni



 This electronic message transmission is a PRIVATE communication which contains
 information which may be confidential or privileged. The information is 
 intended
 to be for the use of the individual or entity named above. If you are not the
 intended recipient, please be aware that any disclosure, copying, distribution
 or use of the contents of this information is prohibited. Please notify the
 sender  of the delivery error by replying to this message, or notify us by
 telephone (877-633-2436, ext. 0), and then delete it from your system.


---//---
He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart;
and, in our own despair, against our will,
 comes wisdom to us by the awful grace of God.
--- Aeschylus

Re: What's wrong with UnixDate(30000101,%Y%m%d)?

[Michael Nhan]

Hi,

You may need to set the timezone as its not set on Winnt by
default.  Open the properties of My Computer and set a SYSTEM variable
TZ to your timezone.  Use the form EST5EDT so you don't have to change
it every 6 months when going to or from daylight saving.  Its in the
perldoc of Date::Manip. :)

Cheers,
Michael


 Date: Tue, 30 Mar 2004 16:40:50 -0500
 From: Laurie Vien [EMAIL PROTECTED]
 To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
 Subject: What's wrong with UnixDate(3101,%Y%m%d)?

 I know this isn't a DBI-specific question, but some of you are familiar with
 what I've been doing so I thought I'd post here:

  The following line of Perl code:
 
  $earliest_contact = UnixDate(3101,%Y%m%d);
 
 
  results in the following error messages:
  D:\process_chunkmail_SEND.pl
  ERROR: Date::Manip unable to determine TimeZone.
  Date::Manip::Date_TimeZone called at /site/lib/Date/Manip.pm line
  661
  Date::Manip::Date_Init() called at /site/lib/Date/Manip.pm line
  779
  Date::Manip::ParseDateString(3101) called at
  /site/lib/Date/Manip.pm line 1725
  Date::Manip::UnixDate(3101, '%Y%m%d') called at
  process_chunkmail_SEND.pl line 50
 
  Can anyone shed any light on what the problem is?  Is it because
  01/01/3000 is too far in the future?  I'm using v5.4.2 of DateManip.
  NOTE:  This problem does NOT happen on my machine; it happens on a remote
  system to which I have no access.  Another subsidiary is testing my Perl
  script and reporting errors to me.
 
  Thank you.
 
  Laurie A. Vien
  Sr. Programmer/Analyst
  Ben  Jerry's Homemade, Inc.
 


---//---
Why should I have to WORK for everything?! It's like saying I don't deserve it!
---Calvin (Calvin  Hobbes ).

Re: Hello

[Michael Nhan]

Hi,

Its the mydoom virus.  Its running rampant all over the net.  Best not to
open and spread it.

Cheers,

Michael

 Date: Thu, 29 Jan 2004 11:17:20 -0500
 From: Hardy Merrill [EMAIL PROTECTED]
 To: [EMAIL PROTECTED], [EMAIL PROTECTED]
 Subject: Re: Hello

 Just checking - is everyone else seeing messages lately like the one
 below, or is it just me.  The attachment is always 'Readme.zip'.  The
 messages may be valid and it might be our email server software here
 doing this, but I'm not sure.  Looks suspect to me so I haven't opened
 the attachment.  The message below was from [EMAIL PROTECTED] who I
 recognize from this list.

 Thanks.

 Hardy Merrill

  [EMAIL PROTECTED] 01/27/04 04:37AM 
 The message contains Unicode characters and has been sent as a binary
 attachment.


---//---
Why should I have to WORK for everything?! It's like saying I don't deserve it!
---Calvin (Calvin  Hobbes ).

Re: Help Needed: DBI (no error string)

[Michael Nhan]

Hi,

 string), when i enable DBI-trace i get that it is majorly due to 3113
 error.
When you get the ORA-3113 error, can you connect via sqlplus or any other
client programs?  Check to see if you have enough swap space, sometime
when you run out of swap you will get ORA-3113 and will not be able to
reconnect until sufficient swap is available.


   Is this because i am using 9i client and the DBD:Oracle only supports
 Oracle 7,8 or is there is some other reason. Please advice

DBD:Oracle supports oracle 9i perfectly well.


Michael
---//---
Why should I have to WORK for everything?! It's like saying I don't deserve it!
---Calvin (Calvin  Hobbes ).

RE: Help Needed: DBI (no error string)

[Michael Nhan]

 Date: Fri, 2 Jan 2004 12:22:19 -0500
 From: Hariharan [EMAIL PROTECTED]
 To: Michael Nhan [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: RE: Help Needed: DBI (no error string)

 Hi,
   Thanks for reply. Swap space of the machine that i am running the
 application or on the server ,the Oracle Docs says that it is due to some
 error on the server. Also i am able to connect to the server through the
 client always.
ORA-03113 is when a session loose contact with its shadow process.
Sometime this is due to not enough swap space on the server.  It can also
be caused by network problems.  Can you check the dump dest to see if
there were any trc files created by the terminated session.  ORA-3113 can
be accompany by other ORA errors that can help track down the cause of the
problem.  You can also turn on tracing in dbi and at the sqlnet level to
see where and when its dying if it continues consistently.


   Thanks for letting me know abt the oracle 9i client issue. One question
 though when i compile DBD:Oracle it is not able to detect the oracle version
 when i do perl Makefile.PL.
Hmm, that is strange.  The oracle s/w on the client, is it a client
install or full install?  It looks at a couple of place for the version
and then attempts to guess the version from the install directory.  if
you look in the Makefile.PL you can see where its trying to decipher the
database version.


Michael

Re: Help - multiple Oracle versions

[Michael Nhan]

Hi,


 I have two versions of Oracle, 8i and 9i, on one UNIX server.  How do I get DBI to 
 use both?

DBD-Oracle links against which ever version of oracle was set at compile
time.  It needs those libraries to function.  You should be able to
connect to both your oracle 8 and oracle 9 instances with the oracle 8
dbd-oracle build.   Make sure that your tnsname.ora file pointed to by
your TNS_ADMIN variable contains all the instances in them.  I've an
oracle 8i client compiled dbd-oracle on both solaris and linux connecting
to oracle 8i and 9i databases with no issues.

Michael

RE: Refreshing a database from another

[Michael Nhan]

What about exp/imp?


 Date: Wed, 17 Dec 2003 09:07:01 +1100
 From: Steve Baldwin [EMAIL PROTECTED]
 To: 'Ian Harisay' [EMAIL PROTECTED], [EMAIL PROTECTED]
 Subject: RE: Refreshing a database from another

 Would standard Oracle replication not do it for you ?

 -Original Message-
 From: Ian Harisay [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, 17 December 2003 8:43 AM
 To: [EMAIL PROTECTED]
 Subject: Refreshing a database from another


 Hi,

 I know this isn't the right place to post the message, so I apologize in
 advance.  I need to refresh one oracle database from another.  The
 schemas are the same.  The only thing I need to refresh is the data in
 the tables.  Can anyone point me to a website or book that would cover
 this.  Thanks in advance.

 -Ian


---//---
Why should I have to WORK for everything?! It's like saying I don't deserve it!
---Calvin (Calvin  Hobbes ).

Re: Apache, Oracle, Perl DBI Problems

[Michael Nhan]

 In fact Tim
 Bunce suggested setting LD_LIBRARY_PATH in the apache
 configuration - I don't know how to do that.

in the httpd.conf
SetEnv LD_LIBRARY_PATH blah:blah

Cheers,
Michael

Re: Reinstallation problems (Oracle 9.2.0.1)

[Michael Nhan]

Hi,

Can you post how you used to connect and the error you are getting?

Michael

 Date: Sun, 21 Sep 2003 18:54:54 +0300
 From: John [EMAIL PROTECTED]
 To: DBI-Users [EMAIL PROTECTED]
 Subject: Reinstallation problems (Oracle 9.2.0.1)

 I uninstalled the Oracle 9i and partitioned my harddisk. Then i installed the Oracle 
 Server on the second half partition (E:).
 OracleHomeE=E:\oracle\ora92;

 However, i cannot connect to the database as i used to. What should i configure now?

 Thanks in advance!

---//---
I don't need to compromise my principles, because they don't have the
slightest bearing on what happens to me anyway.
---Calvin (Calvin  Hobbes).


A computer lets you make more mistakes faster than any invention in human
history - with the possible exceptions of handguns and tequila.
Ratliffe, M.

RE: fetch( ) without execute( ) Error...

[Michael Nhan]

I don't think you should be calling finish before fetching.  I think
that is the problem here.

Michael

 Date: Wed, 3 Sep 2003 12:01:03 -0500
 From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: RE: fetch( ) without execute( ) Error...

 OK.  The other execute is further up.  I am actually receiving this
 error for each fetchrow_hashref.  Here is a bit more of the code:

   my $test2 = $dbh2-prepare(SELECT id FROM fsref WHERE server ='$server'
 AND f
 s_name = '$fs_name');
   $test2-execute();

   $rows2 = $test2-rows();
   print Number of matching rows:  $rows2 \n;
   $test2-finish();
   if ($rows2 == 1) {
 my $vals = $test2-fetchrow_hashref ('NAME_lc');
 my $id = $vals-{id};
 my $query = $dbh2-prepare(SELECT * FROM fsdata WHERE id ='$id');
 $query-execute();
 $query-finish();
 while (my $ref2 = $query-fetchrow_hashref ('NAME_lc')) {
   undef $set2;

 This now includes the other execute.  Thanks again.

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, September 03, 2003 11:54 AM
 To: NIPP, SCOTT V (SBCSI)
 Cc: [EMAIL PROTECTED]
 Subject: Re: fetch( ) without execute( ) Error...



 Which fetchrow_hashref line? I see two of them, but only one execute.  You
 need to include more code for anyone to know what's really wrong here.


 
 Jeff Seger
 Fairchild Semiconductor
 [EMAIL PROTECTED]
 




   NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED]


 09/03/2003 12:43 PM



 To:[EMAIL PROTECTED]
 cc:
 Subject:fetch( ) without execute( ) Error...



  I keep coming up with this error, but I AM performing an
 execute
 prior to the fetch.  I have seen some other threads on this, and have
 upgraded the DBD:Mysql to the latest version on CPAN.  Any ideas?  Here is a
 small portion of the code:

 if ($rows2 == 1) {
my $vals = $test2-fetchrow_hashref ('NAME_lc');
my $id = $vals-{id};
my $query = $dbh2-prepare(SELECT * FROM fsdata WHERE id ='$id');
$query-execute();
$query-finish();
while (my $ref2 = $query-fetchrow_hashref ('NAME_lc')) {
  undef $set2;

 I am getting an error on the fetchrow_hashref line.  Thanks
 in
 advance.

 Scott Nipp
 Phone:  (214) 858-1289
 E-mail:  [EMAIL PROTECTED]
 Web:  http:\\ldsa.sbcld.sbc.com









---//---
I don't need to compromise my principles, because they don't have the
slightest bearing on what happens to me anyway.
---Calvin (Calvin  Hobbes).


A computer lets you make more mistakes faster than any invention in human
history - with the possible exceptions of handguns and tequila.
Ratliffe, M.

Re: Can't Connect to Oracle 9i Database

[Michael Nhan]

Hi,

Try this:

my $dbuser=sys/change_on_install\@tnsalias;
my $dbh=DBI-connect('',$dbuser,'','Oracle',{AutoCommit = 0,RaiseError
=0,ora_session_mode =2});

see perldoc of DBD::Oracle for ora_session_modes.

Regards,

Michael

 Date: Wed, 12 Feb 2003 10:24:49 -0800
 From: Eddie Bradford [EMAIL PROTECTED]
 To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
 Subject: Can't Connect to Oracle 9i Database

 I've written a perl program and I'm trying to connect to a 9i database
 as user 'sys', which requires the 'as sysdba' clause.  Using the
 dbi-connect
 method fails with everything I've passed it.  What's the secret?

 Eddie Bradford
 Systems Analyst/Programmer
 Information Technology Services
 John Muir/Mt. Diablo Health System
 1400 Treat Boulevard
 Walnut Creek, CA  94596
 (925) 947-4466 x32069
 [EMAIL PROTECTED]




---//---
I don't need to compromise my principles, because they don't have the
slightest bearing on what happens to me anyway.
---Calvin (Calvin  Hobbes).


A computer lets you make more mistakes faster than any invention in human
history - with the possible exceptions of handguns and tequila.
Ratliffe, M.

Re: Why can't use SQL GROUP BY...?

[Michael Nhan]

Hi,

Is $Table defined before the prepare is executed?  I've used group
by in perl without issues.  The error returned is complaining about a
missing table name, so I can only conclude that $Table is either blank or
undef when the prepare statement is executed by perl.

Regards,
Michael Nhan

 Date: Thu, 9 Jan 2003 22:59:03 +0800 (CST)
 From: [big5] Gary Fung [EMAIL PROTECTED]
 To: [EMAIL PROTECTED], [EMAIL PROTECTED]
 Subject: Why can't use SQL GROUP BY...?


 Hi,

   I have a Perl program using DBI. I don't know why it will cause error when I use 
GROUP BY... in SQL SELECT statements.

 My coding is similar as:

  $value2 = $dbh-prepare(SELECT page FROM $Table

 GROUP BY page) || die Couldn't add record, .$dbh-errstr();

 Whenever I use GROUP BY.. , an error statement will go out :

 SQL ERROR: Can't find table names in FROM clause!

 Can anyboby give help to me?

 Thank You very much!!

 Regards,

 Gary

 Lonely Christmas(³¯«³¨³)¡A­·ºå»P­·(Twins)¡AµL¶¡¹D(¹q¼v)...
 ¦ÜIn¤â¾÷¹aÁn ³­§A¹L¥V¤Ñ


---//---
I don't need to compromise my principles, because they don't have the
slightest bearing on what happens to me anyway.
---Calvin (Calvin  Hobbes).


A computer lets you make more mistakes faster than any invention in human
history - with the possible exceptions of handguns and tequila.
Ratliffe, M.

Re: (Fwd) [Fwd] [perl #18355] Perl DBI

[Michael Nhan]

Perl and DBI are open source.  Its free, if you don't like it don't use
it.  With that said.  Its not difficulty to build your own perl.  If
you're going to use sun's precompiled perl then you are going to need
sun's CC unless you know how to edit Makefiles to accomodate gcc (which is
free and the binaries are available).  My suggestion, build your own perl
with gcc, then you won't have any issue about buying the sun compilers.
There is a place for microsoft and a place for unix.  Microsoft is not
wining...  Enough said.

Michael


On Wed, 13 Nov 2002, Tim Bunce wrote:

 Date: Wed, 13 Nov 2002 17:14:25 +
 From: Tim Bunce [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: (Fwd) [Fwd] [perl #18355] Perl DBI

 Be gentle.

 - Forwarded message from [EMAIL PROTECTED] via RT [EMAIL PROTECTED] 
-

 Date: 13 Nov 2002 15:43:42 -
 To: AdminCc of perl Ticket #18355: ;
 From: [EMAIL PROTECTED] via RT [EMAIL PROTECTED]
 Subject: [perl #18355] Perl DBI


 Wed Nov 13 07:43:42 2002: Request 18355 was acted upon.
 Transaction: Ticket created by [EMAIL PROTECTED]
Queue: cpansearch
  Subject: Perl DBI
Owner: Nobody
   Requestors: [EMAIL PROTECTED]
   Status: new
  Ticket URL: http://rt.perl.org/rt2/Ticket/Display.html?id=18355 
 -
 Dear Sir, I am very dissapointed at the way Perl community presents Perl DBI 
installation. Instead of simply give the binary for Solaris and let the engineer 
continue with work, no you insist on compiling the perl source code without 
considering side effects (no wonder Microsoft is winning the game). Let me tell you 
the problem:
 When I try to compile perl DBI, I get a message that (Optional Language Package not 
installed). I tried all various forms of Solaris installation and it keeps failing 
simply because Sun believes that it should charge poeple for giving a simple cc 
compiler. So I can not install Perl DBI on Solaris, because I do not have cc be 
default installaed on Sun workstations. Is it possible for you to give me the binary 
version of Perl DBI and relief me from compiling it?

 Regards

 - End forwarded message -


---//---
I don't need to compromise my principles, because they don't have the
slightest bearing on what happens to me anyway.
---Calvin (Calvin  Hobbes).


A computer lets you make more mistakes faster than any invention in human
history - with the possible exceptions of handguns and tequila.
Ratliffe, M.

Re: DBD::Oracle - specifying rollback segments

[Michael Nhan]

Hi,
I believe the syntax is:

set transaction use rollback segment segmentname;

 
 The statement for assigning a rollback segment (ALTER SESSION, I think) is
 Oracle SQL.  You can execute it with prepare()/execute() or do() just like
 any other non-SELECT statement.
 
 Be aware that COMMIT releases the segment so you need AutoCommit off.
 
Cheers,

Michael

---//---
I don't need to compromise my principles, because they don't have the
slightest bearing on what happens to me anyway.
---Calvin (Calvin  Hobbes).


A computer lets you make more mistakes faster than any invention in human
history - with the possible exceptions of handguns and tequila.
Ratliffe, M.

Re: Fatal error: command failed for target 'perl.o'

[Michael Nhan]

Hi,
 
 I am having the same problem when I tried to run make on DBI-1.21
 
 
 DBI_NO_THREADS Perl.c

 sh: cc: not found
You need a c compiler (gcc or cc) or put path to the compiler into your 
path.  It can't locate your compiler.
 *** Error code 1
 make: Fatal error: Command failed for target `Perl.o'
 
 Thanks
 Francis
 
Regards,

Michael
-- 
---//---
I don't need to compromise my principles, because they don't have the
slightest bearing on what happens to me anyway.
---Calvin (Calvin  Hobbes).


A computer lets you make more mistakes faster than any invention in human
history - with the possible exceptions of handguns and tequila.
Ratliffe, M.

Re: DBD Oracle from remote machine

[Michael Nhan]

Hi,

Install the oracle client on machine B and compile/install the
DBD-Oracle module.  You don't need to have a database or all the software
on Machine B but you do need the client software to talk to Oracle.  If
you search the list archive, you can find out a list of files you need to
have.

Cheers,

Michael


On Wed, 11 Jul 2001, Shashi Shina wrote:

 Date: Wed, 11 Jul 2001 15:41:05 +0200
 From: Shashi Shina [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Subject: DBD Oracle from remote machine
 
 Hi all,
First of all I am a newbie !
 I have Oracle 8.x installed on machine A on Linux (http server Apache).
 On the same machine A I have installed DBI and DBD::Oracle.
 And I can access oracle from the same machine A with charm. No Problem !
 e.g.  $dbh = DBI-connect(dbi:Oracle:host=localhost;sid=ORCL, $user,
 $passwd);
 
 But my problem is I want to access Oracle on machine A from remote machine
 B.
 On machine B (Linux, Apache) only DBI is installed.
 Now if I use the following
 e.g.  $dbh = DBI-connect(dbi:Oracle:host=remotehost;sid=ORCL, $user,
 $passwd);
 it give me error DBD oracle not installed
 
 Now, If I try to install DBD::Oracle on machine B, It is giving me error !
 It is looking for
 Oracle on local machine B itself. So I cannot install DBD::Oracle on machine
 B.
 
 Then How can I connect through DBI to Oracle on remote machine??
 Do I have to install whole oracle 8.x again on machine B also for installing
 DBD::Oracle?
 Any help will be highly appreciated !
 
 regards,
 Shashi
 
 
 

RE: Slow execution

[Michael Nhan]

Hi,

Without seeing your sql statement(s) and how your database is setup
there is only so much that one can infer as to the problem.  It could be
cause by your database, or even your network if the other databases are on
slow network.  I've a oracle 8i database with over 10 millions rows in
many of the tables I'm querying and its runs quite well with perl dbi.
Even when I make joins across two different oracle database the speed of
the query is fine.  It all depend on the way the database is setup
(tables,tablespace,indexes) and how your query is written.

Michael
 I am also facing this kind of stuff.  But I see the problem in SELECT only.
 I am joining 6 tables some of them from other databases.  and when I run the
 query on SQL client it takes time but not that much the perl DBI is taking.
 ofcourse my oracle database contains millions of records. Is that the
 problem?

 Regards,
 Prem




 -Original Message-
 From: Michelle Gerfort [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, June 12, 2001 9:29 AM
 To: Michael Nhan; [EMAIL PROTECTED]
 Subject: Re: Slow execution


 Actually the sqlstatement takes a while with the sqlplus as well, so I guess
 it might be a tuning issue.
 Anyway, Here is a snip of my code, with a lot of time checks:

 ($sec, $min, $hour, $mday, $mon, $year, $wday, $yday, $isdst) =
 localtime(time);
 print Time before preparing sqlstatement: $hour $min $sec br;

  my $sth = $dbh-prepare( $sql );
 print $sql br;

  ($sec, $min, $hour, $mday, $mon, $year, $wday, $yday, $isdst) =
 localtime(time);
 print Time before executing the sqlstatement: $hour $min $sec br;

  $sth-execute();

 ($sec, $min, $hour, $mday, $mon, $year, $wday, $yday, $isdst) =
 localtime(time);
 print Time after executing the sqlstatement, before binding to columns:
 $hour $min $sec br;

 $sth-bind_columns( @AllBcol );

 ($sec, $min, $hour, $mday, $mon, $year, $wday, $yday, $isdst) =
 localtime(time);
 print Time after binding to columns: $hour $min $sec br;

 I can se in the time-outputs, that it takes a very long time doing the
 execution

 /Michelle

 Michael Nhan wrote:

  Hi,
 
  Can you post snipet of code so we can assist you?  Include the sql
  statement if possible?  Does the same statement work quickly on sqlplus?
  If not then its probably a sql statement/database tuning issue.
 
  Michael
 
  On Tue, 12 Jun 2001, Michelle Gerfort wrote:
 
   Date: Tue, 12 Jun 2001 15:17:28 +0200
   From: Michelle Gerfort [EMAIL PROTECTED]
   To: [EMAIL PROTECTED] [EMAIL PROTECTED]
   Subject: Slow execution
  
   Hi there
  
   I use an ordinary
   $sth-execute();
   but it seems to take ages to search, creating or updating a post.
   Is this problem due to the sqlstatement or is it a known problem with a
   perl DBI interface?
  
   I run Oracle 7.3.3 on an AIX 4.2 with roxen as webserver.
  
   --
   MVH
   Michelle
  
   ---
   Michelle Gerfort
   Software Engineer
  
   Teligent AB
   P.O. Box 1191
   SE-581 11 Linköping, Sweden
  
   www.teligent.se
  
  
  

 --
 MVH
 Michelle

 ---
 Michelle Gerfort
 Software Engineer

 Teligent AB
 P.O. Box 1191
 SE-581 11 Linköping, Sweden

 www.teligent.se

Re: How to execute a stored procedure by using DBI?

[Michael Nhan]

Hi,

Please read the documentation on DBD-Oracle.   To execute a stored
procedure do the following:

$sth=$dbh-prepare(q{
BEGIN
syn_act_uso;
END;
});

Michael


On Tue, 12 Jun 2001, Xiaoping Gu wrote:

 Date: Tue, 12 Jun 2001 09:55:42 -0400
 From: Xiaoping Gu [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Subject: How to execute a stored procedure by using DBI?

 I created a procedure and it can be run on sql command line.
 Then, I put it in a perl program like this:

 $dth = $dbh-prepare(exec syn_act_uso)
 or die Couldn't prepare statement:  . $dbh-errstr;
 my $success = $dth-execute();
 unless ($success) { die Couldn't exec efmsdbo.syn_act_uso:  .
 $dth-errstr }

 where 'syn_act_uso' is the procedure and it doesn't pass parameters.
 It failed with an error message as follow:

 DBD::Oracle::st execute failed: ORA-00900: invalid SQL statement (DBD ERROR:
 OCIStmtExecute) at act_uso.pl line 129.
 Couldn't exec syn_act_uso: ORA-00900: invalid SQL statement (DBD ERROR:
 OCIStmtExecute) at act_uso.pl line 130.

 Could someone tell me how to execute a procedure by using DBI?  Thanks.

help: Make test fails DBD::Oracle-1.06

[Michael Nhan]

Hi,

Okay, I've attempted to debug this to no-avail on my own so I'm would
really appreciate some help.  Here is my setup..

Oracle-client: 8.1.6 (full install minus database)
Perl: 5.6.1 with threading
OS: Solaris 2.7 sparc
DBI: 1.16
DBD: Oracle 1.06


perl -V:
Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
  Platform:
osname=solaris, osvers=2.7, archname=sun4-solaris-thread-multi-64int
uname='sunos infocs03 5.7 generic_106541-08 sun4u sparc sunw,ultra-5_10 '
config_args=''
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define usemultiplicity=de
fine
useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=define use64bitall=undef uselongdouble=undef
  Compiler:
cc='gcc', ccflags ='-D_REENTRANT -fno-strict-aliasing -D_LARGEFILE_SOURCE -D
_FILE_OFFSET_BITS=64',
optimize='-O',
cppflags='-D_REENTRANT -fno-strict-aliasing'
ccversion='', gccversion='2.95.2 19991024 (release)', gccosandvers='solaris2
.6'
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=87654321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lsee
ksize=8
alignbytes=8, usemymalloc=n, prototype=define
  Linker and Libraries:
ld='gcc', ldflags ='-L/usr/local/lib -L/home/trna/pkg/gnu/lib -L/home/trna/l
ib -L/usr/ucblib -L/usr/dt/lib '
libpth=/lib /usr/lib /usr/local/lib /usr/ccs/lib /usr/openwin/lib /usr/dt/li
b /home/trna/pkg/gnu/lib /home/trna/lib /usr/ucblib
libs=-lsocket -lnsl -lgdbm -ldbm -ldb -ldl -lm -lrt -lpthread -lc -lposix
perllibs=-lsocket -lnsl -ldl -lm -lrt -lpthread -lc -lposix

Characteristics of this binary (from libperl):
  Compile-time options: MULTIPLICITY USE_ITHREADS USE_64_BIT_INT USE_LARGE_FILES 
PERL_IMPLICIT_CONTEXT
  Built under solaris
  Compiled at May 30 2001 14:56:14
  %ENV:

PERL5LIB=/home/trna/pkg/perl/perl5lib:/home/trna/pkg/perl/lib/include_files:/home/trna/pkg/perl/gsclib
PERLDB=/home/trna/scripts/perldb/
  @INC:
/home/trna/pkg/perl/perl5lib
/home/trna/pkg/perl/lib/include_files
/home/trna/pkg/perl/gsclib
/home/trna/pkg/perl/install_561/lib/5.6.1/sun4-solaris-thread-multi-64int
/home/trna/pkg/perl/install_561/lib/5.6.1
/home/trna/pkg/perl/install_561/lib/site_perl/5.6.1/sun4-solaris-thread-multi-64int
/home/trna/pkg/perl/install_561/lib/site_perl/5.6.1
/home/trna/pkg/perl/install_561/lib/site_perl



-
perl Makefile.PL -V:

Using DBI 1.16 installed in /home/trna/pkg/perl/install_561/lib/site_perl/5.6.1/
sun4-solaris-thread-multi-64int/auto/DBI

 Configuring DBD::Oracle ...

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

Using Oracle in /home/trna/pkg/oracle/8.1
Found /home/trna/pkg/oracle/8.1/rdbms/demo/demo_rdbms.mk
Using /home/trna/pkg/oracle/8.1/rdbms/demo/demo_rdbms.mk
Reading /home/trna/pkg/oracle/8.1/rdbms/demo/demo_rdbms.mk.
Reading /home/trna/pkg/oracle/8.1/rdbms/lib/env_rdbms.mk.
Read a total of 1936 lines from /home/trna/pkg/oracle/8.1/rdbms/lib/env_rdbms.mk
 (including inclusions)
Read a total of 2145 lines from /home/trna/pkg/oracle/8.1/rdbms/demo/demo_rdbms.
mk (including inclusions)
Deleted SHELL definition: SHELL=/bin/sh
Deleted LIB_EXT definition: LIB_EXT=a
Deleted OBJ_EXT definition: OBJ_EXT=o
Deleted AR definition: AR=ar
Deleted AS definition: AS=as
Deleted CC definition: CC=cc
Deleted CHMOD definition: CHMOD=chmod
Deleted CPP definition: CPP=cpp
Deleted ECHO definition: ECHO=echo
Deleted LD definition: LD=ld
Deleted PERL definition: PERL=perl
Deleted CFLAGS definition: CFLAGS=$(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QA
CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
Deleted LDFLAGS definition: LDFLAGS=-o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFL
AG)$(LIBHOME)
LMAKE macro redefined by Oracle
 from make
   to /usr/ccs/bin/make
FIND macro redefined by Oracle
 from find
   to /usr/local/bin/find # gnu find!
LINK macro redefined by Oracle
 from $(LDCCOM)
   to $(PURECMDS) $(LD) $(LDFLAGS) -dy $(COMPOBJS)
Deleted $(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/crtn.o from link args.
del_crtobj: COMPOBJS=$(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/crtn.o
  : COMPOBJS=
$(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/crtn.o
Edited COMPOBJS definition
 from: COMPOBJS=$(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/crtn.o
   to: COMPOBJS=
LINKLDLIBS macro redefined by Oracle
 from $(LDLIBS)
   to $(EXPDLIBS) $(EXOSLIBS) $(SYSLIBS) $(LINKEXSYSLIBS) $(MATHLIB) 
$(USRLIBS)COBLDLIBS macro redefined by Oracle
 from $(LDLIBS)
   to $(EXPDLIBS) $(EXOSLIBS) $(SYSLIBS) $(COBEXSYSLIBS) $(MATHLIB) $(USRLIBS)
Deleted OPTIMIZE definition: OPTIMIZE=$(OPTIMIZE2)
AR macro redefined by Oracle
 from ar
   to /usr/ccs/bin/ar
Deleted AR definition: AR=/usr/ccs/bin/ar
AS macro redefined by Oracle
 from as
   to /usr/ccs/bin/as
Deleted AS