Centos 5.6 Oracle10g + apache2 + php5.3 安裝手記

 

##php + mysql + oracle

##perl + mysql + oracle

 

 

#安裝套件確認

確認以下套件是否安裝!

若未安裝可用 yum 進行安裝

yum install pdksh

yum install libXp

yum install libXpm-devel

 

 

#OS 環境設定

 

#建立帳號及Group

groupadd -g501 oinstall

groupadd -g500 dba

useradd -g oinstall -G dba oracle

chown oracle.oinstall -R /oracle

 

##修改參數

vi /etc/sysctl.conf

#oracle

kernel.sem=250 32000 100 128

fs.file-max=65536

net.ipv4.ip_local_port_range=1024 65000

net.core.rmem_default = 262144

net.core.rmem_max = 262144

net.core.wmem_default = 262144

net.core.wmem_max = 262144

 

 

 

vi /etc/security/limits.conf

oracle              soft    nproc   2047

oracle              hard    nproc   16384

oracle              soft    nofile  1024

oracle              hard    nofile  65536

 

 

 

#令參數生效

sysctl -p

 

 

##安裝 JDK

下載並安裝

http://www.oracle.com/technetwork/java/javase/downloads/index.html

我是安裝在 /opt/jdk1.6.0_23 並在 /opt/ 下建立一個 java 連結

# ln –s /opt/jdk1.6.0_23 /opt/java 方便使用

 

./jdk-6u23-linux-i586.bin

mv jdk1.6.0_23/ /opt/

cd /opt/

ln -s jdk1.6.0_23 java

 

/opt/java/bin/java -version

會顯示目前 java 版本表示OK

 

 

#編輯一個環境變數檔

vi oracle.env

 

export DBNAME=testora.test.com.tw

PATH=/opt/java/bin:/ap/bin:/oracle/app/oracle/product/10.2.0/db_1/bin:$PATH

export ORACLE_BASE=/oracle/app

export TMP=/tmp

export TEMP=/tmp

export TMPDIR=/tmp

export DISPLAY=:0.0

export ORACLE_HOME=/oracle/app/oracle/product/10.2.0/db_1/

export ORACLE_SID=ORCL

export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/opmn/bin

export LD_LIBRARY_PATH=$ORACLE_HOME/network/lib:/$ORACLE_HOME/lib:/$ORACLE_HOME/lib32:/usr/lib64

NLS_DATE_FORMAT=YYYY/MM/DD;export NLS_DATE_FORMAT

NLS_LANG=AMERICAN_AMERICA.AL32UTF8;export NLS_LANG

export ORACLE_TERM=vt220

 

#資料庫軟體安裝

##install oracle database

cpio -idvm < 10201_database_linux_x86_64.cpio

cd database/

./runinstall

安裝過程會出現作業系統版本不符的問題而無法安裝!

處理方式有二:

(1) 修改 /etc/redhat-release 中的文字,改為 Red Hat Enterprise Linux AS release 4

(2) ./runinstall –ignoreSysPrereqs #跳過 OS VERSION CHECK

 

安裝時先不要 create database ,請選擇僅安裝資料庫軟件,如此是為了方便由 10.2.0.1 升級至 10.2.0.4

若順利的話會提示以 root 執行以下二個程序

/oracle/app/oraInventory/orainstRoot.sh

/oracle/app/oracle/product/10.2.0/db_1/root.sh

 

##升級至 10.2.0.4

##patch to 10.2.0.4 oracle

unzip p6810189_10204_Linux-x86-64.zip

cd disk1

./runinstall

 

/oracle/app/oracle/product/10.2.0/db_1/root.sh

 

 

### 若要建立新的資料庫可使用 dbca 指令

### 建立 tnsnames.ora

Vi $ORACLE_HOME/network/admin/tnsnames.conf

 

TESTORA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.10 )(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SID = ORCL)

    )

  )

 

##create tablespace  

CREATE TABLESPACE "DATA_DB"

    NOLOGGING

    DATAFILE '/oracle/data/data_db.dbf' SIZE 128M REUSE AUTOEXTEND

    ON NEXT  4096K MAXSIZE  1024M EXTENT MANAGEMENT LOCAL

/

 

##create user

create user testuser identified by XXX default tablespace data_db temporary  tablespace temp;

grant connect,resource to testuser;

 

##create table

create table empl (

employee_no CHAR (5)  NOT NULL,

name VARCHAR2 (12) 

)

storage ( initial 128K next 128K )

tablespace data_db

;

 

alter table empl add constraint emp_PK PRIMARY KEY (employee_no) using index tablespace data_db;

 

### ORACLE資料庫軟件安裝完成

 

 

 

 

 

 

 

##MYSQL僅安裝軟件

tar -zxvf mysql-5.0.27.tar.gz

cd mysql-5.0.27

export CFLAGS=-fPIC

cd ..

rm -rf mysql-5.0.27

rm -f mysql-5.0.27.tar.gz

tar -zxvf mysql-4.1.21.tar.gz

cd mysql-4.1.21

./configure --without-server --prefix=/usr/local/mysql --enable-thread-safe-client

make

make install

 

 

 

 

 

 

 

##安裝 Apache2 & PHP

 

## PHP 安裝前的準備

##http://libpng.sourceforge.net/index.html

cd /usr/local/src

tar jxvf  /tmp/libpng-1.4.1.tar.bz2

cd libpng-1.4.1/

cd ..

mv libpng-1.4.1/ libpng

cd libpng

cp scripts/makefile.linux Makefile

make;make install

 

# http://www.ijg.org/

cd /usr/local/src

tar zxvf /tmp/jpegsrc.v8.tar.gz

mv jpeg-8 libjpeg-8

cd libjpeg-8

./configure --enable-shared --enable-static

make

mkdir -p /usr/local/man/man1

make install

cp -r ./.libs lib

cd /usr/local/src

 

# http://sourceforge.net/projects/freetype/files/freetype2/

tar jxvf /setup/php/freetype-2.3.12.tar.bz2

mv freetype-2.3.12 freetype2

cd freetype2

./configure

make;make install

 

## http://www.boutell.com/gd/

tar jxvf /setup/php/gd-2.0.36RC1.tar.bz2

mv gd-2.0.36RC1 gd2

cd gd2

./configure --with-png=../libpng --with-freetype=../freetype2

 

vi gd_png.c

##libpng-1.4以後,make若碰到./.libs/libgd.so: undefined reference to `png_check_sig'

修改gd_png.c

if (!png_check_sig (sig, 8))改成if (png_sig_cmp (sig, 0, 8))解決

 

 

make

make install

cp -r ./.libs lib

 

 

 

tar -jxvf /setup/php/php-5.3.4.tar.bz2

cd php-5.3.4/

 

./configure  --with-pdo-oci=/oracle/app/oracle/product/10.2.0/db_1

--with-mysql=/usr/local/mysql

--with-apxs2=/ap/web/bin/apxs --with-config-file-path=/ap/web/conf --with-zlib --enable-mbstring=all --with-bz2 --with-ldap --enable-sigchild --enable-inline-optimization --enable-static --disable-debug --with-gettext --with-gd=/usr/local/src/gd2 --with-jpeg-dir=/usr/local/src/libjpeg-8 --with-png-dir=/usr/local/src/libpng --with-freetype-dir=/usr/local/src/freetype2 --disable-rpath --with-xpm-dir=/usr/lib64

make

 

##修改 /ap/web/build/libtool

#         if test "$inst_prefix_dir" = "$destdir"; then

#           $echo "$modename: error: cannot install \`$file' to a directory not ending in $libdir" 1>&2

#           exit $EXIT_FAILURE

#         fi

## 否則make install 時會出現錯誤

 

make install

 

 

 

 

###PHP + oracle TEST

##vi  /php/opendb.inc

<?

$dbh = new PDO("oci:dbname=ORCL", "", "PASSWD");

?>

 

 

##vi test.php

<?

require_once("/php/opendb.inc");

$sql="select * from tab";

  $stmt=$dbh->prepare("$sql");

  $stmt->execute()||die("mug_plan,mfg 讀檔錯誤");

  while(list($tab_list)=$stmt->fetch()) {

        echo “$tab_list\n”;

  }

?>

##應該會顯示目前user 下的table view  list

 

 

 

 

###Perl + oracle + mysql

 

 

http://search.cpan.org/

下載http://search.cpan.org/CPAN/authors/id/T/TI/TIMB/DBI-1.616.tar.gz

http://search.cpan.org/CPAN/authors/id/P/PY/PYTHIAN/DBD-Oracle-1.28.tar.gz

 

 

##DBI

cd /tmp

tar -zxvf DBI-1.616.tar.gz

cd DBI-1.616

perl ./Makefile.PL

make

make test

make install

cd ../

 

 

#DBD-ORACLE

. oracle.env :請看前面說明

tar -xvf DBD-Oracle-1.28.tar

cd DBD-Oracle-1.28

perl ./Makefile.PL

make

make install

 

 

##Perl + MYSQL -- DBD-mysql

http://search.cpan.org/CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.019.tar.gz

 

tar -zxvf DBD-mysql-2.9007.tar.gz

cd DBD-mysql-2.9007

perl Makefile.PL \

--libs="-L/usr/local/mysql/lib/mysql -lmysqlclient -lz" \

--cflags=-I/usr/local/mysql/include/mysql

 

make

make install

 

 

 

##Perl + ORACLE TEST

 

##vi oracle.pl

sub opendb {

 DBI->connect( "dbi:Oracle:orcl", 'testuser','XXXX',) || die "Database connection not made: $DBI::errstr";

}

 

##vi test.pl

#!/usr/bin/perl

 

use DBI;

 

require "oracle.pl";

 

$db=opendb();

$sql=$db->prepare("select  *  from  empl ");

$sql->execute();

print "Oracle\n------------------------\n";

while(($employee_no,$name)=$sql->fetchrow_array()){

  print "$employee_no,$name \n";

}

 

 

##perl + mysql test

 

#vi mysql.pl

sub myopendb { DBI->connect('DBI:mysql:database=public;host=10.0.0.11;port=3306','username','passwd') };

 

#vi testmy.pl

require "mysql.pl";

$mydb=myopendb();

$sql = “update …”;

$mysql = $mydb->prepare("$sql");

$mysql->execute();

$err = $mydb -> errstr;

 

後記:

請參考另一份件 http://jason0615.pixnet.net/blog/post/68611791 為你的 web server 加上流量壓縮功能

文章標籤
創作者介紹
創作者 Jason0615 的頭像
Jason0615

吳承軒的部落格

Jason0615 發表在 痞客邦 留言(0) 人氣()