{"id":414,"date":"2009-11-27T11:22:09","date_gmt":"2009-11-27T17:22:09","guid":{"rendered":"http:\/\/vostorga.org\/?p=414"},"modified":"2009-11-27T11:22:09","modified_gmt":"2009-11-27T17:22:09","slug":"activando-soporte-oracle-instant-client-php5-en-debian-linux","status":"publish","type":"post","link":"https:\/\/vostorga.org\/?p=414","title":{"rendered":"Activando soporte Oracle Instant Client + PHP5 en Debian Linux"},"content":{"rendered":"<p>Para conectarse a una base de datos Oracle con PHP 5, se puede hacer a trav\u00e9s del &#8220;Oracle Instant Client&#8221; y el modulo oci8 de pear.<\/p>\n<p>Primero se debe descargar los paquetes &#8220;Basic&#8221; y &#8220;SDK&#8221; desde <a href=\"http:\/\/www.oracle.com\/technology\/tech\/oci\/instantclient\/instantclient.html\" target=\"_blank\">http:\/\/www.oracle.com\/technology\/tech\/oci\/instantclient\/instantclient.html<\/a>. En mi caso, los archivos fueron<\/p>\n<ul>\n<li>instantclient-basic-linux32-10.2.0.3-20061115.zip<\/li>\n<\/ul>\n<ul>\n<li>instantclient-sdk-linux32-10.2.0.3-20061115.zip<\/li>\n<\/ul>\n<p>Creamos directorios y descomprimimos<\/p>\n<blockquote><p># mkdir -p \/opt\/oracle\/instantclient<br \/>\n# cd \/opt\/oracle\/instantclient<br \/>\n# unzip instantclient-basic-linux32-10.2.0.3-20061115.zip<br \/>\n# unzip instantclient-sdk-linux32-10.2.0.3-20061115.zip<\/p><\/blockquote>\n<p>Agregamos las librer\u00edas de oracle a las librer\u00edas del sistema<\/p>\n<blockquote><p># echo \/opt\/oracle\/instantclient &gt;&gt; \/etc\/ld.so.conf<br \/>\n# ldconfig<\/p><\/blockquote>\n<p>Creamos los v\u00ednculos simb\u00f3licos en caso de que el comando anterior no lo haya hecho:<\/p>\n<blockquote><p># cd instantclient_10_2<br \/>\n# ln -s libclntsh.so.10.1 libclntsh.so<br \/>\n# ln -s libocci.so.10.1 libocci.so<\/p><\/blockquote>\n<p>Instalamos paquetes necesarios para la configuraci\u00f3n del m\u00f3dulo oci8, entre ellos Pear<\/p>\n<blockquote><p># apt-get install php-pear php5-dev build-essential<\/p><\/blockquote>\n<p>En teor\u00eda el comando <em>pecl install oci8<\/em> deber\u00eda de funcionar, pero aparentemente no puede trabajar con las librer\u00edas de Oracle Instanclient, as\u00ed que procedemos a ejecutar los pasos manualmente<\/p>\n<blockquote><p># mkdir -p \/usr\/local\/src<br \/>\n# cd \/usr\/local\/src<br \/>\n# pecl download oci8<br \/>\n# tar xfz oci8-1.3.5.tgz<br \/>\n# cd oci8-1.3.5<br \/>\n# phpize<br \/>\n# .\/configure &#8211;with-oci8=shared,instantclient,\/opt\/oracle\/instantclient\/instantclient_10_2<br \/>\n# make<br \/>\n# make install<\/p><\/blockquote>\n<p>El nombre del archivo oci8-1.3.5.tgz cambiar\u00e1 dependiendo de nuevas versiones<\/p>\n<p>Luego activamos el m\u00f3dulo oci8 en el archivo php.ini (\/etc\/php5\/apache2\/php.ini and \/etc\/php5\/cli\/php.ini), con la siguiente l\u00ednea:<\/p>\n<blockquote><p>extension=oci8.so<\/p><\/blockquote>\n<p>Este paso tarde o temprano tendr\u00e1 que ejecutarse, asi que mejor de una vez configuramos el archivo\u00a0<em> tnsnames.ora<\/em><\/p>\n<blockquote><p>#\u00a0 mkdir -p \/opt\/oracle\/instantclient\/instantclient_10_2\/network\/admin<\/p><\/blockquote>\n<p>Editamos el tnsnames.ora de acuerdo a nuestras necesidades.<\/p>\n<blockquote><p># vi \/opt\/oracle\/instantclient\/instantclient_10_2\/network\/admin\/tnsnames.ora<\/p><\/blockquote>\n<p>Ahora se procede a reiniciar Apache y listo :), podemos auxiliarnos de phpinfo() para comprobar que el m\u00f3dulo oci8 est\u00e1 cargado.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Para conectarse a una base de datos Oracle con PHP 5, se puede hacer a trav\u00e9s del &#8220;Oracle Instant Client&#8221; y el modulo oci8 de pear. Primero se debe descargar los paquetes &#8220;Basic&#8221; y &#8220;SDK&#8221; desde http:\/\/www.oracle.com\/technology\/tech\/oci\/instantclient\/instantclient.html. En mi caso, los archivos fueron instantclient-basic-linux32-10.2.0.3-20061115.zip instantclient-sdk-linux32-10.2.0.3-20061115.zip Creamos directorios y descomprimimos # mkdir -p \/opt\/oracle\/instantclient # cd [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[92,3],"tags":[209,210,137],"class_list":["post-414","post","type-post","status-publish","format-standard","hentry","category-debian","category-linux","tag-debian","tag-oracle","tag-php"],"_links":{"self":[{"href":"https:\/\/vostorga.org\/index.php?rest_route=\/wp\/v2\/posts\/414"}],"collection":[{"href":"https:\/\/vostorga.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vostorga.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vostorga.org\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/vostorga.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=414"}],"version-history":[{"count":8,"href":"https:\/\/vostorga.org\/index.php?rest_route=\/wp\/v2\/posts\/414\/revisions"}],"predecessor-version":[{"id":422,"href":"https:\/\/vostorga.org\/index.php?rest_route=\/wp\/v2\/posts\/414\/revisions\/422"}],"wp:attachment":[{"href":"https:\/\/vostorga.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vostorga.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=414"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vostorga.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}