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_
Ïà¹ØÎĵµ£º
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
ÔÚOracleÖн¨¿â£¬Í¨³£ÓÐÁ½ÖÖ·½·¨¡£Ò»ÊÇʹÓÃOracleµÄ½¨¿â¹¤ÇÒDBCA£¬ÕâÊÇÒ»¸öͼÐνçÃ湤ÇÒ£¬Ê¹ÓÃÆðÀ´·½±ãÇÒºÜÈÝÒ×Àí½â£¬ÒòΪËüµÄ½çÃæÓѺá¢ÃÀ¹Û£¬¶øÇÒÌáʾҲ±È½ÏÆëÈ«¡£ÔÚ£×indowsϵͳÖУ¬Õâ¸ö¹¤¾ß¿ÉÒÔÔÚOracle³ÌÐò×éÖдò¿ª£¨”¿ªÊ¼”—“³ÌÐò”—“ Oracle - OraDb10g_home1”&mdash ......
Á˽âLDAP
LDAPÊÇLight Directory Access ProtocolÇáÁ¿¼¶Ä¿Â¼·ÃÎÊÐÒéµÄ¼ò³Æ£¬LDAPÓëÊý¾Ý¿âÓкܴóµÄÇø±ð£¬ËüµÄÊý¾ÝÊÇÊ÷×´µÄ£¬¶øÇÒÿ¸ö½ÚµãµÄÊôÐÔÒ²±È½Ï¹Ì¶¨¡£
LDAPÐÒéÖÐÓÃdn±íʾһÌõ¼Ç¼µÄλÖã¬dc±íʾһÌõ¼Ç¼ËùÊôÇøÓò£¬ou±íʾһÌõ¼Ç¼ËùÊô×éÖ¯£¬cn±íʾһÌõ¼Ç¼µÄÃû³Æ£¬uid±íʾһÌõ¼Ç¼µÄID£¬ÆäÖÐdnÊǸù¾ ......
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 ......