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

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°²


Ïà¹ØÎĵµ£º

oracle²úÉúËæ»úÊý»ò×Ö·û´®

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 ......

VCÏÂÀûÓÃPro*C¿ª·¢Oracle½Ó¿Ú

±¾ÎĽéÉÜÁËʹÓÃPro*C/C++ÔÚVisual
C++»·¾³Ï¿ª·¢OracleÊý¾Ý¿â½Ó¿Ú³ÌÐòµÄ·½·¨
Éè¼ÆË¼Â·ÆäʵÕâÑù£ºÊ×ÏÈͨ¹ýVC½¨Á¢Ò»¸ö¹¤³Ì£¬×Ô¶¯»¯½¨Á¢MAKEFILE£¬UNIXÐèÒª×Ô¼ºÐ´MAKEFILE¡£
Æä´ÎÅäÖÃVCµÄ»·¾³£¬½«PROCµÄ.H£¬.LIBµÄ·¾¶¼ÓÈëDERECTIRY¡£Ð´Ò»¸öPCÎļþ£¬¼´PROCÎļþ¡£·Åµ½¹¤³ÌÏàÓ¦µÄĿ¼Ï¡£È»ºó°ÑPCÎļþ¼ÓÈ빤³Ì¡£Ê¹ÓÃPROCUI.E ......

RAWÉ豸ÓëORACLEµÄÎÊ´ð


1£®Ê²Ã´½Ð×öÂãÉ豸£¿
¡¡¡¡ÂãÉ豸£¬Ò²½ÐÂã·ÖÇø£¨Ô­Ê¼·ÖÇø£©£¬ÊÇÒ»ÖÖûÓо­¹ý¸ñʽ»¯£¬²»±»Unixͨ¹ýÎļþϵͳÀ´¶ÁÈ¡µÄÌØÊâ×Ö·ûÉ豸¡£ËüÓÉÓ¦ÓóÌÐò¸ºÔð¶ÔËü½øÐжÁд²Ù×÷¡£²»¾­¹ýÎļþϵͳµÄ»º³å¡£
2£®ÈçºÎ±æ±ðÂãÉ豸£¿
¡¡¡¡ÔÚUnixµÄ/dev Ŀ¼Ï£¬ÓÐÐí¶àÎļþ£¬ÆäÖÐÓÐÁ½¸ö´óÀࣺ×Ö·ûÉ豸ÎļþºÍ¿éÉ豸Îļþ¡£
¡¡¡¡×Ö·ûÉè±¸Ì ......

Æô¶¯oracleϵͳÎļþ¼ÓÔØË³Ðò

ÔÚÆô¶¯oracle·þÎñʱ,Ê×ÏÈ»áÔÚ·þÎñ¶ËÕÒ
1.spfile<sid>.ora
ÓÃÓÚÆô¶¯Àý³Ì,Èç¹ûÕÒ²»µ½spfile<sid>.ora,ÔòʹÓ÷þÎñ¶ËȱʡµÄ
2.spfile
À´Æô¶¯,Èç¹ûȱʡµÄspfileÒ²ÕÒ²»µ½,ÔòʹÓÃ
3.init<sid>.ora
À´Æô¶¯Àý³Ì,×îºóÔòÊÇʹÓÃȱʡµÄ
4.pfile
.µ±È»ÄãÒ²¿ÉÒÔÖ¸¶¨pfileÀ´¸²¸ÇȱʡspfileÆô¶¯Àý³Ì,»òͨ¹ýspfile= ......

oracle 10.2.0.1 µ½ 10.2.0.4Éý¼¶

Í£Ö¹Êý¾Ý¿â£¬Í£Ö¹·þÎñ¡£
È»ºóÔÚÔËÐÐÉý¼¶³ÌÐòʱ³öÏÖError:OUI-10133:Invalid stageing area. there
are no top level components


´íÎ󣬰ëÌì²»µÃÆä½â¡£ÖÕÓÚ·¢ÏÖÊÇÒòΪÉý¼¶°ü½âѹ²»ÍêÈ«Ôì³ÉµÄ¡£ÖØÐ¸´ÖÆÒ»·ÝÍêÕû½âѹ¹ýµÄ£¬Éý¼¶¡£OK. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ