Results 1 to 13 of 13
Thread: PHP 5.2.0 Oracle XE 10.2 Windows
Hybrid View
-
27th January 2007 16:12 #1
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 ).
!
-
27th January 2007 16:39 #2
connection string-
tutorial-a.Code:$db_conn = ocilogon("hr", "oracle", "http://vas:1521/");
URI, http tns listener.
-
27th January 2007 17:00 #3
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/
, Oracle !... http tns listener.
-
28th January 2007 09:13 #4.Code:
$db_conn = ocilogon("hr", "oracle", "//vas:1521/XE");
, ( sql*plus) -. - -. , - 1 .
-
28th January 2007 11:42 #5
$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.
-
28th January 2007 13:40 #6
- . .
php_oci8.dll . php.ini , - - php .
-
28th January 2007 14:24 #7
-
28th January 2007 15:27 #8
Last edited by Annihilator; 28th January 2007 at 15:38.
-
28th January 2007 15:42 #9
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.
-
28th January 2007 18:33 #10
, favicon.ico, , - ( -). , , .
, - - php.ini - 2 loadmodule . .
, obtain- .
'or die()' ocilogon(), print_r .
-
28th January 2007 22:12 #11
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.
-
28th January 2007 23:37 #12
, - url-a
%3C , '<' - , URL-a, - .
, oracle SYSDBA, SYSTEM user HR. HR.
- - -.
:
Code:SELECT 'Hello World' AS Greeting FROM DUAL;
-
29th January 2007 00:05 #13
Annihilator: . , !
, , "", (29.01) ( )!!!
,
!
:
: " ! ! ! , ! !"
: !
: " "!!!
2.: . ( 3 ), 4.4.4 Apache 2.0.59 !Last edited by haste; 29th January 2007 at 14:06.




Reply With Quote

Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in