OTN Discussion Forums : PHP5 Oracle Client OCI8 on Linux Ubuntu ...

Reply to this Thread

Search Forum

Back to Thread List

Replies: 9 - Pages: 1 - Last Post: Aug 4, 2008 1:14 AM Last Post By: DV

Threads: [ Previous | Next ]

Posts: 16
Registered: 01/21/08

PHP5 Oracle Client OCI8 on Linux Ubuntu Installation & Configuration Script
Posted: Jul 13, 2008 9:25 AM

Hello,
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.

BR
DV

cj2

Posts: 774
Registered: 01/10/01

Re: PHP5 Oracle Client OCI8 on Linux Ubuntu Installation & Configuration Script
Posted: Jul 21, 2008 12:03 PM

in response to: DV

If you want to make it easier, use the Easy Connect syntax so you don't need a tnsnames.ora file or to set TNS_ADMIN.

Your script says you did this in a Ubuntu VM on Mac. Do you have equivalent script for using the Mac version of Oracle Instant Client?

-- cj

Posts: 16
Registered: 01/21/08

Re: PHP5 Oracle Client OCI8 on Linux Ubuntu Installation & Configuration Sc
Posted: Jul 21, 2008 1:49 PM

in response to: cj2

I was planning to try to develop it also for mac in the next days but I have to see if everything will work properly.

Meanwhile I made a video demo about the installation on Ubuntu
http://www.youtube.com/watch?v=0A2WfY1eoew [UPDATED]

Cya
DV

cj2

Posts: 774
Registered: 01/10/01

Re: PHP5 Oracle Client OCI8 on Linux Ubuntu Installation & Configuration Sc
Posted: Jul 21, 2008 7:00 PM

in response to: DV

In the time it took me to bookmark the video, it became "unavailable" before I'd completed watching it.
Are you re-doing it?

Posts: 16
Registered: 01/21/08

Re: PHP5 Oracle Client OCI8 on Linux Ubuntu Installation & Configuration Sc
Posted: Jul 21, 2008 10:43 PM

in response to: cj2

You can try again as it should work now...

cj2

Posts: 774
Registered: 01/10/01

Re: PHP5 Oracle Client OCI8 on Linux Ubuntu Installation & Configuration Sc
Posted: Jul 22, 2008 9:57 AM

in response to: DV

This could be the start of a great series!

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.

-- cj

Posts: 16
Registered: 01/21/08

Re: PHP5 Oracle Client OCI8 on Linux Ubuntu Installation & Configuration Sc
Posted: Jul 22, 2008 12:37 PM

in response to: cj2

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.

cj2

Posts: 774
Registered: 01/10/01

Re: PHP5 Oracle Client OCI8 on Linux Ubuntu Installation & Configuration Sc
Posted: Jul 23, 2008 12:23 PM

in response to: DV

Delete it

Posts: 16
Registered: 01/21/08

Re: PHP5 Oracle Client OCI8 on Linux Ubuntu Installation & Configuration Sc
Posted: Jul 24, 2008 12:33 AM

in response to: cj2

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.

Bye

Posts: 16
Registered: 01/21/08

Re: PHP5 Oracle Client OCI8 on Linux Ubuntu Installation & Configuration Sc
Posted: Aug 4, 2008 1:14 AM

in response to: cj2

Do you have equivalent script for using the Mac version of Oracle Instant Client?

The equivalent for Mac is ready. I posted it here
http://forums.oracle.com/forums/thread.jspa?threadID=690100

Pages: 1

Back to Thread List

Threads: [ Previous | Next ]

Legend
	Guru : 2500 - 1000000 pts
	Expert : 1000 - 2499 pts
	Pro : 500 - 999 pts
	Journeyman : 200 - 499 pts
	Newbie : 0 - 199 pts
	Oracle ACE Director
	Oracle ACE Member
	Oracle Employee ACE
	Helpful Answer (5 pts)
	Correct Answer (10 pts)