양쪽 이전 판
이전 판
다음 판
|
이전 판
다음 판
양쪽 다음 판
|
develop:php:oracle_module [2017/12/27 01:43] starlits |
develop:php:oracle_module [2018/03/07 22:52] starlits [OCI8 설치 및 설정] |
==== 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 설정 ==== |
$ 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 |