Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 10g °²×°Íê³Éºó,ÎÞ·¨µÇ½EMµÄ½â¾ö°ì·¨


 
 oracle 10g
°²×°Íê³Éºó,
怫EM
ÊäÈëϵͳÓû§ÃûºÍÃÜÂëºÍÊý¾Ý¿âÓû§ÃûºÍÃÜÂëºó,
µãÆô¶¯±¨´í,
¿ÉÄÜÊÇÒòΪÊý¾Ý¿âµÄ×´Ì¬Îª×°ÔØ»ò²»×°ÔØ,
ʼÖÕÎÞ·¨µÇ½½øEM
µÄ½â¾ö°ì·¨......
×´¿ö£º
´ò¿ªhttp://ty-:5500/em
£¬ÏµÍ³ÏÔʾÈçÏÂÐÅÏ¢£º
Êý¾Ý¿â״̬µ±Ç°²»¿ÉÓ᣿ÉÄÜÊÇÒòΪÊý¾Ý¿âµÄ×´Ì¬Îª×°ÔØ»ò²»×°ÔØ¡£µ¥»÷ ......

ORACLE PL/SQLÓëSQL SERVER T SQLһЩ±È½Ï

ORACLE PL/SQLÓëSQL SERVER T-SQLһЩ±È½Ï
×Ö·û´®Á¬½Ó
OracleÓÃ|| ·ûºÅ×÷ΪÁ¬½Ó·û£¬¶øSQL ServerµÄÁ¬½Ó·ûÊǼӺţº+ ¡£
Oracle²éѯÈçÏÂËùʾ£ºSelect ‘Name’ || ‘Last Name’ from tableName
SQL Server²éѯÈçÏ£ºSelect ‘Name’ + ‘Last Name’
GUID
OracleÓÃSYS_GUID ......

²é¿´oracle°æ±¾ÃüÁî

1  ²é¿´oracleµÄ°æ±¾ÐÅÏ¢
£¨1£©Óÿͻ§¶ËÁ¬½Óµ½Êý¾Ý¿â£¬Ö´ÐÐselect * from v$instance
            ²é¿´versionÏî
£¨2£©select * from product_component_version
£¨3£©»ò²éѯV$VERSION²é¿´×é¼þ¼¶ÐÅÏ¢ ......

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


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

ORACLE³£Óýű¾ÃüÁî

Óû§µÄ¹ÜÀí
Ò»¡¢ORACLEµÄ°²È«Óò
1¡¢TABLESPACE QUOTAS£º±í¿Õ¼äµÄʹÓö¨¶î
2¡¢DEFAULT TABLESPACE£ºÄ¬Èϱí¿Õ¼ä
3¡¢TEMPORARY TABLESPACE£ºÖ¸¶¨ÁÙʱ±í¿Õ¼ä¡£
4¡¢ACCOUNT LOCKING£ºÓû§Ëø
5¡¢RESOURCE LIMITE£º×ÊÔ´ÏÞÖÆ
6¡¢DIRECT PRIVILEGES£ºÖ±½ÓÊÚȨ
7¡¢ROLE PRIVILEGES£º½ÇÉ«ÊÚȨÏȽ«Ó¦ÓÃÖеÄÓû§»®Îª²»Í¬µÄ½ÇÉ«£¬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ