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Êý¾ÝÔ´ÒѾ³É¹¦´´½¨ÇÒ²¿Êð³É¹¦¡£
Îå¡¢
Á¬½Ó³ØÅäÖõÄÆ
Ïà¹ØÎĵµ£º
×°ÁËÒ»Ò¹µÄÈí¼þ£¬ÏÈÊÇMySQL£¬myEclipse,Oracle ,²»¶ÏµÄ³ö´í£¬OracleServise²»ÄÜÆô¶¯£¬ºÜÊÇ·³ÈË£¬Ð¶ÔØÁËOracelÁ½´Î£¬ÓÖÖØ×°£¬´íÎóµÃµ½Ò»Ð©½â¾ö£¬×¢²á±í³öÏÖÁ˺öàµÄÎÊÌ⣬ÒÔÇ°ÔÚжÔØÈí¼þµÄʱºò£¬¶¼Ã»ÓÐÓÃרÓõŤ¾ß£¬×¢²á±íÒ»ÍÅÂÒ£¬ÕæÊÇÏ൱µÄºó»Ú£¬ÏÖÔÚ¿´À´ÒªÏë¸Ä¹ýÀ´È·ÊµÊǺÜÄѵÄÀ²£¡ÒÔºóÕâ·½ÃæÒª¶à¼ ......
ôßÉÏͨ¹ýÔ¤±àÒë²ûÊöµÀ¹²Ïí³Ø×îºóµ½SGA£¬ÕâÀï½øÒ»²½ËµÃ÷Ò»ÏÂSGAÖÐÁíÒ»¸ö´ó¿é£¬Êý¾Ý»º³åÇø£¬Ð¯´øÌá¼°Ò»µãÊý¾ÝÎļþºÍ±í¿Õ¼ä£¬ºóÐøרÃÅ»á˵Ã÷Õâ¿é¡£
Ê×ÏÈÁ˽âÏÂSGAÖÖ´óÖÂÓÐÄÇЩ¶«Î÷£¬ÕâЩ¶«Î÷Ëæ×ÅÊý¾Ý¿â°æ±¾µÄÔö¼Ó»áÓÐËùÔö¼Ó£¬²»¹ý´óÖÂÉÏÓ¦¸ÃÒ»Ö£¬ÕâÒ²ÊÇ»ù±¾ËùÓеÄÌåϵ½á¹¹¶¼»áÃèÊöµÄ¶«Î÷£º
ÔÚÈÏʶÊý¾Ý»º³åÇøÇ°£¬ÏȼÇס¼¸¸ö³ ......
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 ......
http://www.builder.com.cn/2007/1027/583048.shtml
ÔÚphp3.0ÒÔÉÏ°æ±¾ÖУ¬phpÄÚÖÃÁ˼¸ºõÄ¿Ç°ËùÓеÄÊý¾Ý¿â´¦Àíº¯Êý£¬°üÀ¨Oracle;ÔÚ±¾ÎÄÖÐÎÒÃÇͨ¹ýÒ»¸öʵÀýÀ´½éÉÜÁËÈçºÎʹÓÃÕâЩº¯ÊýÀ´²Ù×÷OracleÊý¾Ý¿â¡£
PHPÌṩÁË2´óÀàAPI(Ó¦ÓóÌÐò½Ó¿Ú)À´²Ù×÷OracleÊý¾Ý¿â¡£Ò»¸öÊDZê×¼µÄOracle´¦Àíº¯Êý(ORA) ÁíÒ»¸öÊÇOracle 8µ÷Óýӿں¯ ......