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Êý¾ÝÔ´ÒѾ³É¹¦´´½¨ÇÒ²¿Êð³É¹¦¡£
Îå¡¢
Á¬½Ó³ØÅäÖÃµÄÆ
Ïà¹ØÎĵµ£º
´¥·¢Æ÷µÄÀàÐÍÓÐ:
¡¡¡¡´¥·¢Æ÷ÀàÐÍ£º
¡¡¡¡1¡¢ Óï¾ä´¥·¢Æ÷
¡¡¡¡2¡¢ Ðд¥·¢Æ÷
¡¡¡¡3¡¢INSTEAD OF´¥·¢
¡¡¡¡4¡¢ ϵͳÌõ¼þ´¥·¢Æ÷
¡¡¡¡5¡¢ Óû§Ê¼þ´¥·¢Æ÷
Óï¾ä¼¶´¥·¢Æ÷.(Óï¾ä¼¶´¥·¢Æ÷¶Ôÿ¸öDMLÓï¾äÖ´ÐÐÒ»´Î)
ÊÇÔÚ±íÉÏ»òÕßijЩÇé¿öϵÄÊÓͼÉÏÖ´Ð ......
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 ......
µ¼³öÊý¾Ý¿â£ºexp Óû§Ãû/ÃÜÂë@Êý¾Ý¿âÃû file=ÅÌ·û£º/Îļþ¼Ð/ÎļþÃû.bmp owner=Óû§ »ò exp Óû§Ãû/ÃÜÂë@Êý¾Ý¿âÃû file=ÅÌ·û£º/Îļþ¼Ð/ÎļþÃû.bmp full=y
µ¼ÈëÊý¾Ý¿â£ºimp Óû§Ãû/ÃÜÂë@Êý¾Ý¿âÃû file=µ¼³öµÄÎļþ full=y ......
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 Êý¾Ý¿âÁ¬½ÓµÄ×î¼òµ¥·½Ê½£¬Ëü ......
http://www.builder.com.cn/2007/1027/583048.shtml
ÔÚphp3.0ÒÔÉϰ汾ÖУ¬phpÄÚÖÃÁ˼¸ºõĿǰËùÓеÄÊý¾Ý¿â´¦Àíº¯Êý£¬°üÀ¨Oracle;ÔÚ±¾ÎÄÖÐÎÒÃÇͨ¹ýÒ»¸öʵÀýÀ´½éÉÜÁËÈçºÎʹÓÃÕâЩº¯ÊýÀ´²Ù×÷OracleÊý¾Ý¿â¡£
PHPÌṩÁË2´óÀàAPI(Ó¦ÓóÌÐò½Ó¿Ú)À´²Ù×÷OracleÊý¾Ý¿â¡£Ò»¸öÊDZê×¼µÄOracle´¦Àíº¯Êý(ORA) ÁíÒ»¸öÊÇOracle 8µ÷Óýӿں¯ ......