Published in: China PHP Alliance www.phpx.com Authors / Source: Kaln / PHPUSER Popularity: 76
Under Redhat 6.2 Oracle8.1.6i apache1.3.14 php4.0.3 Fully Install Example 1. This article ● Install Oracle8 Database Server under RedHat ● Install Apache and support WML ● Install PHP 2. Preparation before installation: Redhat 6.2 Installation CD Oracle8.161.tar.gz Download Download: http://freeware.online.sh.cn/mirrors/linuxapps/database/oracle/oracle8.161.tar.gz Java Running Environment (JRE) download address: ftp://165.21.84.42/pub/j2sdk/1.3.0/XZC233FCSLNX/J2SDK-1_3_0-linux-rpm.sh apache 1.3.14 download address: http://www.apache.org /Dist/apache1.3.14.tar.gz php4.0.3 PL1 download address: http://www.php.net/do_download.php?download_file =php- 4.0.3pl1.tar.gz & source_site = www.php.net 3. Pre-installation of Oracle ● Install jre1.3.0 [root @ WAPDB / ROOT] # # Sign in as root [root @ WAPDB / ROOT] # chmod 755 j2re-1_3_0-linux-rpm.sh # change J2RE-1_3_0-Linux- RPM.SH permissions [root @ wapdb /root]#./ j2re-1_3_0-linux-rpm.sh # Run J2RE-1_3_0-linux-rpm.sh in the same-level directory to get the JRE RPM package. [root @ WAPDB / ROOT] # rpm -i j2re-1_3_0-linux-rpm # Install JRE1.3.0: ● Create Oracle. Apache User Group: Perform the following command: [Root @ WAPDB / ROOT] # # Log in in root [root @ WAPDB / ROOT] # GroupAdd Oracle # Create Oracle Group [root @ WAPDB / ROOT] # UserAdd Oracle -g Oralce # Used in Oracle Group Oracle [root @ WAPDB / ROOT] # UserAdd Apache -g Oralce # Updated User Apache in Oracle Group Apache [root @ WAPDB / ROOT] # passwd Oracle # Modify Oracle User Password Note: Oracle Group and Oracle users are Oracle Installation Need Note: After creating an Oracle user, the Linux system automatically creates the / home / oracle directory in the / home directory, uses Oracle users, and Oracle users have all permissions for this directory.
[Root @ wapdb / root] # cd / home / oracle [root @ wapdb / root] # vi .bash_profile # editing .bash_profile file, and enter the following # Setup ORACLE environment NLS_LANG = "SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280"; export NLS_LANG JAVA_HOME = / usr / java / jre1.3 bash_env = HOME / .BASHRC ORACLE_HOME = / data / oracle / app / oracle / product / 8.1.6 export oracle_home oracle_sid = WAP EXPORT ORACLE_SID # set up the search path: Path = $ PATH : $ HOME / BIN: $ java_home / bin: $ oracle_home: $ oracle_home / bin: $ oracle_home / d BS export username bash_env path oracle_home java_home 4. Install Oracle8i [Root @ WAPDB / Oracle] # EXIT # to log in, log in to Oracle users to make the set environment to take effect [Oracle @ WAPDB / ORACLE] $ [Oracle @ WAPDB / ORACLE] $ TAR ZXVF ORACLE8161_TAR.GZ # unzipped Oracle compression package to the current directory [Oracle @ WAPDB / ORACLE] $ startX # After starting X-Windows, enable a terminal (XTERM), (graphic window) running Runinstaller in the terminal [Oracle @ WAPDB / ORACLE] $ CD Oracle8ir2 # Enter the decompressed directory [Oracle @ WAPDB / ORACLE8IR2] $ ./RunInstaller # Execute an Oracle installer.
At this time, you can see the graphical OUI welcome screen running with JRE, follow the prompts to continue the installation process (here we can choose typical installation): Welcome: Press Next File Locations: Press Next UNIX Group Name: Oracle, press NEXT error Tip To run ROOT privilege "/Data/oracle/app/oracle/product/8.1.6/orainstroot.sh Ctrl Alt F2, open a new console (character window) Log in to root [root @ WAPDB / ROOT] # cd /data/oracle/app/racle/Product/8.1.6 This time, / data / oracle / app / oracle / product / 8.1.6 has a file ORAINSTROOT.SH, run it [root @ wapdb / 8.1.6]:# Stroot.sh Ctrl Alt F7, return to the installation interface (graphics window) Press the Retry button to continue installed, Available Products: Select Oracle8i Enterprise Edition 8.1.6.1.0, press Next Installation Typical (540MB), press Next, then a progress scale Database Identification: Global Database Name: Enter WAP (can be arbitrary) SID: WAP Press Next Database File Location: Arbitrary Directory, this example For "/Data/oracle/app/racle/product/8.1.6/data", press Next, at this time, the upper right corner scheduler continues to advance, Summary, make a summary of the product you want to install, put press Install, appears Install screen, wait ... You can see the Log file directory of the installation of the bottom prompt of the window, you can query later. Pop-up SETUP Privileges window prompt: Before installation continues, you need to run a script with root "/ data / oracle / app / Oracle/Product/8.1.6/root.sh ", Ctrl Alt F2, returned to the second terminal window just run to execute this file with root privilege, [root @ WAPDB / 8.1.6]# sh root. SH screen display: ENTER T HE FULL PATHNAME OF THE LOCAL BIN DIRECTORY: [/ usr / local / bin]: The carriage return system starts to perform some action, the execution is complete, Ctrl Alt F7 is returned to OUI, press OK.
Database Creation Progress began to gradually make the following four processes Creating and starting Oracle instance Copying database files Initializing database Database creation completed more than four process is complete, the pop Oracle Database Configuration Assistant Alert window that prompts: the database is created, to tell you some basic database Information Global Database System Identifier (SID): WAP Sys Account Password: CHANGE_ON_INSTALL SYSTEM Account Password: Manager Press OK End of Installation, press EXIT to exit OUI, complete the installation. At this point, the installation of the database server has been completed, and the next step is installed in the WEB / WAP server. 5. Install the Oracle client (this step is suitable for installing the database server with the web server on different machines, if you direct step 6 for the same machine) Repeat Step 3 Select "Client Installation" step in step 4. the same. Configure the TNSNames.ora file (which can be configured on / $ oracle_home / bin / running the netasst command). The fastest way is the TNSNames.ora to $ Oracle_home / network / admin / network. Log in to Oracle User [Oracle @ Wapserver /] $ ORACLE_HOME / Network / Admin [Oracle @ Wapserver Admin] $ FTP XXX.XXX.XXX.XXX # Using FTP to log in to the Oracle server, use Oracle and use Oracle users. Ftp> CD /Data/oracle/app/racle/product/8.1.6/neetwork/admin ftp> get tnsnames.ora ftp> bye 6. Configuring apache_1.3.14 [root @ wapdb / local] # tar zxvf apache1.3.14.tar.gz # Decompression Apache [root @ WAPDB / LOCAL] # CD /USR @Local/apache_1.3.14 # Enter Apache's decompressed directory.
[root @ WAPDB / LOCAL] # ./configure --prefix = / usr / local / apache 5. Install php4 [root @ WAPDB / local] # tar zxvf php- 4.0.3pl1.tar.gz # Decompression PHP [root @ WAPDB / LOCAL] # CD PHP-4.0.3 [root @ WAPDB /PHP-4.0.3]#./configure --with-apache = .. / Apache_1.3.14 / --with-oracle = / data / oracle / App / Oracle / Product / 8.1.6 / --With-OCI8 = / DATA / ORACLE / APP / ORACLE / PRODUCT / 8.1.6 / --ENABLE-TRACK-VARS [root @ WAPDB /PHP-4.0.3]# Make # compile [root @ WAPDB /PHP-4.0.3]# make install # installation [root @ WAPDB /PHP-4.0.3]# cp php.ini-dist /usr/local/lib/php.ini # copy ini Document to the lib directory 6. Install apache [root @ WAPDB /PHP-4.0.3]# cd /usr/local/apache_1.3.14 [root@waPDB/apache_1.3.14] # ./configure --prefix = / usr / local / apache / --activate -Module = src / modules / php4 / libphp4.a [root @ WAPDB /APACHE_1.3.14]# make [root @ WAPDB /APACHE_1.3.14]# make install 7. Configuring apache [root @ WAPDB /APACHE_1.3.14]# CD / USR / local / apache / conf [root @ WAPDB / conf] # vi httpd.conf Modify HTTPD.CONF files to remove the comments below: ServerName http: //. . . . . . .
This must be removed to comment listen xxx.xxx.xxx:8888 (where xxx.xxx.xxx is domain name, or IP address) AddType Application / X-httpd-php .php addtype application / x-httpd-php-source .phps modification Bel another two lines: user apache group oracle [root @ WAPDB / conf] # vi mime.types Modify MIME.TYPES file, add WAP support, add the following line: text / vnd.wap.wml WML text / vnd.wap.wmlscript WMLC Image / vnd.wap.wbmp WMLP Application / VND.Wap.Wmlc WMLC Application / VND.Wap.WmlcSripTC WMLSC system installation has been completed, the environment is tested: 8. Start the database: Run in the database server: [Oracle @ WAP / BIN] $ SVRMGRL SVRMGR> Connect Internal Connected. SVRMGR> Startup Oracle Instance Started 9. Start listener [Oracle @ WAPDB / BIN] $ LSNRCTL LSNRCTL> Start Lsnrctl> EXIT This time, the Oracle database has been installed successfully, and the database has been run, you can try [Oracle @ WAPDB / BIN] $ SQLPLUS System / Manager @ WAP The following information appears: SQL * Plus: release 8.1.6.0.0 - Production On Fri Oct 26 20:20:56 2000 (C) Copyright 1999 Oracle Corporation. All Rights Reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production with the parting optioning jserver release 8.1.6.0.0 - Production SQL> Show user user is "system" sql> sql> exit 10. Start Apache [Oracle @ WAPDB / ROOT] # cd / usr / local / apache / bin [Oracle @ WAPDB / ROOT] # apachectl start 11. Test the PHP HTDOCS directory to edit a Test.php Phpinfo ();> Browse the page via the browser, you can see the environmental parameters of PHP, if you find support with Oricle and ORCI8, indicating that PHP has supported Oracle and OCI8. 12. Test PHP and Oracle's connection // file named Test.php. $ Conn = Ocilogon ("System", "Manager", "Test"); if ($ conn) echo success;?> If The program returns a success mark, indicating successful connection.