Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

PHP ÖÐʹÓÃoracle »·¾³ÅäÖÃ

http://www.oracle.com/technology/global/cn/pub/notes/technote_php_instant.html
Ϊ Linux ºÍ Windows °²×° PHP ºÍ Oracle 10g Instant Client
×÷ÕߣºChristopher Jones£¬¼×¹ÇÎĹ«Ë¾µÄ×Éѯ¼¼ÊõÈËÔ±
·¢²¼ÈÕÆÚ£º2004 Äê 12 ÔÂ
Oracle 10g Instant Client£¨Ãâ·ÑÏÂÔØ£©ÊÇPHP ÓëÔ¶³Ì Oracle Êý¾Ý¿âÁ¬½ÓµÄ×î¼òµ¥·½Ê½£¬ËüÖ»ÐèÒª°²×°Èý¸ö¿â¡£
PHP ·ÃÎÊ Oracle µÄµ±Ç° API ËùʹÓÃµÄ Instant Client ¿â³Æ×÷ OCI8.£¨´Ë C ½Ó¿ÚµÄÃû³Æ×îÔçÊÇÔÚ Oracle8 ÖÐÒýÈëµÄ¡££©PHP Oracle 8 º¯Êý ¿ÉÒÔÖ±½Óµ÷Óà Oracle 8.1.7¡¢9.x »ò 10.x£¬»òÕßÒ²¿ÉÒÔΪÁË·½±ãÆð¼û£¬Ê¹ÓÿÉÑ¡µÄ³éÏóÀ࣬Èç PEAR MDB2 ºÍ ADOdb¡£
Instant Client Ò²¿ÉÒÔʹÓÃÀÏ°æ±¾µÄ PHP“oracle”À©Õ¹£¬µ«Ëüµ÷Óò»ÔÞ³ÉʹÓÃµÄ Oracle API¡£PHP ½ç»ò Oracle ½¨Ò鲻ҪʹÓôËÀ©Õ¹½øÐÐеĿª·¢¡£
ÒªÔÚ Apache ÉϽ« Instant Client Óë PHP 4 »ò Á¬Óã¬Çë×ñÑ­ÒÔϲ½Öè¡£ÐèÒªÒ»¸öÏÖÓÐµÄ Oracle Êý¾Ý¿â£»Instant Client ²»Ìṩ Oracle Êý¾Ý¿â¡£Í¨³£Çé¿öÏ£¬´ËÊý¾Ý¿â½«Î»ÓÚÆäËû¼ÆËã»úÉÏ¡£Èç¹ûÊý¾Ý¿âλÓÚ±¾µØ£¬Ôò Oracle ×é¼þÒ»°ãÔçÒÑ¿ÉÓ㬴Ӷø²»ÐèÒª Instant Client¡£
Èí¼þÐèÇó£º
Èí¼þ
¸½×¢
Oracle Instant Client
ÏÂÔØ“Instant Client Package - Basic”¡£ÔÚ Linux ÉÏ£¬»¹Ó¦ÏÂÔØ“Instant Client Package - SDK”¡£
Apache HTTPD Server
PHP ½çÈÔÍƼö Apache 1.3
PHP — PHP ³¬Îı¾´¦ÀíÆ÷
4.3 °æ»ò¸ü¸ß°æ±¾
ÔÚ Windows ÉÏÆôÓÃ PHP OCI8 À©Õ¹
Instant Client ¶þ½øÖÆÎļþÊÇ PHP µÄ Windows Ô¤¹¹½¨¶þ½øÖÆÎļþµÄ²¹³ä¡£
ÏÂÔØ PHP ¶þ½øÖÆѹËõÎļþ£¨²»ÊÇ°²×°³ÌÐò°æ±¾£©ºÍ Apache¡£°´ÕÕ PHP ÊÖ²áÖÐµÄ Windows ϵͳÉϵݲװ°²×°ËüÃÇ¡£OTN µÄ¿ª·ÅÔ´´úÂ뿪·¢ÈËÔ±ÖÐÐÄ°üº¬ÓÐÓñ³¾°×ÊÁϵÄÁ´½Ó£¬Èç“ÔÚ Windows 2000/XP ÉÏ°²×° Oracle¡¢PHP ºÍ Apache”£¬Ëü½éÉÜÁËÈçºÎ°²×°´«Í³¡¢ÍêÕûµÄ Oracle 10g °æ±¾£¨Instant Client ²»ÐèÒª´Ë°æ±¾£©¡£
¼ÌÐø²Ù×÷֮ǰ¼ì²é PHP ÊÇ·ñÕý³£ÔËÐС£´Ë½×¶ÎδÆôÓà Oracle Ö§³Ö¡£
´Ó OTN µÄ Instant Client Ò³ÃæÏÂÔØÓÃÓÚ Windows µÄ Instant Client Basic ³ÌÐò°ü¡£´ËѹËõÎļþµÄ´óС´óԼΪ 30MB¡£
´´½¨Ò»¸ö×ÓĿ¼£¨ÀýÈ磬c:\instantclient10_1£©£¬È»ºó´ÓѹËõÎļþÖи´ÖÆÒÔÏ¿⣺
oraociei10.dll
orannzsbb10.dll
oci.dll
ÕâÈý¸öÎļþµÄ×Ü´óС´óԼΪ 80MB¡£
ҪʹÓà PHP ÀÏ°æ±¾µÄ“oracle”À©Õ¹£¨ÔÚ php.in


Ïà¹ØÎĵµ£º

php³õ¼¶½Ì³Ì(Ê®)ÐÂÎŵÄÁбíºÍɾ³ý

ÏÖÔÚÎÒÃÇ¿ªÊ¼½éÉÜÐÂÎŵÄÁбíºÍɾ³ýÁË¡£
н¨Á¢Ò»¸öÎļþlistnews.php,ÄÚÈÝÈçÏ£º
< ?php
require_once('../inc/config.php');
//°üº¬ÅäÖÃÎļþ
?>
<html>
<head></head>
<title>ÐÂÎŹÜÀí</title>
<body>
<div class="newstitle"></div>
<div class="ne ......

oracle³£ÓÃÃüÁîÏê½â

oracleÀïµÄ³£ÓÃÃüÁîÏê½â
±¾ÎÄÕë¶ÔoracleÈÕ³£µÄÃûÁî×öÁ˽éÉÜ£¬»¶Ó­¸÷λ´óÏÀ¶àÌᱦ¹óÒâ¼ûºÍ¶à¶à²¹³ä£¡
Ò»
ÈÕÖ¾¹ÜÀí
1.forcing log switches
sql> alter system switch logfile;
2.forcing checkpoints
sql> alter system checkpoint;
3.adding online redo log groups
sql> alter database add logfil ......

Oracle³£¼ûÎÊÌâÕï¶Ï


1       ORA-12571¡¢ORA-03113¡¢ORA-03114¡¢ORA-01041
ÌØÕ÷£º¿Í»§¶Ë£¨´úÀí»òÓ¦Ó÷þÎñÆ÷£©ÓÐʱ±¨ÕâÀà¶ÏÁ¬´íÎó
Ô­Òò£ºÈç¹ûż¶û³öÏÖÒ»´Î£¬Ôò¿ÉÄÜΪÍøÂçÔ­Òò»òÓû§Òì³£ÖÐÖ¹£¬Èç¹û¾­³£³öÏÖÔòΪ¿Í»§¶ËÓë·þÎñ¶ËµÄ×Ö·û¼¯²»Ò»Ö¡£
´ëÊ©£ºÈç¹ûż¶û³öÏÖ£¬¿ÉÔÚ·þÎñ¶ËµÄЭÒéÅäÖÃÎļþPROTOCOL.ORAÖÐÔö¼ÓÒ»ÐÐ
TC ......

oracleÊý¾Ý±ÃµÄѧϰ

--21.1 Data Pump¹¤¾ß
 Data Pump
     ´Óoracledatabase 10g¿ªÊ¼ÒýÈëÁËdata pump(Êý¾Ý±Ã)¹¤¾ß£¬ËüÌṩÁËÒ»ÖÖ»ùÓÚ·þÎñÆ÷µÄÊý¾Ýµ¼³öµ¼ÈëʹÓóÌÐò¡£
 ËùÓеÄdata pump¶¼×÷Ϊһ¸ö·þÎñÆ÷½ø³Ì£¬Êý¾Ý²»ÔÙ±ØÐëÓÉÒ»¸ö¿Í»§³ÌÐò´¦Àí¡£Data Pump¹¤¾ßµÄµ¼³öºÍµ¼ÈëʵÏÖ
 OracleÊý¾Ý¿âÖ®¼äÊý¾ÝµÄ´ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ