Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
  
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......

¡¾×ª¡¿OracleÖеÄÓ²½âÎöÓëÈí½âÎö

OracleÖеÄSQLÔÚÖ´ÐÐ֮ǰ½øÐнâÎö£¬Ò»¸öÓ²½âÎö°üÀ¨ÏÂÃæµÄ²½Ö裺
¼ÓÔØµ½¹²Ïí³ØÖÐ - SQLÔ´´úÂë±»¼ÓÔØµ½ÄÚ´æÖС£
Óï·¨½âÎö - Oracle¼ì²éÓ﷨ƴд´íÎó¡£
ÓïÒå½âÎö - OracleÑéÖ¤À´×ÔÊý¾Ý×ÖµäµÄËùÓбíÃûºÍÁÐÃû²¢ÇÒÑéÖ¤ÄãÊÇ·ñÓÐȨ·ÃÎÊÕâЩÊý¾Ý¡£
²éѯת»» - Èç¹ûÔÊÐí(query_rewrite=true)£¬oracle½«°Ñ¸´ÔÓµÄSQLת»»ÎªµÈ¼ÛµÄ¼òµ ......

ÔÚORACLE 10gµÇ½´´½¨ÐÂÓû§

ÔÚ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½âËøÔõô°ì
 
 
 
ÎÊÌâ²¹³ä ......

¹ØÓÚÊý¾Ý¿â·½ÃæoracleÖг£Óõ½µÃº¯Êý

º¯ÊýÊÇÒ»ÖÖÓÐÁã¸ö»ò¶à¸ö²ÎÊý²¢ÇÒÓÐÒ»¸ö·µ»ØÖµµÄ³ÌÐò¡£ÔÚSQLÖÐOracleÄÚ½¨ÁËһϵÁк¯Êý£¬ÕâЩº¯Êý¶¼¿É±»³ÆÎªSQL»òPL/SQLÓï¾ä£¬º¯ÊýÖ÷Òª·ÖΪÁ½´óÀࣺ
µ¥Ðк¯Êý£¬×麯Êý
SQLÖеĵ¥Ðк¯Êý
SQLºÍPL/SQLÖÐ×Ô´øºÜ¶àÀàÐ͵ĺ¯Êý£¬ÓÐ×Ö·û¡¢Êý×Ö¡¢ÈÕÆÚ¡¢×ª»»¡¢ºÍ»ìºÏÐ͵ȶàÖÖº¯ÊýÓÃÓÚ´¦Àíµ¥ÐÐÊý¾Ý£¬Òò´ËÕâЩ¶¼¿É±»Í³³ÆÎªµ¥Ðк¯Êý¡£ ......

oracle 9i on linux AS4

 ÏÈroot´ò²¹¶¡£ºp3006854_9204_linux.zip
ÔÙÉèoracle»·¾³±äÁ¿
°²×°
°²×°½áÊø½¨¿â֮ǰÐèÒª´òµÄ²¹¶¡ÓУº
p2617419_220_GENERIC.zip
p3119415_9204_linux.zip
¾ßÌå²Î¿¼ÕâÆªÎÄÕ£º
Redhat Enterprise Linux 4°²×°oracle
¹Ø¼ü×Ö: redhat el4 oracle °²×°
Ò». °²×°×¼±¸
  1. as4°²×°Íêºó£¬ÐèÒª¼ì²éÏÂÁÐÈí¼þ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ