I have just written 2 bash scripts for the installation and configuration of Apache2, PHP5, Oracle Client v10.2 and OCI8. The scripts were tested on Linux Ubuntu 8.04.1 Server and it seems they also work on some previous versions of Linux Ubuntu and Kubuntu Server and Desktop Editions.
The first script OracleViaPHP.sh downloads, installs and configures all the needed packages. It can be found here http://www.danilovizzarro.it/script/OracleViaPHP.sh
The second script TNSconnect.sh updates the tnsnames.ora file and creates a PHP test page to connect the Oracle DB. It can be found here http://www.danilovizzarro.it/script/TNSconnect.sh
In order to have them working it's required to download the oracle client basic lite and the SDK in the /root directory.
A step-by-step tutorial can be found here http://www.danilovizzarro.it/?p=7
I'm curious to know what you think of it.
In the intro, the in-video explanation text could say where the files come from and what they do.
Over half of the video consists of updating Ubuntu packages (e.g the kernel!) - this makes the video harder to follow and makes the installation seem harder than it really is. It also doesn't match the statement that the OS has been installed. If viewers think the install requires a lot of extra files and OS changes, you might frighten people from doing the install.
Setting the root password and not disabling it again is not the best example of security. Why not just "sudo gnome-terminal" or "sudo xterm" ?
For visual clarity, I'd suggest removing the window translucency.
Thank you for your feedback. I will try to make a new video soon.
I preferred to record everything including the updates of the packages cause in case of error during the installation it would be possible to compare what happen in the video.
Now I don't know if it would be better to delete that part, maybe would be enough to speed it up a bit more.
Check this out. http://www.youtube.com/watch?v=0A2WfY1eoew
translucency removed, boring part deleted
I didn't disable the root account at the end cause it seem that there can be a problem after to re-enable it.
I tried to edit the script to let it work on mac, everything end without errors but I cannot get the OCI module visible.