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

oracle 9iÉý¼¶µ½oracle9208Êý¾Ý¿â

±³¾°£ºÔÚwindows2003serverÉÏ°²×°ÁËOracle9.2.0.1.0£¬ÏÖ´òË㽫ÆäÉý¼¶µ½9.2.0.8°æ±¾£¬²¢´òÉÏ×îÐµİ²È«²¹¶¡April2008°æ¡£
1.Éý¼¶oracle£¨administratorÓû§È¨ÏÞ£©
  (1)µ½metalinkÏÂÔØÉý¼¶Ñ¹Ëõ°ü£¬patchºÅΪ4547809£¬Ñ¹Ëõ°üÃû³ÆΪ p4547809_92080_WINNT.zip£¬for windows 32bit¡£
  (2)½âѹËõzip£¬Ï±߰üº¬Ò»¸öDisk1ºÍreadme.htmlÎļþ¡£°²×°Éý¼¶²¹¶¡Ö®Ç°£¬ÔÚ¹ÜÀíÖÐÍ£µôËùÓеÄoracleÏà¹Ø·þÎñ£¬ÔÚÃüÁîÌáʾ·ûÖÐlsnrctl stop,Í£µô¼àÌýÆ÷¡£
  (3)ÔÚË«»÷DiskϵÄsetup.exeÇ°£¬È·±£»·¾³±äÁ¿ÖÐÓÐORACLE_HOME±äÁ¿£¬²¢ÒÑÕýÈ·ÉèÖ᣷ñÔò»á³öÏÖ´íÎ󣨴íÎóÍüÁË£©¡£
  (4)Ë«»÷setup.exe,×Ô¶¯Éý¼¶µ½9.2.0.8£¬ÃüÁîÌáʾ·ûÌáʾ°²×°Íê³Éºó£¬ËµÃ÷×é¼þÒѾ­°²×°ÉÏ¡£
  (5)4²½²¢Ã»ÓÐupdate×é¼þ£¬ËùÒÔ»¹ÐèÒªupdate.´ËʱÐèÒª¿ªÆôOracleµÄ·þÎñ£¬×îºÃÊÇÖØÆðµçÄÔ£¬OracleĬÈÏ·þÎñ»á×ÔÆô¶¯¡£
  (6)ÒÔsysdbaÉí·ÝµÇ¼Êý¾Ý¿âºó,SQL>startup °²×°oracleÓÐÓÐjvmºÍxdbµÄÓû§È·±£init.oraÖеIJÎÊýSHARED_POOL_SIZE ºÍJAVA_POOL_SIZE Ϊ150m¡£·½·¨ÊDz鿴ÏÖÓÐÁ½¸ö²ÎÊý´óС
   SQL>SHOW PARAMETER SHARED_POOL_SIZE
   SQL>SHOW PARAMETER JAVA_POOL_SIZE
   Èç¹û´óС²»ÊÇ150m,½øÐÐÉèÖãº
   SQL> ALTER SYSTEM SET SHARED_POOL_SIZE='150M' SCOPE=spfile;
   SQL> ALTER SYSTEM SET JAVA_POOL_SIZE='150M' SCOPE=spfile;
   ÉèÖóɹ¦ºóshutdown immediate¹Ø±ÕÊý¾Ý¿â¡£
  (7)ÒÔsysdbaµÇ¼Êý¾Ý¿â
   Ö´ÐÐ SQL> STARTUP MIGRATE
 SQL> SPOOL patch.log
 SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\catpatch.sql
 SQL> SPOOL OFF
    spool patch.logÊÇ°Ñ×öÉý¼¶ÈÕÖ¾µ½patch.log£¬¹©ÒÔºó²ì¿´¡£
   ÆäÖÐORACLE_BASE\ORACLE_HOME±íʾÄãµÄoracleĿ¼£¬¼ÙÉèoracle°²×°Ä¿Â¼Îªc:\oracle\ora92,ÔòµÚÈý¾äӦΪ£º
   SQL>@c:\oracle\ora92\rrdbms\admin\catpatch.sql  ÆäÖÐ@±íʾִÐÐÒÔϽű¾¡£
   Õâ¸ö¹ý³Ì³ÖÐø´ó¸Å20·ÖÖÓ¡£
  (8)Íê³ÉºóshutdownÊý¾Ý¿â£¬È»ºóstartup,Ö´ÐÐÁíÍâÒ»¸ö½Å±¾
   SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\utlrp.sql£¬Íê³ÉºóÉý¼¶²¹¶¡´òÍ꣡£¡
  (8)ÖØÆðÊý¾Ý¿â£¬µÇ½ºóselect * from v$version£»¿ÉÒÔ¿´µ½oracleÉýµ½Á


Ïà¹ØÎĵµ£º

Oracle 10G DataGuard

http://hi.baidu.com/firefly5002/blog/item/5b5719fcb5bd3e1d08244d11.html
Oracle 10G DataGuard
server A: 10.85.10.44 SID=mesdb
target server B: 10.85.10.43
oracle version:10.2.0.1
OS platform : windows 2003
Data GuardĬÈÏÊÇmaximize performance£¬ ¿ÉÒÔÓÃÒÔÏÂÓï¾äÀ´½øÐÐģʽ¼äµÄÇл»¡£
ALTER DATABASE ......

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨

1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
    ²ÎÊý1 IN NUMBER,
    ²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
  ½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ì ......

oracle³£ÓÃÊý¾ÝÀàÐÍ

oracle³£ÓÃÊý¾ÝÀàÐÍ
½ñÌìͬÊÂÎÊЩÊý¾ÝÀàÐ͵ÄÎÊÌ⣬ÓеĻ¹ÕæÓеã¼Ç²»ÇåÁË£¬ÓÚÊǾͼòµ¥×ܽáϳ£ÓõÄÊý¾ÝÀàÐÍÒÔ±¸ÈÕºó²éÓÃ
1¡¢Char
¶¨³¤¸ñʽ×Ö·û´®£¬ÔÚÊý¾Ý¿âÖд洢ʱ²»×ãλÊýÌî²¹¿Õ¸ñ£¬ËüµÄÉùÃ÷·½Ê½ÈçÏÂCHAR(L)£¬LΪ×Ö·û´®³¤¶È£¬
ȱʡΪ1£¬×÷Ϊ±äÁ¿×î´ó32767¸ö×Ö·û£¬×÷ΪÊý¾Ý´æ´¢ÔÚORACLE8ÖÐ×î´óΪ2000¡£²»½¨ÒéʹÓ㬻ᴠ......

ÍƼöѧϰOracleµÄºÃÊé

    ¸Õ¿ªÊ¼Ñ§Ï°Orace£¬Óöµ½Ò»Ð©·Ç³£ºÃµÄÊ飬ÔÚÏÂÃæÁгö£¬Ëæ×ÅѧϰµÄÉîÈë»á°ÑÓöµ½µÄºÃÊ鶼ÁгöÀ´£¬¹©Ñ§Ï°OracleµÄÅóÓѲο¼£¬
Ò²»¶Ó­¸÷λÅóÓѲ¹³ä£º
»ù´¡£º
      1. ORACLE DBA»ù´¡Åàѵ½Ì³Ì      ºÎÃ÷Öø            Ç廪´óѧ³ö°æÉç
&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ