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.
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:
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
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.
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!
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)
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)
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)
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)
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)
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)
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)