With the help of Brian Haas and Ian Harisay I got DBD::Oracle working.
The advice is to use the regular Oracle9i not the lite version.
Another great source of help was:
http://www.puschitz.com/InstallingOracle9i.html
just getting 9i and 9i lite installed. I use fvwm2(nvidia X driver) as
a window
After some time I got Oracle 9i Lite on my Redhat9 (downloaded .iso
images) machine. I can use sqlplus to connect to an off-machine
database and get data. However I cannot find the Pro*C package in the
installer so I can get DBD::Oracle built.
I read the README, README.help, and README.clients.