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

Oracle°²×° - Oracle / »ù´¡ºÍ¹ÜÀí

ÔÚwin7ϰ²×°OracleûÓÐORCL·þÎñ³ÌÐò£¬Çë¸÷λ¸ßÊÖÖ¸µãÖ¸µã°¡£¡
ORACLE°æ±¾ÎÊÌâ,ÀúÊ·Ìù×Ӳο¼ÏÂ....

ÕýÔÚ¼ì²é²Ù×÷ϵͳҪÇó...
ÒªÇóµÄ½á¹û: 5.0,5.1,5.2,6.0 Ö®Ò»
ʵ¼Ê½á¹û: 6.1
¼ì²éÍê³É¡£´Ë´Î¼ì²éµÄ×ÜÌå½á¹ûΪ: ʧ°Ü <<<<
ÎÊÌâ: Oracle Database 11g δÔÚµ±Ç°²Ù×÷ϵͳÖо­¹ýÈÏÖ¤¡£
½¨Òé°¸: È·±£ÔÚÕýÈ·µÄƽ̨Éϰ²×°Èí¼þ¡£
========================================================

ÕýÔÚ¼ì²é Service Pack ÒªÇó...
¼ì²éÍê³É¡£´Ë´Î¼ì²éµÄ×ÜÌå½á¹ûΪ: δִÐÐ <<<<
OUI-18001: ²»Ö§³Ö²Ù×÷ϵͳ 'Windows Vista °æ±¾ 6.1'¡£
½¨Òé°¸: Çë°²×°½¨ÒéµÄ Service Pack¡£
========================================================

Çó½â£¡


Ö±½Ó°²×°32λµÄ¾Í¿ÉÒÔÁË¡£²»ÒªÓÃoracle for vistaµÄ¡£ 



win7ϰ²×°oracleȷʵÎÊÌâ¶à¶à£¬¿´¹ý¼¸¸öÏà¹ØµÄÌû×Ó£¬ÔÚÐéÄâ»úÀïÊÔÑéÁËÏ»¹ÊÇδÄܳɹ¦¡£
²Î¿¼

Òѽâ¾öÁË
ºÇºÇ
ÕÒµ½ refhost.xml Îļþ£¨Î»Öãºdatabase\stage\prereq\db £¬¿ÉÒÔʹÓüÆËã»úµÄËÑË÷¹¦ÄÜ£©£¬´ò¿ª refhost.xml ÅäÖÃÎļþ²¢ÕÒµ½ <CERTIFIED_SYSTEMS> ½Úµã£¬½Ó×ÅÔÚ½ÚµãºóÃæÌí¼ÓÒÔÏÂÄÚÈݲ¢±£´æ¼´¿É£º
  <!--Microsoft Windows 7-->
  <OPERATING_SYSTEM>
  <VERSION VALUE="6.1"/>
  </OPERATING_SYSTEM>


ÒýÓÃ
Òѽâ¾öÁË
ºÇºÇ
ÕÒµ½ refhost.xml Îļþ£¨Î»Öãºdatabase\stage\prereq\db £¬¿ÉÒÔʹÓüÆËã»úµÄËÑË÷¹¦ÄÜ£©£¬´ò¿ª refhost.xml ÅäÖÃÎļþ²¢ÕÒµ½ <CERTIFIED_SYSTEM


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

oracle 10g data guard - Oracle / »ù´¡ºÍ¹ÜÀí

×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐР
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
 SEQUENCE# APP
---------- ---
  13 NO
  13 YES ......

Çë½ÌÒ»¸öoracle¹ÜÀíµÄÎÊÌ⣡ - Oracle / »ù´¡ºÍ¹ÜÀí

·þÎñÆ÷ºǫ́µÄÊý¾Ý¿âÊÇoracle£¬ÔÚ½ñÌìϵͳµÇ¼µÄʱºò±¨¡°µÇ¼²»ÁËÊý¾Ý¿â£¬IOÒì³£¡±£¬½á¹ûÊÇÈ«¹«Ë¾¶¼µÇ²»ÉÏÈ¥£¬ÎÒÖØÆôÁËһϷþÎñÆ÷²ÅºÃÁË£¬ÎÒÏë¿ÉÄÜÊÇÓû§²¢·¢Á¿Ì«´óµÄÔµ¹Ê£¬²»ÖªµÀ¸÷λ´óϺÈÏͬ²»£¿ÓÐʲô½â¾ö°ì·¨Ã»£¿ ......

oracle ´æ´¢¹ý³Ì¸Ä³É ÊÂÎï Ôõôд°¡ - Oracle / ¿ª·¢

CREATE OR REPLACE PROCEDURE usp_refreshTopN
 IS
 BEGIN
 
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ