使用 oracle instantclient 安裝 Perl DBD::Oracle 出現 Unable to locate an oracle.mk or other suitable *.mk

http://stackoverflow.com/questions/26200174/error-while-installing-dbdoracle

1. Download the tar.gz package and unpack it
   
   a)可以使用perl -MCPAN -e shell
   b)出現標題error
   c)去$HOME/.cpan/build/DBD-Oracle-xxx
   d)執行以下步驟 2,3 ...
   
2. Build it
   

   perl Makefile.PL -l
   make && make test
   

3. Install
   

   make install
   

使用 oracle instantclient 安裝 Perl DBD::Oracle 出現 Unable to locate an oracle.mk or other suitable *.mk

http://stackoverflow.com/questions/26200174/error-while-installing-dbdoracle

1. Download the tar.gz package and unpack it
   
   a)可以使用perl -MCPAN -e shell
   b)出現標題error
   c)去$HOME/.cpan/build/DBD-Oracle-xxx
   d)執行以下步驟 2,3 ...
   
2. Build it
   

   perl Makefile.PL -l
   make && make test
   

3. Install
   

   make install
   

CentOS 6.2 安裝 Apache/2.2.15 and PHP/5.2.17

1. OS version

[root@EIP-API-AP php-5.2.17]# lsb_release -a
LSB Version:    :core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch
Distributor ID: CentOS
Description:    CentOS release 6.2 (Final)
Release:        6.2
Codename:       Final

2. Apache version

[root@EIP-API-AP php-5.2.17]# httpd -v
Server version: Apache/2.2.15 (Unix)
Server built:   Oct 16 2014 14:48:21

3. PHP version

php-5.2.17

4. 拿掉/安裝 不要service

chkconfig iptables off
chkconfig postfix off
yum install vsftpd.x86_64 (vim /etc/vsftp/vsftpd.conf --> userlist_deny=NO)

5. OS command

yum install httpd-devel
yum install gcc
yum install libxml2-devel
yum install mysql-devel

yum install autoconf
cp -rp /usr/lib64/mysql/libmysqlclient.so.16.0.0 /usr/lib/libmysqlclient.so
./configure --with-apxs2=/usr/sbin/apxs --with-mysql
make
make test
make install
cp php.ini-recommended /usr/local/lib/php.ini
 

6. vim httpd.conf

<FilesMatch \.php$>
    SetHandler application/x-httpd-php
</FilesMatch>

7. vim php.ini

short_open_tag=on (這樣<% 才認得，否則只能用 <?php)

8. OS command

service httpd restart

9. install oracle instant client

rpm -U oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
rpm -U oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm

10. download oci8

ln -s /usr/lib/oracle/12.1/client64/lib/libclntsh.so.12.1 /usr/lib/oracle/12.1/client64/lib/libclntsh.so
tar zxvf oci8-2.0.8.tgz
cd oci8-2.0.8
phpize
./configure --with-oci8=shared,instantclient,/usr/lib/oracle/12.1/client64/lib
make
make install

11. vim /usr/local/lib/php.ini

extension_dir = "/usr/local/lib/php/extensions/no-debug-non-zts-20060613/"
extension=oci8.so

12. service httpd restart

13. mysqli installation

cd ~/Downloads/php-5.2.17/ext/mysqli/
phpize
./configure --prefix=/usr/local/mysqli --with-php-config=/usr/local/bin/php-config --with-mysqli=/usr/bin/mysql_config
make
make install
vim /usr/local/lib/php.ini (extension=mysqli.so)

14. phpinfo

check if oci8 installed

 

linux 幾個關掉或開啟service的方法

http://carl830.pixnet.net/blog/post/58991014-linux-%E5%B9%BE%E5%80%8B%E9%97%9C%E6%8E%89%E6%88%96%E9%96%8B%E5%95%9Fservice%E7%9A%84%E6%96%B9%E6%B3%95

(如果想立即開啟或關掉就要用service 或是直接到/etc/init.d/底下去操作)
以下是用來設定在系統開啟時預設要執行的service
在RedHat系列底下可以用chkconfig
啟用httpd(如果已經加到chkconfig裡了 就可以不用輸入第一行)

chkconfig httpd --add
chkconfig http on

停用httpd(第二行是把httpd從chkconfig的管理中移除 我的建議是輸入第一行就好了)

chkconfig httpd off
chkconfig httpd --del

在Debian或Ubuntu底下的話 可以用update-rc.d
開啟apache2

update-rc.d apache2 defaults

關掉apache2

update-rc.d -f apache2 remove

至於前面提到的service 這裡提供一些簡單的範例(找不到這個指令的話可以用套件管理找找看)
service開啟httpd

service httpd start

用service關閉httpd

service httpd stop