Publicité
+ Répondre à la discussion
Affichage des résultats 1 à 3 sur 3
  1. #1
    Invité régulier
    Profil pro Fabien
    Inscrit en
    avril 2010
    Messages
    74
    Détails du profil
    Informations personnelles :
    Nom : Fabien

    Informations forums :
    Inscription : avril 2010
    Messages : 74
    Points : 9
    Points
    9

    Par défaut [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

  2. #2
    Invité régulier
    Profil pro Fabien
    Inscrit en
    avril 2010
    Messages
    74
    Détails du profil
    Informations personnelles :
    Nom : Fabien

    Informations forums :
    Inscription : avril 2010
    Messages : 74
    Points : 9
    Points
    9

    Par défaut

    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.

  3. #3
    Invité de passage
    Inscrit en
    septembre 2008
    Messages
    1
    Détails du profil
    Informations forums :
    Inscription : septembre 2008
    Messages : 1
    Points : 1
    Points
    1

    Par défaut Connexions aux bases de données

    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é.

+ Répondre à la discussion
Cette discussion est résolue.

Liens sociaux

Règles de messages

  • Vous ne pouvez pas créer de nouvelles discussions
  • Vous ne pouvez pas envoyer des réponses
  • Vous ne pouvez pas envoyer des pièces jointes
  • Vous ne pouvez pas modifier vos messages
  •