Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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Öд¥·¢Æ÷

´¥·¢Æ÷µÄÀàÐÍÓÐ:
¡¡¡¡´¥·¢Æ÷ÀàÐÍ£º           
¡¡¡¡1¡¢ Óï¾ä´¥·¢Æ÷
¡¡¡¡2¡¢ Ðд¥·¢Æ÷
¡¡¡¡3¡¢INSTEAD OF´¥·¢
¡¡¡¡4¡¢ ϵͳÌõ¼þ´¥·¢Æ÷
¡¡¡¡5¡¢ Óû§Ê¼þ´¥·¢Æ÷
Óï¾ä¼¶´¥·¢Æ÷.(Óï¾ä¼¶´¥·¢Æ÷¶Ôÿ¸öDMLÓï¾äÖ´ÐÐÒ»´Î)
ÊÇÔÚ±íÉÏ»òÕßijЩÇé¿öϵÄÊÓͼÉÏÖ´Ð ......

oracle³£ÓÃÃüÁîÏê½â

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 ......

Oracleµ¼Èëµ¼³öÊý¾Ý¿â

µ¼³öÊý¾Ý¿â£ºexp Óû§Ãû/ÃÜÂë@Êý¾Ý¿âÃû file=ÅÌ·û£º/Îļþ¼Ð/ÎļþÃû.bmp owner=Óû§ »ò exp Óû§Ãû/ÃÜÂë@Êý¾Ý¿âÃû file=ÅÌ·û£º/Îļþ¼Ð/ÎļþÃû.bmp full=y
µ¼ÈëÊý¾Ý¿â£ºimp Óû§Ãû/ÃÜÂë@Êý¾Ý¿âÃû file=µ¼³öµÄÎļþ full=y ......

PHP ÖÐʹÓÃoracle »·¾³ÅäÖÃ

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 Êý¾Ý¿âÁ¬½ÓµÄ×î¼òµ¥·½Ê½£¬Ëü ......

ÈçºÎÔÚ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µ÷Óýӿں¯ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ