Script to test connecting to Oracle DBs

2012-07-27 Thread newbie01 perl
Hi all, I am looking for a Perl script or something similar that I can use to test connection from a client PC to several databases on a server. Does anyone know of any such script lying around somewhere :(- Currently, am testing connection from a client PC to an Oracle DB using Oracle's sqlplus

Re: Some DBI question -

2010-06-02 Thread newbie01 perl
on them or give a link reference that I can check On Tue, Jun 1, 2010 at 10:28 PM, Peter J. Holzer wrote: > On 2010-05-30 17:33:39 +1200, newbie01 perl wrote: > > Am trying out DBI for Oracle and just want to know if for example, I need > to > > include column formatting stuff

Some DBI question -

2010-05-29 Thread newbie01 perl
Hi, Am trying out DBI for Oracle and just want to know if for example, I need to include column formatting stuff etc., is it best to just put them into a .sql file and then execute the .sql file instead of placing them in the Perl DBI script? Also, is there anyway to sort of "hide" the password s

How to set LD_LIBRARY_PATH

2010-05-28 Thread newbie01 perl
Hi all, Can someone advise how to set LD_LIBRARY_PATH from within the Perl scripts? If I set LD_LIBRARY_PATH from the command line, all is okay [oracle ~]$ perl -e 'use DBD::Oracle; print $DBD::Oracle::VERSION,"\n";' Can't load '/oracle/product/db/11.1/perl/lib/site_perl/5.8.3/x86_64-linux-threa

Re: Help on using << on *nix and Windows

2010-04-19 Thread newbie01 perl
BI like you suggested, needs a lot of practice though ... will be good in the long run I suppose On Tue, Apr 20, 2010 at 12:11 AM, Peter J. Holzer wrote: > On 2010-04-19 21:21:45 +1200, newbie01 perl wrote: > > I need to convert a lot of UNIX scripts into Perl. > > No, you are trying

Help on using << on *nix and Windows

2010-04-19 Thread newbie01 perl
Hi all, I need to convert a lot of UNIX scripts into Perl. Most of them uses the UNIX's EOF/EOL functionality. These scripts are mostly used to connect to Oracle databases. At the moment, installing a DBI is not an option. The scripts will be running locally on the servers so technically it should

Re: Any Oracle DBA Around ???? - Perl DBI of Oracle Enterprise Manager (OEM) Install

2010-04-07 Thread newbie01 perl
15:17:15 newbie01 perl wrote: > > Hi Rob and all, > > > > Thanks for all your response. They are all very helpful. Unfortunately, > am > > not in the office at the moment. > > > > I agree with your suggestion about hacking one of the OEM Perl script but > &

Re: Any Oracle DBA Around ???? - Perl DBI of Oracle Enterprise Manager (OEM) Install

2010-04-07 Thread newbie01 perl
age, it is very generic, that it cannot find the DBI module. The script is very simple as below: #!/ use DBI; On Wed, Apr 7, 2010 at 12:16 AM, Rob Coops wrote: > > > On Tue, Apr 6, 2010 at 2:06 PM, Shlomi Fish wrote: > >> Hi Chen, >> >> "newbie01 perl"

Any Oracle DBA Around ???? - Perl DBI of Oracle Enterprise Manager (OEM) Install

2010-04-06 Thread newbie01 perl
Hi all, We currently have OEM installed but will have to uninstall it due to Oracle Licensing issues. Customers do not want to pay for the performance and diagnostic pack and are actually considering to move to SQLServer .. :-) Anyway, am wanting to try out and install oracletool or orcaware. Bot

Re: Perl DBI Oracle SYSDBA help/advise please:

2010-02-12 Thread newbie01 perl
Thanks Jared ... It must be the DBI and DBD version then On Fri, Feb 12, 2010 at 1:34 PM, Jared Still wrote: > On Wed, Feb 10, 2010 at 4:21 PM, newbie01 perl wrote: > >> Hi all, >> >> To anyone who had been using Perl DBI and Oracle, can you please confirm >> if

Perl DBI Oracle SYSDBA help/advise please:

2010-02-10 Thread newbie01 perl
Hi all, To anyone who had been using Perl DBI and Oracle, can you please confirm if connection by SYSDBA works or doesn't? I currently have the following DBI / DBD installed on this problem: DBI Version : 1.43 DBD Version : 1.15 Unfortunately, am not the SA so can't just install the latest modu