不会吧?真给100?HOHO 挺容易的一件事啊。 ;)
解决方案 »
- EXISTS 和 NOT EXISTS
- 谁有最新版的中国地区表?
- 求一多表更新的sql
- 如何把一个库中的所有字段类型为numeric(18,0)的,字段名满足 %quantity% 的字段改为numeric(18,2)
- 100分求助几个SQL查询语句,请高手来拿分了,多谢
- 菜鸟提问,急!!!(联不上服务器)
- 如何使两台远程服务器上的数据保持一致?(急)
- 关于 select ... where ... IN的问题
- 求教一个合并数据的SQL的写法
- 高手相助 --- 存儲過程執行錯誤 急 ﹗﹗﹗ 在線等侯
- 各位大虾能否给出几个研究数据库技术的网址
- 请问如何根据软件所处理的业务量计算出数据库(SYBASE)的大小?
Chris Runge
August 27, 2000
--------------------------------------------------------------------------------Table of Contents Prerequisites and Assumptions
Setup Tasks to Perform as the root User
Configure the Linux Kernel for Oracle8i
Create Mount Point(s)
Create Linux Groups for Database Administrators
Create a Linux Group for the Oracle Universal Installer Inventory
Create a Linux Account to Own Oracle Software
Setup Tasks to Perform as the oracle User
Confirm Proper Group Memberships
Set Permissions for File Creation
Set Environment Variables
Installation
Mounting the Oracle CD-ROM and Starting the Oracle Installer
File Locations
UNIX Group Name
orainstRoot.sh
Available Products
Installation Types
Database Identification
Database File Location
Summary
Install
root.sh Script
Configuration Tools
End of Installation
Post-Installation
Add user(s) to the dba group
Automate Database Startup and Shutdown
Set Environment Variables
Net8 Configuration
Fix the dbstart script
Starting the Oracle server processes and the TNS Listener
Confirm Database Operation
This document is a HOWTO for installing Oracle 8.1.6 on Red Hat Linux 6.2.Prerequisites and Assumptions
This document assumes the following:You are using Red Hat Linux 6.2. You will probably be able to follow these same directions without modification if you have Red Hat Linux 6.0 or 6.1. Note: you will run into a problem installing Oracle 8.1.6 on a Red Hat Linux 7.0 system, although I imagine that Oracle will fix this.This is a new install of Oracle. Upgrades are more involved and are not covered.This will be an installation of Oracle that will be used for development, test, and/or training purposes only. Production installs really should be spread across several different disks; this document only covers installing Oracle on a single partition.You are going to be using the default NLS charset (U.S. English). If you have no idea what this means and have an otherwise U.S. English system just go with it. If not, check the Oracle installation documentation for information on using other NLS charsets.You meet the minimum system requirements. Per Oracle this means that you have 128 MB of RAM (256 MB is recommended), swap space equivalent to twice the amount of RAM in your system or at least 400 MB (whichever is greater), a minimum of 750 MB to 1000 MB of free disk space on the partition you will be installing to, that you are using the Linux kernel 2.2 or higher, and that you are using the system library glibc 2.1 or higher. For what it is worth, I had no problems installing on a Dell Inspiron 7500 with 128 MB of RAM and 128 MB of swap space. I recommend that you have at least 1500 MB free on the partition you will be installing to.Setup Tasks to Perform as the root User
The following tasks should be performed as the root user.Configure the Linux Kernel for Oracle8i
Use the ipcs command to obtain a list of the system's current shared memory and semaphore segments, and their identification number and owner.# ipcs -l------ Shared Memory Limits --------
max number of segments = 512
max seg size (kbytes) = 32768
max total shared memory (kbytes) = 67108864
min seg size (bytes) = 1------ Semaphore Limits --------
max number of arrays = 512
max semaphores per array = 250
max semaphores system wide = 128000
max ops per semop call = 32
semaphore max value = 32767------ Messages: Limits --------
max queues system wide = 128
max size of message (bytes) = 4056
default max size of queue (bytes) = 16384These are the defaults for a Red Hat 6.2 system and will usually suffice for a low-load test, development, or training system. For production, make the changes as indicated in the Oracle8i Installation Guide.Create Mount Point(s)
Create one mount point (this will not be an OFA-compliant installation, which requires at least four mount points). Create it in a partition that has at least 1500 MB free, preferably more.I create the mount point under /opt, which is where I install all commercial software packages. Another place to consider is /usr/local. The remainder of this document assumes that your mount point is /opt/oracle. If you decide to install elsewhere, replace /opt/oracle with the directory you choose.# mkdir -p /opt/oracleCreate Linux Groups for Database Administrators
Oracle database administrators (DBAs) should be a member of the Linux group dba. Any Linux user who is a member of this group will be able to login to Oracle as the internal user without needing to specify a password. To add the group dba, issue the following command:# groupadd dbaCreate a Linux Group for the Oracle Universal Installer Inventory
The Oracle files and directories should be owned by the group oinstall. To add the group oinstall, issue the following command:# groupadd oinstallCreate a Linux Account to Own Oracle Software
The Oracle files and directories should be owned by the user oracle. The oracle user should be used only to install, stop, and start Oracle and not for normal use. The oracle user's primary group should be oinstall; the oracle user should also be a member of the groups dba and oracle.To add the user oracle, issue the following command:# useradd oracleNext, set the password for the oracle user.# passwd oracle
Changing password for user oracle
New UNIX password:
Retype new UNIX password:
passwd: all authentication tokens updated successfullySet the Oracle user's primary group to oinstall, and also make it a member of the dba and oracle groups.# usermod -g oinstall -G dba,oracle oracleFinally, set the appropriate ownership permissions on the mount point you created earlier.# chown oracle.oinstall /opt/oracleSetup Tasks to Perform as the oracle User
The following tasks should be performed while logged in as the oracle user you created above.Confirm Proper Group Memberships
After logging in as oracle, confirm that you are a member of oinstall, dba, and oracle. This can be done with the groups command, as follows:$ groups
oinstall dba oracleSet Permissions for File Creation
The oracle user should have a default file creation mask of 022. This is the default on most Linux distributions, including Red Hat Linux 6.2. Confirm this with the umask command.$ umask
022Set Environment Variables
You will need to set several environment variables before running the Oracle Installer. This can be done either by editing your shell's profile, or by creating a new file that sets these environment variables and calling this new file from your shell's profile. For the purposes of this article we'll do the latter.First, create a new file ~/.oracle816. It should look similar to the following:ORACLE_BASE=/opt/oracle
ORACLE_HOME=$ORACLE_BASE/product/8.1.6
ORACLE_SID=ORCL
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATHOnce you've done that, edit your shell's profile (by default this is ~/.bash_profile on Red Hat Linux) and add to the end the following:# Oracle8i 8.1.6
if [ -f ~/.oracle816 ]; then
. ~/.oracle816
fiOnce the alterations have been made, either logout then login again, or by executing the ~/.oracle816 file you created above, e.g.,$ . ~/.oracle816Next, check that the environment variables are set correctly with the env command:$ env | grep ORACLE
ORACLE_SID=ORCL
ORACLE_BASE=/opt/oracle
ORACLE_HOME=/opt/oracle/product/8.1.6
$ env | grep PATH
PATH=/opt/oracle/product/8.1.6/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/binInstallation
To install Oracle you will need to login as the oracle user and have an X session running. Open up at least two xterms. In one, su over as root. When prompted to do something as root, use this window. When prompted to do something as oracle, use the other window.Mounting the Oracle CD-ROM and Starting the Oracle Installer
As root, mount the CD-ROM:# mount /dev/cdromAs the oracle user start the Oracle Installer:$ cd /mnt/cdrom
$ ./runInstaller
$ Initializing Java Virtual Machine from ../stage/Components/oracle.swd.jre/1.1.
8/1/DataFiles/Expanded/linux/bin/jre. Please wait...The Oracle Universal Installer should appear after a few seconds.Figure 1. The Oracle Univeral Installer Click Next to continue.File Locations
The File Locations window appears.Figure 2. File Locations The Destination path should match the value of the ORACLE_HOME environment variable you specified earlier.Click Next when ready to continue.UNIX Group Name
The UNIX Group Name window appears.Figure 3. UNIX Group Name Enter oinstall for the UNIX Group Name.Click Next when ready to continue.orainstRoot.sh
A window appears stating that you need to run a script /opt/oracle/product/8.1.6/orainstRoot.sh as root before you can continue.Figure 4. orainstRoot.sh Script Run this script as directed.# /opt/oracle/product/8.1.6/orainstRoot.sh
Creating Oracle Inventory pointer file (/etc/oraInst.loc)
Changing groupname of /opt/oracle/oraInventory to oinstall.Then switch back to the window asking you to run the script and click Retry.Available Products
The Available Products screen appears.Figure 5. Available Products Oracle8i Enterprise Edition 8.1.6.1.0 should be selected. If not, select it and click Next.Installation Types
The Installation Types screen appears.Figure 6. Installation Types Select a Typical install, which is the default, then Next when ready to continue.Database Identification
The Database Identification screen appears.Figure 7. Database Identification Enter the value of ORACLE_SID you specified earlier for both the Global Database Name and the SID. If you used the same value for ORACLE_SID that I did, this will be ORCL.Click Next when ready to continue.Database File Location
The Database File Location screen appears.Figure 8. Database File Location As the Installer indicates, it is best to spread Oracle across multiple disks. In this case I have chosen to store all of the files under a single directory: /opt/oracle.After entering the correct directory, click Next when ready to continue.Summary
The Summary screen appears.Figure 9. Summary Click Install when ready to continue.Install
Installation of Oracle will begin.Figure 10. Figure root.sh Script
Towards the end of the installation a window will appear stating that another script, /opt/oracle/product/8.1.6/root.sh, needs to be run as root.Figure 11. root.sh Run the script as directed:# /opt/oracle/product/8.1.6/root.sh
Running Oracle8 root.sh script...
\nThe following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /opt/oracle/product/8.1.6
ORACLE_SID= ORCLEnter the full pathname of the local bin directory: [/usr/local/bin]: [ENTER]
\nCreating /etc/oratab file...
Entry will be added to the /etc/oratab file by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
IMPORTANT NOTE: Please delete any log and trace files previously
created by the Oracle Enterprise Manager Intelligent
Agent. These files may be found in the directories
you use for storing other Net8 log and trace files.
If such files exist, the OEM IA may not restart.When the script is finished, return to the message window and click OK.Click OK after the script has finished.Configuration Tools
The Configuration Tools window appears.Figure 12. Configuration Tools When doing a Typical install of the Oracle8i Server the Net8 Configuration Assistant and the Oracle Database Configuration Assistant will automatically run at the end of the installation. The Net8 Configuration Assistant will configure SQL-Net and your TNS Listener and the Oracle Database Configuration Assistant will build a starter database for you.After the Net8 Configuration Assistant runs a new window will appear indicating the status of the Oracle Database Configuration Assistant.Figure 13. Database Creation Progress When finished a window will appear will the relevant database information for the database that was just created.Figure 14. Oracle Database Configuration Assistant alert Click OK when ready to continue.End of Installation
The End of Installation screen appears.Figure 15. End of Installation Click Exit when ready to continue.You'll be asked if you really want to exit.Figure 16. Exit Confirmation Click Yes. The Oracle Universal Installer will end. You will now need to configure a few things before working with the database.Post-Installation
You will need to be root to perform these many of these post-installation steps, except where otherwise indicated.Add user(s) to the dba group
Remember that the oracle user should only be used to install Oracle and to startup and shutdown the Oracle processes. It should not be used for database administration or other database use. For this reason you should add at least one other user to the dba group for database administration purposes. Be careful about who you choose to add, as all users in the dba group can login to Oracle as the internal user without needed to specify a password.In this example I add the user crunge to the dba group.# usermod -G dba crungeAutomate Database Startup and Shutdown
Automatic database startup and shutdown is determined in part by the file /etc/oratab. This file lists each ORACLE_SID and its accompanying ORACLE_HOME, along with an indicator as to whether the database can be automatically started up and shutdown.Edit /etc/oratab. It should look similar to the following:## This file is used by ORACLE utilities. It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
ORCL:/opt/oracle/product/8.1.6:NChange the last character of the last line to be a Y instead of a N.Next you will need to create an initscript that will startup and shutdown Oracle when the system changes runlevels. To do this create a file named /etc/rc.d/init.d/dbora, and make it look similar to the following:#!/bin/sh
# Set ORA_HOME to be equivalent to the ORACLE_HOME
# from which you wish to execute dbstart and
# dbshut
# set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME
ORA_HOME=/opt/oracle/product/8.1.6
ORA_OWNER=oracle
if [ ! -f $ORA_HOME/bin/dbstart ]
then
echo "Oracle startup: cannot start"
exit
fi
case "$1" in
'start')# Start the Oracle databases:
# The following command assumes that the oracle login will not prompt the
# user for any valuessu - $ORA_OWNER -c $ORA_HOME/bin/dbstart
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
;;
'stop')# Stop the Oracle databases:
# The following command assumes that the oracle login will not prompt the
# user for any valuessu - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
;;
esacAfter creating the file, give it the appropriate execute permissions as follows:# chmod 755 /etc/rc.d/init.d/dboraNow create symlinks to dbora for the various runlevels by issuing the following commands:# ln -s /etc/rc.d/init.d/dbora /etc/rc.d/rc0.d/K10dbora
# ln -s /etc/rc.d/init.d/dbora /etc/rc.d/rc6.d/K10dbora
# ln -s /etc/rc.d/init.d/dbora /etc/rc.d/rc2.d/S98dbora
# ln -s /etc/rc.d/init.d/dbora /etc/rc.d/rc3.d/S98dbora
# ln -s /etc/rc.d/init.d/dbora /etc/rc.d/rc5.d/S98dboraThat's it. The next time the system starts up or shuts down (or changes runlevels) Oracle will startup and shutdown accordingly.Set Environment Variables
There are a few changes you need to make to the oracle user's environment variables. As the oracle user, edit the ~/.oracle816 file and make it look similar to this:ORACLE_BASE=/opt/oracle
ORACLE_HOME=$ORACLE_BASE/product/8.1.6
ORACLE_SID=ORCL
PATH=$ORACLE_HOME/bin:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
ORAENV_ASK=NO
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH ORAENV_ASK
. /usr/local/bin/oraenvOther oracle users (e.g., crunge) should create a ~/.oracle816 file that looks like that of the oracle user. They should also be sure to call it from their shell's profile script. Instructions for doing this were given earlier, under the Pre-Installation Tasks.Net8 Configuration
As root, edit /etc/services and add the linelistener 1521/tcp # Net8 listenerThis reserves TCP port 1521 for use by the Net8 TNS Listener.Fix the dbstart script
The dbstart script that is called by the initscript to startup the Oracle server processes has a typographical error in it. To fix it, login as the as oracle user end edit the file $ORACLE_HOME/bin/dbstart. Go to line 64, which reads as follows: /PL\/SQL (Release|Version)/ {substr($3,1,3) ;Replace /PL\/SQL with /JServer so that the line looks like the following: /JServer (Release|Version)/ {substr($3,1,3) ;Starting the Oracle server processes and the TNS Listener
As root, issue the following command to start the Oracle server processes and the TNS Listener:# /etc/rc.d/init.d/dbora start
#
LSNRCTL for Linux: Version 8.1.6.0.0 - Production on 20-AUG-2000 17:28:33(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.TNS-01106: Listener using listener name LISTENER has already been started
Database "ORCL" already started.Database "ORCL" possibly left running when system went down (system crash?).
Notify Database Administrator.SQL*Plus: Release 8.1.6.0.0 - Production on Sun Aug 20 17:28:35 2000(c) Copyright 1999 Oracle Corporation. All rights reserved.SQL> Connected.
SQL> ORACLE instance shut down.
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.6.1.0 - Productio
th the Partitioning option
JServer Release 8.1.6.0.0 - ProductionSQL*Plus: Release 8.1.6.0.0 - Production on Sun Aug 20 17:28:37 2000(c) Copyright 1999 Oracle Corporation. All rights reserved.SQL> Connected to an idle instance.
SQL> ORACLE instance started.Total System Global Area 56012784 bytes
Fixed Size 69616 bytes
Variable Size 38993920 bytes
Database Buffers 16777216 bytes
Redo Buffers 172032 bytes
Database mounted.
Database opened.
SQL> DisconnectedDatabase "ORCL" warm started.Confirm Database Operation
Use one of the users you modified above to use the Oracle database (e.g., crunge) to verify that the database is operational. Login as that user and issue the following command:$ sqlplus scott/tigerThis starts SQL*Plus and logs you in as the user scott with the password tiger. At the SQL> prompt, issue the command select * from dept;. You should see the output shown below:SQL*Plus: Release 8.1.6.0.0 - Production on Thu Jun 15 14:57:21 2000(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - ProductionSQL> select * from dept; DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTONSQL>Once returned to the SQL> prompt, enter exit to exit SQL*Plus:SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
● 在redhat下安装ORACLE8数据库服务器
● 安装apache,并支持wml
● 安装PHP
2. 安装前的准备软件:
Redhat 6.2安装光盘
Oracle8.161.tar.gz 下载地址:
http://freeware.online.sh.cn/mirrors/LinuxApps/Database/Oracle/oracle8.161.tar.gz
Java运行时刻环境(JRE)下载地址:
ftp://165.21.84.42/pub/j2sdk/1.3.0/xzc233fcslnx/j2sdk-1_3_0-linux-rpm.sh
Apache 1.3.14 下载地址:
http://www.apache.org/dist/apache1.3.14.tar.gz
php4.0.3 pl1 下载地址:
http://www.php.net/do_download.php?download_file=php- 4.0.3pl1.tar.gz&source_site=www.php.net
3. 安装oracle前的准备
● 安装JRE1.3.0
[root@wapdb /root]# #以root身份登录
[root@wapdb /root]# chmod 755 j2re-1_3_0-linux-rpm.sh #改变j2re-1_3_0-linux-rpm.sh
的权限
[root@wapdb /root]#./ j2re-1_3_0-linux-rpm.sh #运行j2re-1_3_0-linux-rpm.sh在同级目录
下可得到JRE的RPM包。
[root@wapdb /root]# rpm –i j2re-1_3_0-linux-rpm #安装JRE1.3.0:
● 创建oracle。apache用户组:
执行以下命令:
[root@wapdb /root]# #以root方式登录
[root@wapdb /root]# groupadd oracle #创建oracle组
[root@wapdb /root]# useradd oracle -g oralce #在oracle组中建新用户oracle
[root@wapdb /root]# useradd apache -g oralce #在oracle组中建新用户apache
[root@wapdb /root]# passwd oracle #修改oracle用户口令
注:oracle组和oracle用户是oracle安装需要的
注:创建oracle用户后,linux系统自动在/home目录下创建/home/oracle目录,给oracle用户使用,oracle用户对此目录拥有所有的权限。
[root@wapdb /root]# cd /home/oracle
[root@wapdb /root]# vi .bash_profile #编辑.bash_profile文件,并输入以下内容
# 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 paths:
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. 安装oracle8I
[root@wapdb /oracle]# exit #退出,以oracle用户重新登录,以使设定的环境生效
[oracle@ wapdb/oracle]$
[oracle@ wapdb/oracle]$ tar zxvf oracle8161_tar.gz #解压oracle压缩包到当前目录
[oracle@ wapdb/oracle]$ startx #启动X-windows后,启用一个终端(xterm),
(图形窗口)在该终端中运行runInstaller
[oracle@wapdb /oracle]$ cd Oracle8iR2 #进入解压缩的目录
[oracle@wapdb /Oracle8iR2]$ ./runInstaller #执行oracle安装程序。 这时可以看到用jre运行的的图形化的OUI的欢迎画面,按照提示继续安装进程(这里我们可以选择典型安装):
Welcome:
按next
File Locations:
按next
UNIX Group Name:
oracle,按next
出错,提示要以root权限运行“/data/oracle/app/oracle/product/8.1.6/orainstRoot.sh
CTRL+ALT+F2,打开一个新的控制台(字符窗口)
以root登录
[root@wapdb /root]# cd /data/oracle/app/oracle/product/8.1.6
这时,/data/oracle/app/oracle/product/8.1.6目录下有一个文件orainstRoot.sh,运行它
[root@wapdb /8.1.6]# sh orainstRoot.sh
CTRL+ALT+F7,回到安装界面(图形窗口)
按Retry按钮,就可以继续安装了,
Available Products:
选Oracle8i Enterprise Edition 8.1.6.1.0,按next
Installation Types:
选Typical(540MB),按next,这时,屏幕右上角出现一个进度标尺
Database Identification:
Global Database Name:输入wap(可以任意)
SID:保留wap
按next
Database File Location:
任意目录,本例设为“/data/oracle/app/oracle/product/8.1.6/data”,按Next,这时,屏幕右上角进度标尺继续前进
出现Summary,对你想要安装的产品作一个总结
按Install,出现Install画面,等待... 可以看到窗口底部提示的安装等log文件目录,可供以后查询。
弹出Setup Privileges窗口
提示:在安装继续进行之前,需要以root运行一个脚本
“/data/oracle/app/oracle/product/8.1.6/root.sh”,
CTRL+ALT+F2,回到刚才运行的第2个终端窗口
以root权限执行该文件,
[root@wapdb /8.1.6]# sh root.sh
屏幕显示:
Enter the full pathname of the local bin directory:[/usr/local/bin]:
回车
系统开始执行一些动作,执行完毕,CTRL+ALT+F7按返回OUI,按OK。
Database Creation Progress开始,逐步进行以下4个过程
Creating and starting Oracle instance
Copying database files
Initializing database
Database creation completed
以上4个过程完成,弹出Oracle Database Configuration Assistant Alert窗口,
提示:数据库创建完成,告诉你数据库的一些基本信息
global databse name:wap
database system identifier(SID):wap
SYS account password:change_on_install
SYSTEM account password:manager
按ok
End of Installation,按Exit退出OUI,完成安装。
到此,已经完成了数据库服务器的安装,下一步进行web/wap服务器的安装。
5. 安装ORACLE客户端
(该步骤适合与数据库服务器与WEB服务器安装在不同机器上,若为同一台机器直接执行 第6步)
重复第3步
在第4步的安装中选择“客户端安装”步骤大致相同。
配置tnsnames.ora文件(可以在/$ORACLE_HOME/bin/运行netasst命令启动OUI来配置)。最快的方法是COPY数据库服务器端的tnsnames.ora到$ORACLE_HOME/network/admin中。
以ORACLE用户登录
[oracle@wapserver /]$ cd $ORACLE_HOME/network/admin
[oracle@wapserver admin]$ ftp xxx.xxx.xxx.xxx #使用FTP登录oracle服务器,以ORACLE
并使用oracle用户.
ftp>cd /data/oracle/app/oracle/product/8.1.6/network/admin
ftp>get tnsnames.ora
ftp>bye
6. 配置apache_1.3.14
[root@wapdb /local]# tar zxvf apache1.3.14.tar.gz #解压apache
[root@wapdb /local]# cd /usr/local/apache_1.3.14 #进入apache的解压目录。
[root@wapdb /local]# ./configure --prefix=/usr/local/apache
5. 安装 PHP4
[root@wapdb /local]# tar zxvf php- 4.0.3pl1.tar.gz #解压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 #编译
[root@wapdb /php-4.0.3]# make install # 安装
[root@wapdb /php-4.0.3]# cp php.ini-dist /usr/local/lib/php.ini #拷贝ini文件到lib目录
6.安装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.配置apache
[root@wapdb /apache_1.3.14]# cd /usr/local/apache/conf
[root@wapdb /conf]# vi httpd.conf
修改httpd.conf文件
以下几行去掉注释:
ServerName http://。 这个一定要去掉注释
Listen XXX.XXX.XXX:8888(其中xxx.xxx.xxx为域名,或者IP地址)
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps 修改以下两行:
User apache
Group oracle
[root@wapdb /conf]# vi mime.types
修改mime.types文件, 添加WAP支持,添加如下行:
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
系统的安装已经完成,下面对环境进行测试:
8.启动数据库:
在数据库服务器里运行:
[oracle@wap /bin]$ svrmgrl
SVRMGR> connect internal
Connected.
SVRMGR> startup
ORACLE instance started
9.启动监听器
[oracle@wapdb /bin]$ lsnrctl
LSNRCTL> start
LSNRCTL> exit
这时,oracle数据库已经安装成功,并且数据库已经启动运行,可以试一下
[oracle@wapdb /bin]$sqlplus system/manager@wap 出现以下信息:
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 Partitioning option
JServer Release 8.1.6.0.0 - Production
SQL> show user
USER is "SYSTEM"
SQL>
SQL> exit
10.启动Apache了
[oracle@wapdb /root]# cd /usr/local/apache/bin
[oracle@wapdb /root]# apachectl start 11.测试PHP
htdocs目录下编辑一个test.php
phpinfo();
?>
通过浏览器浏览该网页,可以看到PHP的环境参数,如果找到有oricle和orci8的支持,说明PHP已经支持ORACLE和OCI8。 12.测试PHP与ORACLE的连接
//文件名为test.php.
$conn=ocilogon("system","manager","test");
if($conn)
echo success;
else
echo fail;
?>
如果该程序返回成功标志,则表明连接成功。
13.测试时候支持WML
在htdocs目录下编辑test.wml "http://www.wapforum.org/DTD/wml_1.1.xml">
hello word! 在任何其他一台win9x的机子上使用WAP模拟器浏览该网页,应该出现”hello word”。
现在整个环境已经调试完成,可以利用PHP+ORACLE8i进行动态html或wml的开发了!