[11G R2] Connexions Simultanées OCI8/Instantclient

Bonjour,


Je suis actuellement avec cette configuration fonctionnelle :

- Debian 6 Squeeze
- Nginx 1.2.3
- PHP5
- PHP-FPM
- Xcache
- Mysql
- Oracle OCI8.so
- Instant Client 11 Basic & SDK



Tout cela a été installé, et fonctionne à merveille comme le laisse suggérer phpinfo:
- Je n'ai pas encore installé PDO_OCI, même s'il ne semble pas être réellement nécessaire pour initialiser une connexion sur une base de données Oracle -

Code:

---

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 890 891 892 893 894 895 896 897 898 899 900 901 902 903 904 905 906 907 908 909 910 911 912 913 914 915 916 917 918 919 920 921 922 923 924 925

PHP Logo PHP Version 5.3.16   System Linux arch5454165 2.6.32-5-amd64 #1 SMP Sun May 6 04:00:17 UTC 2012 x86_64 Build Date Aug 17 2012 22:08:11 Server API FPM/FastCGI Virtual Directory Support disabled Configuration File (php.ini) Path /etc/php5/fpm Loaded Configuration File /etc/php5/fpm/php.ini Scan this dir for additional .ini files /etc/php5/fpm/conf.d Additional .ini files parsed /etc/php5/fpm/conf.d/curl.ini, /etc/php5/fpm/conf.d/gd.ini, /etc/php5/fpm/conf.d/mcrypt.ini, /etc/php5/fpm/conf.d/mysql.ini, /etc/php5/fpm/conf.d/mysqli.ini, /etc/php5/fpm/conf.d/oci8.ini, /etc/php5/fpm/conf.d/pdo.ini, /etc/php5/fpm/conf.d/pdo_mysql.ini, /etc/php5/fpm/conf.d/redis.ini, /etc/php5/fpm/conf.d/suhosin.ini, /etc/php5/fpm/conf.d/xcache.ini PHP API 20090626 PHP Extension 20090626 Zend Extension 220090626 Zend Extension Build API220090626,NTS PHP Extension Build API20090626,NTS Debug Build no Thread Safety disabled Zend Memory Manager enabled Zend Multibyte Support disabled IPv6 Support enabled Registered PHP Streams https, ftps, compress.zlib, compress.bzip2, php, file, glob, data, http, ftp, phar, zip Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls Registered Stream Filters zlib.*, bzip2.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, mcrypt.*, mdecrypt.*   Suhosin logo This server is protected with the Suhosin Patch 0.9.10 Copyright (c) 2006-2007 Hardened-PHP Project Copyright (c) 2007-2012 SektionEins GmbH   Zend logo This program makes use of the Zend Scripting Language Engine: Zend Engine v2.3.0, Copyright (c) 1998-2012 Zend Technologies with Suhosin v0.9.33, Copyright (c) 2007-2012, by SektionEins GmbH   PHP Credits Configuration bcmath BCMath support enabled   Directive Local Value Master Value bcmath.scale 0 0   bz2 BZip2 Support Enabled Stream Wrapper support compress.bzip2:// Stream Filter support bzip2.decompress, bzip2.compress BZip2 Version 1.0.5, 10-Dec-2007   calendar Calendar support enabled   cgi-fcgi php-fpm active   Directive Local Value Master Value cgi.discard_path 0 0 cgi.fix_pathinfo 0 0 cgi.force_redirect 1 1 cgi.nph 0 0 cgi.redirect_status_env no value no value cgi.rfc2616_headers 0 0 fastcgi.error_header no value no value fastcgi.logging 1 1 fpm.config no value no value   Core PHP Version 5.3.16-1~dotdeb.0   Directive Local Value Master Value allow_call_time_pass_reference Off Off allow_url_fopen On On allow_url_include Off Off always_populate_raw_post_data Off Off arg_separator.input & & arg_separator.output & & asp_tags Off Off auto_append_file no value no value auto_globals_jit On On auto_prepend_file no value no value browscap no value no value default_charset utf-8 utf-8 default_mimetype text/html text/html define_syslog_variables Off Off disable_classes no value no value disable_functions no value no value display_errors Off Off display_startup_errors Off Off doc_root no value no value docref_ext no value no value docref_root no value no value enable_dl Off Off error_append_string no value no value error_log no value no value error_prepend_string no value no value error_reporting 22527 22527 exit_on_timeout Off Off expose_php On On extension_dir /usr/lib/php5/20090626 /usr/lib/php5/20090626 file_uploads On On highlight.bg #FFFFFF #FFFFFF highlight.comment #FF8000 #FF8000 highlight.default #0000BB #0000BB highlight.html #000000 #000000 highlight.keyword #007700 #007700 highlight.string #DD0000 #DD0000 html_errors Off Off ignore_repeated_errors Off Off ignore_repeated_source Off Off ignore_user_abort Off Off implicit_flush Off Off include_path .:/usr/share/php:/usr/share/pear .:/usr/share/php:/usr/share/pear log_errors On On log_errors_max_len 1024 1024 magic_quotes_gpc Off Off magic_quotes_runtime Off Off magic_quotes_sybase Off Off mail.add_x_header On On mail.force_extra_parameters no value no value mail.log no value no value max_execution_time 30 30 max_file_uploads 20 20 max_input_nesting_level 64 64 max_input_time 60 60 max_input_vars 1000 1000 memory_limit 128M 128M open_basedir no value no value output_buffering 4096 4096 output_handler no value no value post_max_size 8M 8M precision 14 14 realpath_cache_size 16K 16K realpath_cache_ttl 120 120 register_argc_argv Off Off register_globals Off Off register_long_arrays Off Off report_memleaks On On report_zend_debug On On request_order GP GP safe_mode Off Off safe_mode_exec_dir no value no value safe_mode_gid Off Off safe_mode_include_dir no value no value sendmail_from no value no value sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i serialize_precision 17 17 short_open_tag Off Off SMTP localhost localhost smtp_port 25 25 sql.safe_mode Off Off track_errors Off Off unserialize_callback_func no value no value upload_max_filesize 2M 2M upload_tmp_dir no value no value user_dir no value no value user_ini.cache_ttl 300 300 user_ini.filename .user.ini .user.ini variables_order GPCS GPCS xmlrpc_error_number 0 0 xmlrpc_errors Off Off y2k_compliance On On zend.enable_gc On On   ctype ctype functions enabled   curl cURL support enabled cURL Information 7.21.0 Age 3 Features AsynchDNS No Debug No GSS-Negotiate Yes IDN Yes IPv6 Yes Largefile Yes NTLM Yes SPNEGO No SSL Yes SSPI No krb4 No libz Yes CharConv No Protocols dict, file, ftp, ftps, http, https, imap, imaps, ldap, ldaps, pop3, pop3s, rtsp, scp, sftp, smtp, smtps, telnet, tftp Host x86_64-pc-linux-gnu SSL Version OpenSSL/0.9.8o ZLib Version 1.2.3.4 libSSH Version libssh2/1.2.6   date date/time support enabled "Olson" Timezone Database Version 2012.3 Timezone Database internal Default timezone Europe/Paris   Directive Local Value Master Value date.default_latitude 31.7667 31.7667 date.default_longitude 35.2333 35.2333 date.sunrise_zenith 90.583333 90.583333 date.sunset_zenith 90.583333 90.583333 date.timezone Europe/Paris Europe/Paris   dba DBA support enabled Supported handlers cdb cdb_make db4 inifile flatfile qdbm   Directive Local Value Master Value dba.default_handler flatfile flatfile   dom DOM/XML enabled DOM/XML API Version 20031129 libxml Version 2.7.8 HTML Support enabled XPath Support enabled XPointer Support enabled Schema Support enabled RelaxNG Support enabled   ereg Regex Library Bundled library enabled   exif EXIF Support enabled EXIF Version 1.4 $Id$ Supported EXIF Version 0220 Supported filetypes JPEG,TIFF   Directive Local Value Master Value exif.decode_jis_intel JIS JIS exif.decode_jis_motorola JIS JIS exif.decode_unicode_intel UCS-2LE UCS-2LE exif.decode_unicode_motorola UCS-2BE UCS-2BE exif.encode_jis no value no value exif.encode_unicode ISO-8859-15 ISO-8859-15   fileinfo fileinfo support enabled version 1.0.5-dev   filter Input Validation and Filtering enabled Revision $Id: 2b8c730d7dfaa8485d07cd792f0c82852ffe4113 $   Directive Local Value Master Value filter.default unsafe_raw unsafe_raw filter.default_flags no value no value   ftp FTP support enabled   gd GD Support enabled GD Version bundled (2.0.34 compatible) FreeType Support enabled FreeType Linkage with freetype FreeType Version 2.4.2 T1Lib Support enabled GIF Read Support enabled GIF Create Support enabled JPEG Support enabled libJPEG Version 6b PNG Support enabled libPNG Version 1.2.44 WBMP Support enabled XPM Support enabled XBM Support enabled   Directive Local Value Master Value gd.jpeg_ignore_warning 0 0   gettext GetText Support enabled   hash hash support enabled Hashing Engines md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost adler32 crc32 crc32b salsa10 salsa20 haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5   iconv iconv support enabled iconv implementation glibc iconv library version 2.11.3   Directive Local Value Master Value iconv.input_encoding ISO-8859-1 ISO-8859-1 iconv.internal_encoding ISO-8859-1 ISO-8859-1 iconv.output_encoding ISO-8859-1 ISO-8859-1   json json support enabled json version 1.2.1   libxml libXML support active libXML Compiled Version 2.7.8 libXML Loaded Version 20708 libXML streams enabled   mbstring Multibyte Support enabled Multibyte string engine libmbfl HTTP input encoding translation disabled   mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.   Multibyte (japanese) regex support enabled Multibyte regex (oniguruma) version 5.9.1   Directive Local Value Master Value mbstring.detect_order no value no value mbstring.encoding_translation Off Off mbstring.func_overload 0 0 mbstring.http_input pass pass mbstring.http_output pass pass mbstring.http_output_conv_mimetypes ^(text/|application/xhtml\+xml) ^(text/|application/xhtml\+xml) mbstring.internal_encoding no value no value mbstring.language neutral neutral mbstring.strict_detection Off Off mbstring.substitute_character no value no value   mcrypt mcrypt support enabled mcrypt_filter support enabled Version 2.5.8 Api No 20021217 Supported ciphers cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes Supported modes cbc cfb ctr ecb ncfb nofb ofb stream   Directive Local Value Master Value mcrypt.algorithms_dir no value no value mcrypt.modes_dir no value no value   mhash MHASH support Enabled MHASH API Version Emulated Support   mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version mysqlnd 5.0.8-dev - 20102224 - $Id: 65fe78e70ce53d27a6cd578597722950e490b0d0 $   Directive Local Value Master Value mysql.allow_local_infile On On mysql.allow_persistent On On mysql.connect_timeout 60 60 mysql.default_host no value no value mysql.default_password no value no value mysql.default_port no value no value mysql.default_socket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock mysql.default_user no value no value mysql.max_links Unlimited Unlimited mysql.max_persistent Unlimited Unlimited mysql.trace_mode Off Off   mysqli MysqlI Support enabled Client API library version mysqlnd 5.0.8-dev - 20102224 - $Id: 65fe78e70ce53d27a6cd578597722950e490b0d0 $ Active Persistent Links 0 Inactive Persistent Links 0 Active Links 0   Directive Local Value Master Value mysqli.allow_local_infile On On mysqli.allow_persistent On On mysqli.default_host no value no value mysqli.default_port 3306 3306 mysqli.default_pw no value no value mysqli.default_socket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock mysqli.default_user no value no value mysqli.max_links Unlimited Unlimited mysqli.max_persistent Unlimited Unlimited mysqli.reconnect Off Off   mysqlnd mysqlnd enabled Version mysqlnd 5.0.8-dev - 20102224 - $Id: 65fe78e70ce53d27a6cd578597722950e490b0d0 $ Compression supported SSL supported Command buffer size 4096 Read buffer size 32768 Read timeout 31536000 Collecting statistics Yes Collecting memory statistics No Tracing n/a   Client statistics bytes_sent 0 bytes_received 0 packets_sent 0 packets_received 0 protocol_overhead_in 0 protocol_overhead_out 0 bytes_received_ok_packet 0 bytes_received_eof_packet 0 bytes_received_rset_header_packet 0 bytes_received_rset_field_meta_packet 0 bytes_received_rset_row_packet 0 bytes_received_prepare_response_packet 0 bytes_received_change_user_packet 0 packets_sent_command 0 packets_received_ok 0 packets_received_eof 0 packets_received_rset_header 0 packets_received_rset_field_meta 0 packets_received_rset_row 0 packets_received_prepare_response 0 packets_received_change_user 0 result_set_queries 0 non_result_set_queries 0 no_index_used 0 bad_index_used 0 slow_queries 0 buffered_sets 0 unbuffered_sets 0 ps_buffered_sets 0 ps_unbuffered_sets 0 flushed_normal_sets 0 flushed_ps_sets 0 ps_prepared_never_executed 0 ps_prepared_once_executed 0 rows_fetched_from_server_normal 0 rows_fetched_from_server_ps 0 rows_buffered_from_client_normal 0 rows_buffered_from_client_ps 0 rows_fetched_from_client_normal_buffered 0 rows_fetched_from_client_normal_unbuffered 0 rows_fetched_from_client_ps_buffered 0 rows_fetched_from_client_ps_unbuffered 0 rows_fetched_from_client_ps_cursor 0 rows_affected_normal 0 rows_affected_ps 0 rows_skipped_normal 0 rows_skipped_ps 0 copy_on_write_saved 0 copy_on_write_performed 0 command_buffer_too_small 0 connect_success 0 connect_failure 0 connection_reused 0 reconnect 0 pconnect_success 0 active_connections 0 active_persistent_connections 0 explicit_close 0 implicit_close 0 disconnect_close 0 in_middle_of_command_close 0 explicit_free_result 0 implicit_free_result 0 explicit_stmt_close 0 implicit_stmt_close 0 mem_emalloc_count 0 mem_emalloc_amount 0 mem_ecalloc_count 0 mem_ecalloc_amount 0 mem_erealloc_count 0 mem_erealloc_amount 0 mem_efree_count 0 mem_efree_amount 0 mem_malloc_count 0 mem_malloc_amount 0 mem_calloc_count 0 mem_calloc_amount 0 mem_realloc_count 0 mem_realloc_amount 0 mem_free_count 0 mem_free_amount 0 mem_estrndup_count 0 mem_strndup_count 0 mem_estndup_count 0 mem_strdup_count 0 proto_text_fetched_null 0 proto_text_fetched_bit 0 proto_text_fetched_tinyint 0 proto_text_fetched_short 0 proto_text_fetched_int24 0 proto_text_fetched_int 0 proto_text_fetched_bigint 0 proto_text_fetched_decimal 0 proto_text_fetched_float 0 proto_text_fetched_double 0 proto_text_fetched_date 0 proto_text_fetched_year 0 proto_text_fetched_time 0 proto_text_fetched_datetime 0 proto_text_fetched_timestamp 0 proto_text_fetched_string 0 proto_text_fetched_blob 0 proto_text_fetched_enum 0 proto_text_fetched_set 0 proto_text_fetched_geometry 0 proto_text_fetched_other 0 proto_binary_fetched_null 0 proto_binary_fetched_bit 0 proto_binary_fetched_tinyint 0 proto_binary_fetched_short 0 proto_binary_fetched_int24 0 proto_binary_fetched_int 0 proto_binary_fetched_bigint 0 proto_binary_fetched_decimal 0 proto_binary_fetched_float 0 proto_binary_fetched_double 0 proto_binary_fetched_date 0 proto_binary_fetched_year 0 proto_binary_fetched_time 0 proto_binary_fetched_datetime 0 proto_binary_fetched_timestamp 0 proto_binary_fetched_string 0 proto_binary_fetched_blob 0 proto_binary_fetched_enum 0 proto_binary_fetched_set 0 proto_binary_fetched_geometry 0 proto_binary_fetched_other 0 init_command_executed_count 0 init_command_failed_count 0 com_quit 0 com_init_db 0 com_query 0 com_field_list 0 com_create_db 0 com_drop_db 0 com_refresh 0 com_shutdown 0 com_statistics 0 com_process_info 0 com_connect 0 com_process_kill 0 com_debug 0 com_ping 0 com_time 0 com_delayed_insert 0 com_change_user 0 com_binlog_dump 0 com_table_dump 0 com_connect_out 0 com_register_slave 0 com_stmt_prepare 0 com_stmt_execute 0 com_stmt_send_long_data 0 com_stmt_close 0 com_stmt_reset 0 com_stmt_set_option 0 com_stmt_fetch 0 com_deamon 0 bytes_received_real_data_normal 0 bytes_received_real_data_ps 0   oci8 OCI8 Support enabled Version 1.4.7 Revision $Revision: 321634 $ Active Persistent Connections 0 Active Connections 0 Oracle Run-time Client Library Version 11.2.0.3.0 Oracle Instant Client Version 11.2 Temporary Lob support enabled Collections support enabled   Directive Local Value Master Value oci8.connection_class no value no value oci8.default_prefetch 100 100 oci8.events Off Off oci8.max_persistent -1 -1 oci8.old_oci_close_semantics Off Off oci8.persistent_timeout -1 -1 oci8.ping_interval 60 60 oci8.privileged_connect Off Off oci8.statement_cache_size 20 20   openssl OpenSSL support enabled OpenSSL Library Version OpenSSL 0.9.8o 01 Jun 2010 OpenSSL Header Version OpenSSL 0.9.8o 01 Jun 2010   pcre PCRE (Perl Compatible Regular Expressions) Support enabled PCRE Library Version 8.12 2011-01-15   Directive Local Value Master Value pcre.backtrack_limit 1000000 1000000 pcre.recursion_limit 100000 100000   PDO PDO support enabled PDO drivers mysql   pdo_mysql PDO Driver for MySQL enabled Client API version mysqlnd 5.0.8-dev - 20102224 - $Id: 65fe78e70ce53d27a6cd578597722950e490b0d0 $   Directive Local Value Master Value pdo_mysql.default_socket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock   Phar Phar: PHP Archive support enabled Phar EXT version 2.0.1 Phar API version 1.1.1 SVN revision $Id: f7d08da4ab9e515975840c28b830edc9437c3026 $ Phar-based phar archives enabled Tar-based phar archives enabled ZIP-based phar archives enabled gzip compression enabled bzip2 compression enabled OpenSSL support enabled   Phar based on pear/PHP_Archive, original concept by Davey Shafik. Phar fully realized by Gregory Beaver and Marcus Boerger. Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.   Directive Local Value Master Value phar.cache_list no value no value phar.readonly On On phar.require_hash On On   posix Revision $Id: c00b7465003bf16b27764ccaea3c159ca2e4419d $   redis Redis Support enabled Redis Version 2.2.1   Reflection Reflection enabled Version $Id: 23c90449811cd1a9c860b115456b64946c2823a9 $   session Session Support enabled Registered save handlers files user redis Registered serializer handlers php php_binary wddx   Directive Local Value Master Value session.auto_start Off Off session.bug_compat_42 Off Off session.bug_compat_warn Off Off session.cache_expire 180 180 session.cache_limiter nocache nocache session.cookie_domain no value no value session.cookie_httponly Off Off session.cookie_lifetime 0 0 session.cookie_path / / session.cookie_secure Off Off session.entropy_file no value no value session.entropy_length 0 0 session.gc_divisor 1000 1000 session.gc_maxlifetime 1440 1440 session.gc_probability 1 1 session.hash_bits_per_character 5 5 session.hash_function 0 0 session.name PHPSESSID PHPSESSID session.referer_check no value no value session.save_handler redis redis session.save_path tcp://127.0.0.1:6379?weight=1 tcp://127.0.0.1:6379?weight=1 session.serialize_handler php php session.use_cookies On On session.use_only_cookies On On session.use_trans_sid 0 0   shmop shmop support enabled   SimpleXML Simplexml support enabled Revision $Id: a379111021e24ef020a2eefd8ca830cb1ab5b280 $ Schema support enabled   soap Soap Client enabled Soap Server enabled   Directive Local Value Master Value soap.wsdl_cache 1 1 soap.wsdl_cache_dir /tmp /tmp soap.wsdl_cache_enabled 1 1 soap.wsdl_cache_limit 5 5 soap.wsdl_cache_ttl 86400 86400   sockets Sockets Support enabled   SPL SPL support enabled Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException   standard Dynamic Library Support enabled Path to sendmail /usr/sbin/sendmail -t -i   Directive Local Value Master Value assert.active 1 1 assert.bail 0 0 assert.callback no value no value assert.quiet_eval 0 0 assert.warning 1 1 auto_detect_line_endings 0 0 default_socket_timeout 60 60 from no value no value safe_mode_allowed_env_vars PHP_ PHP_ safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH url_rewriter.tags a=href,area=href,frame=src,input=src,form=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry user_agent no value no value   suhosin Suhosin logo This server is protected with the Suhosin Extension 0.9.33   Copyright (c) 2006-2007 Hardened-PHP Project Copyright (c) 2007-2012 SektionEins GmbH   Directive Local Value Master Value suhosin.apc_bug_workaround Off Off suhosin.cookie.checkraddr 0 0 suhosin.cookie.cryptdocroot On On suhosin.cookie.cryptkey [ protected ] [ protected ] suhosin.cookie.cryptlist no value no value suhosin.cookie.cryptraddr 0 0 suhosin.cookie.cryptua On On suhosin.cookie.disallow_nul 1 1 suhosin.cookie.disallow_ws 1 1 suhosin.cookie.encrypt Off Off suhosin.cookie.max_array_depth 50 50 suhosin.cookie.max_array_index_length 64 64 suhosin.cookie.max_name_length 64 64 suhosin.cookie.max_totalname_length 256 256 suhosin.cookie.max_value_length 10000 10000 suhosin.cookie.max_vars 100 100 suhosin.cookie.plainlist no value no value suhosin.coredump Off Off suhosin.disable.display_errors Off Off suhosin.executor.allow_symlink Off Off suhosin.executor.disable_emodifier Off Off suhosin.executor.disable_eval Off Off suhosin.executor.eval.blacklist no value no value suhosin.executor.eval.whitelist no value no value suhosin.executor.func.blacklist no value no value suhosin.executor.func.whitelist no value no value suhosin.executor.include.allow_writable_files On On suhosin.executor.include.blacklist no value no value suhosin.executor.include.max_traversal 0 0 suhosin.executor.include.whitelist phar phar suhosin.executor.max_depth 0 0 suhosin.filter.action no value no value suhosin.get.disallow_nul 1 1 suhosin.get.disallow_ws 0 0 suhosin.get.max_array_depth 50 50 suhosin.get.max_array_index_length 64 64 suhosin.get.max_name_length 64 64 suhosin.get.max_totalname_length 256 256 suhosin.get.max_value_length 512 512 suhosin.get.max_vars 100 100 suhosin.log.file 0 0 suhosin.log.file.name no value no value suhosin.log.phpscript 0 0 suhosin.log.phpscript.is_safe Off Off suhosin.log.phpscript.name no value no value suhosin.log.sapi 0 0 suhosin.log.script 0 0 suhosin.log.script.name no value no value suhosin.log.syslog no value no value suhosin.log.syslog.facility no value no value suhosin.log.syslog.priority no value no value suhosin.log.use-x-forwarded-for Off Off suhosin.mail.protect 0 0 suhosin.memory_limit 0 0 suhosin.mt_srand.ignore On On suhosin.multiheader Off Off suhosin.perdir 0 0 suhosin.post.disallow_nul 1 1 suhosin.post.disallow_ws 0 0 suhosin.post.max_array_depth 50 50 suhosin.post.max_array_index_length 64 64 suhosin.post.max_name_length 64 64 suhosin.post.max_totalname_length 256 256 suhosin.post.max_value_length 1000000 1000000 suhosin.post.max_vars 1000 1000 suhosin.protectkey On On suhosin.request.disallow_nul 1 1 suhosin.request.disallow_ws 0 0 suhosin.request.max_array_depth 50 50 suhosin.request.max_array_index_length 64 64 suhosin.request.max_totalname_length 256 256 suhosin.request.max_value_length 1000000 1000000 suhosin.request.max_varname_length 64 64 suhosin.request.max_vars 1000 1000 suhosin.server.encode On On suhosin.server.strip On On suhosin.session.checkraddr 0 0 suhosin.session.cryptdocroot On On suhosin.session.cryptkey [ protected ] [ protected ] suhosin.session.cryptraddr 0 0 suhosin.session.cryptua Off Off suhosin.session.encrypt On On suhosin.session.max_id_length 128 128 suhosin.simulation Off Off suhosin.sql.bailout_on_error Off Off suhosin.sql.comment 0 0 suhosin.sql.multiselect 0 0 suhosin.sql.opencomment 0 0 suhosin.sql.union 0 0 suhosin.sql.user_postfix no value no value suhosin.sql.user_prefix no value no value suhosin.srand.ignore On On suhosin.stealth On On suhosin.upload.disallow_binary 0 0 suhosin.upload.disallow_elf 1 1 suhosin.upload.max_uploads 25 25 suhosin.upload.remove_binary 0 0 suhosin.upload.verification_script no value no value   sysvmsg sysvmsg support enabled Revision $Id: bf99fb053e35d98fb01c414dda6d4813a55e6647 $   tokenizer Tokenizer Support enabled   wddx WDDX Support enabled WDDX Session Serializer enabled   XCache XCache Support enabled Version 2.0.1 Modules Built cacher Readonly Protection N/A Cache Init Time 2012-08-21 13:35:36 Cache Instance Id 1541 Opcode Cache enabled, 536,870,912 bytes, 4 split(s), with 4096 slots each Variable Cache enabled, 134,217,728 bytes, 4 split(s), with 4096 slots each Shared Memory Schemes mmap   Directive Local Value Master Value xcache.admin.enable_auth On On xcache.cacher On On xcache.coredump_directory no value no value xcache.count 3 3 xcache.experimental Off Off xcache.gc_interval 900 900 xcache.mmap_path /tmp/xcache /tmp/xcache xcache.readonly_protection 0 0 xcache.shm_scheme mmap mmap xcache.size 512M 512M xcache.slots 4K 4K xcache.stat On On xcache.test 0 0 xcache.ttl 3600 3600 xcache.var_count 3 3 xcache.var_gc_interval 900 900 xcache.var_maxttl 7200 7200 xcache.var_size 128M 128M xcache.var_slots 4K 4K xcache.var_ttl 3600 3600   xml XML Support active XML Namespace Support active libxml2 Version 2.7.8   xmlreader XMLReader enabled   xmlwriter XMLWriter enabled   zip Zip enabled Extension Version $Id$ Zip version 1.11.0 Libzip version 0.10.1   zlib ZLib Support enabled Stream Wrapper support compress.zlib:// Stream Filter support zlib.inflate, zlib.deflate Compiled Version 1.2.1.1 Linked Version 1.2.3.4   Directive Local Value Master Value zlib.output_compression Off Off zlib.output_compression_level -1 -1 zlib.output_handler no value no value   Additional Modules Module Name sysvsem sysvshm   Environment Variable Value USER www-data HOME /var/www   PHP Variables Variable Value _SERVER["USER"] www-data _SERVER["HOME"] /var/www _SERVER["FCGI_ROLE"] RESPONDER _SERVER["QUERY_STRING"] no value _SERVER["REQUEST_METHOD"] GET _SERVER["CONTENT_TYPE"] no value _SERVER["CONTENT_LENGTH"] no value _SERVER["SCRIPT_FILENAME"] /usr/share/nginx/www/index.php _SERVER["SCRIPT_NAME"] /index.php _SERVER["REQUEST_URI"] / _SERVER["DOCUMENT_URI"] /index.php _SERVER["DOCUMENT_ROOT"] /usr/share/nginx/www _SERVER["SERVER_PROTOCOL"] HTTP/1.1 _SERVER["GATEWAY_INTERFACE"] CGI/1.1 _SERVER["SERVER_SOFTWARE"] nginx/1.2.3 _SERVER["REMOTE_ADDR"] 213.174.126.27 _SERVER["REMOTE_PORT"] 17798 _SERVER["SERVER_ADDR"] 188.165.50.64 _SERVER["SERVER_PORT"] 80 _SERVER["SERVER_NAME"] ******* _SERVER["HTTPS"] no value _SERVER["REDIRECT_STATUS"] 200 _SERVER["HTTP_HOST"] ****** _SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Windows NT 6.1; rv:14.0) Gecko/20100101 Firefox/14.0.1 _SERVER["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 _SERVER["HTTP_ACCEPT_LANGUAGE"] fr,fr-fr;q=0.8,en-us;q=0.5,en;q=0.3 _SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate _SERVER["HTTP_CONNECTION"] keep-alive _SERVER["HTTP_IF_MODIFIED_SINCE"] Mon, 09 Apr 2012 13:16:10 GMT _SERVER["HTTP_IF_NONE_MATCH"] "200000000ae8c-aee-4bd3ecf50fdfa" _SERVER["PHP_SELF"] /index.php _SERVER["REQUEST_TIME"] 1345549713

---

Le problème que j'ai:


Impossible de se connecter sur une base de données oracle 11G R2 qui est hébergée sur un Windows 2008 R2 Server, l'erreur renvoyée est :

oci_connect(): ORA-12154: TNS:could not resolve the connect identifier specified in /usr/share/nginx/www/script.php on line 3



Je précise que cela fait d'ailleurs planter la connexion de l'application (made by me) qui est sur le serveur d'oracle 11G qui travaille sur la base de données.

Je me demande donc si à priori il n'y aurait pas une interaction lorsque qu'on utilise le même id / password de l'utilisateur oracle utilisé par l'application ?

En local le navicat se connecte très bien en tant que system, mais sur mon poste à distance c'est niet, même via ssh en tunneling.



Enfin, dernier point pour la connexion à Oracle, j'ai bizarrement lu de part et d'autre que le TNSNAMES.ora devait être configuré, donc je me demande si je devrais pas mettre l'ip publique du serveur dans le TNSNAMES.ora de la database à laquelle j'essaie de me connecter depuis l'extérieur et en local ?

Je devrais copier le même fichier dans l'instant client du serveur web (j'ai installé basic et sdk avec les chemins par défaut du rpm) ?


D'après le tuto ici (page 103 - 104) : http://www.oracle.com/technetwork/topics/php/026973.pdf
Il semblerait que je sois obligé de déclarer $TNS_ADMIN comme je l'ai fait sur les variables d'environnement Windows ?




Pas mal de questions sachant que l'architecture est critique actuellement.
Merci pour l'aide qui serait apportée.

Je suis actuellement en train de rédiger un tuto complet pour les prochaines personnes qui souhaitent un tel serveur web.


Merci :)

Je viens de régler le problème du:

oci_connect(): ORA-12154: TNS:could not resolve the connect identifier specified in /usr/share/nginx/www/script.php on line 3


Qui était dû simplement au fait qu'il fallait configurer le fichier hosts à la fois sur le linux et windows pour que les deux machines puissent se ping l'une et l'autre.

J'ai par ailleurs copié TNSNAMES.ora sur debian pour l'instantclient, je n'ai pas les options tnsping ni sqlplus pourtant j'ai installé les rpm de instantclient, mais y'a rien dedans, je pense que c'est inclus directement depuis les clients complets qui font 700 mo.



L'erreur actuelle est :

ORA-12170: TNS:Connect timeout occurred


Nginx me sort:

504 Gateway Time-out
nginx/1.2.3



Je pense que le problème est côté client puisque le code de connexion marche très bien sur le wamp du serveur où est installé la database.

L'objectif que j'ai est de virer Wamp qui est pas super, du tout.



Donc à partir de là, je vous donne les fichiers de config:





Serveur DB:



C:\Windows\System32\drivers\etc\hosts

127.0.0.1 localhost
188.***.**.** arch117





C:\app\Administrateur\product\11.2.0\dbhome_1\NETWORK\ADMIN\TNSNAMES.ora

# tnsnames.ora Network Configuration File: C:\app\Administrateur\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ARCH =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = arch117)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = arch)
(INSTANCE_NAME = arch)
(GLOBAL_NAME = arch)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)




C:\app\Administrateur\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (HOSTNAME, TNSNAMES)

ADR_BASE = C:\app\Administrateur\product\11.2.0\dbhome_1\log





C:\app\Administrateur\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = arch)
(SID_NAME = arch)
)
)

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = arch117)(PORT = 1521))
)

ADR_BASE_LISTENER = C:\app\Administrateur\product\11.2.0\dbhome_1\log





C:\Users\Administrateur>tnsping arch117
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 22-AO█T-2012 23:09:21

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Fichiers de paramÞtres utilisÚs :
C:\app\Administrateur\product\11.2.0\client_1\instantclient\sqlnet.ora

Adaptateur HOSTNAME utilisÚ pour la rÚsolution de l'alias
Tentative de contact de (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=188.***.**.**)(PORT=1521)))
OK (0 msec)





C:\Users\Administrateur>C:\app\Administrateur\product\11.2.0\dbhome_1\BIN\LSNRCTL.EXE status

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 22-AO█T -2012 23:11:51

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connexion Ó (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=arch117)(PORT=1521)))
STATUT du PROCESSUS D'ECOUTE
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
Date de dÚpart 22-AO█T -2012 14:35:00
DurÚe d'activitÚ 0 jours 8 heures 37 min. 6 sec
Niveau de trace off
SÚcuritÚ ON: Local OS Authentication
SNMP OFF
Fichier de paramÞtres du processus d'Úcoute C:\app\Administrateur\product\11.2.0\dbhome_1\network\admin\listener.ora
Fichier journal du processus d'Úcoute c:\app\administrateur\diag\tnslsnr\arch117\listener\alert\log.xml
RÚcapitulatif d'Úcoute des points d'extrÚmitÚ...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=188.***.**.**)(PORT=1521)))
RÚcapitulatif services...
Le service "CLRExtProc" comporte 1 instance(s).
L'instance "CLRExtProc", statut UNKNOWN, comporte 1 gestionnaire(s) pour ce service...
Le service "arch" comporte 1 instance(s).
L'instance "arch", statut READY, comporte 1 gestionnaire(s) pour ce service...
Le service "archXDB" comporte 1 instance(s).
L'instance "arch", statut READY, comporte 1 gestionnaire(s) pour ce service...
La commande a rÚussi







Chez le client la variable TNSADMIN.ora a été déclarée dans /etc/environment:
TNS_ADMIN=/etc/oracle



Et dans /etc/oracle/tnsnames.ora:

ARCH =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = arch117)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = arch)
(INSTANCE_NAME = arch)
(GLOBAL_NAME = arch)
)
)




/etc/hosts

127.0.0.1 localhost
188.***.**.** arch116
188.***.**.** arch117




Bref, je cherche toujours ... mais ça a bien avancé déjà !



EDIT: Vous allez rire ... Le pare-feu ...
Tout est désormais fonctionnel ! Uniquement lorsque le Firewall est Off ...

Je viens de voir ici: http://www.dbasupport.com/forums/arc...p/t-19188.html

- Your listener is set up to listen on port 1521
- Firewall is configured to accept calls from your client's IP on port 1521
1) Your clients tries to established connection with the database by sending request to port 1521 of the database server
2) Firewall let the call through (it is configured to do so) and listener intercepts the call
3) Listener transfers the request to the database
4) After database checks you are authorised to connect to the database it sends the responce back directly to your client. But database chooses some new port on which the session will be established, let's say it is port 2020. So your client gets the message from your database, saying: You are welcome to connect to the database, we will communicate on port 2020.
5.) Your client obeys the instructions from the database and sends a message to the database server, but this time on port 2020.
6.) This message gets rejected by the firewall, because it can accept only messages through port 1521, not through 2020.
7.) As a result, the database connection is not established.


Donc que faire dans mon cas, sachant que l'ip des deux machines (serveur et client) sont connues de tous par un simple ping et que je ne souhaite pas autoriser des connexions entrantes / sortantes pour une ip à tous les ports.

Risque de sécu majeur.




EDIT 2:

Bon j'ai ouvert le port 1521 uniquement à l'ip du client, et j'ai appliqué un mot de passe fort, mais si vous avez des suggestions à ce propos, faites en part !

Tout fonctionne actuellement.

Bonjour,

Je suis actuellement avec cette configuration fonctionnelle :
wamp server 2.0
instant client_11_2.

Tout cela a été installé, et fonctionne à merveille comme le laisse suggérer phpinfo:.
j'ai résolu le problème de connections php oracle sur une base distant.

mais mon problème je ne peut pas connecter sur une autre base de données oracle distant de même même serveur.
voici le fichier tnsname.ora:
str =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = @srv1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
test =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = @srv2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dbcomp)
)
)

testdb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = @srv2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dbper)
)
)


pour les deux premiers instance( str ,test)je peut le connecter avec php et sql plus..
mais avec la troisième instance(testdb) je peut connecter avec sqlplus mais avec php je ne peut pas .voici la chaine de connection avec php:
$dba = "(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = @srv2)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME =dbper)))";
//$conn = oci_connect("user","pwd",$dba);
voici le message d'erreur.
ORA-28547: échec de connexion au serveur ; erreur probable de l'administration Oracle Net ,
avec cette connections php:
$conn = oci_connect("user","pwd","@srv2:1521/dbper");
voici le msg d'erreur
ORA-12514: TNS : le processus d'écoute ne conna�t pas actuellement le service demandé

(les deux instance test,tesdb sur le même serveur @srv2).
je suis besoin la solution .
merci de ton aide .
je suis bloqué.