windowsϺÍlinuxÏÂPHPÖ§³Öoracle
windowsÏÂ:
1.ÏÂÔØÓÃÓÚ Windows µÄ Instant Client Basic ³ÌÐò°ü:http://download.oracle.com/otn/nt/instantclient/111070/instantclient-basic-win32-11.1.0.7.0.zip
2.½âѹËõ
´´½¨Ò»¸ö×ÓĿ¼£¨ÀýÈ磬d:\oci£©£¬È»ºó´ÓѹËõÎļþÖи´ÖÆÒÔÏ¿⣺
oraociei10.dll
orannzsbb10.dll
oci.dll
µ½´ËĿ¼ÏÂ
´ò¿ªPHP.iniÎļþÀïµÄphp_oci8.dllÄǾäµÄ×¢ÊÍ
Ìí¼ÓPATH±äÁ¿ºÍTNS_ADMIN ±äÁ¿£¬ÖµÊÇ£º
d:\oci
ÔÚ£ºd:\ociÏÂÃæ´´½¨tnsnames.ora
ORALOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.162)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xe)
)
)
ÆäÖÐORALOCAL¿ÉÒÔÈÎÒâÖ¸¶¨£¬xeÊÇ·þÎñÃû³Æ
È»ºó¾Í¿ÉÒÔÖ±½ÓÓãºoci_connect($dbuser, $dbpw, 'ORALOCAL');·ÃÎÊÊý¾Ý¿âÁË
linux ÏÂ
ÏÂÔØÒÔϼ¸¸öÎļþ£º
oracle-instantclient11.1-basic-11.1.0.7.0-1.i386.rpm
oracle-instantclient11.1-devel-11.1.0.7.0-1.i386.rpm
oracle-instantclient11.1-sqlplus-11.1.0.7.0-1.i386.rpm
°²×° apm -Uvh oracle-instantclient11.1-*
$pecl install oci8--ÕâÀïÐèÒª°ÑpeclÁ¬½Óһϵ½»·¾³±äÁ¿ÄÜ·ÃÎʵ½µÄ£¬·ñÔòÐèÒªÓþø¶Ô·¾¶
ÕâÀïÐèÒª°²×°autoconfigÈç¹ûδ°²×°»á±¨´í£¬¿ÉÒÔÓðü¹ÜÀíÆ÷À´°²×°¡£
Èç¹û²»³É¹¦£¬¿ÉÒÔÈ¥/tmp/pear/download/oci8-1.3.5×ÔÐбàÒ룺
./configure --with-php-config=/usr/local/php/bin/php-config --with-oci8=instantclient,/usr/lib/oracle/11.2/client/lib/
apachectl restart
Ò²¿ÉÒÔ°Ñtnsnames.ora ·Åµ½Ò»¸öĿ¼Ï£¬È»ºó¼Óµ½»·¾³±äÁ¿ÄÚ£ºexport TNS_ADMIN=/usr/local/php/lib
È»ºó¾Í¿ÉÒÔÖ±½ÓÓãºoci_connect($dbuser, $dbpw, 'ORALOCAL');·ÃÎÊÊý¾Ý¿âÁË
Ïà¹ØÎĵµ£º
Ò»£ºÇ°ÑÔ
×î½üÔÚÑо¿androidµÄsensor driver£¬Ö÷ÒªÊÇE-compass£¬ÆäÖÐÓõ½ÁËLinux input×Óϵͳ.ÔÚÍøÉÏÒ²¿´Á˺ܶàÕâ·½ÃæµÄ×ÊÁÏ£¬¸Ð¾õ»¹ÊÇÕâÆª·ÖÎöµÄ±È½ÏϸÖÂ͸³¹£¬Òò´Ë×ªÔØÒ»ÏÂÒÔ±ã×Ô¼ºÑ§Ï°£¬Í¬Ê±ºÍ´ó¼Ò·ÖÏí£¡
£¨ÕâÆª²©¿ÍÖ÷ÒªÊÇÒÔ¼üÅÌÇý¶¯ÎªÀýµÄ£¬²»¹ý½²½âµÄÊÇLinux Input Subsystem£¬¿ÉÒÔ×ÐϸµÄÑо¿Ò»Ï£¡£©
¼üÅÌÇý¶¯½«¼ì ......
֮ǰ¿´ÁË¡¶Ð±¬Äں˸ßΣ©¶´sock_sendpageµÄÀûÓ÷ÖÎöµÄÌÖÂÛ
¡·ÕâÆªÌû×Ó£¬ÔھżúÐÖºÍÖîλCUerµÄÖ¸ÒýÏ£¬´óÖÂŪÇåÁËÕû¸ö©¶´µÄʼĩ¡£ÏÖÓë´ó¼Ò·ÖÏí£¨ÒýÓÃ×ÔÎҵĿռä
£©¡£
ÓÐʲô²»×ãÖ®´¦»¹Íû¶à¶àÖ¸½Ì~
Äں˵ÄBUG
Õâ¸öBUGÊ×ÏȵôÓsendfileϵͳµ÷ÓÃ˵Æð¡£
¿¼Âǽ«Ò»¸ö±¾µØÎļþͨ¹ýsocket·¢ËͳöÈ¥µÄÎÊÌâ¡£ÎÒÃÇͨ³£µÄ×ö·¨ÊÇ£º ......
linuxϵͳ¿ÉÒÔ°ÑһЩ³£ÓõÄÃüÁî×öÒ»¸ö¼ò¶ÌµÄ±ðÃû
alias tomcat£½"cd /usr/local/tomcat",µ«ÊÇÍ˳öϵͳºóÕâЩ±ðÃû¾ÍʧЧÁË£¬ÈçºÎ°Ñ±ðÃûдÈëÅäÖÃÎļþ£º
Ê×ÏÈÕÒµ½µÇ½µÄÓû§µÄÎļþ¼Ð£¬±ÈÈçROOTµÇ½µÄʱºò£¬ÔÚ/Ŀ¼Ï½øÈëROOTĿ¼±à¼.bash_profileÎļþ
±ÈÈç¿ÉÒÔÕâÑù±à¼£¨alias ÕâÁ ......
topÃüÁî²ÎÊý˵Ã÷
1.×÷ÓÃ
topÃüÁîÓÃÀ´ÏÔʾִÐÐÖеijÌÐò½ø³Ì£¬Ê¹ÓÃȨÏÞÊÇËùÓÐÓû§¡£
2.¸ñʽ
top [£] [d delay] [q] [c] [S] [s] [i] [n]
3.Ö÷Òª²ÎÊý
d£ºÖ¸¶¨¸üеļä¸ô£¬ÒÔÃë¼ÆËã¡£
q£ºÃ»ÓÐÈκÎÑӳٵĸüС£Èç¹ûʹÓÃÕßÓг¬¼¶Óû§£¬ÔòtopÃüÁ»áÒÔ×î¸ßµÄÓÅÏÈÐòÖ´ÐС£
c£ºÏÔʾ½ø³ÌÍêÕûµÄ·¾¶ÓëÃû³Æ¡£
S£ºÀÛ ......
ÍøÂçѹÁ¦²âÊÔ£¬ÐèÒª´¦ÀíÔʼÊý¾Ý£¬½«ÔʼµÄByte/s ´¦ÀíΪMbps£¬²¢Í¨¹ýÖ±¹ÛÇúÏßͼ±íչʾ³öÀ´¡£
1.ͳ¼ÆÍø¿¨Á÷Á¿
sar -n DEV 1 100 > net
µÃµ½Íø¿¨Á÷Á¿£¬ÔʼÊý¾ÝÈçÏ£º
10:32:41 IFACE rxpck/s txpck/s rxbyt/s ......