BEA Weblogic92 ÅäÖÃOracleÁ¬½Ó³Ø
Ò»¡¢
´ò¿ª¿ØÖÆ̨£º
´ò¿ª http://localhost
:7001/console
£¬Æô¶¯¹ÜÀí¿ØÖÆ̨¡£ÊäÈë¹ÜÀíÔ±Óû§ÃûºÍÃÜÂ루ĬÈÏ£ºweblogic/weblogic£©¡£
¶þ¡¢´´½¨
JDBCÊý¾ÝÔ´£º
1¡¢
µ¥»÷“Ëø¶¨²¢±à¼
”°´Å¥£»
2¡¢
ÔÚ“Óò½á¹¹
”Ê÷ÖУ¬Õ¹¿ª“·þ
Îñ”>“JDBC”
£¬È»ºóÑ¡Ôñ“Êý¾ÝÔ´
”¡£
3¡¢
ÔÚ“Êý¾ÝÔ´¸ÅÒª
”Ò³ÉÏ£¬µ¥»÷“н¨
”¡£
4¡¢
ÔÚ“JDBC Êý¾ÝÔ´ÊôÐÔ
”Ò³ÉÏ£¬ÊäÈë»òÑ¡ÔñÏÂÁÐÐÅÏ¢£º
Ãû³Æ£ºjdbc/oracle
JNDIÃû³Æ£ºjdbc/oracle
Êý¾Ý¿âÀàÐÍ£ºOracle
Êý¾Ý¿âÇý¶¯³ÌÐò£º*Oracle's Driver (Thin XA) Versions:9.0.1,9.2.0,10
µã»÷“ÏÂ
Ò»²½”
¡£
5¡¢ÎÞÐè¸Ä±äĬÈÏÖµ£¬ÔÙµã»÷“ÏÂÒ»²½”
¡£
6¡¢ÊäÈëÒÔÏÂÖµ£º
Êý¾Ý¿âÃû³Æ£ºo9i (Ó¦¸ÃÌîдOracleÊý¾Ý¿âʵÀýµÄ±êʶ£¬¼´SID)
Ö÷»úÃû£º127.0.0.1
£¨Êý¾Ý¿â·þÎñÆ÷IP»òÕßHostName£©
¶Ë¿Ú£º1521
Êý¾Ý¿âÓû§Ãû£ºscott
ÃÜÂ룺tiger
È·ÈÏÃÜÂ룺tiger
µã»÷“ÏÂÒ»²½”
¡£
7¡¢µã»÷“²â
ÊÔÅäÖÔ
°´Å¥¡£ÈôÏÔʾ“Á¬½Ó²âÊԳɹ¦”£¬Ôò˵Ã÷ÒÔÉϲÎÊýÅäÖÃÕýÈ·¡£µã»÷“ÏÂÒ»²½”
°´Å¥¡£
8¡¢
ÔÚ“Ñ¡ÔñÄ¿±ê”
²Ù×÷ÖУ¬Ñ¡ÔñÐèÒª½«±¾Êý¾ÝÔ´²¿Êðµ½ÄÄЩ·þÎñÆ÷ÉÏ£¬Ñ¡Ôñ“AdminServer”
£¬
È»ºóµã»÷“Íê³É”
°´Å¥¡£
9¡¢µã»÷“¼¤»î¸ü¸Ä”
°´Å¥£¬ÊÇÅäÖÃÐÅÏ¢³Ö¾Ã±£´æ²¢
ÉúЧ¡£
10¡¢²é¿´JNDIÃû³Æ½á¹¹£º
ÔÚ×ó²à´°¸ñÖУ¬Õ¹¿ª“»·
¾³”>“·þÎñÆ÷”
¡£
ÔÚ·þÎñÆ÷¸ÅÒªÒ³ÉÏ£¬µ¥»÷·þÎñÆ÷µÄÃû³Æ£¬Èç AdminServer¡£
ÔÚ·þÎñÆ÷ÉèÖÃÒ³ÉÏ£¬µ¥»÷“²é¿´
JNDI Ê÷
” Á¬½Ó¡£
JNDI Ê÷½«ÏÔʾÔÚд°¿ÚÖС£¿ÉÒÔ¿´µ½£¬jdbc/oracle ÒѾ³ÉΪJNDIĿ¼Ê÷µÄÆäÖеĽڵ㡣
ÖÁ´Ë£¬JNDIÊý¾ÝÔ´ÒѾ³É¹¦´´½¨ÇÒ²¿Êð³É¹¦¡£
Îå¡¢
Á¬½Ó³ØÅäÖõÄÆ
Ïà¹ØÎĵµ£º
²©ÑåÅàѵ²¿ÊǹúÄÚΨһĿǰµÄ Oracle ¹Ù·½ÊÚȨ ERP ÈÏÖ¤Åàѵ»ú¹¹
Ä¿Ç°£¬Oracle Ó¦ÓÃϵͳÔÚÈ«Çò¿ç¹ú¹«Ë¾µÃµ½¹ã·ºÓ¦Óã¬ÖîÈçÖйúÒƶ¯¡¢ÉîÛÚ»ªÎª¡¢»ôÄáΤ¶û¡¢¿µÃ÷˹Öйú¡¢ÃÀ¹úÂÁÒµ¡¢DHL ºÍ±¦ÐÅÈí¼þµÈÖªÃû¹«Ë¾¡£Îª´Ë£¬Oracle ×Éѯ¹ËÎÊÊÇÈ«ÇòºÍÖйúÊг¡ÉÏ×î½ôȱµÄÈ˲ÅÖ®Ò»¡£Í¨¹ýOracle ÉÌÎñÌ×¼þÈÏÖ¤µÄ×Éѯ¹ËÎ ......
Oracle Ö÷ÒªÅäÖÃÎļþ½éÉÜ£¨×ªÌû£©
Oracle Ö÷ÒªÅäÖÃÎļþ½éÉÜ£º
profileÎļþ£¬oratab Îļþ£¬Êý¾Ý¿âʵÀý³õʼ»¯Îļþ initSID.ora£¬¼àÌýÅäÖÃÎļþ£¬ sqlnet.ora
Îļþ£¬tnsnames.ora Îļþ
1.2 Oracle Ö÷ÒªÅäÖÃÎļþ½éÉÜ
1.2.1 /etc/profile Îļþ
  ......
£¨1£©²éѯC01¿Î³Ì³É¼¨²»ÎªNullµÄѧÉúµÄÐÕÃûºÍ³É¼¨¡£
·ÖÎö£ºÒòΪÉæ¼°µ½¿Î³Ì³É¼¨ºÍѧÉúÐÕÃû£¬ÐèÒª¶Ôstudent±íºÍsc±í½øÐÐÁ¬½Ó¡£
´úÂ룺
select sname,grade from student,sc where student.sno=sc.sno and c ......
ôßÉÏͨ¹ýÔ¤±àÒë²ûÊöµÀ¹²Ïí³Ø×îºóµ½SGA£¬ÕâÀï½øÒ»²½ËµÃ÷Ò»ÏÂSGAÖÐÁíÒ»¸ö´ó¿é£¬Êý¾Ý»º³åÇø£¬Ð¯´øÌá¼°Ò»µãÊý¾ÝÎļþºÍ±í¿Õ¼ä£¬ºóÐøרÃÅ»á˵Ã÷Õâ¿é¡£
Ê×ÏÈÁ˽âÏÂSGAÖÖ´óÖÂÓÐÄÇЩ¶«Î÷£¬ÕâЩ¶«Î÷Ëæ×ÅÊý¾Ý¿â°æ±¾µÄÔö¼Ó»áÓÐËùÔö¼Ó£¬²»¹ý´óÖÂÉÏÓ¦¸ÃÒ»Ö£¬ÕâÒ²ÊÇ»ù±¾ËùÓеÄÌåϵ½á¹¹¶¼»áÃèÊöµÄ¶«Î÷£º
ÔÚÈÏʶÊý¾Ý»º³åÇøÇ°£¬ÏȼÇס¼¸¸ö³ ......
°ì·¨Ò»
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');&n ......