Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Connect to Oracle with Perl through Cygwin

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Connect to Oracle with Perl through Cygwin
# 1  
Old 03-28-2014
Connect to Oracle with Perl through Cygwin
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.
Code:
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 (*) built for i686-cygwin-thread-multi-64int

The Perl @INC variable contains the current directory ('.')

There is a DBI.pm module installed.

I cd to the directory with the DBI.pm and do:
Code:
cygwin>perl -e 'use DBI;'
Can't load './auto/DBI/DBI.dll' for module DBI: No such file or directory at
at DBI.pm line 263
BEGIN failed--compilation aborted at DBI.pm line 263.
Compilation failed in require at -e line 1.
BEGIN failed--compilation aborted at -e line 1.

But there is a DBI.dll installed at ./auto/DBI.

Does this mean there is an installation problem or what?
Last edited by radoulov; 04-03-2014 at 12:20 PM.. Reason: Please use code tags; Marked as solved
# 2  
Old 04-01-2014
You might need an Oracle for LINUX installed by CygWin. JAVA JDBC tools are also less fussy, like the xigole jislt command line tool and SQuirreL gui. I take it you are looking to run command line SQL*Plus from a script? SQL*Plus is really not that script friendly, or friendly at all, so try jisql.
# 3  
Old 04-01-2014
Note that Oracle ships with its own Perl and DBI.
Try:

Code:
$ export PATH=$ORACLE_HOME/perl/bin:$PATH
$ # check with: which perl
$ export PERL5LIB=$ORACLE_HOME/perl/lib:$ORACLE_HOME/perl/lib/site_perl
$ # test it:
$ perl -MDBI -le1

Last edited by radoulov; 04-02-2014 at 08:52 AM..
# 4  
Old 04-02-2014
I think my problem is solved now.

The main problem was TWO perl installations. The cygwin perl and Oracle perl. When I run my test file I used the cygwin perl interprator, and dbi.pm file from the oracle perl installation. These two didn't match.

But when I run my script with the Oracle perl interprator + the oracle dbi/dbd.pm it worked!

Thanks!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

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

2. Shell Programming and Scripting

Use perl to connect to Oracle ASM as sysdba

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

3. UNIX for Dummies Questions & Answers

Oracle installation on cygwin

Can someone help in Oracle installation on cygwin (2 Replies)
Discussion started by: Uinx_addic
2 Replies

4. Shell Programming and Scripting

Switching user to oracle to connect Oracle 11g DB with 'sysdba'

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

5. UNIX for Dummies Questions & Answers

Not able to connect Oracle

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

6. Programming

Help on a perl script to connect to oracle ASM as sysdba

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

7. Shell Programming and Scripting

Perl connect to remote oracle db without local oracle installation

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

8. Shell Programming and Scripting

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.:confused: Executed: perl -e 'use DBI; print... (1 Reply)
Discussion started by: Vijayakumarpc
1 Replies

9. Shell Programming and Scripting

How to connect to oracle ??

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

10. Shell Programming and Scripting

HOw to connect oracle using ksh and perl script

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
Login or Register to Ask a Question