existing app uses apache http server, perl and oracle
On my windows xp, I had cygwin already (installed and in PATH) and had to
1) unzip oracle instant client, and set PATH to inclue it
2) install strawberry perl v5.10.1
3) install DBD::Oracle using cpan (which can give you some trouble)
4) THEN install apache http server
5) configure it for cgi
Options Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews
and use #/strawberry/perl/bin/perl in my .pl files
and I was all set!
Also I learnt that if you change PATH variable after installing apache http server, even if you restart the service, it did not take the new PATH. So after putting oracle instant client on PATH I had to reinstall apache http!
For step 3
if you are getting error like
status 512 .... DynaLoader.pm...
or if you see
install_driver(Oracle) failed: Can't load 'C:/strawberry/perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified module could not be found at C:/strawberry/perl/lib/DynaLoader.pm line 200
most probably, your oracle client is not in PATH
I just unzipped oracle instant client and put it in PATH
and then set some env variables, and only after that invoked cpan
you can do "force install DBD::Oralce" to ignore test errors
but i was able to run most of the tests fine.
Be sure to look at http://win32.perl.org/wiki/index.php?title=Install_DBD::Oracle_on_Strawberry_Perl