1、下載MySQL-5.0.19-alpha-win32.msi,雙擊安裝
2、安裝開始，選擇Custermer，然后更改安裝路徑(可選)，其他按照默認(rèn)設(shè)置
但是自定義的安裝路徑不宜太深、不能還有特殊字符，比如d:\server\mysql
3、安裝完成后最后一個界面，取消自動配置前的勾，點擊完成。
4、打開“開始菜單|MySQL Server Instance Config Wizard”配置過程如下：
1).首先選擇配置類型的時候，選擇標(biāo)準(zhǔn)配置“Standard Configuration”
2).其次，在選擇系統(tǒng)選項(Windows Options)時，勾選“Include Bin Directory in Windows Path”
3).接著設(shè)置數(shù)據(jù)庫管理員root的密碼
4).最后點確認(rèn)， 最后開始更新配置
5).更新配置過程，可能會彈出“Can't connect to MySQL Server on 'localhost'(10061)”錯誤，
6).此時一般點擊重試“Retry”即可，最后點擊Finish完成配置。
５、配置PHP，啟用MySQL和GD庫
1).查找;extension=php_mysql.dll去掉前面的;啟用MySQL組件。
2).查找;extension=php_gd2.dll去掉前面的;啟用GD庫組件
來自:http://athurg.cn/read.php?141
朋友有一只鳥，挺逗。
他們夫妻平時在家，這只鳥都說：“主人，您好！”
有一次，他出差幾天回來，這只鳥見到他說：“叔叔，您好！”
他找個借口出差，在附近觀察，沒有什么敵情。他回來后，那只鳥還是說：“叔叔，您好！”
又有一次，她出差幾天回來，這只鳥見到她就說：“阿姨，您好！”
她也找個借口出差，在附近觀察，沒有什么動靜。她回來后，那只鳥見到她還是說：“阿姨，您好！”
他們合謀，終于把這只鳥殺了。
呵呵，這鳥。
Oracle Database Express Edition Installation Guide
10g Release 2 (10.2) for Linux
http://download.huihoo.com/database/oracle/
下載 Oracle Database 10g Express Edition for Linux x86
- Available for Debian, Mandriva, Novell, Red Hat and Ubuntu
文件
Oracle Database 10g Express Edition (Universal)
oracle-xe-universal_10.2.0.1-1.0_i386.deb (262,440,214 bytes) (cksum 3404538446) *Debian package
安裝
debian:/home/huihoo/database/oracle# dpkg -i oracle-xe-universal_10.2.0.1-1.0_i3 86.deb
(Reading database ... 76128 files and directories currently installed.)
Unpacking oracle-xe-universal (from oracle-xe-universal_10.2.0.1-1.0_i386.deb) . ..
This system does not meet the minimum requirements for swap space. Based on
the amount of physical memory available on the system, Oracle Database 10g
Express Edition requires 1006 MB of swap space. This system has 818 MB
of swap space. Configure more swap space on the system and retry the installati on.
dpkg: error processing oracle-xe-universal_10.2.0.1-1.0_i386.deb (--install):
subprocess pre-installation script returned error exit status 1
Errors were encountered while processing:
oracle-xe-universal_10.2.0.1-1.0_i386.deb
Create 1GB swap file if needed.
dd if=/dev/zero of=/tmp/tmpswap bs=1k count=1024000
chmod 600 /tmp/tmpswap
/sbin/mkswap /tmp/tmpswap
su
# /sbin/swapon -v /tmp/tmpswap
若要卸出,可運(yùn)行
swapoff /tmp/tmpswap
rm /tmp/tmpswap
再次安裝
debian:/home/huihoo/database/oracle# dpkg -i oracle-xe-universal_10.2.0.1-1.0_i3 86.deb
dpkg: dependency problems prevent configuration of oracle-xe-universal:
oracle-xe-universal depends on libaio (>= 0.3.96) | libaio1 (>= 0.3.96); however:
Package libaio is not installed.
Package libaio1 is not installed.
dpkg: error processing oracle-xe-universal (--install):
dependency problems - leaving unconfigured
Errors were encountered while processing:
oracle-xe-universal
安裝 package libaio libaio1
從 http://packages.debian.org/unstable/libs/libaio 獲得libaio debian package
如: http://ftp.hk.debian.org/debian/pool/main/liba/libaio/libaio_0.3.104-1_i386.deb
# dpkg -i libaio_0.3.104-1_i386.deb
接著
# dpkg -i oracle-xe-universal_10.2.0.1-1.0_i3 86.deb
# /etc/init.d/oracle-xe configure
- A valid HTTP port for the Oracle Database XE graphical user interface (the default is 8080)
- A valid port for the Oracle database listener (the default is 1521)
- A password for the SYS and SYSTEM administrative user accounts
- Whether you want the database to start automatically when the computer starts
If you enter Yes, then the database starts immediately
To start the database manually, run this command:
$ /etc/init.d/oracle-xe start
To stop the database manually, use the following command:
$ /etc/init.d/oracle-xe stop
這時可看見后臺啟動了很多oracle 進(jìn)程
oracle 7357 0.0 1.8 224664 9664 ? Ss 06:25 0:00 xe_pmon_XE
oracle 7359 0.0 1.6 224048 8300 ? Ss 06:25 0:00 xe_psp0_XE
oracle 7361 0.0 4.4 224048 23084 ? Ss 06:25 0:00 xe_mman_XE
oracle 7363 0.0 2.1 226116 11248 ? Ss 06:25 0:00 xe_dbw0_XE
oracle 7365 0.0 2.4 239608 12508 ? Ss 06:25 0:00 xe_lgwr_XE
oracle 7367 0.0 2.6 224108 13764 ? Ss 06:25 0:00 xe_ckpt_XE
oracle 7369 0.0 8.1 224648 42268 ? Ss 06:25 0:00 xe_smon_XE
oracle 7371 0.0 2.6 224108 13896 ? Ss 06:25 0:00 xe_reco_XE
oracle 7373 0.0 4.1 225716 21332 ? Ss 06:25 0:00 xe_cjq0_XE
oracle 7375 0.0 7.9 226864 40820 ? Ss 06:25 0:00 xe_mmon_XE
oracle 7377 0.0 2.0 224052 10560 ? Ss 06:25 0:00 xe_mmnl_XE
oracle 7379 0.0 1.6 224712 8280 ? Ss 06:25 0:00 xe_d000_XE
oracle 7381 0.0 1.5 224668 8036 ? Ss 06:25 0:00 xe_s000_XE
oracle 7383 0.0 1.5 224668 8040 ? Ss 06:25 0:00 xe_s001_XE
oracle 7385 0.0 1.5 224668 8044 ? Ss 06:25 0:00 xe_s002_XE
oracle 7387 0.0 1.5 224668 8048 ? Ss 06:25 0:00 xe_s003_XE
oracle 7414 0.0 2.5 224108 13000 ? Ss 06:25 0:00 xe_qmnc_XE
oracle 7424 0.0 1.7 224076 8784 ? Ss 06:25 0:00 xe_q000_XE
oracle 7426 0.0 2.0 224076 10596 ? Ss 06:25 0:00 xe_q001_XE
http://localhost:8080/
http://localhost:8080/apex
設(shè)置環(huán)境變量
#cd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin
# source oracle_env.csh (for C or tcsh shell)
或
# ./oracle_env.sh (for Bourne, Bash, or Korn shell)
Making Oracle Database XE Server Available to Remote Clients
1 Click the Application menu (on Gnome) or the K menu (on KDE),
then point to Oracle Database 10g Express Edition, and then Go To
Database Home Page.
2 In the Database Login page, log in as SYSTEM, enter the password, and then click Login.
3 In the Oracle Database XE home page, click Administration.
4 Under Tasks, click Manage HTTP Access.
5 Under Manage HTTP Access, select Available from local server and remove clients.
6 Click Apply Changes.
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
bin/sqlplus system
Enter password:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
./sqlplus system@localhost
參考資料
來源：http://wiki.huihoo.com/index.php?title=Install_Oracle_10g_Express_Edition_on_Debian