| 양쪽 이전 판
이전 판
다음 판
|
이전 판
|
develop:php:oracle_module [2017/12/27 01:41]
starlits [OCI8 설치 및 설정] |
develop:php:oracle_module [2018/04/10 00:56] (현재)
starlits [한방에 설치] |
| - php dev <code># apt-get install php7.0-dev </code> | - php dev <code># apt-get install php7.0-dev </code> |
| - build essential <code># apt-get install build-essential libaio1 </code> | - build essential <code># apt-get install build-essential libaio1 </code> |
| | |
| | ==== 한방에 설치 ==== |
| | <code> # apt-get install apache2 php php-mysql php-xmlrpc php-xml php-curl php-gd php-pear libapache2-mod-php7.0 php7.0-dev build-essential libaio1 unzip </code> |
| |
| ===== apache2 설정 ===== | ===== apache2 설정 ===== |
| ==== oracle instant 다운로드 ==== | ==== oracle instant 다운로드 ==== |
| - http://oracle.com 에서 다운로드 받는다. | - http://oracle.com 에서 다운로드 받는다. |
| - [[ http://adminschool.net/data/oracle_instant/instantclient-basic-linux.x64-11.2.0.4.0.zip | instantclient-basic-linux.x64-11.2.0.4.0.zip ]] (필수) | - [[ http://adminschool.net/admin_data/oracle_instant/instantclient-basic-linux.x64-11.2.0.4.0.zip | instantclient-basic-linux.x64-11.2.0.4.0.zip ]] (필수) |
| - [[ http://adminschool.net/data/oracle_instant/instantclient-jdbc-linux.x64-11.2.0.4.0.zip | instantclient-jdbc-linux.x64-11.2.0.4.0.zip ]] | - [[ http://adminschool.net/admin_data/oracle_instant/instantclient-jdbc-linux.x64-11.2.0.4.0.zip | instantclient-jdbc-linux.x64-11.2.0.4.0.zip ]] |
| - [[ http://adminschool.net/data/oracle_instant/instantclient-odbc-linux.x64-11.2.0.4.0.zip | instantclient-odbc-linux.x64-11.2.0.4.0.zip ]] | - [[ http://adminschool.net/admin_data/oracle_instant/instantclient-odbc-linux.x64-11.2.0.4.0.zip | instantclient-odbc-linux.x64-11.2.0.4.0.zip ]] |
| - [[ http://adminschool.net/data/oracle_instant/instantclient-sdk-linux.x64-11.2.0.4.0.zip | instantclient-sdk-linux.x64-11.2.0.4.0.zip ]] | - [[ http://adminschool.net/admin_data/oracle_instant/instantclient-sdk-linux.x64-11.2.0.4.0.zip | instantclient-sdk-linux.x64-11.2.0.4.0.zip ]] (필수) |
| - [[ http://adminschool.net/data/oracle_instant/instantclient-sqlplus-linux.x64-11.2.0.4.0.zip | instantclient-sqlplus-linux.x64-11.2.0.4.0.zip ]] | - [[ http://adminschool.net/admin_data/oracle_instant/instantclient-sqlplus-linux.x64-11.2.0.4.0.zip | instantclient-sqlplus-linux.x64-11.2.0.4.0.zip ]] |
| - [[ http://adminschool.net/data/oracle_instant/instantclient-tools-linux.x64-11.2.0.4.0.zip | instantclient-tools-linux.x64-11.2.0.4.0.zip ]] | - [[ http://adminschool.net/admin_data/oracle_instant/instantclient-tools-linux.x64-11.2.0.4.0.zip | instantclient-tools-linux.x64-11.2.0.4.0.zip ]] |
| |
| ==== oracle instant 설정 ==== | ==== oracle instant 설정 ==== |
| - 압축해제 <code># unzip instantclient-basic-linux.x64-11.2.0.4.0.zip </code> | - 압축해제 <code> |
| | # unzip instantclient-basic-linux.x64-11.2.0.4.0.zip |
| | # unzip instantclient-sdk-linux.x64-11.2.0.4.0.zip |
| | </code> |
| - 압축해제 폴더이동 <code># mv instantclient_11_2/ /usr/local/ </code> | - 압축해제 폴더이동 <code># mv instantclient_11_2/ /usr/local/ </code> |
| - 디렉토리 이동 <code># cd /usr/local/instantclient_11_2/ </code> | - 디렉토리 이동 <code># cd /usr/local/instantclient_11_2/ </code> |
| $ vi ~/.bashrc | $ vi ~/.bashrc |
| ... | ... |
| export DYLD_LIBRARY_PATH="/usr/local/oracle/instantclient_11_2" | export DYLD_LIBRARY_PATH="/usr/local/instantclient_11_2" |
| export TNS_ADMIN="/usr/local/oracle/instantclient_11_2" | export TNS_ADMIN="/usr/local/instantclient_11_2" |
| export ORACLE_HOME="/usr/local/oracle/instantclient_11_2" | export ORACLE_HOME="/usr/local/instantclient_11_2" |
| ... | ... |
| </code> | </code> |
| - 환경설정을 맞춰서 컴파일을 한다. <code> | - 환경설정을 맞춰서 컴파일을 한다. <code> |
| $ ./configure --with-oci8=instantclient,/usr/local/instantclient_11_2 | $ ./configure --with-oci8=instantclient,/usr/local/instantclient_11_2 |
| | </code> |
| | - make 와 make test 를 실행한다. <code> |
| | # make |
| | # make test |
| </code> | </code> |
| - make install 를 실행한다. \\ root가 아닐 경우 퍼미션 에러가 날 수 있다, 이때에는 sudo 를 같이 써준다. <code> | - make install 를 실행한다. \\ root가 아닐 경우 퍼미션 에러가 날 수 있다, 이때에는 sudo 를 같이 써준다. <code> |
| </code> | </code> |
| - apache2 를 재시작한다. <code> # /etc/init.d/apache2 restart </code> | - apache2 를 재시작한다. <code> # /etc/init.d/apache2 restart </code> |
| - oci8.so 모듈을 확인해 본다. <code> | - oci8.so 모듈을 확인해 본다. (이 방법은 확인이 안될때도 있다) <code> |
| # php -m | grep oci8 | # php -m | grep oci8 |
| oci8 | oci8 |
