Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> AW: AW: Oracle 10g for Windows

AW: AW: Oracle 10g for Windows

From: Stefan Jahnke <Stefan.Jahnke_at_bov.de>
Date: Thu, 19 Feb 2004 10:32:52 +0100
Message-ID: <87F172BCF111D0489340AB3CB16A011E0DD1E1@EBMS20.bov.int> 





Hi myself



To answer my own question (maybe somebody else might use that, too):



Getting DBI 1.40 from CPAN plus the DBI::Proxy related modules =
(Storable (I


got 2.07), PlRPC and Net::Daemon and compiling them on cygwin (Perl =
5.8.2)


works.



Get and install ActiveState Perl 5.8.3 (build 809) for Windows.



Then download the DBI 1.40 plus DBD Oracle module for ActiveState 5.8.2 =
from


http://www.cedet.dk/perl/.


Install all the modules using ppm3.



Start the dbiproxy server on windows, using a config file like this:



{

  'localport' =3D> 3333,
  'pidfile' =3D> 'c:\perl\etc\dbiproxy.pid',
  'logfile' =3D> 1,
  'debug' =3D> 1,
  'mode' =3D> 'single',
  'timeout' =3D> 60




}



Try using the proxy from cygwin with a script like this:



use DBI;


use Data::Dumper;



my ($dbh, $sth, $row);


$user=3D"myuser";
$pwd=3D"mypwd";
$dsn=3D"dbi:Oracle:host=3Dlocalhost;sid=3Dmysid";





$dbh =3D


DBI->connect("dbi:Proxy:hostname=3D127.0.0.1;port=3D3333;dsn=3D$dsn",$us=
er,$pwd,{R


aiseError =3D> 1, PrintError =3D>1}) or die$DBI::errstr;
print "Connected ...\n";



$sth =3D $dbh->prepare('select * from subject where id < 5');
$sth->execute;



while ($row =3D $sth->fetchrow_hashref)


{


print Dumper($row);


}



$sth->finish;


$dbh->disconnect;



I had trouble first with the set username and the disconnect methods, =
but as


soon as both dbi version were 1.40, everything worked.=20



Whoever is interested: Perl Tk800.025 (from CPAN) also works on cygwin. =
That


plus a multiwindow XFree config makes you almost feel like /home ;).



Stefan



-----Urspr=FCngliche Nachricht-----


Von: Stefan Jahnke=20


Gesendet: Wednesday, February 18, 2004 1:14 PM
An: 'oracle-l_at_freelists.org'


Betreff: AW: AW: Oracle 10g for Windows




Hi



If Net::Daemon doesn't work on windows, I'm actually wondering about =


=3D



how to


get dbiproxy to work on windows anyway.


In O'Reilly's DBI programming, the author suggests a setup for =3D
connecting to


a DB running on Windows via Proxy from=3D20
a UNIX machine. Totally doesn't work for me.



Did anybody ever get this to work? Or am I on the wrong list for =3D
questions


like this?



Stefan



-----Urspr=3DFCngliche Nachricht-----


Von: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com]
Gesendet: Tuesday, February 17, 2004 8:15 PM
An: oracle-l_at_freelists.org


Betreff: Re: AW: Oracle 10g for Windows




I don't believe that Net::Daemon will work under Windoze.
The only daemons I have personally created have been
via Dave Roth's  Win32::Daemon.



These are daemons on that interact with services.exe.



It may be possible to subvert HTTP::Daemon for use as Net::Daemon,
but I really don't know.



When I need to interact with something on a Windows system, I tend
to do it with this checklist in mind:






If it has to be done on the server, and Perl is the tool of choice, I =


=3D



try


to minimize the number of components.



ie. I don't want to rely on Cygwin.



I will install Perl, and the modules needed to do the job.



I've don't try to setup the Cygwin Perl to use DBD::Oracle, etc.



Instead, I just use the Active State perl when in a Cygwin shell,
which I only do from my laptop.



Jared









Stefan Jahnke <Stefan.Jahnke_at_bov.de>


Sent by: oracle-l-bounce_at_freelists.org


 02/17/2004 10:32 AM


 Please respond to oracle-l



=3D20


        To:     "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>
        cc:=3D20
        Subject:        AW: Oracle 10g for Windows






Hi Jared



Since you are the list's official Perl guru:



Speaking of making impossible things possible:
Is there a way of getting a DBI::Proxy server=3D3D20
to work under windows using Active State (5.6)?
I needed to install Net::Daemon and PlRPC,=3D3D20
but I keep getting Net::Daemon errors reporting=3D3D20
non-implemented methods needed by dbiproxy.



I would like to use that to run perl scripts=3D3D20
that were developed on and for unix to be run=3D3D20
on Cygwin, connecting to a local dbiproxy running=3D3D20
on Win2k (ActiveState Perl).



Any chance?



Stefan



Stefan Jahnke


Consultant


BOV Aktiengesellschaft


Tel.: +49 201/45 13-298


Fax: +49 201/45 13-144


mailto:stefan.jahnke_at_nospam.bov.de


Please remove nospam to contact me via email.
http://www.bov.de


Abonnieren Sie unseren Newsletter: http://www.bov.de/enews



Optimieren Sie durch Portale Ihr taegliches Geschaeft: Wie Anwendungen =


=3D

=3D3D



in


einem dynamischen Prozesskontext Ihre Informationsprozesse deutlich
beschleunigen koennen, erfahren Sie von mailto:martin.ostrowski_at_bov.de



Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht =


=3D3D



unter


fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde =3D3D
bitten wir


um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die =3D3D
rechtliche


Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.



As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask =


=3D

=3D3D



for


your understanding that, for your own protection and ours, we must =


=3D3D



decline


all legal responsibility for the validity of the statements and =3D3D
comments


given above.




-----Urspr=3D3DFCngliche Nachricht-----


Von: Jared Still [mailto:jkstill_at_cybcon.com]
Gesendet: Dienstag, 17. Februar 2004 17:03
An: Oracle-L Freelists


Betreff: RE: Oracle 10g for Windows




Robert,



The point with several of these items is that they=3D3D20
are not provided with the OS.



Re the services: stopping and starting a service will
not pick modifications to the environment. It requires
a reboot.



As for your comment on Perl:  You don't appear to have
too much experience with it.  Perl makes hard things
easy, and impossible things possible.  :)



Jared



On Mon, 2004-02-16 at 06:48, Freeman Robert - IL wrote:

> Comments inline ...
>=3D3D20
> RF
>=3D3D20
> -----Original Message-----
>=3D3D20
> >> What I dislike about working with Oracle on Windows:
>=3D3D20
> >> * No decent scheduler.  Yes there is 'at'.  Like I said...
> Good point, though this should be less of an issue with the new =3D3D


Oracle


> Database 10g Scheduler, which is supposed to be able to kick off =


=3D3D



external


> programs (including batch programs). I have not played with this =


=3D3D



specific

> bit of functionality much, but what I have played with worked.
>=3D3D20
> >> * Installing Perl on win32 with all needed modules has become =3D


a=3D3D20


> >> monumental pain in the rear.


> Hmmmmmm..... Another reason that Perl just isn't one of my fav. =3D3D
scripting

> languages.
>=3D3D20
> >> * Why can't MS provide a semi-decent code editor.
> >> Yeah, notepad. Right.
> and vi or ed is any better??? Granted, once you learn vi, it's pretty


cool,


> but in the begining? UGH! My vote for best windows editor is =3D3D
textpad....

> hands down the best editor I've ever used.
>=3D3D20
> Anyone remember an editor called EC? Do they still make it?
>=3D3D20
> >> * Command line utilities.  You think unix/linux is arcane?
> Actually, you can do a lot at the command line in NT.... Of course, =




=3D

=3D3D



it's


not


> as robust as UNIX (have yet to find, for example, a fold command). =


=3D

=3D3D



Still,


if


> you are some C or basic coding experience or you are adept at the =


=3D3D



web,


it's

> not too bad.=3D3D20
>=3D3D20
> >> * The fact that an incredibly robust PIPE implementation is built =




=3D

=3D3D



in,


> >> but there is no access from the command line.  And that Oracle is =


=3D

=3D3D



built


> >> with the MS stdlib ( think that's the sitation ) so even
> >> when you get 3rd party tools that work with PIPE's, they won't =


=3D3D



work

> >> with Oracle.
> Ok, I agree, this has been an issue with me as well.=3D3D20
>=3D3D20
> >> * The fact that there are still drive letters.
> Ahhhh, so what? :-) Drive letters, mount points, who cares?=3D3D20
>=3D3D20
>=3D3D20
> >> * That MS has *finally* got around to offering unix like =3D3D


utilities, but


> >> wants $100 for them, on top of the money you've already paid for =


=3D

=3D3D



the=3D3D20


> >> OS.


> I've seen NT related UNIX utilities around for a while (don't recall =


=3D

=3D3D



if


they

> were MS though).=3D3D20
>=3D3D20
> >> * That it took until Win23k for MS to design the system to allow
> >> different versions of apps to have different versions of DLL's.
> >> Lesse, we've been doing this on unix for 30 years or so?
> Hey, we all have growing pains! :-)
>=3D3D20
> >> * The stupid Oracle home selector that is strictly a GUI.
> I have yet to use the Oracle home selector. Of course, I'm an old =




=3D3D



Oracle

> command line guy.... OEM gives me a rash.
>=3D3D20
> >> * That whenever a change in environment is made that needs to be =




=3D

=3D3D



picked


> >> up by an existing or new service, you must reboot because there is =


=3D

=3D3D



no


> >> other way to reset the environment seen by services.exe.
> Can't you just stop and restart the service? How often does one need =


=3D

=3D3D



to


> change the environment in production anyway (hopefully not that often =


=3D

=3D3D



once

> it's stable!)
>=3D3D20
> >> Mind you now, Oracle runs just fine on win32.  It's maintaining it =




=3D

=3D3D



and


> >> working with the environment that is so annoying, and made =3D3D
difficult


> >> where it shouldn't be.


> For me, the scheduler has been the biggest issue of all of these. =


=3D3D



Frankly,


> the others don't cause me much of an issue. Each platform has it's =


=3D

=3D3D



good


and


> bad side. Which would I prefer, Oracle on UNIX... but I just don't =


=3D

=3D3D



think

> Windows is that bad.
>=3D3D20
> Jared
>=3D3D20
>=3D3D20
>=3D3D20
> On Fri, 2004-02-13 at 12:26, Freeman Robert - IL wrote:
> >  My 2 cents...
> >=3D3D20
> > Most of the complaints I see about Oracle on Win here are either:
> >=3D3D20
> > 1. By people doing it for the first time, or who rarely do it.
> > 2. By people who are doing Oracle for the first time, or rarely do =




=3D

=3D3D



it.

> >=3D3D20
> > I actually like Oracle on Win, and I agree with Tom, I've had few
> problems
> > with it.
> >=3D3D20
> > I agree that installing service packs is maddening, but don't most
> Unix OS
> > upgrades of any great import seem to require a reboot?=3D3D20
> >=3D3D20
> > Robert
> >=3D3D20
> >=3D3D20
> > -----Original Message-----
> > From: Koivu, Lisa
> > To: oracle-l_at_freelists.org
> > Sent: 2/13/2004 12:53 PM
> > Subject: RE: Oracle 10g for Windows
> >=3D3D20
> > Hi Tom,=3D3D3D20
> >=3D3D20
> > Are you kidding?  You never have to install service packs and
> reboot?=3D3D3D20
> >=3D3D20
> > We run windows 2003 and our "vice president" in IT decided that as =




=3D

=3D3D



a

> > corporate standard we should turn on auto-update and let the boxes
> > reboot themselves.  Excuse me??=3D3D3D20
> >=3D3D20
> > The more I work on Windows, the more I do not like it.  However, =




=3D

=3D3D



I'm

> in
> > the same boat as you.  You make do with what you are given when you
> are
> > not personally paying the bill.
> >=3D3D20
> > Lisa Koivu
> > Senior Monkey
> > Orlando, FL, USA
> >=3D3D20
> > -----Original Message-----
> > From: Mercadante, Thomas F
> > [mailto:thomas.mercadante_at_labor.state.ny.us]=3D3D3D20
> > Sent: Thursday, February 12, 2004 8:58 AM
> > To: 'oracle-l_at_freelists.org'
> > Subject: RE: Oracle 10g for Windows
> >=3D3D20
> > Unfortunately, we have to put up with unrealistic comments like =




=3D3D



these.

> > let
> > me repeat it again for those who forget:
> >=3D3D20
> > Some of us have no choice in the operating system that we work =




=3D3D



with.

> > And
> > some of us are running systems under a Windows environment and are
> > perfectly
> > happy with how things run, and *never ever* have the "problems" =




=3D3D



that

> get
> > reported here. =3D3D3D20
> >=3D3D20
> > I have windows databases that have been running for 3 years now.
> > *Never*
> > does the machine crash.  And *never* do we reboot "just because we
> > should".
> >=3D3D20
> > If you experience bad things, then I suggest you take it up with =




=3D

=3D3D



your

> > system
> > admin.  More than likely, somebody was allowed to treat a database
> > server
> > like a personal desktop.
> >=3D3D20
> > Just my 2 cents.
> >=3D3D20
> > Tom Mercadante
> > Oracle Certified Professional
> >=3D3D20
> >=3D3D20
> > -----Original Message-----
> > From: Jamadagni, Rajendra [mailto:Rajendra.Jamadagni_at_espn.com]
> > Sent: Thursday, February 12, 2004 8:46 AM
> > To: oracle-l_at_freelists.org
> > Subject: RE: Oracle 10g for Windows
> >=3D3D20
> >=3D3D20
> > Remind me again .. is this oracle-l forum or slashdot ??
> >=3D3D20
> > <g>
> >=3D3D20
> > Raj
> >
> =3D3D
------------------------------------------------------------------------=




=3D

=3D3D



> > -=3D3D3D3D
> > -------
> > Rajendra dot Jamadagni at nospamespn dot com
> > All Views expressed in this email are strictly personal.
> > QOTD: Any clod can have facts, having an opinion is an art !
> >=3D3D20
> >=3D3D20
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org
> > [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of David Sharples
> > Sent: Thursday, February 12, 2004 8:44 AM
> > To: oracle-l_at_freelists.org
> > Subject: RE: Oracle 10g for Windows
> >=3D3D20
> >=3D3D20
> > Define dominant?
> >=3D3D20
> > The chances of Linux overtaking the average desktop in the world =




=3D

=3D3D



are

> > pretty slim and Linux is not really mature enough to run enterprise
> > level stuff - maybe soon it will be.
> >=3D3D20
> > Sun and HP are Windows are still more widely used (rightly or =3D3D


wrongly)

> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to:  oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to:  oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------


> >=3D3D20


> > "The sender believes that this E-Mail and any attachments were free =


=3D

=3D3D



of


> =3D3D3D


> > any virus, worm, Trojan horse, and/or malicious code when sent. =


=3D3D



This =3D3D3D


> > message and its attachments could have been infected during =3D3D3D
> > transmission.  By reading the message and opening any attachments, =


=3D

=3D3D



the

> =3D3D3D
> > recipient accepts full responsibility for taking proactive and
> remedial
> > =3D3D3D
> > action about viruses and other defects. The sender's business =3D3D


entity

> is
> > =3D3D3D
> > not liable for any loss or damage arising in any way from this =




=3D3D



message

> =3D3D3D
> > or its attachments."
> >=3D3D20
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to:  oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to:  oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
>=3D3D20
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

----------------------------------------------------------------


Please see the official ORACLE-L FAQ: http://www.orafaq.com




To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------




=3D3D20

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------




----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------




=3D20

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------




=20

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


Received on Thu Feb 19 2004 - 03:32:52 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US