oracle apache phpÂÒÂëÎÊÌâ
°ì·¨Ò»
select * from V$NLS_PARAMETERS
$conn = oci_connect('scott', 'donkey', 'demo', 'zhs16gbk');
while ($dat = oci_fetch_row($cur)) {
print_r(iconv('gb2312', 'utf-8', $dat[0])); //$nickname = mb_convert_encoding($dat[0], 'utf-8', 'gbk');
}
»òÕß $c1 = oci_connect("scott", "tiger", $db, 'UTF8');
°ì·¨¶þ£º
°²×°ºÃ·þÎñÆ÷ºó£¬Óÿͻ§¶Ë¿´·þÎñÆ÷µÄÓïÑÔ
sql>select * from V$NLS_PARAMETERS Where PARAMETER=''NLS_LANGUAGE'';
±ÈÈç½á¹ûÊÇ"SIMPLIFIED CHINESE”
ÔÚApacheÀï¼ÓÈë»·¾³±äÁ¿
export NLS_LANGUAGE="SIMPLIFIED CHINESE"
ÔÚ/etc/init.d/httpdÀï¼ÓÈ룬Դ´úÂë°²×°µÄApacheдһ¸ö½Å±¾µ÷ÓÃapachectl
»òÕßÐèÒª/etc/init.d/httpdÀï¼ÓÈëÀïÒýÈë»·¾³±äÁ¿£¬ÓÉÓÚ±¾»úûÓÐÄǸöÆô¶¯Îļþ£¬ËùÒÔÖ»ÄÜÔÚapachectlÀï¼ÓÈëÈçÏ´úÂ룺
export NLS_LANGUAGE="SIMPLIFIED CHINESE"¡£
·½·¨Èý£ºhttpd.confÀï¼ÓÒ»ÐÐAddDefaultCharset GB2312 /off
·½·¨ËÄ£ºhtmlspecialchars() Ö§³ÖË«×Ö½Ú×Ö·û£¬±ÈÈ纺×Ö
htmlentities()Ö§³Öµ¥×Ö½Ú×Ö·û
·½·¨Î壺apacheµÄÅäÖÃÎļþÒѾ¼ÓÁËAddDefaultCharset GB2312
phpµÄÅäÖÃÎļþÒѾ¼ÓÁË AddDefaultCharset GB2312
Ïà¹ØÎĵµ£º
ÔÚÐéÄâ»úRed Hat Enterprise Linux 4 update 4Öа²×°oracle 10.2.0.1
1)²é¿´ÏµÍ³ÄÚ´æ
[root@linux4 ~]# grep MemTotal /proc/meminfo
2)²é¿´½»»»Çø´óС
[root@linux4 ~]# grep SwapTotal /proc/meminfo
3)
²é¿´/tmpĿ¼´óС
[root@linux4 ~]# df -m /tmp
4)²é¿´²Ù×÷ϵͳ°æ±¾
[root@linux4 ~]# cat /etc/issue
5)¼ ......
×÷ΪʵÏÖ¶¯Ì¬ÍøÕ¾µÄ¹¤¾ßÖ®Ò»£¬PHPÒÔÆäÓï·¨¼òµ¥¡¢¸ßЧ¿ìËٺͶÔÊý¾Ý¿âµÄ¹ã·ºÖ§³Ö¶øÉîÊÜÓû§»¶Ó¡£±àдPHP³ÌÐòºÍASPÒ»ÑùÐèÒªÔÚ±¾»úµ÷ÊÔ£¬Îª´ËÐèÒªÅäÖÃһϵ÷ÊÔ»·¾³¡£
Óкܶ෽°¸¿ÉÒÔÑ¡Ôñ£¬ÕâÀïÌṩÁ½ÖÖ½ÏΪ¼òÒ׵ķ½·¨¡£
²»¹ÜÊÇÄÄÖÖ·½·¨£¬¶¼ÐèÒª°²×°PHP¡£Èç¹ûÄãÊÇPHPʹÓÃÕߣ¬Äã¿ÉÄÜÔÚÍøÉÏÕÒ¹ýPHPµÄ°²×°×ÊѶ£¬ËüÃǼ¸ºõ¶¼ËµµÄ ......
ôßÉÏͨ¹ýÔ¤±àÒë²ûÊöµÀ¹²Ïí³Ø×îºóµ½SGA£¬ÕâÀï½øÒ»²½ËµÃ÷Ò»ÏÂSGAÖÐÁíÒ»¸ö´ó¿é£¬Êý¾Ý»º³åÇø£¬Ð¯´øÌá¼°Ò»µãÊý¾ÝÎļþºÍ±í¿Õ¼ä£¬ºóÐøרÃÅ»á˵Ã÷Õâ¿é¡£
Ê×ÏÈÁ˽âÏÂSGAÖÖ´óÖÂÓÐÄÇЩ¶«Î÷£¬ÕâЩ¶«Î÷Ëæ×ÅÊý¾Ý¿â°æ±¾µÄÔö¼Ó»áÓÐËùÔö¼Ó£¬²»¹ý´óÖÂÉÏÓ¦¸ÃÒ»Ö£¬ÕâÒ²ÊÇ»ù±¾ËùÓеÄÌåϵ½á¹¹¶¼»áÃèÊöµÄ¶«Î÷£º
ÔÚÈÏʶÊý¾Ý»º³åÇøÇ°£¬ÏȼÇס¼¸¸ö³ ......
--21.1 Data Pump¹¤¾ß
Data Pump
´Óoracledatabase 10g¿ªÊ¼ÒýÈëÁËdata pump(Êý¾Ý±Ã)¹¤¾ß£¬ËüÌṩÁËÒ»ÖÖ»ùÓÚ·þÎñÆ÷µÄÊý¾Ýµ¼³öµ¼ÈëʹÓóÌÐò¡£
ËùÓеÄdata pump¶¼×÷Ϊһ¸ö·þÎñÆ÷½ø³Ì£¬Êý¾Ý²»ÔÙ±ØÐëÓÉÒ»¸ö¿Í»§³ÌÐò´¦Àí¡£Data Pump¹¤¾ßµÄµ¼³öºÍµ¼ÈëʵÏÖ
OracleÊý¾Ý¿âÖ®¼äÊý¾ÝµÄ´ ......