Results 1 to 13 of 13

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Banned haste's Avatar
    Join Date: Mar:2006
    Location:
    Posts: 759

    PHP 5.2.0 Oracle XE 10.2 Windows

    PHP Oracle http://www.oracle.com/technology/tec...e_windows.html .

    , , oci8test.php . http://localhost/oci8test.php ! oci8test.php htdocs/ Apache.

    , PHP i8, php.ini e o .
    .zip php.ini, oci8test.php hi.php (phpinfo().htm ).

    !
    Attached Files

  2. #2
    Registered User Annihilator's Avatar
    Join Date: Jun:2004
    Location: Sofia
    Posts: 1,316
    connection string-
    Code:
    $db_conn = ocilogon("hr", "oracle", "http://vas:1521/");
    tutorial-a.
    URI, http tns listener.

  3. #3
    Banned haste's Avatar
    Join Date: Mar:2006
    Location:
    Posts: 759
    Annihilator: !
    http://127.0.0.1/XE Oracle . http://vas:1158/em/ iSQL*Plus , .

    , listener.ora
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    (ADDRESS = (PROTOCOL = TCP)(HOST = vas)(PORT = 1521))
    )
    )
    http://vas:1521/

    ... http tns listener.
    , Oracle !

  4. #4
    Registered User Annihilator's Avatar
    Join Date: Jun:2004
    Location: Sofia
    Posts: 1,316
    Code:
    $db_conn = ocilogon("hr", "oracle", "//vas:1521/XE");
    .

    , ( sql*plus) -. - -. , - 1 .

  5. #5
    Banned haste's Avatar
    Join Date: Mar:2006
    Location:
    Posts: 759
    $db_conn = ocilogon("hr", "oracle", "//vas:1521/XE");
    . error.log Apache-a :

    PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\php\\ext\\php_oci8.dll' - The specified module could not be found.\r\n in Unknown on line 0



    [Sat Jan 27 00:04:47 2007] [error] [client 127.0.0.1] PHP Fatal error: Call to undefined function ocilogon() in C:\\Program Files\\Apache Software Foundation\\Apache2.2\\htdocs\\oci8test. php on line 3

    : 5.2.0 Oracle ( Pthread) Windows?
    Last edited by haste; 28th January 2007 at 13:04.

  6. #6
    Registered User Annihilator's Avatar
    Join Date: Jun:2004
    Location: Sofia
    Posts: 1,316
    - . .
    php_oci8.dll . php.ini , - - php .

  7. #7
    Banned haste's Avatar
    Join Date: Mar:2006
    Location:
    Posts: 759
    php_oci8.dll .
    () php.ini error.log Apache- !

    : Oracle SQL Developer :

    Last edited by haste; 28th January 2007 at 14:37.

  8. #8
    Registered User Annihilator's Avatar
    Join Date: Jun:2004
    Location: Sofia
    Posts: 1,316
    Last edited by Annihilator; 28th January 2007 at 15:38.

  9. #9
    Banned haste's Avatar
    Join Date: Mar:2006
    Location:
    Posts: 759
    php_oci8.dll C:\php\ext !

    : oci.dll C:\php\ext error.log-a Apache:

    [Sun Jan 28 14:44:30 2007] [error] [client 127.0.0.1] PHP Warning: ocilogon() [<a href='function.ocilogon'>function.ocilog on</a>]: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER in C:\\Program Files\\Apache Software Foundation\\Apache2.2\\htdocs\\oci8test. php on line 11
    [Sun Jan 28 14:44:30 2007] [error] [client 127.0.0.1] PHP Warning: ociparse() expects parameter 1 to be resource, boolean given in C:\\Program Files\\Apache Software Foundation\\Apache2.2\\htdocs\\oci8test. php on line 15
    [Sun Jan 28 14:44:30 2007] [error] [client 127.0.0.1] PHP Warning: ociexecute() expects parameter 1 to be resource, null given in C:\\Program Files\\Apache Software Foundation\\Apache2.2\\htdocs\\oci8test. php on line 16
    [Sun Jan 28 14:44:30 2007] [error] [client 127.0.0.1] PHP Warning: ocifetchstatement() expects parameter 1 to be resource, null given in C:\\Program Files\\Apache Software Foundation\\Apache2.2\\htdocs\\oci8test. php on line 18

    (SYSTEM), Oracle SQL Developer ( SYS ).

    2.: unzip- Instant Client- PATH-a - :

    [Sun Jan 28 15:12:06 2007] [warn] pid file C:/Program Files/Apache Software Foundation/Apache2.2/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
    PHP Warning: Module 'oci8' already loaded in Unknown on line 0
    PHP Warning: PHP Startup: Invalid library (maybe not a PHP library) 'php_pdo_oci8.dll' in Unknown on line 0
    [Sun Jan 28 15:12:07 2007] [notice] Apache/2.2.4 (Win32) PHP/5.2.0 configured -- resuming normal operations
    [Sun Jan 28 15:12:07 2007] [notice] Server built: Jan 9 2007 23:17:20
    [Sun Jan 28 15:12:07 2007] [notice] Parent: Created child process 2012
    PHP Warning: Module 'oci8' already loaded in Unknown on line 0
    PHP Warning: PHP Startup: Invalid library (maybe not a PHP library) 'php_pdo_oci8.dll' in Unknown on line 0
    [Sun Jan 28 15:12:07 2007] [notice] Child 2012: Child process is running
    [Sun Jan 28 15:12:07 2007] [notice] Child 2012: Acquired the start mutex.
    [Sun Jan 28 15:12:07 2007] [notice] Child 2012: Starting 250 worker threads.
    [Sun Jan 28 15:12:07 2007] [notice] Child 2012: Starting thread to listen on port 80.
    [Sun Jan 28 15:12:33 2007] [error] [client 127.0.0.1] File does not exist: C:/Program Files/Apache Software Foundation/Apache2.2/htdocs/favicon.ico, referer: http://127.0.0.1/oci8test.php

    , 10201_client_win32 instantclient-basic-win32-10.2.0.3-20061115?

    3.: Apacha-a, instantclient- -!
    Last edited by haste; 28th January 2007 at 17:42.

  10. #10
    Registered User Annihilator's Avatar
    Join Date: Jun:2004
    Location: Sofia
    Posts: 1,316
    , favicon.ico, , - ( -). , , .
    , - - php.ini - 2 loadmodule . .

    , obtain- .
    'or die()' ocilogon(), print_r .

  11. #11
    Banned haste's Avatar
    Join Date: Mar:2006
    Location:
    Posts: 759
    Annihilator !

    :
    1. Windows (+ Patches);
    2. Apache 2.2.4 (+ config);
    3. PHP 5.2.0 (+ config);
    4. Oracle 10.2.0.1.0 Express Edition (+ Oracle SQL Developer 1.1)
    5. Instant Client 10.2 (+ config);
    6. ( - );

    , , oci8test.php ( , )!



    :
    Apache ( - Oracle):
    [Sun Jan 28 20:14:04 2007] [error] [client 127.0.0.1] (20024)The given path misformatted or contained invalid characters: Cannot map GET /%3C?searchquery=Manhattan&searchtype=coc ktail&action=search HTTP/1.1 to file, referer: http://127.0.0.1/aufg.php

    error.log-a Apache!

    (+ )



    , Mediawiki 1.9.0:
    http://www.gossamer-threads.com/list...he/bugs/325534

    , ?
    Last edited by haste; 29th January 2007 at 00:32.

  12. #12
    Registered User Annihilator's Avatar
    Join Date: Jun:2004
    Location: Sofia
    Posts: 1,316
    , - url-a
    %3C , '<' - , URL-a, - .

    , oracle SYSDBA, SYSTEM user HR. HR.
    - - -.

    :
    Code:
    SELECT 'Hello World' AS Greeting FROM DUAL;

  13. #13
    Banned haste's Avatar
    Join Date: Mar:2006
    Location:
    Posts: 759
    Annihilator: . , !

    , , "", (29.01) ( )!!!

    , !

    :
    : " ! ! ! , ! !"

    : !
    : " "!!!

    2.: . ( 3 ), 4.4.4 Apache 2.0.59 !
    Last edited by haste; 29th January 2007 at 14:06.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |