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

oracle´Ó9.2.0.1Éý¼¶µ½9.2.0.8²½Öè

 ±³¾°£ºÔÚwindows 2003 serverÉÏ°²×°ÁËOracle 9.2.0.1.0£¬ÏÖ´òË㽫ÆäÉý¼¶µ½9.2.0.8°æ±¾¡£
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Éýµ½ÁË9208¡£
2.oracle´ò°²È«²


Ïà¹ØÎĵµ£º

×Ô¶¯Íê³ÉOracle¿Í»§¶ËµÄ°²×°¼°ÆäÅäÖÃ


¡¡¡¡Ò»¡¢ÎÊÌâµÄÌá³ö
¡¡¡¡Ä¿Ç°µÄºÜ¶àÊý¾Ý¿âÓ¦ÓóÌÐòÊÇʹÓÃORACLEÊý¾Ý¿â¿ª·¢µÄclient/serverģʽ¡£ÖÚËùÖÜ
Öª£¬Ê¹ÓôËÖÖģʽÐèÒªÔÚÖÕ¶ËÉÏ°²×°ORACLE¿Í»§¶ËÈí¼þ¡£Ó¦ÓóÌÐò¿ÉÒÔʹÓÃInstallShieldÈí¼þ´ò°ü³É°²×°³ÌÐò£¬ÓÉÓû§×ÔÐа²×°¡£µ«
ORACLE¿Í»§¶ËÈí¼þÒ»°ãÐèÒªÓо­ÑéµÄ¿ª·¢ÈËԱͨ¹ýÈË»ú½»»¥µÄ·½·¨°²×°£¬°²×°Íê³Éºó»¹ÐèÔ ......

ORACLE´¦ÀíÈÕÆÚ´óÈ«

ÔÚoracleÖд¦ÀíÈÕÆÚ´óÈ«
  TO_DATE¸ñʽ  
Day:  
dd number 12  
dy abbreviated fri  
day spelled out friday  
ddspth spelled out, ordinal twelfth  
Month:  
mm number 03  
mon abbreviated mar   ......

oracle³£ÓÃsqlÓï¾ä

ÐÞ¸ÄÁÐÊôÐÔ
alter table tablename modify(name ,varchar2(10)) Áпí¶È²»µÃСÓÚÐÞ¸ÄÇ°µÄ¿í¶È
ÈÕÖ¾¹ÜÀí
ÊÓͼ v$logfile
alter database add logfile 'd:\orcl01.log' size 10m;//Ìí¼Ó×é
alter database add logfile member 'd:\orcl02.log' to group 4;//Ïò4×éÖÐÌí¼Ó³ÉÔ±
alter database drop logfile member 'd: ......

Oracle SqlplusÉèÖÃÐÐÊýºÍ¿í¶È


1. ÉèÖÃÒ³ÃæÏÔʾ×ÜÐÐÊý
 
1) ²é¿´Ä¿Ç°µÄpagesize,ĬÈÏÊÇ14:
Sqlplus´úÂë
1.      show pagesize;   
show pagesize;
 
2) ½«pagesizeÉèÖúÃ100,Ôò¿ÉÒÔÒ»´ÎÏÔʾ¹»¶àÐмǼÁË:
Sqlplus´úÂë
1.      set pagesize 1 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ