01-07-2009
OK, I've made some progress. The original issue was being cause because my LD_LIBRARY_PATH variable didn't contain a path to /opt/dbase/OraHome1/lib, it instead contained /opt/dbase/OraHome1/lib32. I updated the LD_LIBRARY_PATH variable and was able to get past the issue originally mentioned.
I am still having issues with make test failing because the scripts use the default oroacle userid and password scott/tiger is not available for log-in. Any thoughts on moving forward with the install step even though make test is failing?
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I am trying to install Oracle perl module(DBD-Oracle). MY oracle server runs on solaris 8 while the machine am tring to install DBD-Oracle runs Suse linux 9(SLE 9)
Oracle client library including sqlplus are NFS mount on my suse linux machine from my solaris oracle server but when I run make on... (1 Reply)
Discussion started by: hassan1
1 Replies
2. UNIX for Advanced & Expert Users
I am trying to install perl-DBD-Oracle-1.16-1.2.rpm on Suse (SLE 9), like
rpm -Uvh perl-DBD-Oracle-1.16-1.2.rpm but I keep getting the following error message
error: Failed dependencies:
libclntsh.so.10.1 is needed by perl-DBD-Oracle-1.16-1.2.el4
libnnz10.so is needed by... (1 Reply)
Discussion started by: hassan1
1 Replies
3. Solaris
Hi, all,
I need to add a user to our system in order to let him use Oracle and Perl. We want him to remain in his home directory and have no access to our data and other users' files.
I created a separate group for this user, and set his shell to rksh when I created his account, by which he... (2 Replies)
Discussion started by: alanlh
2 Replies
4. Shell Programming and Scripting
Here is part of my program code:
#Collect the output of test database and count the no
#of rows too
while(my @array = $tstDbStatementHandle->fetchrow_array)
{
push @tstDbOutputArray,;
$tstDbOutputRows++;
}
... (3 Replies)
Discussion started by: sameerstephen
3 Replies
5. UNIX for Advanced & Expert Users
Hi
When im trying to do make --version and make --help in HP-UX
it throws error
Make: Unknown flag argument -. Stop.
a soft link is present in this directory /usr/bin/make
and hard link is in /usr/ccs/bin/make
what could be the reason can any1 ..please tell me how to solve this... (1 Reply)
Discussion started by: vasanthan
1 Replies
6. Shell Programming and Scripting
I want to use Perl to connect to a remote Oracle DB
I have no oracle installation on my server (and dont plan on installing one) I am using solaris 9 on x86 server.
Is this possible?
I basically want to run some basic sql queries on the remote oracle db which I have access to using perl on my... (0 Replies)
Discussion started by: frustrated1
0 Replies
7. Solaris
Hi,
I have a SunFire 280R abd when I boot it there is a hardware check running and it fails. Here is a long output of the test
rsc> poweron
Are you sure you want to turn your system power on (Yes/No)? yes
rsc> console
RSC Alert: Host System has Reset
@(#)OBP 4.5.10 2002/02/11 10:39... (2 Replies)
Discussion started by: Tex-Twil
2 Replies
8. UNIX for Advanced & Expert Users
I am installing Oracle DBD to PERL 5.16.3 and during make test , I am running into this error :rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/opt/oracle/product/11.2.0/racdb11204/lib" gcc -m32 -shared -O2 -L/usr/local/lib -fstack-protector Oracle.o dbdimp.o oci8.o -o... (3 Replies)
Discussion started by: talashil
3 Replies
9. AIX
AIX 7.1 on Power7 Platform.
I am doing this as root.
OK, somehow my instance is stuck and I cannot create any new instances for the 10.5 (db2icrt gets to step 2 of creation and sits. Have let it sit for 45minutes). db2ilist shows the instance, but deleting it says there is no instance. Tried to... (1 Reply)
Discussion started by: mrmurdock
1 Replies
10. Linux
I have a standalone Oracle Linux server which has no connectivity to the internet.
I was following a blog which directed me to download all ansible dependent setup files and install them using the below command.
# yum localinstall -y python-crypto-2.6.1-1.el7.rf.x86_64.rpm... (7 Replies)
Discussion started by: mohtashims
7 Replies
LEARN ABOUT OSX
dbix::class::storage::dbi::oracle::wherejoins
DBIx::Class::Storage::DBI::Oracle::WhereJoins(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)
NAME
DBIx::Class::Storage::DBI::Oracle::WhereJoins - Oracle joins in WHERE syntax support (instead of ANSI).
PURPOSE
This module is used with Oracle < 9.0 due to lack of support for standard ANSI join syntax.
SYNOPSIS
DBIx::Class should automagically detect Oracle and use this module with no work from you.
DESCRIPTION
This class implements Oracle's WhereJoin support. Instead of:
SELECT x FROM y JOIN z ON y.id = z.id
It will write:
SELECT x FROM y, z WHERE y.id = z.id
It should properly support left joins, and right joins. Full outer joins are not possible due to the fact that Oracle requires the entire
query be written to union the results of a left and right join, and by the time this module is called to create the where query and table
definition part of the SQL query, it's already too late.
METHODS
See DBIx::Class::SQLMaker::OracleJoins for implementation details.
BUGS
Does not support full outer joins. Probably lots more.
SEE ALSO
DBIx::Class::SQLMaker
DBIx::Class::SQLMaker::OracleJoins
DBIx::Class::Storage::DBI::Oracle::Generic
DBIx::Class
AUTHOR
Justin Wheeler "<jwheeler@datademons.com>"
CONTRIBUTORS
David Jack Olrik "<djo@cpan.org>"
LICENSE
This module is licensed under the same terms as Perl itself.
perl v5.16.2 2012-08-16 DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)