02-27-2008
How to connect ORACLE using PERL
Hi Friends,
I am having Perl 5 and Oracle 9i. I just wanna to connect Oracle DB & to perform some select query statement.
Could anyone pls let me know.
I've tried below command which i found in some website, But it throws some error.
Executed:
perl -e 'use DBI; print $DBI::VERSION,"\n";'
Output
Can't locate DBI.pm in @INC (@INC contains: /usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib /usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1 /usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int /usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .) at -e line 1.
BEGIN failed--compilation aborted at -e line 1.
and I am not familiar with Perl. When i search for help on Google, I've found some reply like, DBI should be installed. Is this so. or are there any other way instead of using DBI.
Thanks in Advance,
Vijay,
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
HI,
So far i have been worked on sybase with perl and ksh scripts, i don't know how to connect using oralce, if any body could explain that is great.
Thanks in advance.
chendra (3 Replies)
Discussion started by: chendra.putta
3 Replies
2. Shell Programming and Scripting
Hi,
I am a new user, who wants to connect to oracle through shell scripting.
Can anybody help me?
Regards,
Divyesh (2 Replies)
Discussion started by: divyesh shah
2 Replies
3. 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
4. Shell Programming and Scripting
Hello,
Returing to Unix scripts after a long while,
This might be a simple question for most of you ,
I need to connect from a .sh script to oracle, select XYZ.nextval from dual ,
, meaning either get the Current Val or Next Val for a sequence.
How do I store the return value , I know... (2 Replies)
Discussion started by: Shanks
2 Replies
5. Programming
I am novice to perl. Can someone guide me on the below query. We have an existing perl script which connects to database to check the disk group status which i wanted to retieve directly from ASM rather than database.
This is because, a cluster has more than 4 databases running and a check on... (0 Replies)
Discussion started by: sai_rsk
0 Replies
6. UNIX for Dummies Questions & Answers
In unix i login as root but when i am conneting to SQL as sqlplus "/ as sysdba" then its telling "sh: sqlplus: not found".. (6 Replies)
Discussion started by: ripudaman.singh
6 Replies
7. Shell Programming and Scripting
I need to connect my Oracle 11g DB from shell script with 'sysdba' permissions. To do this I have to switch user from 'root' to 'oracle'.
I've tried the following with no success.
su - oracle -c "<< EOF1
sqlplus -s "/ as sysdba" << EOF2
whenever sqlerror exit sql.sqlcode;... (2 Replies)
Discussion started by: NetBear
2 Replies
8. Shell Programming and Scripting
I am novice to perl. Can someone guide me on the below query. We have an existing perl script which connects to database to check the disk group status which i wanted to retieve directly from ASM rather than database.
This is because, a cluster has more than 4 databases running and a check on... (1 Reply)
Discussion started by: sai_rsk
1 Replies
9. Shell Programming and Scripting
I try to connect to Oracle through cygwin, but it fails.
The Oracle version 11.2 is installed on a Windows 2003 server.
Cygwin and Perl is installed on the same server.
cygwin>uname -a
CYGWIN_NT-5.2 N0871 1.7.9(0.237/5/3) 2011-03-29 10:10 i686 Cygwin
cygwin>perl -v
This is perl, v5.10.1... (3 Replies)
Discussion started by: MSiipola
3 Replies
10. UNIX and Linux Applications
Good evening
I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus.
I tried to find out the user/passwd and service name by env variable and all Ive got is this:
ORACLE_SID_REPCOL=SCL_REPCOL
ORACLE_SID=xmeta
ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies
LEARN ABOUT X11R4
perl-after-upgrade
PERL-AFTER-UPGRADE(1) User Contributed Perl Documentation PERL-AFTER-UPGRADE(1)
NAME
perl-after-upgrade -- fixup FreeBSD packages that depend on perl
SYNOPSIS
perl-after-upgrade
perl-after-upgrade -f
perl-after-upgrade -v
DESCRIPTION
The standard procedure after a perl port (either lang/perl5.6 or lang/perl5.8) upgrade is to basically reinstall all other packages that
depend on perl. This is always a painful exercise. The perl-after-upgrade utility makes this process mostly unnecessary.
The tool goes through the list of installed packages, looks for those that depend on perl, moves files around, modifies shebang lines in
those scripts in which it is necessary to do so, tries its best to adjust dynamically linked binaries that link with libperl.so in the old
path, and updates the package database.
After installation of the new perl is complete, either by hand from the ports collection, or from a package, or via portupgrade, do the
following:
o go root;
o run perl-after-upgrade utility.
Do not specify any arguments at first, so it does nothing destructive. Pay attention to the produced output and especially to
errorlist at the end, if any;
o run the utility again, with -f command line option.
This will actually do the work. Again, pay attention to the output produced;
o fix any reported errors;
o reinstall required packages:
The utility will tell you what packages that depend on perl it could not handle. It will also tell you why it happened (for example,
they were compiled against a binary incompatible perl). If you want such packages to remain operational, you will have to reinstall
then by hand or via portupgrade.
o review the files left in the older perl installation.
This is typically /usr/local/lib/perl5/site_perl/5.X.Y/. There should be very little, if any, files in that directory and its subdi-
rectories, excepting a number of .ph files;
o check that things work as they should;
o remove backup files from the package database.
Those will be /var/db/pkg/*/+CONTENTS.bak;
o that's all.
COPYRIGHT AND LICENSE
Copyright 2005 by Anton Berezin
"THE BEER-WARE LICENSE" (Revision 42)
<tobez@FreeBSD.org> wrote this module. As long as you retain this
notice you can do whatever you want with this stuff. If we meet some
day, and you think this stuff is worth it, you can buy me a beer in
return.
Anton Berezin
NO WARRANTY OF ANY KIND, USE AT YOUR OWN RISK.
HISTORY
The first version of this utility was not bundled with perl package on FreeBSD. It was dumber than the current version in several impor-
tant areas. It was faster.
CREDITS
Thanks to Mathieu Arnold for discussion.
SEE ALSO
perl(1).
perl v5.8.9 2009-04-13 PERL-AFTER-UPGRADE(1)