Installing Apache, PHP, JDeveloper, and the PHP Extension on Linux
Authors: Chris Jones, Manuel Hossfeld, Matthias Brandl
Publication Date: November 2004

Note: This guide, which offers a high-level yet comprehensive approach to installing PHP and JDeveloper on Linux, was used for the November 2004 Oracle and PHP Installfest at the International PHP Conference in Frankfurt. For detailed install guides relating to specific tasks , see the Open Source Developer Center.

For this demonstration we'll install the components in a user account. For the sake of simplicity, we recommend that you use the "oracle" account. (You won't have to switch users at all this way.)

These steps assume Oracle Database 10g is installed.

Apache 1.3

1. Login as Oracle user.
2. Copy/download apache_1.3.31.tar.gz
3. tar -zxf apache_1.3.31.tar.gz
4. cd apache_1.3.31
5. Configure:

   ./configure --enable-module=so --prefix=$HOME/apache --with-port=8888
   

6. Build: make
7. Install: make install
8. Start Apache: $HOME/apache/bin/apachectl start
9. Go to a browser and check that http://localhost:8888/ returns the default "Powered by Apache" page.
10. Stop Apache: $HOME/apache/bin/apachectl stop

Before you proceed, make sure that the packages "bison" and "flex" are installed, because PHP needs them.

1. Copy/download php-4.3.9.tar.gz
2. tar -zxf php-4.3.9.tar.gz
3. Set environment variable ORACLE_SID
4. Set environment variable ORACLE_HOME
5. Set environment variable LD_LIBRARY_PATH to $ORACLE_HOME/lib:${LD_LIBRARY_PATH}
6. Configure (make sure to enter this as one long line):

   ./configure --prefix=$HOME/php --with-apxs=$HOME/apache/bin/apxs
    --with-config-file-path=$HOME/apache/conf
    --with-oci8=$ORACLE_HOME --enable-sigchild
   

7. Build: make
8. Install: Make install
9. cp php.ini-recommended $HOME/apache/conf/php.ini
10. Edit $HOME/apache/conf/httpd.conf and add:

    AddType application/x-httpd-php        .php
    AddType application/x-httpd-php-source .phps
    

11. Restart Apache
12. create $HOME/apache/htdocs/phpinfo.php as:

    <?php
      phpinfo();
    ?>
    

13. In a browser load http://localhost:8888/phpinfo.php. Check that the OCI module is listed.

1. Insert your "Oracle Developer CD - Java, Web Services, and PHP" disk.
2. Open a browser and load "Start_Here.html" (Many of the links in the sub-pages are to www.oracle.com. Without internet access, these will not work.)
3. Click Install Now!.
4. Agree to the license.
5. Close the popup which asks about OTN Java Newletter.
6. Remember the password: 10gJ2EE
7. Click on the "Click here" link next to the JDeveloper entry:
1. Choose Save to disk.
2. Go to a shell.
3. Create a directory such as $HOME/jdev9052 and move the ZIP to this directory
4. Unzip the ZIP file using the password 10gJ2EE.
8. Do: chmod +x <installdir</jdev/bin/jdev
9. Run: <installdir>/jdev/bin/jdev
10. Enter the full path to your JDK ($ORACLE_HOME/jdk will do).
11. Choose Yes to create the working directory.
12. Choose No to migrate existing data.
13. Navigate to Tools->Preferences->Web Browser and Proxy and set the "Browser Command Line" to your browser, e.g. <firefoxhome>/firefox

PHP Extension

1. Follow steps similar to JDeveloper installation to extract the PHP Extension ZIP
2. Move the php-addin.jar to <installdir>/jdev/lib/ext
3. Restart JDeveloper: <installdir>/jdev/bin/jdev
4. Navigate to Tools->Preferences->PHP and set the command line executable to $HOME/php/bin/php

1. If you didn't already unlock the database user "scott" at the end of the Oracle 10g installation, run sqlplus system/<your_system_password> and do:

   alter user scott account unlock;
   exit
   

2. Run JDeveloper.
3. In the Applications Navigator select Applications.
4. Navigate to File->New. Expand the General node and select Workspaces. In the right hand pane select Workspace and click OK.
5. In the "Create Workspace" pane choose a new name: MyWS. Un-check Add a New Empty Project and click OK.
6. In The Applications Navigator, right click on your new workspace, MyWS. Choose New.
7. Expand the General node and select Projects. In the right hand pane select PHP Project and click OK.
8. In the PHP Project Wizard:
1. Choose a new name, MyP, and click Next.
2. Ignore the URL Mapping page and click Finish.
9. In the Applications Navigator, right click on Project. Choose New.
10. Expand Web Tier and select PHP. In the right hand pane select PHP File and click OK.
11. Change the file name to myoci.php and click OK.
12. In the new file, insert the following code, changing "MYSID" to the actual SID (service name) of your database.

    <?php
    
      define('ORA_CON_UN', 'scott');
      define('ORA_CON_PW', 'tiger');
      define('ORA_CON_DB', 'MYSID');
    
      $conn = OCILogon(ORA_CON_UN, ORA_CON_PW , ORA_CON_DB );
    
      if (!$conn) {
                exit;
      }
    
      echo OCIServerVersion($conn) ."<br>\n";
      echo "Connected as ".ORA_CON_UN. "</br>\n";
      echo date('Y-m-d H:i:s')."<br><br>\n";
    
      $query = 'select * from emp';
    
      $stid = OCIParse($conn, $query);
      OCIExecute($stid, OCI_DEFAULT);
      print "<table border='1'>\n";
      while ($succ = OCIFetchInto($stid, $row, OCI_RETURN_NULLS)) {
        print "<tr>\n";
        foreach ($row as $item) {
          print '<td>';
          print isset($item)?htmlentities($item):' ';
          print "</td>\n";
        }
        print "</tr>\n";
      }
      print "</table>\n";
    
      OCILogoff($conn);
    ?>
    

13. When JDeveloper "runs" this file, it will start up your browser with an "http://" URL associated with the file. Apache needs to know the URL-to-file mapping, and JDeveloper needs to know what URL to use. Edit httpd.conf and add the following lines, replacing "/home/cjones" with the home directory of the account you're using (e.g. "/opt/oracle"):

    Alias /MyWS/MyP/public_html/ "/home/cjones/jdevhome/mywork/MyWS/MyP/public_html/"
    <Directory "/home/cjones/jdevhome/mywork/MyWS/MyP/public_html">
      Options Indexes MultiViews
      AllowOverride None
      Order allow,deny
      Allow from all
    </Directory>
    

    and restart Apache.
14. In the Applications Navigator, right click on MyP and select Project Properties.
1. Select PHP Script Execution Settings.
2. Add the port number 8888 to the URL, making it http://localhost:8888/MyWS/MyP/public_html/.
3. Click Test URL. There should be four lines of output, each testing a variation of the URL. The final row with the full URL should show Success. Click OK.
15. In the Applications Navigator, right click on MyP and select Run. Browse the Run Target and use your new file, myoci.php. Click OK. A new browser should open up showing the results of the query.