Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µçÁ¦ÐÐÒµ½â¾ö·½°¸ ¸¶Ê×ê¿

ÖйúµçÁ¦ÐÐҵĿǰÕýÔÚ¾­Àúמ޴óµÄ±ä»¯£º´Ó¹ú¼Ò°ìµçµ½ÆóÒµ°ìµç£¬ÐγÉÁ˶à¼Ò¾ºÕù°ìµçµÄ¸ñ¾Ö£»³§Íø·Ö¿ª¡¢¾º¼ÛÉÏÍø£¬´Ó¼Æ»®µ½Êг¡×ª¹ì£¬ÒýÈë¶àÖÖ¾­¼Ã³É·Ö£»´ÓµØÓòÐÔ·ÖÉ¢¹©µçÏò´óµçÍø·¢Õ¹£»´ÓÕþÆó²»·Öµ½ÕþÆó·Ö¿ª¡£ÕâЩ±ä»¯£¬Ê¹ÖйúµÄµçÁ¦ÐÐÒµ¾­ÊÜ×ÅÇ°ËùδÓеÄѹÁ¦¡£
    Ò»·½Ã棬2003Äê¹úÄڵķ¢µçÆóÒµÖØиÄ×é£ ......

SQL SERVER 2000ÖзÃÎÊOracleÊý¾Ý¿â·þÎñÆ÷µÄ¼¸ÖÖ·½·¨

ÔÚSQL SERVER 20000ÖзÃÎÊOracleÊý¾Ý¿â·þÎñÆ÷µÄ¼¸ÖÖ·½·¨
1.ͨ¹ýÐм¯º¯Êýopendatasource
ÒªÇó:±¾µØ°²×°Oracle¿Í»§¶Ë
select * from opendatasource('MSDAORA', 'Data Source=XST4;User ID=manager;Password=sjpsjsjs')..MISD.PBCATCOL
ÆäÖУ¬MSDAORAÊÇOLEDB FOR OracleµÄÇý¶¯£¬
×¢Òâ:Óû§ÃûºÍ±íÃûÒ»¶¨Òª´óС£¬·þÎñÆ÷ºÍ ......

SQLServerºÍOracleµÄ³£Óú¯Êý¶Ô±È

1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.È¡Õû£¨½ØÈ¡£©
S:select cast(-1.002 as int) value
O:selec ......

Oracle´´½¨ÐòÁÐ sequence


OracleÖеÄÐòÁкŹËÃû˼Òå¾ÍÊÇ´´½¨Ò»¸öÐòÁкţ¬¿ÉÒÔÔÚ²åÈë»òÕ߸üеÄʱºòµ÷Óã¬Ï൱ÓÚÊÇÒ»¸öÉú³ÉÆ÷
´´½¨Óï·¨£º
create sequence myse
increment by 1       --Ôö³¤¶È
start with
1         --´ÓÄÄÀïÔö¼Ó£¬¾ÍÊÇ˵ÏÂÒ»¸ö»ñÈ¡µÄÖµ´ÓÕâ¸öÖµ ......

ORACLE 10G for RHEL AS 4 °²×°(ÍêÕû°æ)

ORACLE 10G for RHEL AS 4 °²×°
ÑéÖ¤°²×°:¼ì²éORACLEËùÐèµÄ³ÌÐòÊÇ·ñ°²×°¾ùÒÑ°²×°(»ò¸ü¸ß°æ±¾)
compat-db-4.1.25-9.i386.rpm
compat-gcc-32-3.2.3-47.3.i386.rpm
compat-gcc-32-c++-3.2.3-47.3.i386.rpm
compat-libstdc++-33-3.2.3-47.3.i386.rpm
compat-oracle-rhel4-1.0-5.i386.rpm
gcc-3.4.3-9.EL4.i386.rpm
gli ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ