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

Oracle 10.2.0.3 Patch°²×°

      Oracle 10.2.0.1µÄPatchµµÖð½¥ÐγÉÁ˼Ò×åÌåϵÁË,ÏÖÔÚÈôó¼ÒÀ´ÈÏʶһÏÂÕâ¸öÌåϵ°É!µ½Ä¿Ç°Ëù·¢²¼µÄÖ÷ÒªµÄPatchÓÐ10.2.0.2,10.2.0.3,10.2.0.4,10.2.0.4.1,10.2.0.4.2,10.2.0.4.3,10.2.0.5.
      ֮ǰÔÚ32λºÍ64λLinuxÏ°²×°Á˽ÏΪÎȶ¨µÄOracle 10G for Linux x86ºÍOracle 10G for Linux x86_64,ÓÉÓÚûÓÐÏÂÔØPatchµµ,ÈÃÎÒÒ»Ö±¶¼ÓÐÒ»ÖÖÏë·¨,Ò»¶¨ÒªÔÚ²âÊÔ»úÆ÷ÉÏ´òÉÏPatch.
      ×î½üÔÚѧϰRAC¼¼Êõ,ÔÚÐéÄâ»úÉÏ°²×°Oracle 10G for Linux x86 and Oracle 10G for Linux x84_64,Òò´ËPatchÐèÒª´òµ½10.2.0.3.Ôڴ˽«Ò»Ð©°²×°²½ÖèºÍÐĵÃÓë´ó¼Ò·ÖÏí:
      1).ÏÂÔØOracle 10.2.0.3µÄPatch
      2).½âѹ²¢·Åµ½/home/oracleĿ¼ÏÂ,ÒÔ±ã½øÐа²×°
      3).reboot Linux,È»ºóÒÔOracle User½øÈëϵͳ
      4).shutdown Databse,Stop all Oracle Service.
      5).Cool Backup Database
      6).Congratulation,You could run program of Patch
      ×¢Òâ:Èç¹ûûÓд´½¨Êý¾Ý¿â,Éý¼¶¾Í½áÊøÁË,Èç¹ûÉý¼¶ÒѾ­´´½¨Êý¾Ý¿â,ÐèÒªÖ´ÐÐÒ»ÏÂÒÔϵIJÙ×÷
      7).startup upgrade; lsnrctl start
        7.1).WindowsÏ°²×°ÐèÒªÐÞ¸Äjava_pool_size / large_pool_size=150M
        7.2).ͬʱÔËÐнű¾@rdbms/admin/catupgrd.sql
      8).shutdown immediate
      9).startup
      10).WindowsÏÂÐèÒªÔËÐнű¾@rdbms/admin/utlrp.sql
      11).--²ì¿´Êý¾Ý¿â°²×°µÄ×é¼þ\°æ±¾\״̬:
       col  com_name format a30
       col  version      format  a30
       col status         format  a10
      SELECT COMP_NAME,VERSION,STATUS from DBA_


Ïà¹ØÎĵµ£º

oracle imp\exp Óï·¨¼ò½é

ORACLE EXP/IMP ²ÎÊýÏê½â
2008-01-09 18:16
ORACLE EXP/IMP ²ÎÊýÏê½â
===========================================================
×÷Õß: magic21(http://magic21.itpub.net)
·¢±íÓÚ: 2007.09.27 10:46
·ÖÀà: ÈÕ»ýÔÂÀÛ
³ö´¦: http://magic21.itpub.net/post/5324/400048
-------------------------------------- ......

oracle imp\exp Óï·¨¼ò½é2

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
 
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬
......

Oracle PL/SQL¹ÜÀíLDAP·þÎñÆ÷(DBMS_LDAP°üµÄʹÓÃ)

Á˽âLDAP

LDAPÊÇLight Directory Access ProtocolÇáÁ¿¼¶Ä¿Â¼·ÃÎÊЭÒéµÄ¼ò³Æ£¬LDAPÓëÊý¾Ý¿âÓкܴóµÄÇø±ð£¬ËüµÄÊý¾ÝÊÇÊ÷×´µÄ£¬¶øÇÒÿ¸ö½ÚµãµÄÊôÐÔÒ²±È½Ï¹Ì¶¨¡£
LDAPЭÒéÖÐÓÃdn±íʾһÌõ¼Ç¼µÄλÖã¬dc±íʾһÌõ¼Ç¼ËùÊôÇøÓò£¬ou±íʾһÌõ¼Ç¼ËùÊô×éÖ¯£¬cn±íʾһÌõ¼Ç¼µÄÃû³Æ£¬uid±íʾһÌõ¼Ç¼µÄID£¬ÆäÖÐdnÊǸù¾ ......

javaÊý¾Ý¿â¿ª·¢ÖÐÁ½ÖÖ×¢²áoracleÇý¶¯µÄ·½Ê½

Ò»¡¢ÀûÓÃClass.forNameº¯Êý£¨ÓÃjava¿ª·¢B/SģʽµÄ³ÌÐò£© 1.´úÂëÈçÏ£º //×¢²áÇý¶¯³ÌÐò
public boolean connectDb() {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
return true;
} catch (ClassNotFoundException e) {
System.out.println(e);
return false;
}
} ......

SqlServer,Oracle ³£Óú¯Êý±È½Ï


SqlServer,Oracle ³£Óú¯Êý±È½Ï
 
Êýѧº¯Êý£º
1.¾ø¶ÔÖµ
¡¡¡¡ Sql Server: SELECT abs(-1) value
¡¡¡¡ Oracle: SELECT abs(-1) value from dual
2.È¡Õû(´ó)
¡¡¡¡ Sql Server: SELECT ceiling(-1.001) value
¡¡¡¡ Oracle: SELECT ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
¡¡¡¡ Sql Server: SELECT f ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ