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±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
OracleÖеÄSQLÔÚÖ´ÐÐ֮ǰ½øÐнâÎö£¬Ò»¸öÓ²½âÎö°üÀ¨ÏÂÃæµÄ²½Ö裺
¼ÓÔØµ½¹²Ïí³ØÖÐ - SQLÔ´´úÂë±»¼ÓÔØµ½ÄÚ´æÖС£
Óï·¨½âÎö - Oracle¼ì²éÓ﷨ƴд´íÎó¡£
ÓïÒå½âÎö - OracleÑéÖ¤À´×ÔÊý¾Ý×ÖµäµÄËùÓбíÃûºÍÁÐÃû²¢ÇÒÑéÖ¤ÄãÊÇ·ñÓÐȨ·ÃÎÊÕâЩÊý¾Ý¡£
²éѯת»» - Èç¹ûÔÊÐí(query_rewrite=true)£¬oracle½«°Ñ¸´ÔÓµÄSQLת»»ÎªµÈ¼ÛµÄ¼òµ ......
ÔÚORACLE 10gµÇ½´´½¨ÐÂÓû§£º
ÔÚORACLE 10gµÇ½´´½¨ÐÂÓû§£º
1¡¢ÓÃsys Óû§µÇ¼
2¡¢create user test1 identified by test123;
3¡¢grant connect,resource to test1;
ÓÃtest1µÇ½£º sqlplus test1/test123
°²×°ÍêÁËOracleÊý¾Ý¿â£¬ÍüÁËÔÚ¿ÚÁî¹ÜÀíÖиøSCOTT½âËøÔõô°ì
ÎÊÌâ²¹³ä ......
º¯ÊýÊÇÒ»ÖÖÓÐÁã¸ö»ò¶à¸ö²ÎÊý²¢ÇÒÓÐÒ»¸ö·µ»ØÖµµÄ³ÌÐò¡£ÔÚSQLÖÐOracleÄÚ½¨ÁËһϵÁк¯Êý£¬ÕâЩº¯Êý¶¼¿É±»³ÆÎªSQL»òPL/SQLÓï¾ä£¬º¯ÊýÖ÷Òª·ÖΪÁ½´óÀࣺ
µ¥Ðк¯Êý£¬×麯Êý
SQLÖеĵ¥Ðк¯Êý
SQLºÍPL/SQLÖÐ×Ô´øºÜ¶àÀàÐ͵ĺ¯Êý£¬ÓÐ×Ö·û¡¢Êý×Ö¡¢ÈÕÆÚ¡¢×ª»»¡¢ºÍ»ìºÏÐ͵ȶàÖÖº¯ÊýÓÃÓÚ´¦Àíµ¥ÐÐÊý¾Ý£¬Òò´ËÕâЩ¶¼¿É±»Í³³ÆÎªµ¥Ðк¯Êý¡£ ......
ÏÈroot´ò²¹¶¡£ºp3006854_9204_linux.zip
ÔÙÉèoracle»·¾³±äÁ¿
°²×°
°²×°½áÊø½¨¿â֮ǰÐèÒª´òµÄ²¹¶¡ÓУº
p2617419_220_GENERIC.zip
p3119415_9204_linux.zip
¾ßÌå²Î¿¼ÕâÆªÎÄÕ£º
Redhat Enterprise Linux 4°²×°oracle
¹Ø¼ü×Ö: redhat el4 oracle °²×°
Ò». °²×°×¼±¸
1. as4°²×°Íêºó£¬ÐèÒª¼ì²éÏÂÁÐÈí¼þ ......