第8天 ORACLE安装及NGINX整合PHP环境
oracle 11g安装在centos5.9x64下过程1.
先检查是否安装开发工具、JAVA、ksh等，及其它如下
yum search检查，若没有安装，则用
yumgroupinstall 开发工具 开发库 Java开发
yum install pdksh
yum install sysstat
yum install libaio-devel
yum install numactl-devel
yum installunixODBC unixODBC-devel
#ulimit -S -c unlimited
2.
vi /etc/sysctl.conf
fs.suid_dumpable = 1
fs.aio-max-nr = 1048576
fs.file-max = 6553560
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
#kernel.shmall = 2097152
#kernel.shmmax = 536870912
3.
vi /etc/pam.d/login
session required pam_limits.so
vi /etc/security/limits.conf
(在该文件的最后添加下面四行)
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
4.
groupadd oinstall
groupadd dba
useradd oracle -g oinstall -G dba
passwd oracle
mkdir -p /u01/app/oracle
mkdir-p /u01/app/oracle/product/11g/db_1
ls -l
chown -R oracle:oinstall /u01
ls -l
chmod 755 -R /u01
5.
su - oracle
vi .bash_profile
PATH=$PATH:$HOME/bin
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11g/db_1
export ORACLE_SID=jxwpxdb
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
6.
移动ORACLE安装文件到 /u01/app
mv database /u01/app
chown -R oracle.oinstall database
至此配置完毕，设置静态IP地址，然后重启。
7.
运行安装程序
/u01/app/database/runInstaller
8.
提示进行,会建立库。等待完成(然后建立网络侦听和库实例 netca dbca)
9.完成后用oracle用户登录，执行
sqlplus sys as sysdba
show user;
select * fromt tabs;
---------oracle 11g安装在centos5.9x64下过程-过程说明--------------------------------
安装开发工具、JAVA等，及其它
yum install libaio-devel
yum install numactl-devel
yum install sysstat unixODBC unixODBC-devel
ulimit -S -c unlimited
vi /etc/sysctl.conf
fs.suid_dumpable = 1 #允许coredump
fs.aio-max-nr = 1048576 #同时可以拥有的异步IO请求数目
fs.file-max = 6553560 #系统所有进程一共可以打开的文件数量
kernel.shmmni = 4096 #系统范围内共享内存段的最大数量
kernel.sem = 250 32000 100 128 #设置信号量（信号集最大信号数量、信号的最大量、可以执行的信号操作的数量、信号集最大数量）
net.ipv4.ip_local_port_range = 9000 65500#设置端口使用范围
net.core.rmem_default = 262144 #默认的接收窗口大小
net.core.rmem_max = 4194304 #最大的TCP数据接收缓冲
net.core.wmem_default = 262144 #默认的发送窗口大小
net.core.wmem_max = 1048586#最大的TCP数据发送缓冲
#kernel.shmall = 2097152#（可以以默认为准，设置为内存的90%，值为shmmax/4k）全部允许使用的共享内存大小
#kernel.shmmax = 536870912 （可以以默认为准，设置为内存的90%）单个段允许使用的共享内存大小
vi /etc/security/limits.conf
(在该文件的最后添加下面四行)
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
#groupadd oinstall
#groupadd dba
#useradd oracle -g oinstall -G dba
#passwd oracle
# mkdir -p /u01/app/oracle
# mkdir-p /u01/app/oracle/product/11g/db_1
#ls -l
# chown -R oracle:oinstall /u01
#ls -l
# chmod 755 -R /u01
su - oracle
vi .bash_profile
PATH=$PATH:$HOME/bin
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11g/db_1
export ORACLE_SID=linux-oracle
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
移动ORACLE安装文件到 /u01/app
mv database /u01/app
chown -R oracle.oinstall database
运行安装程序
/u01/app/database/runInstaller
提示进行,然后建立网络侦听和库实例
netca
dbca
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
LEMP集成环境安装
wget http://nginx.org/download/nginx-1.5.3.tar.gz
tar zxvf nginx-1.5.3.tar.gz
cd nginx-1.5.3
useradd nginx
./configure --prefix=/usr/local/nginx --user=nginx --group=nginx --with-http_stub_status_module
make
make install
cd /usr/local/nginx/
chown nginx.nginx logs
vi /usr/local/nginx/conf/nginx.conf
tar zxvf mysql-5.1.70.tar.gz
cd mysql-5.1.70
./configure --prefix=/usr/local/mysql --with- --with-collation=utf8_general_ci --with-extra-charsets=gbk,gb2312
make;make install
cp support-files/my-medium.cnf.sh /etc/my.cnf
cp support-files/mysql.server.sh /etc/init.d/mysql51d
/etc/init.d/mysql51d start
cat /etc/my.cnf
port= 3306
socket= /usr/local/mysql/var/mysql51.sock
datadir = /data/mysql51
port= 3306
socket= /usr/local/mysql/var/mysql51.sock
skip-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log-bin=mysql-bin
binlog_format=mixed
server-id = 1
quick
max_allowed_packet = 16M
no-auto-rehash
log-error=/usr/local/mysql/var/mysqlerr.log
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
interactive-timeout
tar zxvf php-5.3.27.tar.gz
cd php-5.3.27
./configure --prefix=/usr/local/php53 --with-gd --with-zlib --with-mysql=/usr/local/mysql --with-config-file-path=/usr/local/php53 --enable-mbstring --enable-fpm
make
make install
cp php.ini-production /usr/local/php53/php.ini
tar zxvf ZendGuardLoader-php-5.3-linux-glibc23-x86_64.tar.gz
cd ZendGuardLoader-php-5.3-linux-glibc23-x86_64/php-5.3.x/
cp ZendGuardLoader.so/usr/local/php53/lib/php/
vi /usr/local/php53/ php.ini
;report_zend_debug = 0
zend_extension=/usr/local/php53/lib/php/ZendGuardLoader.so
zend_loader.enable=1
cd /usr/local/php53/etc
cp php-fpm.conf.default php-fpm.conf
vi /usr/local/php53/etc/php-fpm.conf
pid = run/php-fpm.pid
error_log = log/php-fpm.log
user = nginx
group = nginx
listen = 127.0.0.1:9000
pm = dynamic
pm.max_children = 35
pm.start_servers = 20
pm.min_spare_servers = 5
pm.max_spare_servers = 35
vi /usr/local/nginx/conf/nginx.conf
location ~ \.php$ {
root phphtml;
fastcgi_pass 127.0.0.1:9000;
fastcgi_indexindex.php;
# fastcgi_paramSCRIPT_FILENAME/scripts$fastcgi_script_name;
include fastcgi.conf;
}
cat /etc/init.d/nginxfpm
#!/bin/bash
# chkconfig: - 65 55
# description: nginx
# processname: nginx
case $1 in
start)
/usr/local/php53/sbin/php-fpm -c /usr/local/php53/php.ini
/usr/local/nginx/sbin/nginx
;;
stop)
kill -s QUIT $(cat /usr/local/php53/var/run/php-fpm.pid)
kill -s QUIT $(cat /usr/local/nginx/logs/nginx.pid)
;;
*)
echo "You input wrong."
esac
# cat index.php
# cat i.php
注：若网页连接不正常。
排错
Warning: mysql_connect() : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr/local/nginx/phphtml/index.php on line 2
Warning: mysql_close(): no MySQL-Link resource supplied in /usr/local/nginx/phphtml/index.php on line 6
一般是由于没有/tmp/mysql.sock文件造成的，可链接此文件到此位置解决。
附加：
模块curl 安装扩展
在PHP的安装目录中进行
cd php-5.3.27/ext/curl/
phpize
./configure --with-curl=/usr/local/curl2 --with-php-config=/usr/local/php53/bin/php-config
make
cp modules/curl.so /usr/local/php53/lib/php/
vi /usr/local/php53/php.ini
extension="/usr/local/php53/lib/php/curl.so"
页:
[1]