Connect to Oracle with Perl through Cygwin Post: 302894969

Sponsored Content

Top Forums Shell Programming and Scripting Connect to Oracle with Perl through Cygwin Post 302894969 by MSiipola on Friday 28th of March 2014 06:51:13 AM

03-28-2014

Registered User

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

MSiipola

View Public Profile for MSiipola

Find all posts by MSiipola

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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...

4. 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...

5. 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...

6. 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"..

7. 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;...

8. UNIX for Dummies Questions & Answers

Oracle installation on cygwin

Can someone help in Oracle installation on cygwin

9. Shell Programming and Scripting

Use perl to connect to Oracle ASM as sysdba

10. 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...

LEARN ABOUT DEBIAN

template::dbi

Template::DBI(3pm)					User Contributed Perl Documentation					Template::DBI(3pm)

NAME

       Template::DBI - DBI plugin for the Template Toolkit

SYNOPSIS

	   $ perldoc Template::Plugin::DBI

DESCRIPTION

       The Template-DBI distribution contains the DBI plugin for the Template Toolkit.	At some point in the future it is likely to contain other
       DBI-related plugins and extension modules for the Template Toolkit.

       The DBI plugin was distributed as part of the Template Toolkit until version 2.15 released in May 2006.	At this time it was extracted into
       this separate Template-DBI distribution.

       See the documentation for Template::Plugin::DBI for further details on using the DBI plugin.

AUTHORS

       The DBI plugin was originally written by Simon A Matthews, and distributed as a separate module.  It was integrated into the Template
       Toolkit distribution for version 2.00 and included contributions from Andy Wardley, Craig Barratt, Dave Hodgkinson and Rafael Kitover.
       Andy Wardley extracted it back into a separate distribution in May 2006.  After that, in 2010 Jens Rehsack maintains this distribution.

COPYRIGHT

	 Copyright (C) 1999-2006 Simon Matthews, Andy Wardley.	All Rights Reserved
	 Copyright (C) 2010 Jens Rehsack.  All Rights Reserved

       This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

SEE ALSO

       Template, Template::Plugins, Template::Plugin::DBI, DBI, Tie::DBI

perl v5.10.1							    2011-02-05							Template::DBI(3pm)