Oracle 9.2.0.1Éý¼¶µ½9.2.0.8°æ±¾
	
    
    
	¾°£ºÔÚwindows xp serverÉϰ²×°ÁËOracle 9.2.0.1£¬ÏÖʹÓÃp4547809_92080_WINNT.zip½«ÆäÉý¼¶µ½9.2.0.8°æ±¾£¬²¢´òÉÏ×î
Ðµİ²È«²¹¶¡April 2008°æ¡£
1.Éý¼¶oracle£¨administratorÓû§È¨ÏÞ£©£¨ÏÂÔØp4547809_92080_WINNT.zipÍøÖ·£º
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT.zip£©
£¨1£©¡¢Ñ¹Ëõ°üÃû³ÆÎª p4547809_92080_WINNT.zip£¬for windows 32bit£¬½âѹËõzip£¬Ï±߰üº¬Ò»¸öDisk1ºÍreadme.htmlÎļþ
¡£°²×°Éý¼¶²¹¶¡Ö®Ç°£¬ÔÚ¹ÜÀíÖÐÍ£µôËùÓеÄoracleÏà¹Ø·þÎñ£¨ÔÚ·þÎñÖÐÍ£Ö¹£©
£¨2£©¡¢Ë«»÷½âѹºóÎļþ¼ÐϵÄsetup.exe,°²×°Ê±Ä¿±êÑ¡ÏîÀÔÚÃû³ÆÀïÏÂÀÑ¡Ôñ£¬¾Í¿ÉÒÔÖ¸¶¨³öÔÀ´µÄ°²×°Ãû³ÆºÍ·¾¶£¬×Ô
¶¯Éý¼¶µ½9.2.0.8£¬ÃüÁîÌáʾ·ûÌáʾ°²×°Íê³Éºó£¬ËµÃ÷×é¼þÒѾ°²×°ÉÏ¡£
£¨3£©¡¢ÒÔsysdbaÉí·ÝµÇ¼Êý¾Ý¿âºó£¬È·±£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¹Ø±ÕÊý¾Ý¿â¡£
£¨4£©¡¢ÒÔ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\rdbms\admin\catpatch.sql  ÆäÖÐ@±íʾִÐÐÒÔϽű¾¡£
    Õâ¸ö¹ý³Ì³ÖÐø´ó¸Å20·ÖÖÓ¡£
  (5)Íê³Éºóshutdown immediateÊý¾Ý¿â£¬
È»ºóSQL> STARTUP MIGRATE ,
Ö´ÐÐÁíÍâÒ»¸ö½Å±¾£º
   SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\utlrp.sql£¬Íê³ÉºóÉý¼¶²¹¶¡´òÍ꣡£¡
  (6)ÖØÆðÊý¾Ý¿â£¨shutdown immediate¡¢STARTUP MIGRATE£©£¬
µÇ½ºóselect * from v$version£»¿ÉÒÔ¿´µ½oracleÉýµ½ÁË9208¡£
2.oracle´ò°²È«²¹¶¡
(1)²¹¶¡ÐÅÏ¢£ºCritical Patch Update Note  Release 9.2.0.8 for Microsoft Windows (32-Bit)£¬patchºÅΪ6867138¡£
(2)CPUÊǹý¶ÉÐÔ²¹¶¡£¬ÐèÒªÓÃOracleµÄ°²×°¹¤¾ßopatch°²
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    1 ´ÓÏÖÓеıíÖÐËæ»úÈ¡¼Ç¼
select * from (select st_base_id from t_base order by dbms_random.random) where rownum<=100; --Õâ¸öÊÇËæ»úÈ¡³ö100¸ö¼Ç¼¡£
2 ²úÉúËæ»ú×Ö·û´®
select dbms_random.string('u',100) from dual; --²úÉú´óд×Öĸ×é³ÉµÄ×Ö·û´®£¬'u'Ò²¿ÉÒÔд³É'U'
select dbms_random.string('l',100) from ......
	
    
        
    
    ±¾ÎĽéÉÜÁËʹÓÃPro*C/C++ÔÚVisual 
C++»·¾³Ï¿ª·¢OracleÊý¾Ý¿â½Ó¿Ú³ÌÐòµÄ·½·¨
Éè¼ÆË¼Â·ÆäʵÕâÑù£ºÊ×ÏÈͨ¹ýVC½¨Á¢Ò»¸ö¹¤³Ì£¬×Ô¶¯»¯½¨Á¢MAKEFILE£¬UNIXÐèÒª×Ô¼ºÐ´MAKEFILE¡£
Æä´ÎÅäÖÃVCµÄ»·¾³£¬½«PROCµÄ.H£¬.LIBµÄ·¾¶¼ÓÈëDERECTIRY¡£Ð´Ò»¸öPCÎļþ£¬¼´PROCÎļþ¡£·Åµ½¹¤³ÌÏàÓ¦µÄĿ¼Ï¡£È»ºó°ÑPCÎļþ¼ÓÈ빤³Ì¡£Ê¹ÓÃPROCUI.E ......
	
    
        
    
    
1£®Ê²Ã´½Ð×öÂãÉ豸£¿ 
¡¡¡¡ÂãÉ豸£¬Ò²½ÐÂã·ÖÇø£¨Ôʼ·ÖÇø£©£¬ÊÇÒ»ÖÖûÓо¹ý¸ñʽ»¯£¬²»±»Unixͨ¹ýÎļþϵͳÀ´¶ÁÈ¡µÄÌØÊâ×Ö·ûÉ豸¡£ËüÓÉÓ¦ÓóÌÐò¸ºÔð¶ÔËü½øÐжÁд²Ù×÷¡£²»¾¹ýÎļþϵͳµÄ»º³å¡£ 
2£®ÈçºÎ±æ±ðÂãÉ豸£¿ 
¡¡¡¡ÔÚUnixµÄ/dev Ŀ¼Ï£¬ÓÐÐí¶àÎļþ£¬ÆäÖÐÓÐÁ½¸ö´óÀࣺ×Ö·ûÉ豸ÎļþºÍ¿éÉ豸Îļþ¡£ 
¡¡¡¡×Ö·ûÉè±¸Ì ......
	
    
        
    
    ÔÚÆô¶¯oracle·þÎñʱ,Ê×ÏÈ»áÔÚ·þÎñ¶ËÕÒ
1.spfile<sid>.ora
ÓÃÓÚÆô¶¯Àý³Ì,Èç¹ûÕÒ²»µ½spfile<sid>.ora,ÔòʹÓ÷þÎñ¶ËȱʡµÄ
2.spfile
À´Æô¶¯,Èç¹ûȱʡµÄspfileÒ²ÕÒ²»µ½,ÔòʹÓÃ
3.init<sid>.ora
À´Æô¶¯Àý³Ì,×îºóÔòÊÇʹÓÃȱʡµÄ
4.pfile
.µ±È»ÄãÒ²¿ÉÒÔÖ¸¶¨pfileÀ´¸²¸ÇȱʡspfileÆô¶¯Àý³Ì,»òͨ¹ýspfile= ......
	
    
        
    
    Í£Ö¹Êý¾Ý¿â£¬Í£Ö¹·þÎñ¡£
È»ºóÔÚÔËÐÐÉý¼¶³ÌÐòʱ³öÏÖError:OUI-10133:Invalid stageing area. there 
are no top level components
                    
    
´íÎ󣬰ëÌì²»µÃÆä½â¡£ÖÕÓÚ·¢ÏÖÊÇÒòΪÉý¼¶°ü½âѹ²»ÍêÈ«Ôì³ÉµÄ¡£ÖØÐ¸´ÖÆÒ»·ÝÍêÕû½âѹ¹ýµÄ£¬Éý¼¶¡£OK. ......